Chat with us, powered by LiveChat During the global recession of 2008 and 2009, there were many accusations of unethical behavior by Wall Street executives, financial managers, and | EssayAbode

During the global recession of 2008 and 2009, there were many accusations of unethical behavior by Wall Street executives, financial managers, and

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. 

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.7112753478
Non_Bus Non_Ath Yes 0.4305740196
Non_Bus Ath No 0.5800199649
Bus Non_Ath Yes 0.712502204
Bus Non_Ath Yes 0.5059986034
Non_Bus Non_Ath Yes 0.7923525191
Non_Bus Ath Yes 0.6923199269
Non_Bus Non_Ath Yes 0.4725094357
Non_Bus Ath No 0.5616470978
Non_Bus Non_Ath No 0.1051796133
Non_Bus Ath Yes 0.0170799671
Non_Bus Non_Ath Yes 0.4482677838
Non_Bus Non_Ath No 0.6200706441
Non_Bus Non_Ath No 0.389997952
Bus Non_Ath Yes 0.3352558613
Non_Bus Non_Ath Yes 0.4327927019
Non_Bus Non_Ath Yes 0.4950502885
Bus Ath No 0.6441312155
Non_Bus Non_Ath Yes 0.894192155
Bus Ath No 0.6284949426
Non_Bus Ath No 0.8995951335
Bus Non_Ath Yes 0.2718817133
Bus Non_Ath Yes 0.9716950301
Bus Non_Ath Yes 0.4799357825
Bus Non_Ath Yes 0.0340225961
Bus Ath Yes 0.5793524816
Non_Bus Ath Yes 0.0939798091
Bus Ath No 0.5459055273
Bus Non_Ath Yes 0.1278275727
Bus Non_Ath Yes 0.8659585878
Bus Non_Ath No 0.8712285358
Bus Non_Ath Yes 0.2851895213
Bus Non_Ath Yes 0.2885514181
Non_Bus Ath No 0.0494438276
Bus Non_Ath No 0.304863446
Bus Non_Ath Yes 0.6694787003
Bus Ath Yes 0.9719570143
Bus Non_Ath Yes 0.2978503286
Bus Ath Yes 0.459403537
Non_Bus Ath No 0.1832227513
Non_Bus Non_Ath No 0.517817931
Bus Ath Yes 0.6427111896
Bus Non_Ath Yes 0.0342898795
Non_Bus Ath Yes 0.5844241334
Bus Ath Yes 0.9193847056
Bus Non_Ath Yes 0.3671714656
Non_Bus Ath No 0.6218549946
Bus Ath No 0.9047011714
Non_Bus Non_Ath Yes 0.2554249577
Non_Bus Ath Yes 0.3213803943
Bus Non_Ath Yes 0.6328279586
Bus Ath No 0.0686367731
Non_Bus Ath No 0.0461094771
Bus Ath Yes 0.8356373944
Non_Bus Non_Ath No 0.7036883744
Bus Non_Ath Yes 0.7230756981
Bus Non_Ath Yes 0.2525092725
Non_Bus Ath No 0.1995998653
Non_Bus Non_Ath No 0.4729557466
Non_Bus Ath No 0.7902564818
Non_Bus Ath No 0.6900972415
Non_Bus Ath No 0.4833916627
Non_Bus Ath Yes 0.7887382447
Non_Bus Ath Yes 0.3737391405
Bus Non_Ath Yes 0.5683911174
Bus Ath No 0.1447417078
Bus Ath No 0.9728584394
Bus Ath Yes 0.6293843829
Non_Bus Ath No 0.2247329092
Non_Bus Non_Ath Yes 0.65565279
Bus Ath Yes 0.6058694279
Bus Non_Ath Yes 0.7404994681
Non_Bus Non_Ath No 0.1330531741
Bus Non_Ath No 0.096142285
Non_Bus Non_Ath No 0.1138069037
Bus Non_Ath Yes 0.7394735392
Non_Bus Non_Ath No 0.3700980448
Non_Bus Ath Yes 0.6596608394
Non_Bus Ath No 0.6015988422
Non_Bus Non_Ath No 0.1413221352
Bus Ath Yes 0.3499420383
Non_Bus Non_Ath No 0.8453669283
Non_Bus Non_Ath Yes 0.5721587785
Bus Ath No 0.9328269202
Non_Bus Ath Yes 0.3367030047
Non_Bus Non_Ath Yes 0.3384756046
Non_Bus Non_Ath Yes 0.5540634029
Bus Ath No 0.0246132519
Non_Bus Ath Yes 0.8408377607
Non_Bus Ath Yes 0.4255351855
Non_Bus Non_Ath No 0.4402312768
Non_Bus Non_Ath Yes 0.114351386
Non_Bus Non_Ath Yes 0.17741275
Bus Non_Ath No 0.3948321689
Non_Bus Ath No 0.6959653401
Bus Ath Yes 0.734584607
Bus Ath No 0.2501444221
Bus Ath Yes 0.0618216056
Non_Bus Ath No 0.8384980036
Bus Non_Ath Yes 0.2788559694
Bus Non_Ath Yes 0.4975478098
Non_Bus Ath Yes 0.5608473953
Bus Ath Yes 0.8773253444
Bus Ath Yes 0.3692349048
Non_Bus Non_Ath No 0.7329329379
Non_Bus Non_Ath No 0.1822065272
Bus Non_Ath Yes 0.8097957047
Bus Ath Yes 0.1986927198
Non_Bus Ath No 0.1017504103
Non_Bus Non_Ath No 0.263241827
Bus Non_Ath Yes 0.7921050925
Bus Non_Ath Yes 0.6010921879
Bus Non_Ath No 0.804408602
Non_Bus Ath Yes 0.2825391665
Bus Non_Ath No 0.0642950096
Non_Bus Ath Yes 0.694895466
Non_Bus Ath No 0.3728732296
Non_Bus Non_Ath No 0.2672269766
Bus Ath No 0.3716969035
Non_Bus Ath Yes 0.4383879949
Non_Bus Non_Ath No 0.3922029312
Non_Bus Ath No 0.8336606811
Non_Bus Ath Yes 0.9803068996
Non_Bus Non_Ath No 0.4954980731
Bus Non_Ath Yes 0.3226917792
Bus Ath No 0.4640939981
Bus Ath No 0.1840082816
Non_Bus Non_Ath Yes 0.3842391979
Bus Non_Ath Yes 0.7227699615
Bus Ath Yes 0.3450524541
Non_Bus Ath No 0.7759151339
Bus Ath Yes 0.9718817972
Non_Bus Non_Ath No 0.5386718037
Bus Ath No 0.2046932639
Non_Bus Non_Ath Yes 0.0882075386
Bus Non_Ath No 0.2985873182
Non_Bus Non_Ath Yes 0.3473165721
Bus Ath Yes 0.3033326312
Bus Non_Ath Yes 0.355003074
Non_Bus Ath No 0.8441364475
Bus Non_Ath Yes 0.8784650326
Bus Ath No 0.9987074928
Bus Ath No 0.4047420395
Non_Bus Non_Ath Yes 0.581058939
Bus Non_Ath Yes 0.865726525
Non_Bus Non_Ath No 0.1026424528
Bus Non_Ath Yes 0.4493927042
Bus Non_Ath Yes 0.4275226278
Non_Bus Non_Ath Yes 0.6904659028
Bus Non_Ath Yes 0.9372142517
Bus Ath Yes 0.2795815943
Bus Ath Yes 0.4792792569
Bus Ath No 0.7974316142
Bus Ath Yes 0.39099578
Non_Bus Ath Yes 0.6873892675
Non_Bus Ath No 0.9764895466
Bus Ath Yes 0.2364536278
Bus Ath Yes 0.5152977086
Bus Non_Ath Yes 0.7485103342
Non_Bus Non_Ath No 0.1578466316
Non_Bus Ath Yes 0.1199260957
Bus Ath Yes 0.0630241888
Bus Ath No 0.016286921
Bus Non_Ath Yes 0.8674454263
Bus Non_Ath Yes 0.9612312641
Non_Bus Non_Ath Yes 0.3601639296
Bus Non_Ath Yes 0.6586050771
Bus Non_Ath Yes 0.2968960844
Non_Bus Non_Ath No 0.9460646352
Bus Ath Yes 0.7049741408
Bus Ath No 0.0599438086
Bus Ath No 0.1570620959
Bus Ath Yes 0.3682289028
Non_Bus Non_Ath Yes 0.9787776591
Non_Bus Non_Ath No 0.3698265304
Non_Bus Ath No 0.1264331618
Non_Bus Ath No 0.985631678
Bus Ath Yes 0.3939222387
Bus Non_Ath No 0.8819768147
Non_Bus Non_Ath No 0.3679965642
Bus Non_Ath Yes 0.3046042844
Non_Bus Non_Ath No 0.1973131619
Non_Bus Non_Ath No 0.5172376544
Non_Bus Non_Ath Yes 0.229266813
Bus Non_Ath Yes 0.7692493672
Bus Non_Ath Yes 0.3839877086
Bus Ath Yes 0.9076395853
Bus Ath No 0.6090779635
Bus Ath Yes 0.6975032933
Bus Ath Yes 0.8850737394
Bus Ath Yes 0.1651469082
Bus Ath Yes 0.3652736207
Non_Bus Non_Ath Yes 0.4616935948
Bus Non_Ath Yes 0.3635791133
Non_Bus Ath No 0.2297490009
Non_Bus Non_Ath Yes 0.7725363647
Non_Bus Ath Yes 0.9422520243
Non_Bus Ath No 0.5294121476
Non_Bus Non_Ath Yes 0.2443072365
Non_Bus Non_Ath Yes 0.6940244809
Bus Ath Yes 0.6309834095
Bus Non_Ath Yes 0.3415228138
Bus Non_Ath Yes 0.9646652797
Bus Non_Ath No 0.1665020828
Non_Bus Non_Ath Yes 0.1414538427
Non_Bus Non_Ath Yes 0.1302756453
Non_Bus Ath No 0.5847812513
Bus Ath Yes 0.5454792664
Bus Non_Ath No 0.6914721714
Bus Ath Yes 0.8004547435
Bus Non_Ath Yes 0.1517215239
Non_Bus Ath Yes 0.6197648434
Non_Bus Non_Ath No 0.3569186351
Bus Ath No 0.5847312728
Non_Bus Non_Ath No 0.843751841
Non_Bus Ath No 0.9670751538
Bus Ath No 0.1834812271
Bus Non_Ath Yes 0.4638893922
Non_Bus Ath No 0.0995245949
Non_Bus Ath No 0.0265944289
Bus Non_Ath No 0.2180242002
Bus Non_Ath Yes 0.5159346021
Bus Non_Ath Yes 0.5668808157
Non_Bus Ath Yes 0.1976340265
Bus Non_Ath Yes 0.3024223304
Bus Non_Ath Yes 0.0992958306
Non_Bus Non_Ath Yes 0.5295233117
Non_Bus Non_Ath Yes 0.7946662527
Bus Non_Ath Yes 0.3462773048
Non_Bus Ath Yes 0.2206577872
Bus Non_Ath Yes 0.0409246399
Non_Bus Ath No 0.7309932586
Non_Bus Non_Ath Yes 0.9077091491
Bus Non_Ath Yes 0.9393165225
Non_Bus Ath No 0.3784243768
Bus Non_Ath No 0.3385685545
Non_Bus Ath Yes 0.0521712803
Bus Non_Ath Yes 0.2106762014
Non_Bus Ath No 0.9790523272
Bus Non_Ath Yes 0.4505485844
Bus Non_Ath Yes 0.8764660498
Bus Non_Ath Yes 0.3456548521
Non_Bus Non_Ath No 0.3725565697
Bus Ath Yes 0.0486611988
Non_Bus Non_Ath No 0.3317648173
Non_Bus Non_Ath Yes 0.1002325277
Non_Bus Ath No 0.032185819
Non_Bus Ath Yes 0.805110385
Bus Non_Ath Yes 0.5138425185
Bus Non_Ath Yes 0.9333984665
Non_Bus Ath No 0.4256038553
Non_Bus Non_Ath No 0.016571758
Non_Bus Non_Ath Yes 0.0955359515
Non_Bus Non_Ath Yes 0.731654737
Bus Non_Ath Yes 0.1882241858
Non_Bus Ath No 0.9948318797
Bus Ath No 0.7689758387
Non_Bus Non_Ath No 0.6153255972
Non_Bus Non_Ath Yes 0.53301085
Non_Bus Ath Yes 0.2989164263
Bus Ath Yes 0.2422255384
Bus Non_Ath Yes 0.751657012
Non_Bus Ath No 0.9060328969
Bus Ath Yes 0.3595354286
Non_Bus Non_Ath No 0.2182473604
Bus Non_Ath Yes 0.6779822944
Non_Bus Ath Yes 0.6337965586
Bus Ath Yes 0.8135928646
Bus Non_Ath No 0.5252872216
Non_Bus Non_Ath Yes 0.8553072663
Bus Non_Ath Yes 0.206218432
Bus Ath No 0.1934696302
Bus Non_Ath Yes 0.2337600037
Non_Bus Non_Ath No 0.747116931
Bus Non_Ath Yes 0.07517537