Answer questions 1-6 on the attached excel spreadsheet.During the global recession of 2008 and 2009, there were many accusations of unethical behavior by Wall Street executives, financial managers, and other corporate officers. At that time, an article appeared suggesting that part of the reason for such unethical business behavior may stem from the fact that cheating has become more prevalent among business students. The article reported that 86% of business students admitted to cheating at some time during their academic career as compared to 77% of non-business students.Cheating has been a concern of the dean of the College of Business at Rocky University for several years. Some faculty members in the college believe that cheating is more widespread at Rocky than at other universities, while other faculty members think that cheating is not a major problem at the college. To resolve some of these issues, the dean commissioned a study to assess the current ethical behavior of business students at Rocky. As part of this study, an anonymous exit survey was administered to a sample of 90 business students from this years graduating class. Responses to the following questions were used to obtain data regarding three types of cheating.During your time at Rocky, did you ever present work copied off the internet as your own?____ Yes ____ NoDuring your time at Rocky, did you ever copy answers off another students exam?____ Yes ____ NoDuring your time at Rocky, did you ever collaborate with other students on projects that were supposed to be completed individually?____ Yes ____ NoAny student who answered yes to one or more of these questions was considered to have been involved in some type of cheating. The complete data set is in the file named Rocky, linked at the bottom of the page.1. To summarize the data, compute the proportion of all students, the proportion of all male students, and the proportion of all female students whoa.) presented work copied off the internet as their ownb.) copied answers off another students examc.)collaborated with other students on projects that were supposed to be completed individually.Then comment on your findings.2. Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in some type of cheating.3. Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in copying off the internet.4. Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in copying off anothers exam.5. Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in collaborating on an individual project.6. Conduct a hypothesis test (using either the p-value approach or the critical value approach) to determine if the proportion of all business students at Rocky University who were not involved in some type of cheating is less than that of all business students elsewhere. Use = 0.05. Do not forget to include the correctly worded hypotheses.