1. Pivot Table
	Bus	Non_Bus
total by school	51	49	100
athletes	25	29	54
non	26	19	45
ath yes	16	14	30
ath no	9	16	25
non yes	19	9	28
non no	7	10	17
	51	49	100

3-7 Hypothesis Test
Business Nonathlete vs. National Average
Proportion
Sample Size (n) =count(range)	19
Response of Interest (ROI)	Cheated
Count for Response (CFR) =COUNTIF(range,ROI)
Sample Proportion (pbar) =CFR/n