In order to complete this assignment, you will need to use statistical analysis software. Refer to the third study activity in Unit 1 to ensure you have all the necessary software to do so. Note: For Excel 2011 for Mac, you must have the Microsoft Office for Mac 2011 update 14.1 installed, issued August 2011. Solver is included as part of the update. After confirming that the update is installed, refer to steps 1–4 in this Microsoft Office forum to activate the Solver.In order to complete this assignment, you will need to use statistical analysis software. Refer to the third study activity in Unit 1 to ensure you have all the necessary software to do so. Note: For Excel 2011 for Mac, you must have the Microsoft Office for Mac 2011 update 14.1 installed, issued August 2011. Solver is included as part of the update. After confirming that the update is installed, refer to steps 1–4 in this Microsoft Office forum to activate the Solver.Practical Application Scenario 1
You are the manager of the Gander Mountain store in Frogtown, Illinois. Recently, a customer mentioned they believed your prices for ammunition were lower than the prices of Gander Mountain’s primary competitor in hunting equipment, Cabela’s. You would like to include that statement in a forthcoming print advertisement, so you need statistical evidence to support this assertion.
Identify the null and alternative hypotheses needed to test the contention. Then identify the most appropriate sample selection technique to gather data for testing the hypotheses. What statistical test should you use to accept or reject this hypothesis using the data you will collect?Practical Application Scenario 2
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 feel they have achieved some degree of success; however, you are worried about the effect that the new pattern might have on driving distance.
The Golf Ball Distances document 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 current UniDun type. Your job is to determine if the current UniDun balls can be driven further than the new SF balls. To resolve this question, you need appropriate answers to the following four questions. Remember to use your Business Statistics in Practice textbook, the supplementary instruction session archives, and the optional course resources to help you answer each of the following questions:
Identify the appropriate null and alternative hypotheses for this test. Express each in writing and in the form of an equation. Identify the appropriate statistical test to accept or reject the null hypothesis. Calculate the statistical parameters, the mean, variance, and standard deviation. Then calculate the statistical test and the p-value. In a three- to five-paragraph synopsis, explain your results to the vice president of marketing, including the terms of the scenario variables.
Hint: You will need to use Excel’s Analysis ToolPak, or the Mac equivalent, StatPlus:mac, to calculate the statistical parameters, the mean, variance, and standard deviation, and to calculate the statistical test that you have chosen and its p-value. SAS Enterprise Guide users do not need to first calculate the statistical parameters.Practical Application Scenario 3
As the food court manager at the Mall of Elbonia, you must determine how much time customers spend at the mall during different times of the week (for example: midweek day; midweek evening; weekend day; weekend evening). Last week, the mall survey staff randomly surveyed mall visitors as they left the mall. One key question asked how much time the customer had spent in the mall on that day.
The findings from this study are provided in the document titled Mall Time Results, provided in Resources. Columns A through D show the time spent by the customers interviewed, according to the part of the week and time of day when the interviews occurred. Is there any statistically significant difference (at alpha = .05) in the average amount of time people spend in the mall based on the part of the week and time of day? To determine the answer to this question, you need appropriate answers to all of the following four questions. Remember to use your Business Statistics in Practice textbook, the supplementary instruction session archives, and the optional course resources to help you answer each question.
Identify the null and alternative hypotheses you should form for this test. Express each in writing and also in equation form. Identify the appropriate statistical test to accept or reject the null hypothesis. Calculate the appropriate statistical test values to accept or reject your null and alternative hypotheses. What should you tell the Mall of Elbonia’s food court stores managers in terms of the mall’s high-traffic times and customer tendencies?
Assignment Submission
Compile all of your practical application scenario answers into one Word file (submitted as a .docx file). Copy the Excel or SAS output, including graphics, tables, and so on, into that document. Highlight your findings for these practical applications scenarios in yellow. Submit the file in the assignments area for grading and instructor feedback. Prior to submission, review the eleven questions within the three scenarios as well as the scoring guide to ensure you meet all evaluation criteria.Golf Ball Distance TestDistance Measured in YardsCurrent New264 277261 269267 263272 266258 262283 251258 262266 289259 286270 264263 274264 266284 262263 271260 260283 281255 250272 263266 278268 264270 272287 259289 264280 280272 274275 281265 276260 269278 268275 262281 283274 250273 253263 260275 270267 263279 261274 255276 263262 279Mall Time Interview ResultsMidweek, Day Midweek, Evening Weekend, Day Weekend, Evening66 64 64 18578 71 121 20766 174 29 20332 53 147 8435 52 162 12534 96 108 18488 135 61 129149 142 77 9486 149 88 182145 59 131 65146 82 127 11038 118 141 13995 132 176 10880 81 161 117106 111 3 12542 68 82 6595 22 128 4777 50 51 8898 125 81 8471 105 54 165122 92 161 86125 115 158 16485 148 45 19997 66 134 8333 74 38 36
Mall Time Interview Results Midweek, Day Midweek, Evening Weekend, Day Weekend, Evening66 64 64 18578 71 121 20766 174 29 20332 53 147 8435 52 162 12534 96 108 18488 135 61 129149 142 77 9486 149 88 182145 59 131 65146 82 127 11038 118 141 13995 132 176 10880 81 161 117106 111 3 12542 68 82 6595 22 128 4777 50 51 8898 125 81 8471 105 54 165122 92 161 86125 115 158 16485 148 45 19997 66 134 8333 74 38 36