How to process the attached question showing calculations in Excel Spreadsheet

Unit VII Assignment: Hypothesis Testing for College Tuition Cost

In this assignment, you will be using inferential statistics to determine if a claim about college tuition cost is accurate.

According to the College Board's website, the average tuition cost per year for a public four-year college (in-state cost) is $10,230.

1. Assume that you disagree with the claim. Do you think the average tuition cost is higher? Or lower?

1. Using your answer in part A, write a set of hypotheses (null hypothesis and alternative hypothesis) to represent that claim and its complement. Replace the ?s below with the appropriate inequality signs (). Highlight the hypothesis that represents your claim.

1. Gather data for tuition cost of 20 different universities. Assume the data you gather is normally distributed.

10024	9286	11962	10800
7290	7872	10474	10167
11796	9944	9070	11060
6517	8445	8910	8289
6485	8800	7462	9340

1. Calculate the mean and standard deviation of your data set. You may use technology such as Google Sheets, Excel, or a TI-83/TI-84. Round to the nearest hundredth.

Mean _____ Standard Deviation ________________

1. Using a significance level , find the critical value using the following steps.

1. What are the degrees of freedom?

1. Will this be a one-tailed or two tailed test?

1. Using table 5 from the back of your textbook (page A18 in Appendix B), what is the critical value?

1. Add the critical values to the graph below and shade the rejection region.

(Special Instruction: For this part, it is recommended that you do this by hand. You can print out this page and use the image below as a template to write on or you can create a handwritten normal curve. Take a photo of your graph and replace the image below with it. If you need any technical assistance with this process, pleaseemail Waldorf's tech support.)

1. Calculate the test statistic. Replace the ?s in the formula with the appropriate values. Round to the nearest hundredth.

1. Add the test statistic to your graph from part F, and insert the image below.

1. What is the P-value? View thevideo Hypothesis Testing for the Mean (Sigma Unknown) Part II to learn how to use Google Sheets to calculate the P-value of a t-test (transcript for Hypothesis Testing for the Mean (Sigma Unknown) Part II video).

?

1. Make a decision to reject or fail to reject the null hypothesis using eitherthe test statistic or theP-value. Note that the same conclusion will be reached using either method.

Fail to reject

1. Interpret the decision in the context of the original claim.

We failed to reject the null hypothesis. At the 0.05% level of significance, there is not enough evidence to support the claim that the average cost of tuition is higher than $10,230.

1. If you lower the level of significance to , does your decision change? Explain your reasoning.

1. Describe the type I and type II errors that could occur in our test by completing each of the following statements.

• A ____________ (type I, type II)error will occur when the actual mean of college tuition cost is ______________ (at most, at least)$10,230 but you reject the null hypothesis, .

• A ____________ (type I, type II)error will occur when the actual mean of college tuition cost is ______________ (less than, greater than)$10,230 but you fail to reject the null hypothesis, .