Explore BrainMass

Explore BrainMass

    P-Value for Golf Ball Driving Distance Test Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:33 am ad1c9bdddf


    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.