# Hypothesis Testing and Assessing Levels of Significance

Perform the following hypothesis tests on the data in spreadsheet HW #1. State the conclusion of the hypothesis tests. The level of significance is 0.05 in each test.

1. The claim that the average Median SAT is over 1200.

2. The claim that the proportion of schools with Expenditures/Student over $50,000 is 0.2.

3. The claim that there is no difference in mean Acceptance Rate between University and Liberal Arts College.

4. The claim that the variance of Median SAT is less than 4000.

https://brainmass.com/statistics/hypothesis-testing/hypothesis-testing-assessing-levels-significance-512284

#### Solution Preview

Hi there,

Thanks for letting me work on your post. Here is my explanation:

1. First, we use the formula in excel to figure out the mean and standard deviation.

mean=average(C2:C50)=1263.10, standard deviation=stdev(C2:C50)=62.6765 (Both average and stdev are functions in excel).

z=(1263.10)/(62.6765/sqrt(49))=7.05.

P(z>7.05)=1-P(z<7.05)=0.

Since P value is smaller than 0.05, we could conclude that the average Median SAT is over ...

#### Solution Summary

The expert examines hypothesis testing and assessing levels of significant.