Student Instructions BM

Student Instructions BM

Overview – Benchmark
Your group has been given a dataset containing 240 records, located in the Student_BM tab of this spreadsheet..
Each student is only responsible for analyzing 60 of these record records – the specifics of which will be assigned by the instructor.
It is important that each student has a unique 60 records, as the results will be an input into the CLC, and duplication of
results is not helpful. Note that the data have been randomized, so the data given to your group are likely different than the
data given to other groups.
The intent of this assignment is for students to organize their data using a pivot table, get a graphical understanding
of the data through a bar chart, then do hypothesis testing comparing Bo Diddly Tech results versus the national average.
All of your analysis should be done in the Student_BM tab of this spreadsheet and submitted as part of the assignmemt.
The location where the pivot table, bar chart, and relevant information should be placed in the Student_BM tab is
indicated by RED instructions.
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 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.
4. Determine if 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.
5. Determine if there is a statistical difference between athlete BDT business students and the national average for business
students as reported by the Chronicle of Higher Education.
6. Determine if there is a statistical difference between BDT business students and the national average for business students
as reported by the Chronicle of Higher Education.
7. Determine if there is a statistical difference between BDT nonbusiness students and the national average for nonbusiness
students as reported by the Chronicle of Higher Education.
Instructions Data Interpretation Component:
Utilizing the data you have analyzed, write a managerial report of 500-800 words to the dean. The managerial report needs to
include an introduction, analysis, conclusion, and a minimum of three supporting references.
1. Introduction (Define): Explain in your own words 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.
5. Analyze: Provide a summary of your conclusions based upon the four population proportion hypothesis tests.
6. The Dean has expressed a concern related to the amount of cheating currently taking place at Bo Diddley Tech and has strongly
suggested that you “tweak” the statistical data such that it favors 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 on your analysis of the data?

Student_BM

CollegeAthleteCheated1. Pivot TableNationwide Average% Cheated
Insert pivot table in this cell – F2Business56%
Nonbusiness47%
Insert pivot table in this cell – F2
Bar chart starts in this cell – F20
Bar chart starts in this cell – F20
Insert the appropriate numbers into the hypothesis testing calculations below based upon your pivot table results. Note the results.
3-6 Hypothesis Test
Business Nonathlete vs. National AverageBusiness Athlete vs. National AverageBusiness vs. National AverageNonbusiness vs. National AverageBusiness Athlete vs. Business Nonathlete
ProportionProportionProportionProportionp1 and p2 Proportion
Sample Size (n) =count(range)ERROR:#REF!Sample Size (n) =count(range)ERROR:#REF!Sample Size (n) =count(range)ERROR:#REF!Sample Size (n) =count(range)ERROR:#REF!AthleteNonathlete
Response of Interest (ROI)CheatedResponse of Interest (ROI)CheatedResponse of Interest (ROI)CheatedResponse of Interest (ROI)CheatedSample Size (n1 or n2) =COUNT(range)ERROR:#REF!ERROR:#REF!ERROR:#REF!
Count for Response (CFR) =COUNTIF(range,ROI)ERROR:#REF!Count for Response (CFR) =COUNTIF(range,ROI)ERROR:#REF!Count for Response (CFR) =COUNTIF(range,ROI)ERROR:#REF!Count for Response (CFR) =COUNTIF(range,ROI)ERROR:#REF!Response of Interest (ROI)ERROR:#REF!ERROR:#REF!ERROR:#REF!
Sample Proportion (pbar) =CFR/nERROR:#REF!Sample Proportion (pbar) =CFR/nERROR:#REF!Sample Proportion (pbar) =CFR/nERROR:#REF!Sample Proportion (pbar) =CFR/nERROR:#REF!Count for Response (CFR) =COUNTIF(n1or2,ROI)Did Not CheatDid Not Cheat
Sample Proportion (p1 or p2) =CFR1or2/n1or2ERROR:#REF!ERROR:#REF!
Highlight your H0 and HaTwo Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > poHighlight your H0 and HaTwo Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > poHighlight your H0 and HaTwo Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > poHighlight your H0 and HaTwo Tail H0: p = po Ha: p ≠ po Left Tail H0: p ≥ po Ha: p < po Right Tail H0: p ≤ po Ha: p > po
Hypothesized0.56Hypothesized0.56Hypothesized0.56Hypothesized0.47Highlight your H0 and HaTwo Tail H0: p1-p2=0 Left Tail H0: p1-p2≥0 Right Tail H0: p1-p2≤0Ha: p1-p2≠0 Ha: p1-p2<0 Ha: p1-p2>0
Confidence Coefficient (Coe)0.95Confidence Coefficient (Coe)0.95Confidence Coefficient (Coe)0.95Confidence Coefficient (Coe)0.95Hypothesized Value0
Level of Significance (alpha) =1-Coe0.05Level of Significance (alpha) =1-Coe0.05Level of Significance (alpha) =1-Coe0.05Level of Significance (alpha) =1-Coe0.05Level of Sig. α0.05
Point Estimation of Difference (Point) =p1-p2ERROR:#REF!
Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n)ERROR:#REF!Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n)ERROR:#REF!Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n)ERROR:#REF!Standard Error (StdError) =SQRT(Hypo*(1-Hypo)/n)ERROR:#REF!
Test Statistic (Z-stat) =(pbar-Hypo)/StdErrorERROR:#REF!Test Statistic (Z-stat) =(pbar-Hypo)/StdErrorERROR:#REF!Test Statistic (Z-stat) =(pbar-Hypo)/StdErrorERROR:#REF!Test Statistic (Z-stat) =(pbar-Hypo)/StdErrorERROR:#REF!Pooled Estimation of p (PE) =(n1*p1+n2*p2)/(n1+n2)ERROR:#REF!
Accept or Reject: Left TailERROR:#REF!Accept or Reject: Left TailERROR:#REF!Accept or Reject: Left TailERROR:#REF!Accept or Reject: Left TailERROR:#REF!Standard Error (StdError) =SQRT(PE*(1-PE)*(1/n1+1/n2))ERROR:#REF!
Accept or Reject: Right TailERROR:#REF!Accept or Reject: Right TailERROR:#REF!Accept or Reject: Right TailERROR:#REF!Accept or Reject: Right TailERROR:#REF!Test Statistic Z-stat =(Point-Hypo)/StdErrorERROR:#REF!
Accept or Reject: Two TailERROR:#REF!Accept or Reject: Two TailERROR:#REF!Accept or Reject: Two TailERROR:#REF!Accept or Reject: Two TailERROR:#REF!Accept or Reject: Left TailERROR:#REF!
Accept or Reject: Right TailERROR:#REF!
p-value (Lower Tail) =NORM.S.DIST(z,TRUE)ERROR:#REF!p-value (Lower Tail) =NORM.S.DIST(z,TRUE)ERROR:#REF!p-value (Lower Tail) =NORM.S.DIST(z,TRUE)ERROR:#REF!p-value (Lower Tail) =NORM.S.DIST(z,TRUE)ERROR:#REF!Accept or Reject: Two TailERROR:#REF!
p-value (Upper Tail) =1-LowerTailERROR:#REF!p-value (Upper Tail) =1-LowerTailERROR:#REF!p-value (Upper Tail) =1-LowerTailERROR:#REF!p-value (Upper Tail) =1-LowerTailERROR:#REF!
p-value (Two Tail) =2*MIN(LowerTail,UpperTail)ERROR:#REF!p-value (Two Tail) =2*MIN(LowerTail,UpperTail)ERROR:#REF!p-value (Two Tail) =2*MIN(LowerTail,UpperTail)ERROR:#REF!p-value (Two Tail) =2*MIN(LowerTail,UpperTail)ERROR:#REF!p-value (Lower Tail) =NORM.S.DIST(Zstat,TRUE)ERROR:#REF!
Accept or Reject p-value: Left TailERROR:#REF!Accept or Reject p-value: Left TailERROR:#REF!Accept or Reject p-value: Left TailERROR:#REF!Accept or Reject p-value: Left TailERROR:#REF!p-value (Upper Tail) =1-LowerTailERROR:#REF!
Accept or Reject p-value: Right TailERROR:#REF!Accept or Reject p-value: Right TailERROR:#REF!Accept or Reject p-value: Right TailERROR:#REF!Accept or Reject p-value: Right TailERROR:#REF!p-value (Two Tail) =2*MIN(LowerTail,UpperTail)ERROR:#REF!
Accept or Reject p-value: Two TailERROR:#REF!Accept or Reject p-value: Two TailERROR:#REF!Accept or Reject p-value: Two TailERROR:#REF!Accept or Reject p-value: Two TailERROR:#REF!Accept or Reject p-value: Left TailERROR:#REF!
Accept or Reject p-value: Right TailERROR:#REF!
p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!p-Lower Limit =pbar-CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!Accept or Reject p-value: Two TailERROR:#REF!
p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!p-Upper Limit =pbar+CONFIDENCE.NORM(alpha,StdError,n)ERROR:#REF!
Based upon the count of cheaters, categorized into business and nonbusiness students, place the relevant numbers in the purple area of the table below and note the conclusion.
8. Test of Independence – Is cheating independent of college and athletic participation?
Comparing business and nonbusiness students number of cheaters for 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
BusinessNonbusinessCalculations
Dependent variableObsExpObsExpTotalERROR:#REF!ERROR:#REF!
AthleteERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
NonathleteERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
TotalERROR:#REF!ERROR:#REF!ERROR:#REF!
Chi square test statistic =ERROR:#REF!
Level of signicance0.05
# of rows2
# of columns2
df =1df = (rows – 1)(columns – 1)
p-factor =ERROR:#REF!
Chi square critical3.8415
Conclusion:ERROR:#REF!

Data

 

 

 

 

 

 

 

 

 

CollegeAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessAthleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessNonathleteCheated
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessAthleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
BusinessNonathleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessNonathleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteCheated
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessAthleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteDid Not Cheat
NonbusinessNonathleteCheated
Order a Similar Paper

Nonbusiness

NonathleteCheated

You didn't find what you were looking for? Upload your specific requirements now and relax as your preferred tutor delivers a top quality customized paper

Order Now