need someone good expert in statistics and probability and research

profilenecolas00073
BUS-352-RS-Benchmark_BoDiddleyTech-Student21.xlsx
Home>Business & Finance homework help>Economics homework help>need someone good expert in statistics and probability and research

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 Ath Yes 0.1467284802
Non_Bus Non_Ath Yes 0.2988605685
Bus Non_Ath No 0.0881414197
Non_Bus Non_Ath Yes 0.0975662711
Bus Ath Yes 0.5781271085
Bus Non_Ath Yes 0.594061819
Non_Bus Ath Yes 0.4358395301
Bus Ath No 0.3193715403
Non_Bus Ath Yes 0.3137900372
Non_Bus Non_Ath Yes 0.460020641
Non_Bus Ath No 0.1200931525
Bus Ath No 0.9217496914
Bus Ath No 0.3622192587
Non_Bus Non_Ath Yes 0.0225954716
Bus Non_Ath Yes 0.9858363676
Bus Ath Yes 0.7966659137
Bus Non_Ath No 0.7162039435
Non_Bus Non_Ath No 0.8047715953
Non_Bus Ath No 0.8886569907
Non_Bus Non_Ath No 0.577326537
Non_Bus Ath No 0.2189774175
Bus Non_Ath Yes 0.9199484974
Bus Ath Yes 0.9503020946
Bus Ath Yes 0.9013796302
Bus Non_Ath No 0.2711488953
Non_Bus Ath Yes 0.7522127813
Bus Ath Yes 0.7362228597
Non_Bus Ath Yes 0.0853616687
Non_Bus Non_Ath No 0.8362270961
Bus Ath No 0.1601853933
Non_Bus Non_Ath No 0.6343337431
Non_Bus Ath Yes 0.5339760819
Non_Bus Non_Ath No 0.0891704882
Non_Bus Non_Ath Yes 0.5241362391
Bus Non_Ath No 0.8524442132
Bus Ath No 0.8253643867
Bus Non_Ath Yes 0.8294054786
Non_Bus Ath No 0.471717217
Bus Non_Ath Yes 0.5575376151
Non_Bus Non_Ath No 0.9417531364
Non_Bus Non_Ath Yes 0.9383662826
Bus Non_Ath Yes 0.41008536
Non_Bus Ath No 0.324923701
Non_Bus Non_Ath Yes 0.2154022915
Bus Non_Ath Yes 0.58824897
Bus Non_Ath Yes 0.4242249762
Non_Bus Non_Ath Yes 0.4606412899
Non_Bus Ath No 0.293596119
Non_Bus Ath No 0.660833503
Non_Bus Non_Ath No 0.6200729974
Bus Ath No 0.5644844983
Bus Non_Ath Yes 0.146953221
Non_Bus Ath No 0.3006835823
Bus Non_Ath Yes 0.9510279767
Bus Ath No 0.2675072736
Non_Bus Non_Ath Yes 0.3058848186
Bus Non_Ath Yes 0.4853936523
Bus Non_Ath Yes 0.4259245713
Non_Bus Ath Yes 0.5459301845
Bus Non_Ath No 0.3825531773
Bus Non_Ath Yes 0.3665597499
Bus Non_Ath Yes 0.9438724275
Non_Bus Non_Ath No 0.1359084541
Non_Bus Non_Ath No 0.2152573111
Non_Bus Ath No 0.1639938971
Bus Non_Ath Yes 0.1175790738
Bus Non_Ath Yes 0.8381517735
Bus Non_Ath No 0.4877496496
Bus Non_Ath No 0.4453068503
Bus Ath No 0.2158587766
Non_Bus Ath Yes 0.9505403841
Bus Ath Yes 0.4729392204
Bus Ath Yes 0.7237317387
Non_Bus Non_Ath No 0.8762786245
Non_Bus Non_Ath No 0.8854341274
Non_Bus Non_Ath No 0.8328416027
Bus Non_Ath Yes 0.3099947047
Non_Bus Non_Ath No 0.9965093063
Non_Bus Non_Ath No 0.9861908602
Bus Ath Yes 0.8041121747
Non_Bus Ath No 0.2319397028
Bus Ath Yes 0.6355877651
Bus Ath No 0.3881027226
Bus Ath Yes 0.3054546111
Bus Non_Ath Yes 0.7807041551
Non_Bus Ath Yes 0.7187603641
Bus Non_Ath Yes 0.2620180796
Bus Non_Ath Yes 0.715240743
Bus Non_Ath Yes 0.3864724716
Bus Non_Ath Yes 0.3464698028
Bus Ath No 0.6431708068
Non_Bus Non_Ath No 0.8895744014
Bus Ath Yes 0.9175100812
Non_Bus Non_Ath No 0.7830596967
Bus Ath No 0.8657115197
Bus Non_Ath Yes 0.8108989833
Bus Ath No 0.9120714699
Non_Bus Non_Ath No 0.5084428359
Non_Bus Ath No 0.5441437852
Bus Non_Ath Yes 0.1632969017
Bus Ath Yes 0.6376850659
Non_Bus Non_Ath No 0.3471161246
Non_Bus Non_Ath Yes 0.5377302661
Non_Bus Ath Yes 0.8588884199
Non_Bus Ath No 0.6928908672
Bus Non_Ath Yes 0.7272980469
Non_Bus Ath No 0.5461385781
Bus Ath Yes 0.7027168827
Bus Ath Yes 0.3615770779
Bus Non_Ath Yes 0.7179316159
Bus Ath No 0.0144712781
Bus Ath Yes 0.0104309084
Non_Bus Non_Ath Yes 0.0383883504
Non_Bus Ath Yes 0.9679813234
Non_Bus Ath No 0.3897386004
Non_Bus Ath No 0.4102062121
Bus Ath Yes 0.6808782761
Bus Non_Ath Yes 0.2451809106
Non_Bus Ath Yes 0.6548667276
Bus Non_Ath Yes 0.8865296937
Non_Bus Ath No 0.4421222873
Bus Ath Yes 0.5093983621
Bus Non_Ath Yes 0.230298631
Bus Non_Ath Yes 0.0777657081
Non_Bus Non_Ath No 0.7103545468
Bus Non_Ath Yes 0.7961082565
Bus Non_Ath Yes 0.9740560988
Bus Ath No 0.662656215
Bus Ath No 0.4736203557
Non_Bus Non_Ath No 0.916586201
Bus Ath Yes 0.6802343928
Bus Non_Ath Yes 0.6143390075
Bus Non_Ath Yes 0.3787813982
Non_Bus Ath Yes 0.8980193628
Bus Non_Ath Yes 0.3267140238
Bus Ath Yes 0.2609067818
Bus Non_Ath Yes 0.5743317474
Bus Ath No 0.4050852584
Non_Bus Ath No 0.5215116725
Bus Ath Yes 0.7443592072
Non_Bus Ath Yes 0.3669596457
Bus Ath Yes 0.0847776362
Non_Bus Non_Ath Yes 0.2723596286
Non_Bus Ath No 0.8340407185
Bus Non_Ath Yes 0.7779881664
Non_Bus Ath Yes 0.709494264
Non_Bus Ath Yes 0.2612487432
Bus Non_Ath Yes 0.7789976469
Non_Bus Non_Ath Yes 0.1361014831
Non_Bus Non_Ath No 0.0667351216
Bus Non_Ath Yes 0.7524982467
Bus Non_Ath No 0.8238131512
Non_Bus Non_Ath Yes 0.9921885694
Non_Bus Non_Ath Yes 0.8397214244
Bus Non_Ath Yes 0.8832559213
Non_Bus Ath No 0.0136455976
Bus Ath Yes 0.4788502061
Bus Ath Yes 0.516035605
Bus Ath Yes 0.7599863733
Non_Bus Non_Ath No 0.5921612464
Bus Non_Ath No 0.6370306415
Bus Ath Yes 0.1304858279
Non_Bus Ath No 0.9007100434
Non_Bus Ath No 0.8360358178
Non_Bus Ath No 0.7735225719
Bus Ath Yes 0.7466458229
Bus Ath Yes 0.0408841982
Bus Ath Yes 0.4848678755
Bus Ath No 0.7373567204
Bus Ath Yes 0.9692185066
Non_Bus Non_Ath Yes 0.4289009593
Non_Bus Non_Ath Yes 0.8748206059
Non_Bus Non_Ath Yes 0.108968083
Bus Ath No 0.7762236166
Bus Ath Yes 0.718641315
Non_Bus Ath Yes 0.6920665234
Non_Bus Non_Ath Yes 0.3747989142
Bus Non_Ath Yes 0.1742577433
Non_Bus Ath Yes 0.2667499812
Bus Non_Ath Yes 0.5164219945
Non_Bus Ath No 0.0075241544
Non_Bus Ath No 0.4224438008
Non_Bus Non_Ath Yes 0.869769888
Non_Bus Non_Ath Yes 0.2693244053
Bus Ath No 0.6260943383
Non_Bus Ath No 0.9150109205
Non_Bus Ath Yes 0.564156095
Bus Ath Yes 0.9518016755
Non_Bus Non_Ath No 0.7256716959
Bus Ath No 0.8963060875
Bus Non_Ath Yes 0.4114128499
Non_Bus Non_Ath No 0.0527483546
Bus Non_Ath Yes 0.4108784969
Non_Bus Ath Yes 0.977563473
Non_Bus Ath No 0.565369905
Non_Bus Ath Yes 0.3663284033
Non_Bus Ath Yes 0.3220095689
Bus Non_Ath Yes 0.0801577116
Bus Non_Ath No 0.2704817277
Bus Non_Ath Yes 0.9556925017
Bus Ath No 0.2546137547
Non_Bus Ath Yes 0.2739687681
Non_Bus Ath Yes 0.7247873773
Non_Bus Non_Ath No 0.5015066094
Bus Non_Ath No 0.5622246386
Bus Non_Ath Yes 0.3774874193
Non_Bus Non_Ath Yes 0.9798191671
Bus Non_Ath Yes 0.1966332885
Non_Bus Non_Ath No 0.9031739259
Non_Bus Ath No 0.0535508301
Bus Non_Ath Yes 0.2091251734
Bus Ath No 0.5664503299
Non_Bus Ath Yes 0.249923726
Bus Non_Ath Yes 0.8298885309
Non_Bus Non_Ath Yes 0.0820483312
Non_Bus Non_Ath No 0.6613176731
Non_Bus Ath Yes 0.331853313
Non_Bus Ath No 0.1261481692
Bus Non_Ath Yes 0.0677457218
Non_Bus Ath No 0.3240534353
Non_Bus Non_Ath Yes 0.9435956189
Bus Ath No 0.0244627693
Non_Bus Non_Ath Yes 0.5700862678
Bus Ath Yes 0.6662412287
Non_Bus Non_Ath No 0.3773427878
Non_Bus Non_Ath No 0.141497803
Non_Bus Non_Ath No 0.4756020882
Bus Non_Ath Yes 0.5100339899
Non_Bus Non_Ath Yes 0.0033185036
Non_Bus Ath No 0.438705741
Bus Non_Ath Yes 0.9796938241
Non_Bus Non_Ath No 0.3362771789
Bus Non_Ath Yes 0.4588431828
Non_Bus Ath No 0.3031421424
Bus Ath No 0.4541250277
Non_Bus Non_Ath Yes 0.3539837486
Bus Ath No 0.3725227008
Non_Bus Non_Ath Yes 0.773504475
Bus Ath No 0.8102592595
Non_Bus Non_Ath Yes 0.8204725603
Non_Bus Non_Ath No 0.2605711139
Bus Non_Ath Yes 0.5196745896
Bus Non_Ath Yes 0.9092647521
Bus Ath No 0.4864262962
Bus Ath No 0.9592807519
Bus Ath Yes 0.9025599479
Bus Non_Ath Yes 0.6083888029
Non_Bus Ath No 0.4356284721
Non_Bus Non_Ath No 0.0448506017
Non_Bus Ath Yes 0.2432952467
Bus Non_Ath Yes 0.854548322
Non_Bus Ath No 0.5086111746
Bus Non_Ath Yes 0.9025905967
Non_Bus Non_Ath Yes 0.4855592521
Non_Bus Non_Ath Yes 0.2344291577
Non_Bus Ath No 0.4545801573
Non_Bus Non_Ath No 0.0552617114
Bus Non_Ath Yes 0.2410342504
Non_Bus Ath No 0.8821237099
Bus Ath No 0.4138502894
Non_Bus Non_Ath Yes 0.7284517449
Non_Bus Non_Ath No 0.7552999068
Bus Non_Ath No 0.7481273347
Non_Bus Non_Ath No 0.3310068986
Non_Bus Ath No 0.8540325276
Bus Ath Yes 0.2593979094
Bus Ath Yes 0.2264962899
Bus Non_Ath No 0.2981034382
Bus Ath No 0.1706751007
Bus Ath No 0.2730274373
Non_Bus Non_Ath No 0.4467849462
Bus Non_Ath No 0.5725945759
Non_Bus Ath Yes 0.9045551363
Non_Bus Ath No 0.6272500094
Bus Ath No 0.4124525034
Bus Ath Yes 0.359559214
Bus Non_Ath Yes 0.4406846858
Non_Bus Non_Ath No 0.5594646885
Bus Ath Yes 0.6887153422
Bus Ath Yes 0.7767646783
Non_Bus Non_Ath Yes 0.1566213673
Bus Non_Ath Yes 0.4582644878
Non_Bus Ath Yes 0.4308469204
Non_Bus Non_Ath Yes 0.8965770222
Non_Bus Ath No 0.3090863734
Bus Non_Ath Yes 0.2912921754
Non_Bus Ath Yes 0.7517265244
Non_Bus Ath Yes 0.7678298565
Non_Bus Non_Ath No 0.8941655005
Bus Ath Yes 0.0621472483
Bus Non_Ath Yes 0.1957389968
Bus Ath Yes 0.1210986541
Bus Non_Ath No 0.2740622242
Non_Bus Ath No 0.7952982998
Non_Bus Ath No 0.6517780043
Non_Bus Ath Yes 0.6388597777
Non_Bus Ath Yes 0.4925092963
Non_Bus Non_Ath Yes 0.9472647307
Non_Bus Ath Yes 0.7433668767
Non_Bus Non_Ath Yes 0.5448449889
Non_Bus Ath Yes 0.2603713663
Bus Non_Ath Yes 0.4913889038
Bus Ath No 0.0903957707
Non_Bus Ath No 0.188758022
Bus Ath No 0.2665935818
Bus Ath Yes 0.4240670779
Bus Ath Yes 0.1143893105
Non_Bus Non_Ath No 0.2528525121
Bus Non_Ath Yes 0.1555064174
Bus Non_Ath Yes 0.7493462673
Bus Non_Ath Yes 0.3734912953
Bus Non_Ath Yes 0.4071541605
Bus Non_Ath Yes 0.9947233495
Bus Non_Ath No 0.0852239529
Non_Bus Non_Ath No 0.4937916565
Non_Bus Non_Ath Yes 0.4102072548
Non_Bus Ath Yes 0.8941241149
Bus Non_Ath No 0.1619302652
Bus Non_Ath Yes 0.0368737514
Bus Non_Ath Yes 0.0039408298
Bus Non_Ath Yes 0.4256609931
Non_Bus Ath No 0.4939576349
Non_Bus Ath No 0.1722402441
Non_Bus Ath Yes 0.7892684254
Bus Non_Ath Yes 0.8512913953
Non_Bus Ath Yes 0.9662964747
Non_Bus Ath Yes 0.5755817211
Bus Ath Yes 0.4074093848
Bus Non_Ath Yes 0.4316525552
Bus Non_Ath Yes 0.787957832
Bus Ath Yes 0.0823208586
Bus Ath Yes 0.1696162127
Non_Bus Ath No 0.1616148801
Non_Bus Ath No 0.2854967388
Bus Non_Ath Yes 0.6231821553
Bus Non_Ath Yes 0.8244859042
Non_Bus Non_Ath No 0.1253527395
Bus Ath Yes 0.9569728601
Non_Bus Ath Yes 0.2799537378
Non_Bus Ath Yes 0.9925222374
Bus Ath No 0.6587809168
Bus Non_Ath Yes 0.1155617728
Non_Bus Non_Ath No 0.3065457734
Non_Bus Ath No 0.7455735842
Bus Non_Ath Yes 0.5250053263
Bus Non_Ath Yes 0.0904257517
Non_Bus Non_Ath Yes 0.1928149205
Bus Non_Ath No 0.5861373589
Bus Non_Ath Yes 0.8430963948
Non_Bus Non_Ath Yes 0.0588106158
Bus Ath Yes 0.7525261401
Non_Bus Non_Ath Yes 0.7496397088
Bus Ath Yes 0.6041945614
Bus Non_Ath Yes 0.9126991014
Non_Bus Non_Ath Yes 0.5945484383
Non_Bus Ath Yes 0.1667093881
Bus Ath Yes 0.0313282036
Bus Non_Ath Yes 0.0413348269
Bus Ath No 0.5632721762
Non_Bus Ath Yes 0.0220116849
Bus Non_Ath Yes 0.9421242186
Non_Bus Ath No 0.4035337033
Non_Bus Non_Ath No 0.563101153
Bus Ath Yes 0.8056430167
Bus Ath Yes 0.653458148
Bus Non_Ath No 0.5889226991
Bus Ath Yes 0.9281069874
Non_Bus Ath No 0.0166256481
Non_Bus Ath Yes 0.7264395288
Non_Bus Ath Yes 0.8760651311
Bus Ath Yes 0.659091485
Bus Non_Ath Yes 0.4477343763
Bus Non_Ath Yes 0.290148623
Non_Bus Ath Yes 0.8641701081
Non_Bus Ath No 0.2264633261
Non_Bus Ath No 0.0587570933
Bus Ath Yes 0.6345124867
Non_Bus Ath No 0.9959108176
Bus Ath No 0.6623349066
Non_Bus Non_Ath No 0.0258632352
Bus Non_Ath Yes 0.3912020566
Non_Bus Ath Yes 0.8010867166
Non_Bus Ath Yes 0.8370519501
Non_Bus Ath No 0.5764203245
Bus Ath Yes 0.8440293765
Bus Non_Ath No 0.3410362987
Bus Ath Yes 0.1179217118
Non_Bus Non_Ath Yes 0.6645840144
Non_Bus Ath Yes 0.128949147
Bus Ath No 0.0095169966
Bus Non_Ath Yes 0.0697320503
Bus Non_Ath Yes 0.7680891504
Bus Non_Ath Yes 0.335671384
Bus Ath No 0.1043179451
Bus Ath Yes 0.5478449042
Non_Bus Non_Ath Yes 0.7130121802
Bus Ath Yes 0.9223255118
Bus Non_Ath Yes 0.1057851993
Bus Ath Yes 0.0323205854
Bus Ath No 0.9564681056
Bus Non_Ath Yes 0.3234013811
Bus Ath Yes 0.0390600094
Bus Non_Ath Yes 0.2438839111
Non_Bus Ath Yes 0.1829816634
Non_Bus Ath Yes 0.4787637624
Bus Ath No 0.4317611917
Bus Ath No 0.4935010397
Non_Bus Non_Ath Yes 0.6934312422
Non_Bus Ath No 0.1402164855
Bus Ath Yes 0.6476782343
Non_Bus Ath Yes 0.5410243269
Bus Non_Ath No 0.2528466606
Non_Bus Ath Yes 0.6196278564
Non_Bus Non_Ath Yes 0.1438032859
Non_Bus Ath No 0.6137674101
Non_Bus Non_Ath No 0.4778624865
Bus Non_Ath Yes 0.1548333524
Bus Non_Ath Yes 0.3615998746
Bus Ath Yes 0.6836183882
Non_Bus Non_Ath Yes 0.5855241809
Bus Non_Ath Yes 0.540592708
Non_Bus Non_Ath Yes 0.7163121442
Bus Non_Ath Yes 0.4754193639
Bus Ath Yes 0.806555795
Bus Ath No 0.4884927177
Non_Bus Ath Yes 0.6932178101
Non_Bus Ath Yes 0.2569920669
Non_Bus Ath Yes 0.2228488914
Bus Ath No 0.7909673809
Bus Ath Yes 0.5974861706
Bus Ath No 0.6467677043
Non_Bus Ath No 0.8445532332
Bus Ath No 0.1879855106
Bus Non_Ath Yes 0.9177721724
Bus Non_Ath Yes 0.3744536353
Bus Non_Ath No 0.4342604953
Non_Bus Non_Ath Yes 0.7475727093
Non_Bus Non_Ath Yes 0.8463215451
Bus Ath Yes 0.3229610329
Bus Ath No 0.1289041423
Bus Ath Yes 0.8378382958
Non_Bus Ath Yes 0.3749640819
Bus Non_Ath Yes 0.1779782446
Non_Bus Non_Ath No 0.1427864173
Non_Bus Ath Yes 0.9636597071
Bus Non_Ath Yes 0.6517704271
Non_Bus Non_Ath Yes 0.7132785695
Bus Ath No 0.2881434565
Bus Ath Yes 0.3644664804
Non_Bus Ath Yes 0.3807861152
Bus Non_Ath Yes 0.300749932
Non_Bus Non_Ath No 0.3741170539
Non_Bus Non_Ath No 0.0735588063
Non_Bus Ath No 0.938091352
Bus Ath Yes 0.0985529892
Non_Bus Non_Ath No 0.0183419348
Non_Bus Non_Ath Yes 0.402469423
Non_Bus Non_Ath No 0.6741086431
Bus Ath Yes 0.9482905715
Non_Bus Non_Ath Yes 0.6517349723
Bus Ath No 0.7907007084
Non_Bus Ath No 0.265886673
Non_Bus Non_Ath Yes 0.7142105388
Bus Non_Ath No 0.2437240453
Non_Bus Ath No 0.2177401817
Bus Non_Ath Yes 0.6757163124
Non_Bus Non_Ath Yes 0.8024079449
Non_Bus Non_Ath No 0.778876018
Bus Ath No 0.7839944541
Non_Bus Non_Ath Yes 0.2645000106
Bus Ath Yes 0.7231846944
Bus Ath No 0.6857165516
Non_Bus Non_Ath Yes 0.0555173013
Bus Non_Ath No 0.243968783
Non_Bus Non_Ath No 0.5761290408
Bus Non_Ath Yes 0.4060416464
Non_Bus Non_Ath No 0.32532464
Bus Non_Ath Yes 0.7744594054
Bus Ath No 0.2770083147
Bus Non_Ath Yes 0.8241302033
Bus Ath Yes 0.8446006116
Non_Bus Ath Yes 0.1442930253
Bus Non_Ath Yes 0.2383082896
Bus Ath Yes 0.9658556041
Non_Bus Ath Yes 0.2503033399
Non_Bus Ath No 0.6989883775
Non_Bus Non_Ath No 0.6642950451
Non_Bus Non_Ath Yes 0.8163776394
Bus Non_Ath Yes 0.8123336261
Bus Non_Ath Yes 0.0744649252
Non_Bus Ath Yes 0.4539408799
Non_Bus Ath No 0.6366867345
Bus Non_Ath No 0.5243177395
Bus Ath No 0.0321600038
Non_Bus Ath Yes 0.9669296399
Non_Bus Ath No 0.1302337981
Non_Bus Ath No 0.1945657578
Non_Bus Non_Ath No 0.1817464044
Non_Bus Non_Ath Yes 0.9539856779
Non_Bus Ath Yes 0.6702870297
Non_Bus Ath No 0.3238476853
Bus Non_Ath Yes 0.1301316786
Bus Ath No 0.5033666879
Non_Bus Ath No 0.5936301261
Non_Bus Ath Yes 0.6312349552
Bus Non_Ath Yes 0.3358862703
Non_Bus Non_Ath Yes 0.2099798552
Bus Ath Yes 0.109174191
Non_Bus Non_Ath Yes 0.2001247672
Non_Bus Ath No 0.8437741777
Non_Bus Ath No 0.2737690153
Bus Non_Ath Yes 0.3766899111
Non_Bus Non_Ath Yes 0.2066275023
Non_Bus Non_Ath Yes 0.5271293358
Bus Ath Yes 0.1475664542
Non_Bus Ath Yes 0.4024937342
Non_Bus Ath Yes 0.8435847766
Bus Ath No 0.8644664656
Non_Bus Non_Ath No 0.8624122228
Bus Ath Yes 0.1831806462
Bus Ath No 0.9028901104
Bus Non_Ath Yes 0.5013600303
Bus Ath No 0.7359055717
Non_Bus Ath Yes 0.3790094709
Bus Non_Ath Yes 0.2362409153
Bus Non_Ath Yes 0.5261158668
Bus Non_Ath Yes 0.1131958544
Bus Non_Ath No 0.9733995679
Non_Bus Ath No 0.4989744926
Bus Ath Yes 0.595137567
Non_Bus Non_Ath Yes 0.5683739731
Non_Bus Ath No 0.941903746
Non_Bus Ath No 0.9448525993
Non_Bus Non_Ath No 0.2468951164
Non_Bus Ath No 0.5169161711
Non_Bus Non_Ath Yes 0.6075924505
Bus Ath Yes 0.2668568216
Non_Bus Non_Ath Yes 0.0970400315
Bus Non_Ath Yes 0.0315220368
Bus Ath Yes 0.8657514017
Non_Bus Non_Ath No 0.5747963692
Bus Non_Ath Yes 0.8649688228
Bus Non_Ath Yes 0.7344931912
Non_Bus Non_Ath Yes 0.0712114204
Non_Bus Non_Ath Yes 0.2224354572
Bus Non_Ath Yes 0.6118410528
Bus Ath No 0.0964239157
Bus Ath No 0.287638499
Bus Ath Yes 0.0527244008
Bus Ath Yes 0.6423566593
Bus Non_Ath Yes 0.9016010576
Non_Bus Ath Yes 0.0222611832
Non_Bus Non_Ath No 0.2047592795
Non_Bus Non_Ath No 0.7228499117
Bus Non_Ath No 0.4944748858
Bus Non_Ath Yes 0.0180201181
Bus Ath Yes 0.8699796902
Bus Ath Yes 0.6551309833
Bus Non_Ath No 0.3941810008
Non_Bus Ath No 0.0480359306
Non_Bus Ath Yes 0.7997009006
Bus Ath Yes 0.6751869481
Non_Bus Ath Yes 0.4540490841
Non_Bus Ath No 0.3938466325
Non_Bus Ath No 0.5338434214
Non_Bus Non_Ath No 0.2510898815
Non_Bus Ath Yes 0.8838363959
Bus Non_Ath Yes 0.8304771101
Non_Bus Non_Ath No 0.1412805091
Non_Bus Ath Yes 0.8168915968
Non_Bus Ath No 0.4886447777
Non_Bus Ath Yes 0.0637770193
Bus Ath No 0.5770696266
Bus Non_Ath Yes 0.0363874579
Non_Bus Non_Ath Yes 0.930865899
Non_Bus Non_Ath Yes 0.9848279721
Non_Bus Ath Yes 0.0586130558
Non_Bus Non_Ath Yes 0.2670175009
Bus Ath Yes 0.6878184212
Non_Bus Ath Yes 0.5481441393
Bus Ath Yes 0.472968598
Non_Bus Ath No 0.2474609025
Bus Ath Yes 0.7329074379
Non_Bus Ath Yes 0.1503428551
Bus Ath Yes 0.9699470227
Bus Ath Yes 0.9087632511
Bus Ath Yes 0.4696128152
Non_Bus Non_Ath Yes 0.9781792466
Non_Bus Ath No 0.4179182987
Bus Non_Ath Yes 0.1774129802
Bus Ath Yes 0.2875642892
Bus Ath No 0.9701048611
Non_Bus Ath Yes 0.23497919
Bus Ath No 0.1545077513
Bus Ath Yes 0.4399316743
Non_Bus Non_Ath No 0.2330481942
Bus Non_Ath Yes 0.5556061795
Bus Non_Ath Yes 0.5051098795
Non_Bus Ath No 0.66699446
Non_Bus Non_Ath Yes 0.1638448147
Non_Bus Ath Yes 0.4916730957
Non_Bus Non_Ath Yes 0.6652013627
Non_Bus Ath Yes 0.473190549
Non_Bus Ath No 0.2107815018
Non_Bus Ath No 0.330621121
Bus Ath Yes 0.4767320733
Non_Bus Ath No 0.7225203596
Non_Bus Ath Yes 0.1174004807
Non_Bus Non_Ath Yes 0.9308782133
Bus Non_Ath Yes 0.5858114693
Non_Bus Ath Yes 0.9735053336
Bus Non_Ath No 0.3218308553
Bus Non_Ath Yes 0.6456738633
Non_Bus Non_Ath No 0.387884249
Bus Ath Yes 0.5762649826
Non_Bus Ath Yes 0.957873485
Non_Bus Non_Ath Yes 0.3196763884
Non_Bus Non_Ath Yes 0.1268911215
Non_Bus Ath Yes 0.2925285794
Bus Ath No 0.7762952488
Bus Ath Yes 0.4462111151
Bus Non_Ath Yes 0.6346726543
Non_Bus Ath No 0.7949465854
Non_Bus Non_Ath Yes 0.8090250618
Non_Bus Non_Ath No 0.3134097718
Non_Bus Ath No 0.2748778066
Bus Ath Yes 0.5304008591
Bus Non_Ath No 0.7685207177
Bus Non_Ath Yes 0.0259119294
Non_Bus Ath No 0.1764815295
Non_Bus Ath Yes 0.5108192054
Non_Bus Ath No 0.1636463248
Bus Ath Yes 0.4990264508
Non_Bus Non_Ath No 0.5308624682
Bus Ath Yes 0.02169503
Non_Bus Non_Ath No 0.9461059536
Non_Bus Non_Ath No 0.7692321793
Non_Bus Non_Ath No 0.3525279819
Non_Bus Non_Ath Yes 0.3099179002
Non_Bus Non_Ath Yes 0.1758091245
Bus Ath No 0.6277509828
Non_Bus Ath Yes 0.5831856289
Bus Ath No 0.9414774425
Bus Ath Yes 0.5962472774
Bus Ath Yes 0.0970682571
Bus Ath Yes 0.0944656211
Bus Non_Ath No 0.3290527552
Non_Bus Ath Yes 0.7969959407
Non_Bus Ath No 0.921543637
Bus Non_Ath Yes 0.8989121534
Bus Non_Ath Yes 0.4286953491
Bus Non_Ath Yes 0.5560184181
Non_Bus Non_Ath No 0.8465199499
Non_Bus Ath No 0.0366956983
Bus Non_Ath Yes 0.9021647301
Non_Bus Non_Ath No 0.5342718536
Non_Bus Ath Yes 0.369952845
Non_Bus Ath Yes 0.0917495605
Bus Ath No 0.0295933888
Bus Non_Ath Yes 0.8094670199
Non_Bus Non_Ath Yes 0.3564092662
Bus Ath Yes 0.8924844314
Bus Non_Ath Yes 0.3555070134
Non_Bus Ath Yes 0.1847334313
Bus Non_Ath Yes 0.5144697493
Bus Non_Ath Yes 0.9312831078
Bus Non_Ath Yes 0.9072244231
Bus Non_Ath Yes 0.407116885
Non_Bus Non_Ath No 0.76296289
Non_Bus Ath No 0.4881449169
Non_Bus Ath Yes 0.8957656666
Non_Bus Non_Ath Yes 0.4487444061
Non_Bus Ath Yes 0.1240438647
Non_Bus Non_Ath Yes 0.8960922201
Non_Bus Non_Ath No 0.1336511467
Bus Non_Ath Yes 0.4212209566
Bus Non_Ath No 0.8363458
Bus Ath No 0.539097968
Bus Non_Ath Yes 0.2875735418
Non_Bus Ath No 0.7505325881
Bus Ath Yes 0.7704617253
Bus Non_Ath No 0.5581546015
Bus Non_Ath Yes 0.9756591475
Non_Bus Ath No 0.2192540539
Non_Bus Ath No 0.3998089593
Non_Bus Ath No 0.9186280855
Bus Non_Ath Yes 0.7606574897
Non_Bus Non_Ath No 0.7880483824
Bus Non_Ath Yes 0.4904308615
Non_Bus Non_Ath Yes 0.9343226053
Bus Non_Ath Yes 0.9532832157
Non_Bus Non_Ath Yes 0.3398747735
Non_Bus Non_Ath Yes 0.3635880773
Non_Bus Ath No 0.6135985916
Bus Ath No 0.4396576411
Bus Non_Ath Yes 0.9631660842
Non_Bus Ath No 0.4418603018
Non_Bus Ath Yes 0.3023185935
Non_Bus Ath Yes 0.1538970414
Non_Bus Non_Ath No 0.0943368886
Non_Bus Non_Ath No 0.8994042344
Bus Ath Yes 0.0455678051
Bus Ath No 0.4790053429
Non_Bus Non_Ath Yes 0.8806799989
Non_Bus Non_Ath Yes 0.7276417183
Non_Bus Non_Ath No 0.6816835149
Non_Bus Non_Ath No 0.6710627375
Bus Ath No 0.2669069572
Bus Ath Yes 0.3382536121
Non_Bus Non_Ath Yes 0.2332883289
Bus Ath Yes 0.2079536843
Non_Bus Ath No 0.0020667419
Non_Bus Non_Ath Yes 0.1550926469
Bus Non_Ath Yes 0.2408324678
Non_Bus Non_Ath Yes 0.3394168082
Bus Non_Ath Yes 0.6354858498
Bus Ath No 0.6105801555
Bus Ath Yes 0.3141411417
Non_Bus Ath No 0.2916037209
Bus Ath No 0.6990227274
Bus Ath No 0.9395426597
Bus Non_Ath Yes 0.2074067517
Non_Bus Ath No 0.1611183609
Non_Bus Non_Ath No 0.0528599517
Bus Ath Yes 0.7317272552
Non_Bus Non_Ath Yes 0.4495881056
Bus Ath No 0.0468047266
Non_Bus Non_Ath Yes 0.298171831
Non_Bus Non_Ath Yes 0.6270351644
Non_Bus Ath Yes 0.0823432351
Non_Bus Non_Ath Yes 0.2415554351
Bus Non_Ath Yes 0.2007594087
Bus Ath Yes 0.1949843497
Bus Ath No 0.6513093689
Bus Non_Ath Yes 0.7111326966
Bus Non_Ath Yes 0.7465700823
Bus Non_Ath Yes 0.3772360999
Bus Non_Ath No 0.4990256361
Bus Non_Ath Yes 0.5953687055
Non_Bus Ath No 0.2222431699
Non_Bus Ath Yes 0.7513251782
Bus Non_Ath Yes 0.1719335446
Non_Bus Non_Ath Yes 0.2548403827
Non_Bus Non_Ath No 0.692440271
Bus Ath Yes 0.1840544954
Non_Bus Ath Yes 0.0466997657
Non_Bus Non_Ath No 0.004559964
Non_Bus Ath Yes 0.3806701717
Non_Bus Non_Ath Yes 0.8583969039
Bus Non_Ath Yes 0.6202169055
Bus Ath No 0.7363384807
Non_Bus Ath Yes 0.6923196266
Non_Bus Ath No 0.3012052816
Non_Bus Non_Ath No 0.8707372793
Non_Bus Non_Ath Yes 0.0694389943
Non_Bus Ath No 0.5569441376
Non_Bus Non_Ath No 0.6984804589
Non_Bus Ath Yes 0.5398156338
Bus Non_Ath Yes 0.6622263645
Bus Ath Yes 0.618122633
Non_Bus Non_Ath Yes 0.4310521399
Bus Ath Yes 0.4978735211
Bus Ath Yes 0.387806417
Bus Non_Ath Yes 0.3697718211
Non_Bus Non_Ath No 0.5261213029
Non_Bus Non_Ath Yes 0.3587389113
Bus Ath No 0.4270045442
Bus Non_Ath Yes 0.4218422465
Bus Ath No 0.0263393403
Bus Ath No 0.5627638252
Non_Bus Non_Ath No 0.4016144489
Bus Non_Ath Yes 0.9276712624
Non_Bus Ath No 0.8128442725
Bus Non_Ath Yes 0.7884622262
Bus Non_Ath Yes 0.7812888409
Non_Bus Ath No 0.9644774465
Non_Bus Ath No 0.8072104158
Bus Ath Yes 0.0029776499
Non_Bus Non_Ath Yes 0.2697231397
Bus Ath Yes 0.7905281737
Bus Non_Ath Yes 0.9486135236
Bus Non_Ath Yes 0.1497644727
Non_Bus Ath Yes 0.2015782275
Non_Bus Non_Ath Yes 0.533743965
Bus Non_Ath Yes 0.5541516281
Bus Ath Yes 0.2707083058
Bus Ath No 0.9389060711
Bus Non_Ath Yes 0.040799827
Non_Bus Non_Ath No 0.1740379274
Non_Bus Non_Ath No 0.9001915411
Bus Ath Yes 0.5424595422
Bus Non_Ath Yes 0.8079423929
Bus Non_Ath Yes 0.707613676
Bus Ath Yes 0.6866720866
Bus Non_Ath Yes 0.8512969617
Bus Non_Ath Yes 0.3844436973
Non_Bus Non_Ath Yes 0.7462656923
Non_Bus Ath No 0.1409748169
Non_Bus Non_Ath Yes 0.2762739495
Bus Ath No 0.5239589363
Non_Bus Non_Ath Yes 0.9074120801
Non_Bus Non_Ath Yes 0.1352118184
Non_Bus Ath No 0.2755735222
Non_Bus Ath Yes 0.715674729
Bus Non_Ath No 0.754103842
Non_Bus Ath No 0.6836433838
Non_Bus Non_Ath No 0.192166966
Non_Bus Ath Yes 0.3832345982
Non_Bus Non_Ath Yes 0.3378963832
Non_Bus Non_Ath Yes 0.9570270143
Non_Bus Non_Ath No 0.4289911952
Non_Bus Non_Ath Yes 0.2004423191
Bus Non_Ath No 0.2405571752
Non_Bus Ath No 0.5115398859
Non_Bus Non_Ath Yes 0.04618857
Bus Ath No 0.4404957444
Non_Bus Non_Ath Yes 0.727519338
Non_Bus Ath Yes 0.1884107234
Bus Ath No 0.6908737804
Bus Non_Ath No 0.9038836073
Non_Bus Non_Ath No 0.3922143788
Bus Ath Yes 0.4818248321
Bus Ath No 0.9333166377
Bus Ath No 0.9955148751
Bus Ath Yes 0.7932720593
Non_Bus Non_Ath No 0.8975132963
Bus Ath No 0.9938100761
Non_Bus Non_Ath Yes 0.1632463272
Non_Bus Ath No 0.8090979829
Bus Ath Yes 0.8454109967
Non_Bus Non_Ath Yes 0.7245727811
Bus Non_Ath Yes 0.5354322589
Bus Ath No 0.3152609048
Bus Ath No 0.9133924082
Non_Bus Non_Ath No 0.3718833216
Bus Non_Ath Yes 0.8561135412
Non_Bus Non_Ath Yes 0.2409467178
Bus Non_Ath Yes 0.5103412143
Bus Non_Ath Yes 0.0865272354
Bus Non_Ath Yes 0.8870541187
Non_Bus Non_Ath No 0.336329471
Bus Ath Yes 0.4431463995
Non_Bus Non_Ath Yes 0.5070931561
Non_Bus Non_Ath Yes 0.0625185563
Non_Bus Ath Yes 0.2025943959
Non_Bus Non_Ath Yes 0.6845715756
Non_Bus Non_Ath No 0.3730908733
Non_Bus Non_Ath Yes 0.7009641962
Bus Ath Yes 0.4970935384
Non_Bus Ath No 0.9154564986
Bus Non_Ath No 0.3855755069
Non_Bus Ath No 0.9101870101
Non_Bus Ath Yes 0.503033451
Bus Non_Ath Yes 0.2390950437
Bus Ath Yes 0.7508540085
Non_Bus Non_Ath Yes 0.5803169413
Bus Non_Ath Yes 0.0679571246
Non_Bus Non_Ath Yes 0.0111425219
Bus Ath No 0.0562781928
Bus Non_Ath Yes 0.6077835958
Non_Bus Non_Ath No 0.3917492226
Non_Bus Ath Yes 0.8543606319
Bus Ath No 0.8211573208
Bus Non_Ath Yes 0.2744025497
Non_Bus Non_Ath No 0.2621568249
Bus Non_Ath No 0.7947902923
Bus Ath No 0.7722440909
Non_Bus Non_Ath Yes 0.4716366587
Non_Bus Non_Ath No 0.8947681294
Non_Bus Ath No 0.0290761373
Non_Bus Non_Ath Yes 0.5070857474
Bus Non_Ath Yes 0.8887800469
Bus Ath No 0.5472654632
Non_Bus Non_Ath Yes 0.5850605547
Non_Bus Ath Yes 0.3688674689
Non_Bus Ath No 0.1075061896
Non_Bus Non_Ath No 0.1180695226
Non_Bus Ath Yes 0.7715073674
Non_Bus Ath No 0.428214186
Bus Ath Yes 0.4638370369
Non_Bus Non_Ath Yes 0.9966198764
Bus Non_Ath Yes 0.0874676861
Bus Ath No 0.2355511131
Non_Bus Ath No 0.2269887827
Non_Bus Ath Yes 0.6778520853
Non_Bus Non_Ath Yes 0.3905409031
Non_Bus Non_Ath No 0.9867166154
Bus Ath No 0.5275417558
Non_Bus Non_Ath No 0.1192640413
Bus Ath No 0.9441134046
Bus Ath No 0.3685913945
Bus Ath Yes 0.5955380336
Bus Ath No 0.2058663814
Non_Bus Ath Yes 0.8131658908
Bus Ath No 0.1182076386
Bus Non_Ath Yes 0.2459335049
Bus Ath No 0.6634245947
Bus Ath Yes 0.6861946107
Bus Ath No 0.5361002063
Bus Non_Ath Yes 0.6136945576
Bus Ath Yes 0.0169950056
Non_Bus Ath No 0.9654619443
Non_Bus Ath No 0.8081650227
Non_Bus Non_Ath Yes 0.3079099546
Bus Non_Ath Yes 0.8238284546
Non_Bus Ath No 0.4651230586
Non_Bus Ath No 0.6352743265
Bus Ath Yes 0.2823174425
Non_Bus Non_Ath No 0.7830085579
Non_Bus Non_Ath No 0.0674466576
Bus Ath No 0.2123191168
Bus Non_Ath Yes 0.214094262
Non_Bus Non_Ath Yes 0.0011928818
Bus Ath No 0.6193434046
Non_Bus Non_Ath Yes 0.6062653106
Bus Non_Ath Yes 0.6971297888
Bus Non_Ath Yes 0.378846145
Non_Bus Ath Yes 0.4296524095
Non_Bus Non_Ath No 0.1482916192
Non_Bus Ath No 0.8464229437
Non_Bus Ath Yes 0.9705784218
Non_Bus Ath No 0.6582837
Bus Non_Ath Yes 0.0370674839
Bus Ath No 0.3956267707
Non_Bus Non_Ath Yes 0.7314712945
Non_Bus Non_Ath No 0.4019401049
Bus Ath Yes 0.4310966128
Non_Bus Ath No 0.8848772209
Non_Bus Ath Yes 0.9592314781
Bus Non_Ath Yes 0.1654033411
Bus Ath No 0.0963727179
Non_Bus Ath No 0.8647834163
Bus Non_Ath Yes 0.307316356
Non_Bus Non_Ath Yes 0.4958408312
Bus Non_Ath Yes 0.1947926672
Non_Bus Non_Ath Yes 0.574484714
Non_Bus Ath Yes 0.1743701315
Non_Bus Ath No 0.5465793855
Bus Ath Yes 0.8804475649
Non_Bus Non_Ath No 0.0593017376
Bus Non_Ath Yes 0.8630947065
Non_Bus Ath Yes 0.5882807162
Non_Bus Non_Ath Yes 0.9480320959
Bus Ath Yes 0.4286034073
Bus Non_Ath Yes 0.2287729326
Bus Non_Ath No 0.9612649431
Bus Ath Yes 0.3373837117
Bus Non_Ath Yes 0.8905650918
Bus Non_Ath Yes 0.2248803868
Non_Bus Ath Yes 0.3796146898
Non_Bus Non_Ath Yes 0.5900994144
Bus Ath Yes 0.3013494201
Non_Bus Ath No 0.6136492066
Non_Bus Ath Yes 0.2032303353
Non_Bus Ath Yes 0.3159393541
Bus Non_Ath Yes 0.0594244687
Non_Bus Ath No 0.942125919
Bus Ath No 0.0217319908
Bus Non_Ath Yes 0.1610127793
Non_Bus Ath Yes 0.0934211352
Non_Bus Non_Ath Yes 0.6189624331
Bus Non_Ath Yes 0.816191278
Non_Bus Non_Ath Yes 0.6820028106
Non_Bus Ath Yes 0.9201763002
Bus Non_Ath Yes 0.511400393
Non_Bus Ath No 0.7322368671
Bus Non_Ath Yes 0.6262894371
Non_Bus Non_Ath Yes 0.3842809545
Bus Non_Ath Yes 0.6569400872
Bus Non_Ath Yes 0.9596270878
Bus Non_Ath Yes 0.9030654194
Non_Bus Ath Yes 0.8968992676
Non_Bus Ath No 0.3415165955
Non_Bus Ath Yes 0.1101349033
Non_Bus Non_Ath Yes 0.8900379323
Bus Ath No 0.6565721815
Bus Ath No 0.4331923725
Non_Bus Non_Ath No 0.4960248392
Bus Ath No 0.0886593889
Bus Non_Ath Yes 0.7434091098
Bus Non_Ath Yes 0.2088340539
Bus Ath No 0.9082438328
Bus Non_Ath Yes 0.7248434083
Bus Ath Yes 0.4647085984
Non_Bus Ath Yes 0.4266754305
Bus Ath Yes 0.0306257361
Non_Bus Non_Ath No 0.7290256391
Bus Ath Yes 0.0914852196
Non_Bus Non_Ath Yes 0.0513448249
Bus Ath Yes 0.4366256121
Non_Bus Non_Ath Yes 0.1621376486
Bus Ath Yes 0.5727342825
Non_Bus Ath Yes 0.0723196324
Bus Non_Ath No 0.1614583002
Non_Bus Ath Yes 0.7589164234
Non_Bus Ath Yes 0.2272432387
Bus Non_Ath Yes 0.5969142013
Bus Non_Ath Yes 0.0420412919
Bus Non_Ath Yes 0.0484016507
Bus Non_Ath Yes 0.5656179473
Bus Non_Ath Yes 0.357033672
Non_Bus Non_Ath No 0.6449568107
Non_Bus Ath Yes 0.8449543232
Bus Ath No 0.896812635
Non_Bus Ath Yes 0.5885790183
Bus Non_Ath Yes 0.1754356647
Non_Bus Non_Ath No 0.1108886107
Bus Non_Ath Yes 0.2605748309
Bus Ath Yes 0.834187066
Bus Ath Yes 0.252423873
Bus Non_Ath Yes 0.2646339854
Non_Bus Non_Ath No 0.7231817641
Non_Bus Ath No 0.3667579808
Bus Non_Ath No 0.8275223445
Non_Bus Ath Yes 0.1416839042
Bus Non_Ath No 0.6264519546
Non_Bus Ath Yes 0.2431844856
Bus Ath No 0.9936603626
Bus Non_Ath Yes 0.1474953137
Non_Bus Ath Yes 0.1475734139
Bus Ath Yes 0.1056955917
Bus Non_Ath Yes 0.5491535106
Bus Non_Ath Yes 0.1256593921
Non_Bus Non_Ath No 0.8674797008
Non_Bus Non_Ath Yes 0.0742251141
Non_Bus Non_Ath Yes 0.3969122347
Bus Ath Yes 0.0694417231
Bus Non_Ath Yes 0.4978758696
Bus Ath Yes 0.6471130007
Bus Ath Yes 0.4568489455
Bus Ath No 0.767896967
Bus Ath No 0.6456684771
Non_Bus Non_Ath No 0.1098389902
Non_Bus Ath Yes 0.0574387921
Non_Bus Non_Ath Yes 0.9939640892
Bus Non_Ath Yes 0.8962145805
Non_Bus Ath Yes 0.8486488043
Non_Bus Ath Yes 0.9644952721
Bus Ath No 0.8732677053
Non_Bus Ath Yes 0.3923154693
Bus Non_Ath No 0.9661711402
Bus Ath Yes 0.8989558273
Bus Non_Ath No 0.6088043716
Non_Bus Non_Ath Yes 0.3545613381
Bus Non_Ath Yes 0.6106886661
Bus Ath No 0.0697114511
Bus Non_Ath Yes 0.3428826594
Bus Ath No 0.962079434
Bus Ath Yes 0.9066031592
Non_Bus Non_Ath No 0.6598438351
Non_Bus Ath Yes 0.1055492657
Bus Ath Yes 0.8952636419
Non_Bus Non_Ath No 0.5566289285
Non_Bus Non_Ath No 0.040239506
Non_Bus Ath No 0.1966057618
Non_Bus Ath Yes 0.4438034593
Non_Bus Ath Yes 0.6200269116
Non_Bus Ath No 0.7781332988
Bus Non_Ath Yes 0.0274187201
Non_Bus Non_Ath Yes 0.5074285747
Non_Bus Ath Yes 0.6088893357
Non_Bus Non_Ath Yes 0.1325154049
Non_Bus Ath Yes 0.847230336
Bus Non_Ath Yes 0.4256833054
Non_Bus Ath No 0.5932088207
Bus Non_Ath Yes 0.8193121809
Non_Bus Ath Yes 0.5975723983
Bus Ath Yes 0.4370601441
Non_Bus Ath No 0.6962675356
Bus Ath Yes 0.2739955647
Bus Non_Ath No 0.9176937783
Non_Bus Non_Ath No 0.3900894569
Bus Non_Ath Yes 0.7582445502
Bus Ath Yes 0.7165148313
Bus Non_Ath Yes 0.7792701952
Bus Non_Ath Yes 0.8797189249
Bus Non_Ath Yes 0.2771488095
Non_Bus Ath Yes 0.1773930908
Non_Bus Non_Ath Yes 0.3311617304
Bus Ath Yes 0.7637557127
Bus Non_Ath Yes 0.5838073187
Bus Ath No 0.2608034217
Bus Ath Yes 0.6437356863
Bus Non_Ath Yes 0.0900272544
Non_Bus Ath Yes 0.3910075835
Bus Non_Ath Yes 0.0892311528
Non_Bus Ath No 0.3249508281
Bus Non_Ath Yes 0.2880919132
Bus Non_Ath Yes 0.4712879676
Bus Ath Yes 0.6345287803
Non_Bus Ath No 0.4654936418
Bus Ath Yes 0.5739126113
Bus Ath Yes 0.1678056995
Non_Bus Ath No 0.5499006933
Bus Non_Ath No 0.4853192513
Bus Ath Yes 0.4947368058
Bus Non_Ath Yes 0.8723341281
Non_Bus Ath Yes 0.4350286347
Non_Bus Non_Ath No 0.1675541326
Non_Bus Non_Ath Yes 0.6928336124
Bus Ath No 0.2707978927
Non_Bus Ath No 0.8487165597
Non_Bus Ath Yes 0.4014016426
Bus Ath No 0.5017929875
Bus Ath Yes 0.8167734955
Bus Non_Ath Yes 0.8452908709
Bus Non_Ath Yes 0.5361888265
Bus Ath No 0.7012136063
Bus Non_Ath Yes 0.205948514
Bus Non_Ath Yes 0.2696116236
Bus Ath Yes 0.0828990082
Non_Bus Ath Yes 0.5680986062
Bus Ath Yes 0.7332429126
Bus Non_Ath Yes 0.2756040027
Bus Ath Yes 0.0324595462
Non_Bus Non_Ath No 0.0029067749
Non_Bus Ath No 0.6103029621
Non_Bus Ath Yes 0.0513486491
Bus Ath Yes 0.8502272986
Non_Bus Non_Ath No 0.4920812394
Bus Non_Ath Yes 0.9453189304
Non_Bus Non_Ath No 0.7028232222
Non_Bus Non_Ath No 0.5067324725
Non_Bus Ath Yes 0.4502217164
Non_Bus Ath No 0.3352716527
Non_Bus Non_Ath Yes 0.0254756739
Bus Ath Yes 0.7504112293
Bus Non_Ath Yes 0.9270302256
Bus Ath No 0.927088741
Non_Bus Ath No 0.9310517199
Bus Ath Yes 0.8742373273
Non_Bus Non_Ath No 0.2976385246
Non_Bus Non_Ath No 0.1905174523
Bus Ath Yes 0.8021771456
Non_Bus Non_Ath No 0.2874641136
Bus Ath No 0.1504187041
Bus Ath Yes 0.8483220857
Bus Ath Yes 0.5783598516
Non_Bus Ath Yes 0.9261253282
Non_Bus Non_Ath No 0.7826318754
Non_Bus Non_Ath No 0.955194953
Non_Bus Non_Ath Yes 0.588003242
Non_Bus Ath No 0.3987371201
Bus Non_Ath Yes 0.6135670981
Non_Bus Ath Yes 0.6056203447
Non_Bus Ath Yes 0.633084608
Non_Bus Ath No 0.3596830606
Non_Bus Ath Yes 0.3441837623
Non_Bus Ath Yes 0.5808873953
Non_Bus Ath No 0.4807622195
Bus Non_Ath Yes 0.1911077006
Non_Bus Ath Yes 0.7884690339
Non_Bus Non_Ath Yes 0.2249707645
Non_Bus Non_Ath No 0.8650854106
Bus Ath Yes 0.4763743077
Non_Bus Non_Ath No 0.2828452517
Non_Bus Ath Yes 0.5256364213
Bus Ath No 0.2520821894
Bus Ath Yes 0.0119363619
Bus Ath Yes 0.017797041
Bus Non_Ath Yes 0.024242219
Non_Bus Non_Ath No 0.4926228105
Non_Bus Non_Ath Yes 0.500337008
Non_Bus Non_Ath No 0.9058070281
Bus Ath No 0.7691791782
Bus Non_Ath Yes 0.9380909104
Non_Bus Non_Ath No 0.4074258562
Bus Ath Yes 0.2902116574
Non_Bus Non_Ath No 0.0784337047
Non_Bus Non_Ath Yes 0.2760089515
Non_Bus Ath Yes 0.5209875103
Bus Ath Yes 0.154001259
Bus Non_Ath Yes 0.4827607162
Non_Bus Non_Ath No 0.7825022844
Non_Bus Ath Yes 0.5446641682
Non_Bus Ath No 0.9984454108
Non_Bus Non_Ath No 0.2878023064
Bus Non_Ath Yes 0.1557380733
Non_Bus Non_Ath No 0.9314759843
Non_Bus Non_Ath No 0.6808673086
Bus Ath No 0.8099587271
Non_Bus Ath No 0.6218160817
Bus Ath Yes 0.2697360718
Non_Bus Ath Yes 0.849077618
Non_Bus Non_Ath No 0.8593985841
Non_Bus Non_Ath No 0.5180878304
Bus Ath No 0.7459454887
Bus Non_Ath Yes 0.4959470239
Non_Bus Ath Yes 0.8384797672
Bus Non_Ath Yes 0.2619707787
Non_Bus Ath Yes 0.5058239991
Bus Ath Yes 0.046744383
Non_Bus Non_Ath No 0.9236786046
Non_Bus Ath No 0.6184922051
Bus Ath Yes 0.8554932378
Bus Non_Ath Yes 0.1182205501
Non_Bus Non_Ath No 0.4070815551
Non_Bus Ath Yes 0.9553089098
Bus Non_Ath Yes 0.7001284837
Non_Bus Non_Ath Yes 0.8332974884
Bus Ath No 0.5319004607
Non_Bus Non_Ath Yes 0.3870978466
Non_Bus Non_Ath No 0.5394429036
Non_Bus Non_Ath Yes 0.1253574481
Non_Bus Non_Ath No 0.8284249206
Bus Ath Yes 0.8198004118
Non_Bus Non_Ath Yes 0.1129701937
Bus Non_Ath Yes 0.5841373247
Non_Bus Ath Yes 0.2948338779
Non_Bus Ath No 0.7956411028
Non_Bus Ath No 0.4430842492
Non_Bus Ath No 0.8525526486
Non_Bus Ath Yes 0.9060482131
Non_Bus Non_Ath Yes 0.2457417223
Bus Non_Ath Yes 0.357587904
Non_Bus Ath Yes 0.0242776228
Bus Non_Ath Yes 0.2307050497
Non_Bus Non_Ath Yes 0.0756229238
Bus Non_Ath Yes 0.2176315169
Bus Non_Ath Yes 0.1306275674
Bus Non_Ath Yes 0.2115731798
Non_Bus Ath No 0.2272869996
Bus Non_Ath Yes 0.8592940251
Bus Ath Yes 0.0444852917
Bus Non_Ath Yes 0.7641278908
Bus Ath Yes 0.353944448
Non_Bus Non_Ath Yes 0.8197898198
Bus Ath Yes 0.7687065407
Non_Bus Non_Ath Yes 0.6720033844
Bus Ath No 0.1261990116
Bus Ath No 0.7550694255
Non_Bus Ath No 0.9624482236
Bus Non_Ath Yes 0.774133974
Bus Ath Yes 0.4323755244
Bus Ath No 0.9512054976
Bus Non_Ath Yes 0.6380142677
Non_Bus Ath No 0.1320017513
Bus Non_Ath Yes 0.348630359
Non_Bus Non_Ath No 0.4524305578
Bus Ath No 0.7491677983
Bus Ath Yes 0.7784764956
Non_Bus Non_Ath No 0.9818177513
Bus Non_Ath Yes 0.4277776433
Bus Ath Yes 0.3491604133
Bus Ath Yes 0.6836934264
Bus Ath No 0.540007068
Non_Bus Non_Ath Yes 0.2907699297
Bus Non_Ath Yes 0.9393722258
Bus Ath Yes 0.4640150802
Bus Non_Ath Yes 0.4363627002
Bus Ath No 0.2314499714
Bus Ath No 0.012869478
Non_Bus Ath Yes 0.2455464323
Non_Bus Non_Ath Yes 0.1279865852
Bus Ath Yes 0.0262182171
Bus Non_Ath Yes 0.4918278948
Bus Ath Yes 0.1660247843
Non_Bus Non_Ath Yes 0.348219566
Bus Non_Ath Yes 0.6779779964
Non_Bus Ath No 0.704102881
Bus Ath Yes 0.3437030564
Non_Bus Non_Ath No 0.7468370885
Non_Bus Ath No 0.9466847778
Non_Bus Ath No 0.6155857721
Bus Non_Ath Yes 0.9615107276
Bus Ath Yes 0.512470677
Bus Non_Ath Yes 0.7614787408
Non_Bus Non_Ath No 0.7925273537
Non_Bus Non_Ath Yes 0.088713069
Non_Bus Ath Yes 0.8869000513
Bus Ath Yes 0.2478303812
Bus Non_Ath Yes 0.1954190345
Non_Bus Non_Ath Yes 0.5435773419
Non_Bus Non_Ath No 0.5473215243
Non_Bus Ath No 0.8542971194
Non_Bus Non_Ath Yes 0.5346230703
Bus Non_Ath Yes 0.1242880085
Bus Non_Ath Yes 0.8209490333
Bus Ath Yes 0.913844307
Non_Bus Ath Yes 0.6182437959
Non_Bus Ath No 0.2681662013
Bus Ath No 0.7169724099
Non_Bus Ath Yes 0.7537610318
Non_Bus Ath Yes 0.5829431594
Bus Ath No 0.0485872232
Bus Ath Yes 0.1316007473
Bus Ath No 0.7824928029
Bus Non_Ath Yes 0.2066142615
Non_Bus Ath Yes 0.4627623402
Bus Non_Ath Yes 0.7586122852
Non_Bus Ath Yes 0.7278672124
Bus Ath No 0.4004280285
Bus Non_Ath Yes 0.7003843716
Bus Non_Ath Yes 0.8986171135
Non_Bus Ath No 0.4480412558
Bus Ath Yes 0.3634341531
Bus Ath No 0.2172645757
Non_Bus Non_Ath No 0.0843492675
Bus Ath Yes 0.5742147437
Bus Ath Yes 0.8832163991
Bus Ath Yes 0.7097860363
Bus Non_Ath Yes 0.0524857965
Bus Non_Ath Yes 0.5243950177
Bus Ath Yes 0.9867841863
Bus Ath No 0.7803050944
Non_Bus Non_Ath Yes 0.6711883448
Bus Non_Ath Yes 0.3108491043
Bus Non_Ath No 0.1710436288
Bus Non_Ath No 0.0344348978
Non_Bus Ath No 0.1771069431
Bus Ath No 0.3138249002
Non_Bus Non_Ath No 0.2672589296
Bus Non_Ath Yes 0.6123333494
Non_Bus Non_Ath Yes 0.2665035861
Bus Non_Ath Yes 0.0051693584
Bus Non_Ath Yes 0.7683820365
Bus Ath Yes 0.5714050274
Non_Bus Ath No 0.0856962593
Non_Bus Non_Ath No 0.2060645646
Non_Bus Ath Yes 0.7695706836
Bus Ath Yes 0.7932506479
Non_Bus Non_Ath No 0.7160516884
Bus Non_Ath Yes 0.6892972619
Non_Bus Non_Ath No 0.9691715986
Non_Bus Ath Yes 0.5699949317
Non_Bus Ath No 0.7309368519
Bus Ath No 0.2666342596
Bus Non_Ath No 0.995250671
Bus Ath Yes 0.2853433461
Bus Non_Ath Yes 0.5498084538
Non_Bus Ath No 0.2131106602
Non_Bus Non_Ath No 0.9073737918
Non_Bus Ath Yes 0.2527006257
Non_Bus Ath Yes 0.3998538619
Non_Bus Non_Ath Yes 0.1844246353
Bus Non_Ath No 0.7299307806
Bus Ath Yes 0.117824731
Non_Bus Ath No 0.172266946
Bus Non_Ath No 0.462310911
Bus Ath Yes 0.4269903845
Bus Ath No 0.3196499943
Non_Bus Non_Ath No 0.4264594845
Non_Bus Non_Ath No 0.9541872499
Bus Ath No 0.926849348
Bus Ath No 0.5279614218
Non_Bus Non_Ath No 0.834616602
Bus Non_Ath Yes 0.1651026341
Non_Bus Ath No 0.8585700828
Bus Non_Ath Yes 0.954891073
Bus Ath No 0.3973728842
Bus Non_Ath Yes 0.8851285785
Non_Bus Non_Ath Yes 0.0661758583
Bus Non_Ath No 0.4075213695
Bus Ath Yes 0.8265286686
Non_Bus Non_Ath No 0.9460958993
Non_Bus Non_Ath Yes 0.1034366813
Bus Non_Ath Yes 0.6253478883
Non_Bus Non_Ath Yes 0.0031469396
Non_Bus Non_Ath No 0.7736588894
Bus Ath No 0.6314707519
Non_Bus Ath Yes 0.4646335651
Non_Bus Non_Ath No 0.95593905
Bus Non_Ath Yes 0.7264148077
Bus Ath Yes 0.5989754559
Bus Non_Ath Yes 0.4436306476
Bus Ath No 0.6304630806
Bus Non_Ath Yes 0.611111903
Bus Non_Ath Yes 0.8823839474
Non_Bus Non_Ath No 0.165107345
Non_Bus Non_Ath Yes 0.8231561096
Non_Bus Ath No 0.7391159668
Non_Bus Non_Ath Yes 0.4684493117
Non_Bus Ath No 0.509341955
Non_Bus Non_Ath Yes 0.8779222716
Non_Bus Non_Ath No 0.9043970007
Bus Ath Yes 0.0268189742
Non_Bus Ath Yes 0.1472817315
Bus Ath Yes 0.6915864505
Non_Bus Non_Ath No 0.6507643032
Non_Bus Ath No 0.8348770678
Bus Non_Ath Yes 0.9154887202
Non_Bus Ath No 0.5910543933
Non_Bus Non_Ath No 0.3352391491
Non_Bus Non_Ath Yes 0.5743009976
Non_Bus Non_Ath Yes 0.1541196068
Bus Non_Ath No 0.9206428901
Non_Bus Non_Ath No 0.086683587
Non_Bus Non_Ath No 0.3764895412
Non_Bus Ath No 0.1490928032
Non_Bus Non_Ath Yes 0.3506174048
Non_Bus Ath Yes 0.6710393278
Non_Bus Non_Ath Yes 0.148581189
Non_Bus Non_Ath No 0.6712074951
Non_Bus Non_Ath Yes 0.9375737746
Non_Bus Ath No 0.9967595098
Non_Bus Ath No 0.2180946492
Non_Bus Non_Ath No 0.2456913481
Non_Bus Non_Ath No 0.1260572207
Bus Ath Yes 0.4630843835
Non_Bus Non_Ath Yes 0.9759525094
Non_Bus Ath Yes 0.8556801985
Non_Bus Non_Ath Yes 0.317768333
Non_Bus Ath Yes 0.1117275576
Non_Bus Non_Ath No 0.9611635044
Non_Bus Ath No 0.8726743351
Non_Bus Ath No 0.9910934376
Bus Non_Ath Yes 0.0087824896
Non_Bus Non_Ath No 0.1851445609
Non_Bus Non_Ath Yes 0.6084317505
Bus Non_Ath Yes 0.1423874799
Bus Non_Ath Yes 0.6950985343
Non_Bus Non_Ath Yes 0.5712603292
Non_Bus Ath Yes 0.3183316336
Non_Bus Non_Ath Yes 0.9657417672
Non_Bus Non_Ath No 0.2060501771
Bus Non_Ath Yes 0.0049126211
Non_Bus Ath Yes 0.3805570665
Bus Ath No 0.3065726004
Non_Bus Non_Ath Yes 0.2094020572
Bus Non_Ath Yes 0.2524382342
Bus Ath Yes 0.6749089091
Bus Ath No 0.5148050361
Non_Bus Non_Ath No 0.462363168
Non_Bus Ath No 0.7604607084
Bus Non_Ath Yes 0.6815451834
Bus Non_Ath Yes 0.6445357163
Non_Bus Non_Ath No 0.6497526542
Bus Non_Ath Yes 0.2215414578
Bus Ath Yes 0.5998767404
Bus Non_Ath Yes 0.859603344
Non_Bus Ath Yes 0.6077865131
Non_Bus Ath No 0.0625342545
Non_Bus Ath Yes 0.2543882131
Bus Ath Yes 0.2577288103
Bus Non_Ath Yes 0.3602350037
Non_Bus Ath Yes 0.0315915315
Bus Ath Yes 0.7504194335
Non_Bus Ath No 0.4953974937
Bus Ath Yes 0.7506902155
Non_Bus Non_Ath Yes 0.3701958314

Student_BM

College Athlete Cheated 1. Pivot Table Nationwide Average % Cheated
Insert pivot table in this cell - F2 Business 56%
Nonbusiness
2. Bar Chart
Bar chart starts in this cell - F22
Insert the appropriate numbers into the hypothesis testing calculations below based upon your pivot table results. Note the results.
3-7 Hypothesis Test
Business Nonathlete vs. National Average Business Athlete vs. National Average Business vs. National Average Nonbusiness vs. National Average Business Athlete vs. Business Nonathlete
Proportion Proportion Proportion Proportion p1 and p2 Proportion
Sample Size (n) =count(range) Sample Size (n) =count(range) Sample Size (n) =count(range) Sample Size (n) =count(range) Athlete Nonathlete
Response of Interest (ROI) Cheated Response of Interest (ROI) Cheated Response of Interest (ROI) Cheated Response of Interest (ROI) Cheated Sample Size (n1 or n2) =COUNT(range)
Count for Response (CFR) =COUNTIF(range,ROI) Count for Response (CFR) =COUNTIF(range,ROI) Count for Response (CFR) =COUNTIF(range,ROI) Count for Response (CFR) =COUNTIF(range,ROI) Response of Interest (ROI) Cheated Cheated
Sample Proportion (pbar) =CFR/n Sample Proportion (pbar) =CFR/n Sample Proportion (pbar) =CFR/n Sample Proportion (pbar) =CFR/n Count for Response (CFR) =COUNTIF(n1or2,ROI)
Sample Proportion (p1 or p2) =CFR1or2/n1or2
Highlight your H0 and Ha Two Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > po Highlight your H0 and Ha Two Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > po Highlight your H0 and Ha Two Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > po Highlight your H0 and Ha Two Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > po Highlight your H0 and Ha Two Tail H0: p1-p2=0 Left Tail H0: p1-p2≥0 Right Tail H0: p1-p2≤0 Ha: p1-p2≠0 Ha: p1-p2<0 Ha: p1-p2>0
Hypothesized Hypothesized Hypothesized Hypothesized Hypothesized Value
Confidence Coefficient (Coe) 0.95 Confidence Coefficient (Coe) 0.95 Confidence Coefficient (Coe) 0.95 Confidence Coefficient (Coe) 0.95
Level of Significance (alpha) =1-Coe 0.05 Level of Significance (alpha) =1-Coe 0.05 Level of Significance (alpha) =1-Coe 0.05 Level of Significance (alpha) =1-Coe 0.05 Level of Sig. α 0.05
Point Estimation of Difference (Point) =p1-p2 0
Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n) ERROR:#DIV/0! Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n) ERROR:#DIV/0! Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n) ERROR:#DIV/0! Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n) ERROR:#DIV/0!
Test Statistic (Z-stat) =(pbar-Hypo)/StdError ERROR:#DIV/0! Test Statistic (Z-stat) =(pbar-Hypo)/StdError ERROR:#DIV/0! Test Statistic (Z-stat) =(pbar-Hypo)/StdError ERROR:#DIV/0! Test Statistic (Z-stat) =(pbar-Hypo)/StdError ERROR:#DIV/0! Pooled Estimation of p (PE) =(n1*p1+n2*p2)/(n1+n2) ERROR:#DIV/0!
Accept or Reject: Left Tail ERROR:#DIV/0! Accept or Reject: Left Tail ERROR:#DIV/0! Accept or Reject: Left Tail ERROR:#DIV/0! Accept or Reject: Left Tail ERROR:#DIV/0! Standard Error (StdError) =SQRT(PE*(1-PE)*(1/n1+1/n2)) ERROR:#DIV/0!
Accept or Reject: Right Tail ERROR:#DIV/0! Accept or Reject: Right Tail ERROR:#DIV/0! Accept or Reject: Right Tail ERROR:#DIV/0! Accept or Reject: Right Tail ERROR:#DIV/0! Test Statistic Z-stat =(Point-Hypo)/StdError ERROR:#DIV/0!
Accept or Reject: Two Tail ERROR:#DIV/0! Accept or Reject: Two Tail ERROR:#DIV/0! Accept or Reject: Two Tail ERROR:#DIV/0! Accept or Reject: Two Tail ERROR:#DIV/0! Accept or Reject: Left Tail ERROR:#DIV/0!
Accept or Reject: Right Tail ERROR:#DIV/0!
p-value (Lower Tail) =NORM.S.DIST(z,TRUE) ERROR:#DIV/0! p-value (Lower Tail) =NORM.S.DIST(z,TRUE) ERROR:#DIV/0! p-value (Lower Tail) =NORM.S.DIST(z,TRUE) ERROR:#DIV/0! p-value (Lower Tail) =NORM.S.DIST(z,TRUE) ERROR:#DIV/0! Accept or Reject: Two Tail ERROR:#DIV/0!
p-value (Upper Tail) =1-LowerTail ERROR:#DIV/0! p-value (Upper Tail) =1-LowerTail ERROR:#DIV/0! p-value (Upper Tail) =1-LowerTail ERROR:#DIV/0! p-value (Upper Tail) =1-LowerTail ERROR:#DIV/0!
p-value (Two Tail) =2*MIN(LowerTail,UpperTail) ERROR:#DIV/0! p-value (Two Tail) =2*MIN(LowerTail,UpperTail) ERROR:#DIV/0! p-value (Two Tail) =2*MIN(LowerTail,UpperTail) ERROR:#DIV/0! p-value (Two Tail) =2*MIN(LowerTail,UpperTail) ERROR:#DIV/0! p-value (Lower Tail) =NORM.S.DIST(Zstat,TRUE) ERROR:#DIV/0!
Accept or Reject p-value: Left Tail ERROR:#DIV/0! Accept or Reject p-value: Left Tail ERROR:#DIV/0! Accept or Reject p-value: Left Tail ERROR:#DIV/0! Accept or Reject p-value: Left Tail ERROR:#DIV/0! p-value (Upper Tail) =1-LowerTail ERROR:#DIV/0!
Accept or Reject p-value: Right Tail ERROR:#DIV/0! Accept or Reject p-value: Right Tail ERROR:#DIV/0! Accept or Reject p-value: Right Tail ERROR:#DIV/0! Accept or Reject p-value: Right Tail ERROR:#DIV/0! p-value (Two Tail) =2*MIN(LowerTail,UpperTail) ERROR:#DIV/0!
Accept or Reject p-value: Two Tail ERROR:#DIV/0! Accept or Reject p-value: Two Tail ERROR:#DIV/0! Accept or Reject p-value: Two Tail ERROR:#DIV/0! Accept or Reject p-value: Two Tail ERROR:#DIV/0! Accept or Reject p-value: Left Tail ERROR:#DIV/0!
Accept or Reject p-value: Right Tail ERROR:#DIV/0!
p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! Accept or Reject p-value: Two Tail ERROR:#DIV/0!
p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0! p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n) ERROR:#DIV/0!
Determine the count of noncheaters and cheaters for business students, nonbusiness students, all athletes, and all non-athletes and place the relevant numbers in the purple/grey area of the table below and note the conclusion.
8. Test of Independence - Is cheating independent of college and athletic participation?
Comparing the number of cheaters for business students, nonbusiness students, athletes, and nonathletes
Ho: all groups cheat at the same rate
Ha: there is a difference in cheating based upon college or athletic participation
Independent Variable
Business Athlete Nonbusiness Athlete Business Nonathlete Nonbusiness Nonathlete Calculations
Dependent variable Obs Exp Obs Exp Obs Exp Obs Exp Total ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Did Not Cheat ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Cheated ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0
Total 0 0 0 0 0
Chi square test statistic = ERROR:#DIV/0!
Level of signicance 0.05
# of rows 2
# of columns 4
df = 3 df = (rows - 1)(columns - 1)
p-value = ERROR:#DIV/0!
Chi square critical 7.8147
Conclusion: ERROR:#DIV/0!

SummaryResults

Hypothesis Test Rejection Region (Tail) Critical Value Test Statistics Reject (Yes/No) P-value Interpretation
Business Nonathlete vs. National Average
Business Athlete vs. National Average
Business vs. National Average
Nonbusiness vs. National Average
Business Athlete vs. Business Nonathlete
Test of Independence