Please provide clear answers and excel formulas as applicable. During the global

Question

Please provide clear answers and excel formulas as applicable.

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 suggesting that part of the reason for such unethical business behavior may stem from the fact that cheating has become more prevalent among business students. The article reported that 86% of business students admitted to cheating at some time during their academic career as compared to 77% of non-business students.

Cheating has been a concern of the dean of the College of Business at Rocky University for several years. Some faculty members in the college believe that cheating is more widespread at Rocky than at other universities, while other faculty members think that cheating is not a major problem at the college. To resolve some of these issues, the dean commissioned a study to assess the current ethical behavior of business students at Rocky. As part of this study, an anonymous exit survey was administered to a sample of 90 business students from this year’s graduating class. Responses to the following questions were used to obtain data regarding three types of cheating.

During your time at Rocky, did you ever present work copied off the internet as your own?

____ Yes
____ No

During your time at Rocky, did you ever copy answers off another student?

____ Yes
____ No

During your time at Rocky, did you ever collaborate with other students on projects that were supposed to be completed individually?

____ Yes
____ No

Any student who answered yes to one or more of these questions was considered to have been involved in some type of cheating. The complete data set is in the file named Rocky, linked at the bottom of the page.

Managerial Report
Prepare a report (see below) for the dean of the college that summarizes your assessment of the nature of cheating by business students at Rocky University. Be sure to include the following seven (7) items in your report.

To summarize the data, compute the proportion of all students, the proportion of all male students, and the proportion of all female students who

presented work copied off the internet as their own

copied answers off another student

collaborated with other students on projects that were supposed to be completed individually.  
Then comment on your findings.

Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in some type of cheating.

Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in copying off the internet.

Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in copying off another student.

Develop 95% confidence intervals for the proportion of all students, the proportion of all male students, and the proportion of all female students who were involved in collaborating on an individual project.

Conduct a hypothesis test (using either the p-value approach or the critical value approach) to determine if the proportion of all business students at Rocky University who were not involved in some type of cheating is less than that of all business students elsewhere. Use = 0.05. Do not forget to include the correctly worded hypotheses.

What advice would you give to the dean based upon your analysis of the data? Focus your advice on answering the following: What is the magnitude of the issue? What would you recommend for both students and faculty? What is the potential impact on relationships with the business community and what would you recommend? How can this study be improved?

Student Copied from Internet Copied on Exa. Collaborated on Individual Project Gender 1 NO NO YES Female 2 YES YES NO Male 3 YES NO NO Male 4 YES YES YES Female 5 YES YES NO Male 6 YES YES NO Female 7 NO NO YES Male 8 NO NO NO Female 9 NO NO YES Female 10 NO NO NO Female 11 NO NO NO Male 12 NO YES NO Female 13 NO YES YES Male 14 NO NO YES Male 15 NO YES YES Female 16 NO YES NO Female 17 NO YES YES Female 18 NO YES NO Female 19 YES YES YES Male 20 NO YES YES Male 21 YES NO NO Male 22 NO YES YES Female 23 NO YES NO Male 24 NO NO YES Female 25 YES YES YES Male 26 YES YES NO Female 27 YES NO NO Male 28 NO NO YES Female 29 YES YES NO Female 30 YES NO YES Female 31 NO YES NO Female 32 YES YES YES Male 33 YES YES NO Female 34 NO NO NO Female 35 NO YES NO Female 36 NO YES NO Male 37 NO NO NO Male 38 NO YES YES Male 39 YES NO YES Female 40 NO NO NO Female 41 YES NO NO Male 42 NO NO NO Male 43 YES YES YES Female 44 NO YES YES Male 45 YES NO YES Female 46 YES YES YES Male 47 NO YES NO Male 48 NO YES NO Female 49 NO YES YES Female 50 NO NO YES Male 51 YES YES NO Male 52 YES NO NO Female 53 YES NO YES Female 54 NO YES YES Female 55 NO NO NO Male 56 NO NO NO Female 57 YES YES NO Female 58 NO NO NO Male 59 YES NO YES Female 60 YES YES NO Female 61 NO YES NO Male 62 YES NO YES Male 63 NO NO YES Female 64 NO NO YES Male 65 YES NO NO Male 66 YES NO YES Male 67 NO YES YES Male 68 NO NO NO Female 69 NO NO YES Female 70 NO YES YES Male 71 NO YES YES Male 72 NO NO YES Male 73 NO YES NO Male 74 NO NO NO Male 75 YES NO NO Male 76 YES NO YES Female 77 NO NO YES Female 78 NO NO YES Female 79 YES YES YES Male 80 NO YES YES Male 81 NO NO YES Male 82 YES YES NO Male 83 YES YES YES Female 84 NO YES YES Male 85 NO YES YES Male 86 NO NO YES Male 87 NO NO YES Male 88 YES YES YES Male 89 NO YES YES Male 90 90 NO NO NO Male

Explanation / Answer

as per chegg policies i am giving answer to 1st 4 parts.

1)

Copied from Internet

Copied on Exm

Collaborated on Individual Project

count of Yes

34

46

49

propotion

0.377777778

0.511111111

0.544444444

Females:

Copied from Internet

Copied on Exm

Collaborated on Individual Project

count of females Yes

16

20

22

proportion females

0.39

0.49

0.54

Males:

Copied from Internet

Copied on Exm

Collaborated on Individual Project

count of males Yes

18

26

27

proportion males

0.37

0.53

0.55

95% ci for PROPORTION:

P +- z(A/2)*sqrt(p*(1-p)/n)

2)

Copied from Internet

all students

females

males

lower

0.29370883

0.240927

0.232364

upper

0.461846725

0.539561

0.50233

3)

involved in some type of cheating

all students

females

males

lower

0.756310351

0.745468

0.751313

upper

0.918108254

0.961849

0.962973

4)

Copied on Exm

all students

females

males

lower

0.424433

0.3348

0.390875

upper

0.597789

0.64081

0.67035

5)

Collaborated on Individual Project

all students

females

males

lower

0.458089

0.383945

0.411751

upper

0.6308

0.689225

0.69029

Copied from Internet

Copied on Exm

Collaborated on Individual Project

count of Yes

34

46

49

propotion

0.377777778

0.511111111

0.544444444

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.