Visualize: Include and describe your bar chart and initial perceptions of outcomes.
Analyze: Provide a summary of your conclusions based on the four population proportion tests, a two-sample proportion test, and test for independence (refer to Chapter 5.2 in TSIY). Begin with the statement of Ho and Ha and whether it is an upper-, lower-, or 2-tailed test. Use the model results and decide whether to reject Ho using the critical values approach, p-value approach, and confidence interval estimation approach to hypothesis testing. Create a summary table of each the six 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? Include your “SummaryResults” table.
Reference page: Include at least three references to support the “Ethical Summary” section of your managerial report.
You are required to submit your Excel data analysis along with your written report.