Statistics for Business & Economics Problem-During the global recession of 2008 and 2009…

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 that suggested 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 in 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 year’s 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?YesNoDuring your time at Rocky, did you ever copy answers off another student’s exam?YesNoDuring your time at Rocky, did you ever collaborate with other students on projects that were supposed to be completed individually?YesNoAny 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.Managerial ReportPrepare a report (see below) for the dean of the college that summarizes your assessment of the nature of cheating by business students at Rocky University. Be sure to include the following seven (7) items in your report.To summarize the data, compute the proportion of all students the proportion of all male students, and the proportion of all female students that presenteda. Work copied off the internet as their ownb. Copied answers off another student’s examc. Collaborated with other students on projects that were supposed to be completed individually.Then comment on your findings.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.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.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 another’s exam.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 individual project.Conduct a hypothesis test 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.What advice would you give to the dean based upon your analysis of the data?Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements. Items that should be included, but are not limited to are a title page, an introduction, a body which answers the questions posed in the problem and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments you should have in-text citations and a reference page too. Please include any tables of calculations, calculated values and graphs associated with this problem in the body.NOTE: Submitting your Excel file will aid in grading with partial credit if errors are found in the paper.Be sure that your report contains the following:A title pageAn introductionA body of the paper that answers the questions posed in the problem and calculations and graphs associated with this problem.A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.Be sure to submit your Excel file as well.