4. (4 points) A recent study found that consumers are making average monthly debt payment of $983. The data of average debt payments for 26 metropolitan areas are in the data set, labeled Debt_Payments, on the website. a. Use Excel's Data Analysis to get the descriptive statistics. Include the 95% of confidence level in the printout. b. Construct a 95% confidence interval for the population mean diameter. c. Test whether average monthly debt payments are greater than $950 at a = 0.05. Use the critical value approach. d. Refer to the test in part c. Conduct the test with the p-value approach. 2