Explore BrainMass

P-Value for Golf Ball Driving Distance Test Excel

A major manufacturer of golf equipment seeks to improve its market share by introducing a golf ball that is less likely to slice when hit. The company's research and development group has been experimenting with dimple patterns that promote straight flight, and have achieved some degree of success. The vice president of marketing, however, is worried about the effect that the new pattern might have on driving distance.

To investigate this issue, the research and development group did a test to compare the driving distances for the two balls: 50 balls of the new type, and 50 of the old. They used a mechanical hitting machine to control all factors other than the balls themselves. The resulting data of distance measured to the nearest yard for each of the 100 balls that were hit is provided in the Golf Ball Distance Test Excel file.

I have attached an Excel Spreadsheet with the driving distances.


Solution Preview

Hi there,

Thanks for letting me know the excel attachment. I've attached my ...

Solution Summary

The solution provides detailed process of how to use P value to test null hypothesis in the attached Excel file.