Please, attach one Excel file with solutions to ALL exercises for this assignment. You can send a link of the Excel file to me.

According to Fidelity Investments, the average 401(k) account balance was $99,900 in 2017. To test if this average has recently changed, suppose a sample of 30 401(k) plans was selected, and it was found that the average 401(k) balance was $110,110 with the sample standard deviation equal to $27,140.

Using = 0.02, does this sample provide enough evidence to conclude that the average 401(k) account balance has changed since 2017? For the hypothesis test:

Use the critical value approach

Use the p-value approach