State the conclusion of the hypothesis tests

Question

Discuss te below:

Perform the following hypothesis tests on the data in spreadsheet. 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.

School	Type	Median SAT	Acceptance Rate	Expenditures/Student
Amherst	Lib Arts	1315	22%	$                             26,636
Barnard	Lib Arts	1220	53%	$                             17,653
Bates	Lib Arts	1240	36%	$                             17,554
Berkeley	University	1176	37%	$                             23,665
Bowdoin	Lib Arts	1300	24%	$                             25,703
Brown	University	1281	24%	$                             24,201
Bryn Mawr	Lib Arts	1255	56%	$                             18,847
Cal Tech	University	1400	31%	$                           102,262
Carleton	Lib Arts	1300	40%	$                             15,904
Carnegie Mellon	University	1225	64%	$                             33,607
Claremont McKenna	Lib Arts	1260	36%	$                             20,377
Colby	Lib Arts	1200	46%	$                             18,872
Colgate	Lib Arts	1258	38%	$                             17,520
Columbia	University	1268	29%	$                             45,879
Cornell	University	1280	30%	$                             37,137
Davisdson	Lib Arts	1230	36%	$                             17,721
Duke	University	1310	25%	$                             39,504
Georgetown	University	1278	24%	$                             23,115
Grinnell	Lib Arts	1244	67%	$                             22,301
Hamilton	Lib Arts	1215	38%	$                             20,722
Harvard	University	1370	18%	$                             46,918
Haverford	Lib Arts	1285	35%	$                             19,418
Johns Hopkins	University	1290	48%	$                             45,460
Middlebury	Lib Arts	1255	25%	$                             24,718
MIT	University	1357	30%	$                             56,766
Mount Holyoke	Lib Arts	1200	61%	$                             23,358
Northwestern	University	1230	47%	$                             28,851
Oberlin	Lib Arts	1247	54%	$                             23,591
Occidental	Lib Arts	1170	49%	$                             20,192
Pomona	Lib Arts	1320	33%	$                             26,668
Princeton	University	1340	17%	$                             48,123
Rice	University	1327	24%	$                             26,730
Smith	Lib Arts	1195	57%	$                             25,271
Stanford	University	1370	18%	$                             61,921
Swarthnore	Lib Arts	1310	24%	$                             27,487
U Michigan	University	1195	60%	$                             21,853
U of Chicago	University	1300	45%	$                             38,937
U of Rochester	University	1155	56%	$                             38,597
U Pennsylvania	University	1280	41%	$                             30,882
U Va	University	1218	37%	$                             19,365
UCLA	University	1142	43%	$                             26,859
UNC	University	1109	32%	$                             19,684
Vassar	Lib Arts	1287	43%	$                             20,179
Washington U (MO)	University	1225	54%	$                             39,883
Washinton and Lee	Lib Arts	1234	29%	$                             17,998
Wellesley	Lib Arts	1250	49%	$                             27,879
Wesleyan (CT)	Lib Arts	1290	35%	$                             19,948
Williams	Lib Arts	1336	28%	$                             23,772
Yale	University	1350	19%	$                             52,468