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 years 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 students 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.

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.

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?

Stat Project Points: 25 Points

Stat Project Estimated CU Time: 3 CU

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 years 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 students 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.

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.

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?

XCEL

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
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

Stat Project Points: 25 Points

Stat Project Estimated CU Time: 3 CU