15 May Instructions ??for Data Analysis Component: ??1. ????????Make a pivot table with ‘Business Student’ (Rows), ??’Athlete’ (Rows), ‘Cheated’ (Columns
Instructions for Data Analysis Component: 1. Make a pivot table with "Business Student" (Rows), "Athlete" (Rows), "Cheated" (Columns), and "Cheated" (Summed Value). 2. Create a bar chart showing cheating by athletes and business students. 3. Determine whether 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 (test for a proportion).
Instructions
| Benchmark – Ethical Behavior of Business Students at Bo Diddley Tech | |
| 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 have stemmed from the fact that cheating had become more prevalent among business students, according to a February 10, 2009, article in the Chronicle of Higher Education. The article reported that 56% of business students admitted to cheating at some time during their academic career as compared to 47% of nonbusiness students. Cheating has been a concern of the dean of the College of Business (COB) at Bo Diddley Tech (BDT) for several years. Some faculty members believe that cheating is more widespread at BDT than at other universities, whereas other faculty members think that cheating is not a major problem in the College of Business. To begin to address these issues, the dean of COB commissioned a study to assess the current ethical behavior of business students at BDT. As a former college athlete herself, the dean believed that the spirit of fair play students developed as part of participating in athletics would make them less likely to cheat. As part of this study, an anonymous exit survey was administered to a sample of 1,440 students from this year's graduating class, half of whom were business students and half of whom were not. The survey asked various questions, including the student's college (business or nonbusiness) and if the student was an athlete or a nonathlete. Responses of the various questions were fed into a computer algorithm (advance data analytics) that made a quantitative determination as to whether the student should be considered a "cheater" or not. The results are in the attached Excel spreadsheet, "Overview – Benchmark – Ethical Behavior of Business Students at Bo Diddley Tech." Utilize the data set in the Excel spreadsheet and select a randomized 100-unit sample from the original 1,440 exit surveys. You will use the DCOVAS framework. Reference readings in The Statistician In You: Simple Everyday Life-Hacks (TSIY). | |
| The intent of this assignment is to organize your data using a pivot table, get a graphical understanding of the data through a bar chart, then do hypothesis testing comparing Bo Diddley Tech results versus the national average. | |
| · Define the problem. | |
| · Collect data from the appropriate source(s). | |
| · Organize data using tables. | |
| · Visualize data using a chart or graph. | |
| · Analyze data using a tool and/or calculation(s). | |
| · Solution: Provide a conclusion and solution. | |
| The intent of this assignment is to organize your data using a pivot table, get a graphical understanding of the data through a bar chart, then do hypothesis testing comparing Bo Diddley Tech results versus the national average. | |
| ***Note: First, sort the data from smallest to largest to change the order of the dataset.*** | |
| All of your analysis should be done in the "Student_BM" tab of this spreadsheet and submitted as part of the assignmemt. The locations where the pivot table, bar chart, and relevant information should be placed in the Student_BM tab are indicated by RED instructions. Copy the first 100 data points including the labels of Column D, E, and F. Paste data in Student_BM Worksheet | |
| Column G is a random number field and will keep changing. | |
| Once completed, the "Student_BM" tab will serve as the basis for writing your management report. It is expected that any conclusions you draw in the management report will be consistent with the data and analyses contained in the spreadsheet. | |
| Instructions for Data Analysis Component: | |
| 1. Make a pivot table with "Business Student" (Rows), "Athlete" (Rows), "Cheated" (Columns), and "Cheated" (Summed Value). | |
| 2. Create a bar chart showing cheating by athletes and business students. | |
| 3. Determine whether 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 (test for a proportion). | |
| 4. Determine whether there is a statistical significance to business athlete students at BDT cheating less than the national average for business students as reported by the Chronicle of Higher Education (test for a proportion). | |
| 5. Determine whether there is a statistical difference between BDT business students and the national average for business students as reported by the Chronicle of Higher Education. (test for a proportion). | |
| 6. Determine whether there is a statistical difference between BDT nonbusiness students and the national average for nonbusiness students as reported by the Chronicle of Higher Education (test for a proportion). | |
| 7. Determine whether there is a statistical difference between BDT business student-athletes and nonathletes (test for two sample proportions). | |
| 8. Determine whether there is a statistical relationship among the four groups of business athlete students, nonbusiness athlete students, business nonathlete students, and nonbusiness nonathlete students at BDT (chi-square test of independence). | |
| Instructions for Data Interpretation Component: | |
| 1. Introduction (define): In your own words, explain why you are providing this report and the problem(s) you are trying to solve. | |
| 2. Collect: Describe the data set you used. | |
| 3. Organize: Describe your pivot table. | |
| 4. Visualize: Include and describe your bar chart and initial perceptions of outcomes. | |
| 5. 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. | |
| 6. 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. | |
| 7. Conclusion: What advice would you give to the dean based upon your analysis of the data? Include your "SummaryResults" table. | |
| 8. Reference page: Include at least three references to support the "Ethical Summary" section of your managerial report. | |
| Review assigment directions for more details. | |
RawData
| College | Athlete | Cheated | recordShuffler | <– First, Sort data from Smallest to Largest | |
| Non_Bus | Non_Ath | Yes | 0.6860370441 | ||
| Non_Bus | Non_Ath | Yes | 0.6458010269 | ||
| Non_Bus | Ath | No | 0.3005032596 | ||
| Bus | Non_Ath | Yes | 0.2771678841 | ||
| Bus | Non_Ath | Yes | 0.7760938528 | ||
| Non_Bus | Non_Ath | Yes | 0.3881962633 | ||
| Non_Bus | Ath | Yes | 0.0621622464 | ||
| Non_Bus | Non_Ath | Yes | 0.3908951432 | ||
| Non_Bus | Ath | No | 0.324497564 | ||
| Non_Bus | Non_Ath | No | 0.8470943191 | ||
| Non_Bus | Ath | Yes | 0.0692165003 | ||
| Non_Bus | Non_Ath | Yes | 0.3089179601 | ||
| Non_Bus | Non_Ath | No | 0.2193596788 | ||
| Non_Bus | Non_Ath | No | 0.8324004802 | ||
| Bus | Non_Ath | Yes | 0.6836525661 | ||
| Non_Bus | Non_Ath | Yes | 0.3929634409 | ||
| Non_Bus | Non_Ath | Yes | 0.4637090939 | ||
| Bus | Ath | No | 0.9856849652 | ||
| Non_Bus | Non_Ath | Yes | 0.1153135196 | ||
| Bus | Ath | No | 0.5328338134 | ||
| Non_Bus | Ath | No | 0.9513050551 | ||
| Bus | Non_Ath | Yes | 0.8071331792 | ||
| Bus | Non_Ath | Yes | 0.972389617 | ||
| Bus | Non_Ath | Yes | 0.6511770651 | ||
| Bus | Non_Ath | Yes | 0.3230778045 | ||
| Bus | Ath | Yes | 0.5283968496 | ||
| Non_Bus | Ath | Yes | 0.757766588 | ||
| Bus | Ath | No | 0.0428905502 | ||
| Bus | Non_Ath | Yes | 0.1105615586 | ||
| Bus | Non_Ath | Yes | 0.2480002682 | ||
| Bus | Non_Ath | No | 0.1463933101 | ||
| Bus | Non_Ath | Yes | 0.7493771551 | ||
| Bus | Non_Ath | Yes | 0.5208310125 | ||
| Non_Bus | Ath | No | 0.7903620998 | ||
| Bus | Non_Ath | No | 0.5474555979 | ||
| Bus | Non_Ath | Yes | 0.8980609388 | ||
| Bus | Ath | Yes | 0.8194889183 | ||
| Bus | Non_Ath | Yes | 0.1910283715 | ||
| Bus | Ath | Yes | 0.6169409302 | ||
| Non_Bus | Ath | No | 0.7096011954 | ||
| Non_Bus | Non_Ath | No | 0.4496709828 | ||
| Bus | Ath | Yes | 0.3012355702 | ||
| Bus | Non_Ath | Yes | 0.8869449816 | ||
| Non_Bus | Ath | Yes | 0.3319594908 | ||
| Bus | Ath | Yes | 0.9472258781 | ||
| Bus | Non_Ath | Yes | 0.9914567613 | ||
| Non_Bus | Ath | No | 0.2195410328 | ||
| Bus | Ath | No | 0.341407052 | ||
| Non_Bus | Non_Ath | Yes | 0.4404465764 | ||
| Non_Bus | Ath | Yes | 0.2363942724 | ||
| Bus | Non_Ath | Yes | 0.5145596028 | ||
| Bus | Ath | No | 0.2448798604 | ||
| Non_Bus | Ath | No | 0.5884419619 | ||
| Bus | Ath | Yes | 0.7276743093 | ||
| Non_Bus | Non_Ath | No | 0.155406285 | ||
| Bus | Non_Ath | Yes | 0.4629179634 | ||
| Bus | Non_Ath | Yes | 0.4716633659 | ||
| Non_Bus | Ath | No | 0.0306971433 | ||
| Non_Bus | Non_Ath | No | 0.3919758992 | ||
| Non_Bus | Ath | No | 0.4942416201 | ||
| Non_Bus | Ath | No | 0.8555194488 | ||
| Non_Bus | Ath | No | 0.8188737657 | ||
| Non_Bus | Ath | Yes | 0.1367678522 | ||
| Non_Bus | Ath | Yes | 0.5346574077 | ||
| Bus | Non_Ath | Yes | 0.4595572547 | ||
| Bus | Ath | No | 0.0660741532 | ||
| Bus | Ath | No | 0.7009096072 | ||
| Bus | Ath | Yes | 0.1733123527 | ||
| Non_Bus | Ath | No | 0.7335227379 | ||
| Non_Bus | Non_Ath | Yes | 0.4653648246 | ||
| Bus | Ath | Yes | 0.9112222939 | ||
| Bus | Non_Ath | Yes | 0.2884203221 | ||
| Non_Bus | Non_Ath | No | 0.6068193413 | ||
| Bus | Non_Ath | No | 0.7418446065 | ||
| Non_Bus | Non_Ath | No | 0.008684653 | ||
| Bus | Non_Ath | Yes | 0.5163563263 | ||
| Non_Bus | Non_Ath | No | 0.8139929935 | ||
| Non_Bus | Ath | Yes | 0.6761129126 | ||
| Non_Bus | Ath | No | 0.5172077313 | ||
| Non_Bus | Non_Ath | No | 0.0216180259 | ||
| Bus | Ath | Yes | 0.9130885554 | ||
| Non_Bus | Non_Ath | No | 0.439117215 | ||
| Non_Bus | Non_Ath | Yes | 0.0183507092 | ||
| Bus | Ath | No | 0.9275130909 | ||
| Non_Bus | Ath | Yes | 0.6406221496 | ||
| Non_Bus | Non_Ath | Yes | 0.9771891819 | ||
| Non_Bus | Non_Ath | Yes | 0.8501707636 | ||
| Bus | Ath | No | 0.1949083795 | ||
| Non_Bus | Ath | Yes | 0.1445697946 | ||
| Non_Bus | Ath | Yes | 0.1683865994 | ||
| Non_Bus | Non_Ath | No | 0.8006357682 | ||
| Non_Bus | Non_Ath | Yes | 0.045507707 | ||
| Non_Bus | Non_Ath | Yes | 0.8998406174 | ||
| Bus | Non_Ath | No | 0.1844362078 | ||
| Non_Bus | Ath | No | 0.8925824553 | ||
| Bus | Ath | Yes | 0.552916457 | ||
| Bus | Ath | No | 0.2170841073 | ||
| Bus | Ath | Yes | 0.5032056933 | ||
| Non_Bus | Ath | No | 0.0240893802 | ||
| Bus | Non_Ath | Yes | 0.8285496594 | ||
| Bus | Non_Ath | Yes | 0.3959450234 | ||
| Non_Bus | Ath | Yes | 0.2739310575 | ||
| Bus | Ath | Yes | 0.823416122 | ||
| Bus | Ath | Yes | 0.0268415133 | ||
| Non_Bus | Non_Ath | No | 0.7812885017 | ||
| Non_Bus | Non_Ath | No | 0.7767353513 | ||
| Bus | Non_Ath | Yes | 0.4732408451 | ||
| Bus | Ath | Yes | 0.4716884783 | ||
| Non_Bus | Ath | No | 0.6080792991 | ||
| Non_Bus | Non_Ath | No | 0.1475310049 | ||
| Bus | Non_Ath | Yes | 0.8649684219 | ||
| Bus | Non_Ath | Yes | 0.0287861288 | ||
| Bus | Non_Ath | No | 0.8476425303 | ||
| Non_Bus | Ath | Yes | 0.9111009666 | ||
| Bus | Non_Ath | No | 0.5568842639 | ||
| Non_Bus | Ath | Yes | 0.883216775 | ||
| Non_Bus | Ath | No | 0.8780053304 | ||
| Non_Bus | Non_Ath | No | 0.4483455106 | ||
| Bus | Ath | No | 0.0503581438 | ||
| Non_Bus | Ath | Yes | 0.2118860359 | ||
| Non_Bus | Non_Ath | No | 0.0961414712 | ||
| Non_Bus | Ath | No | 0.1077632912 | ||
| Non_Bus | Ath | Yes | 0.4897929841 | ||
| Non_Bus | Non_Ath | No | 0.4293298928 | ||
| Bus | Non_Ath | Yes | 0.7317120681 | ||
| Bus | Ath | No | 0.44372603 | ||
| Bus | Ath | No | 0.5077706617 | ||
| Non_Bus | Non_Ath | Yes | 0.9329226698 | ||
| Bus | Non_Ath | Yes | 0.5645920906 | ||
| Bus | Ath | Yes | 0.281860834 | ||
| Non_Bus | Ath | No | 0.5680178768 | ||
| Bus | Ath | Yes | 0.3229965862 | ||
| Non_Bus | Non_Ath | No | 0.6329105998 | ||
| Bus | Ath | No | 0.742657669 | ||
| Non_Bus | Non_Ath | Yes | 0.9933035824 | ||
| Bus | Non_Ath | No | 0.9189788734 | ||
| Non_Bus | Non_Ath | Yes | 0.5927801112 | ||
| Bus | Ath | Yes | 0.4575239164 | ||
| Bus | Non_Ath | Yes | 0.3585603786 | ||
| Non_Bus | Ath | No | 0.9107768963 | ||
| Bus | Non_Ath | Yes | 0.6954767424 | ||
| Bus | Ath | No | 0.6492323434 | ||
| Bus | Ath | No | 0.3279575388 | ||
| Non_Bus | Non_Ath | Yes | 0.2655936924 | ||
| Bus | Non_Ath | Yes | 0.0229430561 | ||
| Non_Bus | Non_Ath | No | 0.6694272982 | ||
| Bus | Non_Ath | Yes | 0.5286568006 | ||
| Bus | Non_Ath | Yes | 0.1611387741 | ||
| Non_Bus | Non_Ath | Yes | 0.2017723471 | ||
| Bus | Non_Ath | Yes | 0.843089371 | ||
| Bus | Ath | Yes | 0.1252444307 | ||
| Bus | Ath | Yes | 0.5830704524 | ||
| Bus | Ath | No | 0.95270018 | ||
| Bus | Ath | Yes | 0.5078069717 | ||
| Non_Bus | Ath | Yes | 0.1010452763 | ||
| Non_Bus | Ath | No | 0.1467611161 | ||
| Bus | Ath | Yes | 0.3131666639 | ||
| Bus | Ath | Yes | 0.2472295822 | ||
| Bus | Non_Ath | Yes | 0.0928150578 | ||
| Non_Bus | Non_Ath | No | 0.0680522441 | ||
| Non_Bus | Ath | Yes | 0.2249735458 | ||
| Bus | Ath | Yes | 0.6016399922 | ||
| Bus | Ath | No | 0.1307743762 | ||
| Bus | Non_Ath | Yes | 0.4617673519 | ||
| Bus | Non_Ath | Yes | 0.3440239672 | ||
| Non_Bus | Non_Ath | Yes | 0.2909621884 | ||
| Bus | Non_Ath | Yes | 0.961590957 | ||
| Bus | Non_Ath | Yes | 0.0067033601 | ||
| Non_Bus | Non_Ath | No | 0.9955563457 | ||
| Bus | Ath | Yes | 0.7875765355 | ||
| Bus | Ath | No | 0.5439031065 | ||
| Bus | Ath | No | 0.5701835754 | ||
| Bus | Ath | Yes | 0.9443950825 | ||
| Non_Bus | Non_Ath | Yes | 0.1969700925 | ||
| Non_Bus | Non_Ath | No | 0.7624928129 | ||
| Non_Bus | Ath | No | 0.757660242 | ||
| Non_Bus | Ath | No | 0.5131994319 | ||
| Bus | Ath | Yes | 0.9156948732 | ||
| Bus | Non_Ath | No | 0.216706457 | ||
| Non_Bus | Non_Ath | No | 0.722902657 | ||
| Bus | Non_Ath | Yes | 0.4061574729 | ||
| Non_Bus | Non_Ath | No | 0.535763621 | ||
| Non_Bus | Non_Ath | No | 0.245795251 | ||
| Non_Bus | Non_Ath | Yes | 0.6454357571 | ||
| Bus | Non_Ath | Yes | 0.2442140827 | ||
| Bus | Non_Ath | Yes | 0.1795804802 | ||
| Bus | Ath | Yes | 0.6982319752 | ||
| Bus | Ath | No | 0.409484205 | ||
| Bus | Ath | Yes | 0.6548890504 | ||
| Bus | Ath | Yes | 0.4353167978 | ||
| Bus | Ath | Yes | 0.7214794544 | ||
| Bus | Ath | Yes | 0.8160310973 | ||
| Non_Bus | Non_Ath | Yes | 0.005104097 | ||
| Bus | Non_Ath | Yes | 0.7686414794 | ||
| Non_Bus | Ath | No | 0.8181551802 | ||
| Non_Bus | Non_Ath | Yes | 0.4748509691 | ||
| Non_Bus | Ath | Yes | 0.9022549047 | ||
| Non_Bus | Ath | No | 0.5604779311 | ||
| Non_Bus | Non_Ath | Yes | 0.6146623723 | ||
| Non_Bus | Non_Ath | Yes | 0.0635815079 | ||
| Bus | Ath | Yes | 0.3654536854 | ||
| Bus | Non_Ath | Yes | 0.4571876327 | ||
| Bus | Non_Ath | Yes | 0.6484894484 | ||
| Bus | Non_Ath | No | 0.9207683164 | ||
| Non_Bus | Non_Ath | Yes | 0.8095084145 | ||
| Non_Bus | Non_Ath | Yes | 0.3181524887 | ||
| Non_Bus | Ath | No | 0.1925211566 | ||
| Bus | Ath | Yes | 0.6166376418 | ||
| Bus | Non_Ath | No | 0.1662850506 | ||
| Bus | Ath | Yes | 0.7410965618 | ||
| Bus | Non_Ath | Yes | 0.075925376 | ||
| Non_Bus | Ath | Yes | 0.7302089844 | ||
| Non_Bus | Non_Ath | No | 0.3889784002 | ||
| Bus | Ath | No | 0.0252267721 | ||
| Non_Bus | Non_Ath | No | 0.2524607662 | ||
| Non_Bus | Ath | No | 0.7213023376 | ||
| Bus | Ath | No | 0.8057619151 | ||
| Bus | Non_Ath | Yes | 0.5310242609 | ||
| Non_Bus | Ath | No | 0.8842536637 | ||
| Non_Bus | Ath | No | 0.6334909691 | ||
| Bus | Non_Ath | No | 0.0177417325 | ||
| Bus | Non_Ath | Yes | 0.2887296584 | ||
| Bus | Non_Ath | Yes | 0.2621850409 | ||
| Non_Bus | Ath | Yes | 0.361327931 | ||
| Bus | Non_Ath | Yes | 0.8934716819 | ||
| Bus | Non_Ath | Yes | 0.4157614108 | ||
| Non_Bus | Non_Ath | Yes | 0.8915407619 | ||
| Non_Bus | Non_Ath | Yes | 0.0819592673 | ||
| Bus | Non_Ath | Yes | 0.8418333072 | ||
| Non_Bus | Ath | Yes | 0.3600929504 | ||
| Bus | Non_Ath | Yes | 0.798421429 | ||
| Non_Bus | Ath | No | 0.6099961433 | ||
| Non_Bus | Non_Ath | Yes | 0.9058334083 | ||
| Bus | Non_Ath | Yes | 0.4276901598 | ||
| Non_Bus | Ath | No | 0.0701655603 | ||
| Bus | Non_Ath | No | 0.9867057921 | ||
| Non_Bus | Ath | Yes | 0.0757827176 | ||
| Bus | Non_Ath | Yes | 0.7977512807 | ||
| Non_Bus | Ath | No | 0.0739439987 | ||
| Bus | Non_Ath | Yes | 0.4162777222 | ||
| Bus | Non_Ath | Yes | 0.8677692537 | ||
| Bus | Non_Ath | Yes | 0.8383543899 | ||
| Non_Bus | Non_Ath | No | 0.3425939577 | ||
| Bus | Ath | Yes | 0.3728085044 | ||
| Non_Bus | Non_Ath | No | 0.2613102738 | ||
| Non_Bus | Non_Ath | Yes | 0.3586968947 | ||
| Non_Bus | Ath | No | 0.2632501 | ||
| Non_Bus | Ath | Yes | 0.7715030974 | ||
| Bus | Non_Ath | Yes | 0.0307531453 | ||
| Bus | Non_Ath | Yes | 0.144818836 | ||
| Non_Bus | Ath | No | 0.2050061722 | ||
| Non_Bus | Non_Ath | No | 0.6285951401 | ||
| Non_Bus | Non_Ath | Yes | 0.0215474898 | ||
| Non_Bus | Non_Ath | Yes | 0.3697538547 | ||
| Bus | Non_Ath | Yes | 0.6411031875 | ||
| Non_Bus | Ath | No | 0.9035934777 | ||
| Bus | Ath | No | 0.6596090903 | ||
| Non_Bus | Non_Ath | No | 0.677972778 | ||
| Non_Bus | Non_Ath | Yes | 0.8839941439 | ||
| Non_Bus | Ath | Yes | 0.3106330839 | ||
| Bus | Ath | Yes | 0.1036625943 | ||
| Bus | Non_Ath | Yes | 0.7597908444 | ||
| Non_Bus | Ath | No | 0.840684987 | ||
| Bus | Ath | Yes | 0.1203156498 | ||
| Non_Bus | Non_Ath | No | 0.4351941787 | ||
| Bus | Non_Ath | Yes | 0.4841716953 | ||
| Non_Bus | Ath | Yes | 0.9386952508 | ||
| Bus | Ath | Yes | 0.9451203034 | ||
| Bus | Non_Ath | No | 0.494227172 | ||
| Non_Bus | Non_Ath | Yes | 0.8946000168 | ||
| Bus | Non_Ath | Yes | 0.8134401315 | ||
| Bus | Ath | No | 0.1806810062 | ||
| Bus | Non_Ath | Yes | 0.6315324441 | ||
| Non_Bus | Non_Ath | No | 0.9623537224 | ||
| Bus | Non_Ath | Yes | 0.4296418769 |
