Par, Inc., is a major manufacturer of golf equipment. Management believes that Par's market share could be increased with the introduction of a cut-resistant, longer-lasting golf ball. Therefore, the research group at Par has been investigating a new golf ball coating designed to resist cuts and provide a more durable ball. The tests with the coating have been promising.

One of the researchers voiced concern about the effect of the new coating on driving distances. Par would like the new cut-resistant ball to offer driving distances comparable to those of the current-model golf ball. To compare the driving distances for the two balls, 40 balls of both the new and current models were subjected to distance tests. 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 results of the tests, with distances measured to the nearest yard, follow. These data are available on the website that accompanies the text.

Letu1=population mean driving distance for the current golf ball

u2=population mean driving distance for the new golf ball,

In your answers, (USING EXCEL)

1. Formulate hypotheses and conduct the hypothesis testing at 5% level of significance,

2. Provide the result of the testing using Excel with Golf.xlsx

Current	New
264	277
261	269
267	263
272	266
258	262
283	251
258	262
266	289
259	286
270	264
263	274
264	266
284	262
263	271
260	260
283	281
255	250
272	263
266	278
268	264
270	272
287	259
289	264
280	280
272	274
275	281
265	276
260	269
278	268
275	262
281	283
274	250
273	253
263	260
275	270
267	263
279	261
274	255
276	263
262	279

3. Draw the conclusion of the test and discuss how the firm uses this analysis