Chat with us, powered by LiveChat Instructions ??for Data Analysis Component: ??1. ????????Make a pivot table with ‘Business Student’ (Rows), ??’Athlete’ (Rows), ‘Cheated’ (Columns | EssayAbode

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

<t

Related Tags

AcademicAPAAssignmentBusinessCapstoneCollegeConclusionCourseDayDiscussionDouble SpacedEssayEnglishFinanceGeneralGraduateHistoryInformationJustifyLiteratureManagementMarketMastersMathMinimumMLANursingOrganizationalOutlinePagesPaperPresentationQuestionsQuestionnaireReferenceResponseResponseSchoolSubjectSlidesSourcesStudentSupportTimes New RomanTitleTopicsWordWriteWriting

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