Q4. One-sample test for means, population standard deviation unknown. Use information in the Excel f

Q4. One-sample test for means, population standard deviation unknown. Use information in the Excel file Consumer Transportation Survey. Test the hypothesis that individuals drive an average of 450 miles per week. Be sure to complete and clearly label parts a-f.For each hypothesis test use a significance level of 0.05 and explicitly state: a. Null hypothesis and alternative hypothesis b. Whether the hypothesis test is a lower one-tail test, an upper one-tail test, or a two-tail test. c. Decision ruled. Test statistic and critical value(s)e. Results of applying the decision rule (i.e. do you reject or fail to reject the null hypothesis; andf. Conclusions