Resubmit of a previos problem. I\'ve attached all given information as a two scr
ID: 3203897 • Letter: R
Question
Resubmit of a previos problem. I've attached all given information as a two screen grabs and put the given table into an actaul table istead of just a picture of it. I hope this is what is needed to give proper help. The first one is the instructions for the assignment.and then the second is the excel file information provided for the golf balls, inorder to do the assignment questions. I tried to work on the assignment from the previous answer but with the different numbers, it was just too confusing and I don't know if my answers are correct. Thanks again.
Current New 289 303 286 295 292 289 297 292 283 288 308 277 283 288 291 315 284 312 295 290 288 300 289 292 309 288 288 297 285 286 308 307 280 276 297 289 291 304 293 290 295 298 312 285 314 290 305 306 297 300 300 307 290 302 285 295 303 294 300 288 306 309 299 276 298 279 288 286 300 296 292 289 304 287 299 281 301 289 287 305 Case Problem: Golf Equipment, Inc. Golf Equipment, Inc. has developed a new coating designed to resist cuts and provide a more durable golf ball. One concern for Golf Equipment was the effect of the new coating on driving distances. Some board members were hypothesizing that the mean driving distance of the new golf ball will either be longer or shorter than the mean driving distance of the current golf ball This would seriously question the future production of the new ball because of the USGA strict recommendations and golfers expectations. Therefore, Golf Equipment would like the new cut- resistant ball to offer driving distances comparable to those of the current-model golf ball. In other words, the mean driving distances should be similar. To compare the driving distances for the two balls, 40 balls of both new and current models were subjected to distance test. The testing was performed with a mechanical hitting machine so that any difference between the mean distances for the two models could be attributed to a difference in the two models. The sample data (in yards) is available in the attached Excel file 1. Provide descriptive statistical summaries of the data for each mode What are your primary observations concerning the two data sets? Calculate the 95% confidence interval for the population mean of each model. Do these intervals overlap 2. Formulate a hypothesis test for the comparison of the mean driving distances of the current and new golf balls. 3. Analyze data to provide a hypothesis testing conclusion 4. Calculate the 95% confidence interval for the difference between the means of the two populations. What can be concluded from this interval? Is it the same as your conclusion made in Task 3? 5. What is your final recommendation concerning the production of the new balls?Explanation / Answer
1)
You get output in excel by using discrepitive statistics.
Here margin of error ( E) =2.799
Confidence interval is ( mean - E , mean + E ) = ( 295.275 - 2.799 , 295.275+2.7999) =( 292.476 , 278.074 )
Confidence interval for current data is (292.476 , 278.074 )
Margin of error =3.165 so confidence interval for New data is
( 293.5 - 3.165 , 293.5+3.165 ) =( 290.335 ,296.665 )
2) H0 : miu1=miu2 vs H1:miu1 not equal to miu2
miu1 is the population mean of current data and miu2 is the population mean of new data
3) t-test for two sample is
Go to data analysis>>> select t-test assuming unequal variance >> drag variable 1 range for current data and drag variable 2 range fro new data>>>put hypothesis difference is zero>>> you get output is
Here p value for two tailed is 0.3981 is greater than alpha=0.05 so we do not reject H0 at 5 % l.o.s
Conclusion : Both population mean are equal, There is no significant diffence between two population means.
Mean 295.275 Standard Error 1.383968421 Median 295 Mode 297 Standard Deviation 8.752984839 Sample Variance 76.61474359 Kurtosis -0.76258722 Skewness 0.306169371 Range 34 Minimum 280 Maximum 314 Sum 11811 Count 40 Confidence Level(95.0%) 2.799340358Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.