This is all the information that was given. Please help me figure this out

PLEASE COMPLETE EXCEL SHEET! I DONT UNDERSTAND :(

ZOOM IN TO READ THE TEXT PLEASE. BEST I COULD DO

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 at Bo Diddley Tech (BDT) for several years. Some faculty members in the college 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. To resolve some of these issues, the dean 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 develop 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 240 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 and if the student was an athlete or not. Responses of the various questions were fed into a computer algorithm 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, "Benchmark - Bo Diddley Tech Data Set." Prepare a managerial report as part of your submission to the dean of the college that summarizes your assessment of the nature of cheating at BDT. Be sure to include the following items in your written report. Utilize the data set provided by the instructor in the Excel spreadsheet, "Benchmark - Bo Diddley Tech Data Set" (60 records per student). Submit the Excel data calculations (Alpha 0.05). 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 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. 4. 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. 5. 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. 6. 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. College Athlete Cheated Cheated 1. Pivot Table Insert pivot table in this cell - F2 Nationwide Avera Business Nonbusiness x Cheated 56% 47% 2. Bar Chart 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 Average Business Athlete vs. National Average Proportion Proportion Sample Size inil Samnle Size in Business vs. National Average Proportion Sample Size in Business Nonathlete vs. National Average Proportion Sample Size (n) = count(range) Response of Interest (ROI) Cheated Count for Response (CFR) -COUNTIF(range,RON Sample Proportion (pbar] -CFRin Business Athlete vs. National Average Proportion Sample Size (n) =count(range) Response of Interest (RON) Cheated Count for Response (CFR) -COUNTIF(range,ROI) Sample Proportion (pbar) -CFRIN Business vs. National Average Proportion Sample Size in = countrange) Response of Interest (RON) Count for Response (CFR) -COUNTIF(range,RON Sample Proportion (pbar) =CFRin Nonbusiness vs. National Average Proportion Sample Size (n) =count(range) Response of Interest (ROI Ches Count for Response (CFR) -COUNTIF(range, ROI) Sample Proportion (pbar) -CFRin Cheated Two Tail HO: p = po Ha: papo Left Tail Ho: p2 po Highlight your HO and Ha Ha: p DO 0.56 0.95 Two Tail HO: p = Ha:p Left Tail HO:p Ha:p Right Tail HO Highlight your HO and Ha Two Tail HO: p = po # po Left Tail Ho: p2 po Ha: p DO 0.56 0.95 Highlight your HO and Ha Happo Ha:p> 0.56 0.95 0 Hypothesized Confidence Coefficient (Coel Level of Significance (alpha) = 1-Coe Hypothesized Confidence Coefficient (Coe) Level of Significance (alpha) = 1-Coe Hypothesized Confidence Coefficient (Coel Level of Significance (alpha) = 1-Coe Hypothesized Confidence Coefficient (Coel Level of Significance (alpha) = 1-Coel 0.05 0.05 0.05 0 #DIV/0! #DIV/0! #DIV0! #DIV/0! #DIV/0! #DIV/0! Standard Error (StdError) =SQRT(Hypo" 1-Hypolin) Test Statistic (Z-stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tail Accept or Reject: Right Tail Accept or Reject: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! Standard Error (StdError) =SQRT(Hypo" (1-Hypoin) Test Statistic (Z-stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tall Accept or Reject: Right Tail Accept or Reject: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! Standard Error (StdError) =SQRT(Hypo" (1-Hypoin) Test Statistic (Z.stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tail Accept or Reject: Right Tail Accept or Reject: Two Tail Standard Error (StdError) =SQRT(Hypo" (1-Hypolin) Test Statistic (Z.stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tail Accept or Reject: Right Tail Accept or Rejeot: Two Tail #DIV/0! #DIV/0! #DIV/0! #D #DI #DI #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! P-value (Lower Tail) =NORM.S.DIST(2, TRUE P-value (Upper Tally = 1-Lower Tail P-value (Two Tail) -2 MIN(Lower Tail Upper Tail) Accept or Rejeot p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail P-value (Lower Tail) =NORM.S.DIST(2, TRUE) P-value (Upper Taill = 1-Lower Tail P-value (Two Tail -2'MIN(Lower Tail Upper Tail Accept or Rejeot p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Rejeot p-value: Two Tail #DIV/0! P-value (Lower Tail] ENORM.S.DIST(2, TRUE) P-value (Upper Tail) = 1-Lower Tail p-value (Two Tail) = 2 MIN(Lower Tail Upper Tail) Accept or Reject p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! ! #DIV/0! P-value (Lower Tail) -NORM.S.DIST(3,TRUE) P-value (Upper Tail) = 1-Lower Tail P-value (Two Tail) -2 MIN(Lower Tail, UpperTail) Accept or Reject p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #U #D1 #D #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! p-Lower Limit =pbar. p-Upper Limit GHORMASIS Starol P-Lower Limit Epbar p-Upper Limit borRORICINSKA MODA Sosure NORMAI P-Lower Limit =pbar. p-Upper Limit MORMI terror p-Lower Limit =pbar p-Upper Limit JORMASI terror #DIV/0! #DIV/0! ! #DIV/0! #DIV/0! obORICINCRAC RADI Sabah AORICIDCRAERODRICH PORICINERIAERODRIGE 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 at Bo Diddley Tech (BDT) for several years. Some faculty members in the college 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. To resolve some of these issues, the dean 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 develop 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 240 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 and if the student was an athlete or not. Responses of the various questions were fed into a computer algorithm 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, "Benchmark - Bo Diddley Tech Data Set." Prepare a managerial report as part of your submission to the dean of the college that summarizes your assessment of the nature of cheating at BDT. Be sure to include the following items in your written report. Utilize the data set provided by the instructor in the Excel spreadsheet, "Benchmark - Bo Diddley Tech Data Set" (60 records per student). Submit the Excel data calculations (Alpha 0.05). 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 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. 4. 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. 5. 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. 6. 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. College Athlete Cheated Cheated 1. Pivot Table Insert pivot table in this cell - F2 Nationwide Avera Business Nonbusiness x Cheated 56% 47% 2. Bar Chart 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 Average Business Athlete vs. National Average Proportion Proportion Sample Size inil Samnle Size in Business vs. National Average Proportion Sample Size in Business Nonathlete vs. National Average Proportion Sample Size (n) = count(range) Response of Interest (ROI) Cheated Count for Response (CFR) -COUNTIF(range,RON Sample Proportion (pbar] -CFRin Business Athlete vs. National Average Proportion Sample Size (n) =count(range) Response of Interest (RON) Cheated Count for Response (CFR) -COUNTIF(range,ROI) Sample Proportion (pbar) -CFRIN Business vs. National Average Proportion Sample Size in = countrange) Response of Interest (RON) Count for Response (CFR) -COUNTIF(range,RON Sample Proportion (pbar) =CFRin Nonbusiness vs. National Average Proportion Sample Size (n) =count(range) Response of Interest (ROI Ches Count for Response (CFR) -COUNTIF(range, ROI) Sample Proportion (pbar) -CFRin Cheated Two Tail HO: p = po Ha: papo Left Tail Ho: p2 po Highlight your HO and Ha Ha: p DO 0.56 0.95 Two Tail HO: p = Ha:p Left Tail HO:p Ha:p Right Tail HO Highlight your HO and Ha Two Tail HO: p = po # po Left Tail Ho: p2 po Ha: p DO 0.56 0.95 Highlight your HO and Ha Happo Ha:p> 0.56 0.95 0 Hypothesized Confidence Coefficient (Coel Level of Significance (alpha) = 1-Coe Hypothesized Confidence Coefficient (Coe) Level of Significance (alpha) = 1-Coe Hypothesized Confidence Coefficient (Coel Level of Significance (alpha) = 1-Coe Hypothesized Confidence Coefficient (Coel Level of Significance (alpha) = 1-Coel 0.05 0.05 0.05 0 #DIV/0! #DIV/0! #DIV0! #DIV/0! #DIV/0! #DIV/0! Standard Error (StdError) =SQRT(Hypo" 1-Hypolin) Test Statistic (Z-stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tail Accept or Reject: Right Tail Accept or Reject: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! Standard Error (StdError) =SQRT(Hypo" (1-Hypoin) Test Statistic (Z-stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tall Accept or Reject: Right Tail Accept or Reject: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! Standard Error (StdError) =SQRT(Hypo" (1-Hypoin) Test Statistic (Z.stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tail Accept or Reject: Right Tail Accept or Reject: Two Tail Standard Error (StdError) =SQRT(Hypo" (1-Hypolin) Test Statistic (Z.stat) = (pbar-Hypo)/StdError Accept or Reject: Left Tail Accept or Reject: Right Tail Accept or Rejeot: Two Tail #DIV/0! #DIV/0! #DIV/0! #D #DI #DI #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! P-value (Lower Tail) =NORM.S.DIST(2, TRUE P-value (Upper Tally = 1-Lower Tail P-value (Two Tail) -2 MIN(Lower Tail Upper Tail) Accept or Rejeot p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail P-value (Lower Tail) =NORM.S.DIST(2, TRUE) P-value (Upper Taill = 1-Lower Tail P-value (Two Tail -2'MIN(Lower Tail Upper Tail Accept or Rejeot p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Rejeot p-value: Two Tail #DIV/0! P-value (Lower Tail] ENORM.S.DIST(2, TRUE) P-value (Upper Tail) = 1-Lower Tail p-value (Two Tail) = 2 MIN(Lower Tail Upper Tail) Accept or Reject p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! ! #DIV/0! P-value (Lower Tail) -NORM.S.DIST(3,TRUE) P-value (Upper Tail) = 1-Lower Tail P-value (Two Tail) -2 MIN(Lower Tail, UpperTail) Accept or Reject p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #U #D1 #D #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! p-Lower Limit =pbar. p-Upper Limit GHORMASIS Starol P-Lower Limit Epbar p-Upper Limit borRORICINSKA MODA Sosure NORMAI P-Lower Limit =pbar. p-Upper Limit MORMI terror p-Lower Limit =pbar p-Upper Limit JORMASI terror #DIV/0! #DIV/0! ! #DIV/0! #DIV/0! obORICINCRAC RADI Sabah AORICIDCRAERODRICH PORICINERIAERODRIGE