ב B Region A Sales Revenue Region B Sales Revenue 92.72817 90.52267 100.2288 96.93451 99.06408 92.44597 107.6639 89.09684 107.3468 94.85909 100.7747 97.14166 101.8908 95.33259 95.56107 96.51236 90.09602 91.82839 98.26044 93.18629 100.7817 91.6377 106.1515 93.20223 106.0119 90.93427 98.06337 86.36859 98.48849 95.88713 94.75724 92.9911 92.89991 86.84901 91.46865 97.31391 109.7539 90.46351 97.45174 95.25973 97.80963 98.64545 93.73602 95.64491 103.8875 100.697 91.93051 88.82587 98.9363 97.01171
Please conduct a step by step of these statistical tests on separate sheets of Microsoft Excel. If the calculations in Microsoft Excel are incorrect, the null and alternative hypotheses, as well as the conclusions drawn from them, will be meaningless and will not receive any points
2. Two-Sample T-Test: Compare the average sales revenue of two different regions to determine if there is a significant difference.
(Hints: The null can be about maintaining status-quo or no difference among groups; if alternative hypothesis is non-directional use the two-tailed p-value from excel file to make a decision about rejecting or not rejecting null)
H0 =
H1=
Step by step
Solved in 2 steps
