Exercise 2. In an article that appeared in Chronicle of Higher Education on February 10, 2009 claimed that part of the reason for unethical behavior by Wall Street executives, financial managers, and other corporate officers is due to the fact that cheating has become more prevalent among business students. The article reported that 56% business students admitted to cheating at some time during their academic career.

Cheating has been a concern of the dean of the College of Business at Bayview University for several years. Some faculty members in the college believe that cheating is more widespread at Bayview than at other universities, whereas other faculty members think that cheating is not a major problem in the college. To help the dean to address these issues, conduct the following task using the dataset Bayview. Note: Any student who answered Yes to one of more of these questions is considered to have been involved in some type of cheating.

a)Use graphs (pie chart or bar chart) or frequency tables to summarize each variable (one graph or table per variable) and comment on your findings (compare the responses for each of the questions).

b)Use this sample of 90 students to develop 95% confidence intervals for the proportion of business students at Bayview University who were involved in some type of cheating.

c)Conduct a hypothesis test to determine whether the proportion of business students at Bayview University who were involved in some type of cheating is equal to 56% as reported by the Chronicle of Higher Education. Use ? = .05.

d)Compare your results for Parts b and c. Describe your findings.

e)What advice would you give to the dean based upon your analysis of the data?

AutoSave O Off) H Lab #4 for Online Class-1 - Excel Search himra afzaal File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Arial 10 - = ag Conditional Formatting * Insert 2 AY = General B U v A A = $ Format as Table v x Delete Analyze Sensitivity Paste Data A Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity 122 X V B C D E F G H J K L M N O P Q R S Copied from Collaborated on involved in some 1 Student Internet Copied on Exam Individual Project type of cheating? Gender 1 No No No No Female 2 No No No No Male 3 Yes No Yes Yes Male 4 Yes Yes No Yes Male 5 No No Yes Yes |Male 6 Yes No No Yes Female 7 Yes Yes Yes Yes Female 8 Yes Yes Yes Yes Male 9 No No No No Male 10 Yes No No Yes Female 11 No No No No Male 12 No |Yes Yes Yes Female 13 No No Yes Yes Male 14 No No No No Male 15 No Yes Yes Yes Male 16 No No No No Male 17 No No No No Male 18 No No No No Female 19 No No No No Female 20 No No Yes Yes Male 21 No No No No Male 22 Yes No No Yes Female 23 No No No No Female 24 No No No No Male 25 No No Yes Yes Female 26 No Yes No Yes Female 27 No No No No Female 28 No No Yes Yes Male 29 No No Yes Yes Male 30 No No No No Male 31 No No No No Male 32 Yes Yes |Yes Yes Female 33 No Yes Yes Yes Male 34 No No No No Male 35 No No No No Female 36 Yes No Yes Yes Female 37 Yes No Yes Yes Male Exercise 1 UsedCars Exercise 2 Bayview Sheet3 + 100% 9:54 PM Type here to search O 3/29/2021AutoSave O Off) Lab #4 for Online Class-1 - Excel Search himra afzaal H Share Comments File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat - Arial 10 = = General Conditional Formatting * Insert 2 AY B A $ Format as Table v x Delete Analyze Sensitivity Paste Data A Cell Styles ~ Format Number Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment 122 X V C D E F G H J K L M N O P Q R S 39 38 No No No No Female 40 39 Yes Yes Yes Yes Male 40 Yes Yes Yes Yes Female 42 41 No Yes Yes Yes Male 43 42 No No No No Female 44 43 No No Yes Yes Female 44 No No Yes Yes Male 15 No No Yes Yes Male 16 No No No No Female 47 No No No No Male 18 Yes |No No Yes Male 49 No No No No Male 50 Yes No No Yes Female 51 No No No No Male 52 No No No No Male 53 Yes Yes Yes Male 54 No No No Male 55 No No No Female 56 No No Yes Male 57 No No No Male 58 No No No Female 59 No No No Female 60 No No No Female 1 No No No Female 62 No No No Male 63 No No No Female 64 No No No Female 65 No No No Male 66| No Yes Yes Yes Female $7 No No No No Female 68 Yes Yes Yes Yes Female 69 No No No No Male 70 No No No No Female 71 No No No No Female 72 No No No No Male 73 No No No No Male 75 74 No Yes Yes Yes Female 76 75 No No No No Female 77 76 No Yes Yes Yes Female 78 No INn No Female Exercise 1 UsedCars Exercise 2 Bayview Sheet3 + 100% 9:55 PM Type here to search O 9 3/29/202178 17 No No No No Female 79 78 No No No No Male 80 79 No No No No Female 81 80 No No No No Female 82 81 No No No No Female 83 82 No No No No Male 84 83 No No No No Male 85 84 No No No No Female 86 85 No Yes Yes Yes Male 87 86 No No No No Male 88 87 No No Yes Yes Male 89 88 No No No No Male 90 89 No Yes Yes Yes Male 91 90 No No No No Female 92 Exercise 1 UsedCars Exercise 2 Bayview Sheet3 +