To complete this lab you need to use the Excel file Bayview uploaded with this a

Question

To complete this lab you need to use the Excel file Bayview uploaded with this assignment. Use Excel as much as you can, you may calculate some answers by hand to create the Managerial Report, see questions below. Make sure the end document that you upload has all the answers and is presented in one document, not multiple uploaded documents. Make sure to show all the steps in your calculations for the parts you do by hand. If you use Excel, show the functions and formulas that you used, copy and paste into one document.

The goal of this lab is to form confidence intervals and perform hypothesis tests using quantitative data; and to give an assessment to the dean based on your analysis of the data.

Ethical Behavior of Business Students at Bayview University

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 stem from the fact that cheating has become more prevalent among business students (Chronicle of Higher Education, February 10, 2009). 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 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 resolve some of these issues, the dean commissioned a study to assess the current ethical behavior of business students at Bayview. 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 Bayview, did you ever present work copied off the Internet as your own? Yes / No

During your time at Bayview, did you ever copy answers off another student’s exam? Yes / No

During your time at Bayview, 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.

Female

Managerial Report

Prepare a report for the dean of the college that summarizes your assessment of the nature of cheating by business students at Bayview University. Be sure to include the following items in your report.

1.) Use descriptive statistics to summarize the data and comment on your findings.

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

3.) Conduct a hypothesis test to determine if the proportion of business students at Bayview University who were involved in some type of cheating is less than that of business students at other institutions as reported by the Chronicle of Higher Education.

4.) Conduct a hypothesis test to determine if the proportion of business students at Bayview University who were involved in some form of cheating is less than that of nonbusiness students at other institutions as reported by the Chronicle of Higher Education.

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

Student Copied from Internet Copied on Test Collaborated on Individual Project Gender 1 No No No Female 2 No No No Male 3 Yes No Yes Male 4 Yes Yes No Male 5 No No Yes Male 6 Yes No No Female 7 Yes Yes Yes Female 8 Yes Yes Yes Male 9 No No No Male 10 Yes No No Female 11 No No No Male 12 No Yes Yes Female 13 No No Yes Male 14 No No No Male 15 No Yes Yes Male 16 No No No Male 17 No No No Male 18 No No No Female 19 No No No Female 20 No No Yes Male 21 No No No Male 22 Yes No No Female 23 No No No Female 24 No No No Male 25 No No Yes Female 26 No Yes No Female 27 No No No Female 28 No No Yes Male 29 No No Yes Male 30 No No No Male 31 No No No Male 32 Yes Yes Yes Female 33 No Yes Yes Male 34 No No No Male 35 No No No Female 36 Yes No Yes Female 37 Yes No Yes Male 38 No No No Female 39 Yes Yes Yes Male 40 Yes Yes Yes Female 41 No Yes Yes Male 42 No No No Female 43 No No Yes Female 44 No No Yes Male 45 No No Yes Male 46 No No No Female 47 No No No Male 48 Yes No No Male 49 No No No Male 50 Yes No No Female 51 No No No Male 52 No No No Male 53 Yes Yes No 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 61 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 Female 67 No No No Female 68 Yes Yes Yes Female 69 No No No Male 70 No No No Female 71 No No No Female 72 No No No Male 73 No No No Male 74 No Yes Yes Female 75 No No No Female 76 No Yes Yes Female 77 No No No Female 78 No No No Male 79 No No No Female 80 No No No Female 81 No No No Female 82 No No No Male 83 No No No Male 84 No No No Female 85 No Yes Yes Male 86 No No No Male 87 No No Yes Male 88 No No No Male 89 No Yes Yes Male 90 No No No

Female

Explanation / Answer

1. R CODES :
data1=read.csv(file.choose(),header=T)
attach(data1)
class(data1$Gender)
summary(data1)

OUTPUT :
Copied.from.Internet  Copied.on.Test  Collaborated.on.Individual.Project
No :74 No :72 No :61
Yes:16 Yes:18 Yes:29
Gender
Female:42
Male :48

The % of students copying from internet and copied on test is less than those not copying.
The % of students collaborated on individual project is less than those not collaborated.
The % of males is slight higher than that of females.

2.
k=1
a=c(rep(0,37))
for(i in 1:90)
{
if(Copied.from.Internet[i]=="Yes" ||Copied.on.Test[i]=="Yes" || Collaborated.on.Individual.Project[i]=="Yes")
{
a[k]=i
k=k+1
}
}

data2=data1[a,]
data2

binom.test(37, 90, 0.5,alternative="two.sided",conf.level=0.95)
95% confidence intervals for the proportion of all students :
95 percent confidence interval
0.3084186 0.5198221

attach(data2)
Gender
[1] Male Male Male Female Female Male Female Female Male Male
[11] Male Female Female Female Male Male Female Male Female Male
[21] Male Female Male Female Male Male Male Female Male Male
[31] Female Female Female Female Male Male Male

binom.test(21, 90, 0.5,alternative="two.sided",conf.level=0.95)
95% confidence intervals for the proportion of male students :
95 percent confidence interval:
0.1506115 0.3342915

binom.test(16, 90, 0.5,alternative="two.sided",conf.level=0.95)
95% confidence intervals for the proportion of female students :
95 percent confidence interval:
0.1051691 0.2725848

3.
binom.test(37, 90, 0.56,alternative="less",conf.level=0.95)
Exact binomial test

data: 37 and 90
number of successes = 37, number of trials = 90, p-value = 0.003183
alternative hypothesis: true probability of success is less than 0.56
95 percent confidence interval:
0.0000000 0.5032403
sample estimates:
probability of success
0.4111111
Here, p-value<0.05, hence we reject H0 in favour of H1 and conclude that the proportion of business students at Bayview University who were involved in some type of cheating is less than that of business students at other institutions as reported by the Chronicle of Higher Education.

4.
binom.test(37, 90, 0.47,alternative="less",conf.level=0.95)
Exact binomial test

data: 37 and 90
number of successes = 37, number of trials = 90, p-value = 0.1553
alternative hypothesis: true probability of success is less than 0.47
95 percent confidence interval:
0.0000000 0.5032403
sample estimates:
probability of success
0.4111111
Here, p-value>0.05, hence we accept H0 and conclude that he proportion of business students at Bayview University who were involved in some form of cheating is not less than that of nonbusiness students at other institutions as reported by the Chronicle of Higher Education.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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