Ethical Behavior of Business Students at Bo Diddley Tech

Prepare a managerial report as part of your submission to the dean of the college that summarizes your assessment of the nature of cheating at BDT. Be sure to include the following items in your written report.
Utilize the data set provided by the instructor in the Excel spreadsheet, “Benchmark – Bo Diddley Tech Data Set” (60 records per student).
Submit the Excel data calculations (Alpha 0.05).
Make a pivot table with: Business Student (Rows), Athlete (Rows), Cheated (Columns), and Cheated (Summed Value).
Create a bar chart showing cheating by athletes and business students.
Determine if there is a statistical difference between nonathlete BDT business students and the national average for business students as reported by the Chronicle of Higher Education.
Determine if there is a statistical difference between athlete BDT business students and the national average for business students as reported by the Chronicle of Higher Education.
Determine if there is a statistical difference between BDT business students and the national average for business students as reported by the Chronicle of Higher Education.
Determine if there is a statistical difference between BDT nonbusiness students and the national average for nonbusiness students as reported by the Chronicle of Higher Education.
Utilizing the data you have analyzed, write a managerial report of 500-800 words for the dean. The managerial report needs to include an introduction, analysis, conclusion, and a minimum of three supporting references.
Introduction (Define): Explain, in your own words, why you are providing this report and the problem(s) you are trying to solve.
Collect: Describe the data set you used.
Organize: Describe your pivot table.
Visualize: Include and describe your bar chart.
Analyze: Provide a summary of your conclusions based on the four population proportion hypothesis tests.
Ethical Summary: The dean has expressed a concern related to the amount of cheating currently taking place at BDT and has strongly suggested that you “tweak” the statistical data such that they favor the image of the university. Discuss the potential use of unethical manipulation of statistical data to provide a biased outcome as well as the ethical counter proposal you would offer the dean in this scenario.
Conclusion: What advice would you give to the dean based upon your analysis of the data?