SOLVE ON EXCEL ONLY

SOLVE ON EXCEL ONLY

1. Use descriptive statistics to summarize the data and comment on your findings.
2. Develop 95% confidence interval for the proportion of all students, the proportion of male students, and the proportion of female students who were involved in some type of cheating.
3. Conduct a hypothesis test to determine whether the proportion of business students at Bayview University who were involved in some type of cheating is less than that of business students at other institutions by the Chronicle of higher education.
4. Conduct a hypothesis test to determine whether the proportion of business students at Bayview University who were involved in some form of cheating is less than that of nonbusiness students at other institutions are reported by the Chronicles of Higher Education.

\f\f\f\f80 19 NO INU 81 80 No No No Female 82 81 No No No Female 83 82 No No No Male 84 83 No No No Male 85 84 No No No Female 86 85 No Yes Yes Male 87 86 No No No Male 88 87 No No Yes Male 89 88 No No No Male 90 89 No Yes Yes Male 91 90 No No No Female