Use the Mall of Elbonia Interview Results file, linked in the Resources under the Required Resources heading, and data analysis software to complete the scenario for this assessment. You may also use the Hypothesis Tester - Single Sample file to test your hypothesis; refer to the Hypothesis Tester - An Introduction media piece (linked in the Resources) to review the process for computing this equation. Practical Application Scenario In this scenario, you have just been hired away from your Macy's linens department buyer position by the Mall of Elbonia (MoE), as the new food court manager. Why? Rumor had it you have just earned your MBA. One week ago, the MoE conducted convenience interviews with customers in the mall's food court. One hundred interviews were gathered. The results are summarized in the Mall of Elbonia Interview Results file. In this file, you will find the customers listed in rows, with columns containing data on: The customer's gender. (If you need this data for your computations in this assessment, use the coding convention: 0 for female, 1 for male.) How much time the customer spent in the mall. How much money he or she spent on food. The customer's rating of the mall's friendliness and attractiveness. After you have applied the descriptive data measures, you find the mean to be particularly telling. You believe that you can happily tell the food court owners that the average amount mall customers spend on food during a visit has increased. You realize this is a onesample test of hypothesis situation. A 2011 study previously found that customers spent an average of $18.75 per visit. Directions Use the data in the Mall of Elbonia Interview Results file and the process outlined below to confirm that the average amount mall customers spend on food during a visit to your mall has increased. Use an alpha of .05. 1. Determine the null hypothesis via the appropriate math equation, and write a brief explanation. 2. Determine the alternative hypothesis via the appropriate math equation, and write a brief explanation. 3. Solve the equation to determine whether to accept or reject the null hypothesis. 4. Determine whether the p-value indicates acceptance or rejection of the null. Use alpha = .05. Next, address the following: Report the rejection or acceptance of the null, in terms of the scenario results. Write a three-sentence paragraph that details: o Why you can be statistically confident that the average amount a food court's customer spends has increased, decreased, or remained the same. What would happen if alpha was .01 or .10. Recommend actions to the food court owners based on your findings. Additional Requirements Compile your work and report in a 1-2 page Microsoft Word file: Paste in the tables you used to make your calculations. Clearly title your tables, including each row and column. Highlight the results of your data calculations within each table. Hypothesis Tester - Single Sample Hypothesis Test for a Population Mean, Sigma Known If the population standard deviation is known, we can directly calculate the standard deviation of the sampling distribution (the standard error of the estimate), and use the standardized normal distribution to get a z-multiple, using the Excel function NORMSINV. We can then calculate p for each of the three possible test conditions, and compare it to each level of alpha to see whether the null hypothesis should be rejected. Inputs: Hypothesized population mean: 295 Population standard deviation (sigma): 12 Sample size (n): 50 Sample mean (x-bar): 297.6 <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. Intermediate Calculations: Standard error of the estimate: 1.69705627 Test statistic (z): 1.53206469 Results: One-tailed, H0: Mu =>295, p= 0.9372 For the Alpha level given, H0 should be: 0.01 Not rejected One-tailed, H0: Mu <=295, p= 0.0628 Not rejected Two-tailed, H0: Mu = 295, p = 0.1255 Not rejected Alpha: End of worksheet ate number for your situation. ate number for your situation. ate number for your situation. ate number for your situation. he Alpha level given, H0 should be: 0.05 Not rejected 0.1 Not rejected Not rejected Rejected Not rejected Not rejected Hypothesis Tester - Single Sample Hypothesis Test for a Population Mean, Sigma Unknown If the population standard deviation is not known, we must use the sample standard deviation as an estimate and use it to calculate the standard deviation of the sampling distribution (the standard error of the estimate). We also use the t-distribution to get a multiple corresponding to the desired confidence level, using the Excel function TINV. We can then calculate p for each of the three possible test conditions, and compare it to each level of alpha to see whether the null hypothesis should be rejected. Inputs: Hypothesized population mean: 7 Sample standard deviation (s): 1.05 Sample size (n): 60 Sample mean (x-bar): 7.25 <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. Intermediate Calculations: Standard error of the estimate: 0.1355544 Test statistic (t): 1.8442778 Degrees of freedom (d.f.): 59 Results: One-tailed, H0: Mu =>7, p= 0.9649 End of worksheet For the Alpha level given, H0 should be: Alpha: 0.01 0.05 Not rejected Not rejected One tailed, H0: Mu <=7, p= 0.0351 Not rejected Rejected Two-tailed, H0: Mu = 7, p = 0.0702 Not rejected Not rejected our situation. our situation. our situation. our situation. H0 should be: 0.1 Not rejected Rejected Rejected Hypothesis Tester - Single Sample Hypothesis Test for a Population Proportion From a sample proportion we can calculate the standard deviation of the sampling distribution (the standard error of the estimate) and use the standardized normal distribution to get a z-multiple, using the Excel function NORMSINV. We can then calculate p for each of the three possible test conditions, and compare it to each level of alpha to see whether the null hypothesis should be rejected. Inputs: Hypothesized population proportion: 0.35 Sample proportion (p-bar): 0.4 Sample size (n): 30 <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. <-- Input the appropriate number for your situation. Intermediate Calculations: Standard error of the estimate: 0.0871 Test statistic (z): 0.5741692518 Results: One tailed, H0: P => 0.35, p = 0.7171 For the Alpha level given, H0 should b 0.01 Not rejected One tailed, H0: P <= 0.35, p = 0.2829 Not rejected Two-tailed, H0: P = 0.35, p = 0.5659 Not rejected Alpha: End of worksheet te number for your situation. te number for your situation. te number for your situation. he Alpha level given, H0 should be: 0.05 Not rejected 0.1 Not rejected Not rejected Not rejected Not rejected Not rejected Mall of Elbonia Interview Results Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Gender 1 0 0 1 1 0 1 1 1 0 1 1 1 0 0 0 0 1 0 1 1 0 0 1 1 0 0 1 1 1 0 1 0 0 0 1 1 0 1 1 1 1 1 1 1 Clothing $65 $139 $186 $125 $193 $186 $60 $231 $83 $157 $185 $125 $174 $125 $110 $164 $192 $165 $123 $189 $115 $116 $188 $146 $184 $121 $169 $95 $135 $157 $163 $134 $179 $144 $180 $92 $154 $180 $168 $117 $193 $96 $118 $214 $169 Food $16 $17 $22 $24 $17 $20 $18 $18 $20 $20 $26 $18 $17 $26 $18 $18 $15 $28 $18 $19 $16 $27 $13 $24 $24 $19 $15 $16 $24 $26 $12 $19 $24 $21 $20 $15 $19 $26 $13 $25 $17 $24 $13 $28 $18 Time in Mall 51 40 231 131 20 204 61 64 84 161 148 67 231 165 59 16 174 41 337 63 57 242 12 116 46 146 152 61 71 226 48 289 81 170 53 161 34 111 53 125 101 130 108 109 141 Friendliness 8 5 3 5 3 2 4 1 5 5 7 10 6 1 9 2 3 7 5 9 8 7 8 9 9 7 4 1 1 9 7 10 6 3 10 9 7 5 6 1 10 9 4 6 2 Attractiveness 9 8 1 8 3 1 3 5 7 5 6 9 4 5 5 3 1 1 4 10 9 8 6 7 7 8 4 1 9 10 10 9 5 5 5 9 8 7 5 1 8 8 1 9 1 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 1 1 0 0 1 1 0 0 0 1 0 0 1 1 1 0 1 1 1 1 0 0 0 0 0 1 0 0 1 1 1 0 0 1 1 1 0 0 0 0 1 1 1 0 0 0 0 $113 $199 $64 $177 $149 $130 $186 $180 $93 $114 $195 $185 $81 $223 $164 $119 $165 $146 $87 $158 $187 $113 $159 $174 $169 $140 $126 $177 $124 $181 $124 $145 $186 $118 $141 $154 $161 $92 $183 $215 $104 $178 $155 $104 $171 $172 $88 $16 $26 $13 $23 $24 $15 $24 $17 $24 $15 $20 $21 $15 $29 $16 $17 $20 $19 $24 $20 $26 $12 $27 $18 $21 $17 $23 $18 $21 $17 $26 $13 $21 $24 $19 $16 $20 $26 $20 $15 $19 $21 $18 $19 $26 $17 $19 185 95 136 45 102 81 205 26 237 229 39 125 318 64 124 127 89 98 145 124 118 161 42 39 210 242 170 76 149 161 24 77 239 87 20 90 52 97 42 222 167 36 87 213 74 235 56 7 10 5 8 6 9 5 1 1 9 9 5 5 1 2 8 7 3 6 8 7 8 3 2 6 2 1 9 8 7 7 6 3 9 2 1 5 2 10 8 2 8 8 6 10 8 1 9 9 2 4 5 7 8 4 3 8 10 3 9 3 3 7 8 7 8 10 6 2 1 2 1 6 9 8 9 7 8 8 1 4 2 9 4 7 8 9 1 7 7 7 8 1 3 93 1 94 0 95 0 96 0 97 0 98 1 99 0 100 0 End of worksheet $208 $98 $174 $149 $140 $170 $177 $79 $22 $19 $21 $22 $23 $13 $27 $17 67 215 46 333 39 39 57 235 9 1 1 10 5 4 1 6 9 1 1 7 1 5 3 8