279 Assessment Instructions For this assessment, you will need to use Excel to c

Question

279

Assessment Instructions

For this assessment, you will need to use Excel to calculate statistical parameters, the mean, variance, and standard deviation. You will also need to choose an appropriate statistical test for a scenario, and calculate p-value. To choose the statistical test and calculate the p-value, you are encouraged to use the Analysis Toolpak software (for PC users) or the StatPlus:mac software (for Mac users). If you do not have one of these data analysis programs (or a comparable tool) available on your computer, refer to the instructions in the Resources to activate or download the software.

Practical Application Scenario

Your love of golf has brought you back to the range as the new product manager for UniDun's "Straight Flight" (SF) line of golf balls. The company's research and development group has been experimenting with dimple patterns that promote straight flight and have achieved some degree of success. You, however, are worried about the effect that the new pattern might have on driving distance.

The Golf Ball Distance Test file (linked in the Resources under the Required Resources heading) contains test results that compare the driving distances for the two different kinds of balls: 40 balls of the new SF type, and 40 of the old UniDun type. Your job is to determine if the old UniDun balls can be driven further than the new SF balls. To resolve this question, you need appropriate answers to the following four questions.

Identify the null and alternative hypotheses you should form for this test. State each both as a written explanation and as a math equation.

Identify the appropriate statistical test to accept or reject the null hypothesis.

Calculate the p-value.

What should you tell the vice president of marketing about the new golf ball product?

Compile your work into one Microsoft Word file, pasting in the tables you have used to make your calculations. Be sure to clearly title your tables, including each row and column. Highlight the results of your data calculations within the tables

Golf Ball Distance Test Distance Measured in Yards 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

Explanation / Answer

The above would qualify for a one tailed hypothesis with:

Ho : Mean current > mean new i.e current balls go farther than the newly designed balls

Ha : Mean current <= mean new i.e new balls go farther than the current balls.

We tested the hypothesis at 5% significance.

P-value for one tailed test = 0.09

Thus, p-value > significance level and hence null hypothesis is accepted.

Hence,statistically, the older balls are better than the newer ones and this is to be conveyed to the vice-president of marketing of the new balls.

Hope this helps.

264 277 F-Test Two-Sample for Variances 261 269 267 263 Variable 1 Variable 2 272 266 Mean 270.275 267.5 258 262 Variance 76.61474359 97.94871795 283 251 Observations 40 40 258 262 df 39 39 266 289 F 0.782192408 259 286 P(F<=f) one-tail 0.223266874 270 264 F Critical one-tail 0.586694336 263 274 264 266 t-Test: Two-Sample Assuming Equal Variances 284 262 263 271 Variable 1 Variable 2 260 260 Mean 270.275 267.5 283 281 Variance 76.61474359 97.94871795 255 250 Observations 40 40 272 263 Pooled Variance 87.28173077 266 278 Hypothesized Mean Difference 0 268 264 df 78 270 272 t Stat 1.328361594 287 259 P(T<=t) one-tail 0.093966142 289 264 t Critical one-tail 1.664624645 280 280 P(T<=t) two-tail 0.187932285 272 274 t Critical two-tail 1.990847069 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

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.