Please show how to get the answers using excel with formulas on worksheet. thank you!

5. Willco is a manufacturer in a mature cyclical industry. During the most recent industry cycle, its net income averaged $30 million per year with a standard deviation of $10 million ( n=6 observations). Management claims that Willco's performance during the most recent cycle results from new approaches and that we can dismiss profitability expectations based on its average or normalized earnings of $24 million per year in prior cycles. A. With as the population value of mean annual net income, formulate null and altemative hypotheses consistent with testing Willco management's claim. B. Assuming that Willco's net income is at least approximately normally distributed, identify the appropriate test statistic. C. Identify the rejection point or points at the 0.05 level of significance for the hypothesis rested in Part A. D. Determine whether or not to reject the null hypothesis at the 0.05 significance level