Test whether profit for Massive Dynamic increased across the twotime periods. You are not told anything about the populationvariances. Highlight the numbers that help you test the nullhypothesis. In the text box below, explain whether once company hasoutperformed the other based on the evidence you provided in thelast four spreadsheets. You need to reference the numbers youhighlighted in your analysis. If you are concise, this should onlytake a few sentences. Note that I have not provided an α, so youranalaysis should include a discussion about significancelevels.
| Massive Dynamic |
| 1999-2001 | 2017-2019 |
| $12,541,670.00 | $12,691,796.00 |
| $12,599,974.00 | $12,791,509.00 |
| $12,580,740.00 | $12,545,205.00 |
| $12,562,499.00 | $13,000,366.00 |
| $12,536,897.00 | $13,299,434.00 |
| $12,549,939.00 | $13,120,443.00 |
| $12,609,762.00 | $12,613,030.00 |
| $12,592,993.00 | $12,480,269.00 |
| $12,590,347.00 | $13,110,196.00 |
| $12,591,582.00 | $13,170,295.00 |
| $12,567,813.00 | $13,167,244.00 |
| $12,532,945.00 | $13,072,151.00 |
Please show how to do in Excel, thank you!
