Unit 7 Lab Project LAB Unit 7: Stat Project [(Required/Graded) 25 points) CSLO A
ID: 3174209 • Letter: U
Question
Unit 7 Lab Project
LAB Unit 7: Stat Project [(Required/Graded) 25 points) CSLO A.5,CSLO A.6,CSLO F.5, CSLO G]
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. A portion of the data collected follows. The complete data set is in the WEBfile named Bayview.
Student
Copied from Internet
Copied on Exam
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
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
88
No
No
No
Male
89
No
Yes
Yes
Male
90
No
No
No
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.
Use descriptive statistics to summarize the data and comment on your findings.
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.
Ans.
For the proportion of all students:
p=42/90=0.4666667
So the lower bound is
p - Z*sqrt(p*(1-p)/n) =0.4666667 - 1.96*sqrt(0.4666667*(1-0.4666667)/90) =0.3635954
So the upper bound is
p + Z*sqrt(p*(1-p)/n) =0.4666667 + 1.96*sqrt(0.4666667*(1-0.4666667)/90) =0.569738
For the proportion of all male students:
p=24/90=0.2666667
So the lower bound is
p - Z*sqrt(p*(1-p)/n) =0.2666667 - 1.96*sqrt(0.2666667*(1-0.2666667)/90) =0.1753038
So the upper bound is
p + Z*sqrt(p*(1-p)/n) =0.2666667 + 1.96*sqrt(0.2666667*(1-0.2666667)/90) =0.3580296
So the lower bound is
p - Z*sqrt(p*(1-p)/n) =0.2 - 1.96*sqrt(0.2*(1-0.2)/90) =0.1173591
So the upper bound is
p + Z*sqrt(p*(1-p)/n) =0.2 + 1.96*sqrt(0.2*(1-0.2)/90) =0.2826409
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.
Ans.
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.
What advice would you give to the dean based upon your analysis of the data?
Ans.
These are the following steps that the dean could use to curb Cheating:
Conduct a viva after the submission of the project work to gauge the understanding of the student and rate the effectiveness of the project.
Provide an insight to the student explaining to them how and why the project is helpful to them in their academic and personal growth so that the tendency to cheat will be minimize.
In the next exams, the faculty can assign more teachers to the examination room, spread out student to curb communication during examination.
Faculty should invest in plagiarism software to help curb cheating form the internet.
Stat Project Points: 25 Points
Stat Project Estimated CU Time: 3 CU
Find Excel information below.
Student
Copied from Internet
Copied on Exam
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
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
88
No
No
No
Male
89
No
Yes
Yes
Male
90
No
No
No
Female
Explanation / Answer
Solution:-
2)
x = 39, n = 90
p = 0.4333
State the hypotheses. The first step is to state the null hypothesis and an alternative hypothesis.
Null hypothesis: P > 0.56
Alternative hypothesis: P < 0.56
Note that these hypotheses constitute a one-tailed test. The null hypothesis will be rejected only if the sample proportion is too small.
Formulate an analysis plan. For this analysis, the significance level is 0.05. The test method, shown in the next section, is a one-sample z-test.
Analyze sample data. Using sample data, we calculate the standard deviation () and compute the z-score test statistic (z).
= sqrt[ P * ( 1 - P ) / n ]
= 0.0523
z = (p - P) /
z = - 2.423
where P is the hypothesized value of population proportion in the null hypothesis, p is the sample proportion, and n is the sample size.
Since we have a one-tailed test, the P-value is the probability that the z-score is less than -2.423. We use the Normal Distribution Calculator to find P(z < - 2.423) = 0.007696
Thus, the P-value = 0.007696
Interpret results. Since the P-value (0.007696) is less than the significance level (0.05), we cannot accept the null hypothesis.
From this we conclude that 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.
3)
x = 39, n = 90
p = 0.4333
State the hypotheses. The first step is to state the null hypothesis and an alternative hypothesis.
Null hypothesis: P > 0.47
Alternative hypothesis: P < 0.47
Note that these hypotheses constitute a one-tailed test. The null hypothesis will be rejected only if the sample proportion is too small.
Formulate an analysis plan. For this analysis, the significance level is 0.05. The test method, shown in the next section, is a one-sample z-test.
Analyze sample data. Using sample data, we calculate the standard deviation () and compute the z-score test statistic (z).
= sqrt[ P * ( 1 - P ) / n ]
= 0.0526
z = (p - P) /
z = - 0.697
where P is the hypothesized value of population proportion in the null hypothesis, p is the sample proportion, and n is the sample size.
Since we have a one-tailed test, the P-value is the probability that the z-score is less than - 0.697. We use the Normal Distribution Calculator to find P(z < - 2.423) = 0.2429
Thus, the P-value = 0.2429
Interpret results. Since the P-value (0.2429) is less than the significance level (0.05), we cannot accept the null hypothesis.
From this we conclude that 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.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.