STATS ASSIGNMENT 07 MA260 Statistical Analysis

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. 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 in 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’s exam? 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.
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 that presented a. Work copied off the
internet as their own b. Copied answers off another student’s exam c.
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’s exam.
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 individual project.
Conduct a hypothesis test 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. What advice would you give to the dean based upon your analysis of
the data? Write a report that adheres to the Written Assignment
Requirements under the heading. Items that should be included, but are
not limited to are a title page, an introduction, a body which answers
the questions posed in the problem and a conclusion paragraph that
addresses your findings and what you have determined from the data and
your analysis. As with all written assignments you should have in-text
citations and a reference page too. Please include any tables of
calculations, calculated values and graphs associated with this problem
in the body. NOTE: Submitting your Excel file will aid in grading with
partial credit if errors are found in the paper. Be sure that your
report contains the following: A title page An introduction A body of
the paper that answers the questions posed in the problem and
calculations and graphs associated with this problem. A conclusion
paragraph that addresses your findings and what you have determined from
the data and your analysis. Be sure to submit your Excel file as well.StudentCopied from InternetCopied on ExamCollaborated on Individual ProjectGender1NONONOFemale2YESYESNOFemale3NONOYESFemale4YESNONOFemale5YESYESNOMale6NONOYESFemale7YESYESYESFemale8NOYESNOFemale9NOYESNOMale10NONOYESMale11YESYESNOMale12NOYESNOFemale13NONOYESMale14YESYESYESFemale15NONOYESFemale16NOYESYESMale17YESYESNOFemale18NOYESNOMale19NONOYESFemale20NONOYESFemale21NONONOMale22YESNOYESMale23NOYESNOMale24YESYESYESMale25YESYESYESFemale26YESNONOMale27YESNONOFemale28NOYESYESMale29YESYESNOFemale30NOYESNOMale31NOYESNOMale32NOYESNOMale33NONOYESFemale34YESNOYESFemale35YESYESNOMale36NOYESNOMale37YESNOYESMale38NONONOMale39YESYESYESMale40YESNOYESFemale41YESNOYESMale42YESNOYESFemale43YESYESYESMale44NONOYESMale45NOYESYESFemale46NOYESNOFemale47YESNONOMale48NOYESYESFemale49NONOYESFemale50YESYESNOFemale51YESYESNOMale52YESNONOFemale53YESNONOMale54YESYESNOMale55YESNOYESMale56NOYESYESFemale57NOYESNOFemale58NOYESYESFemale59NOYESNOFemale60NONONOMale61NOYESNOMale62NONOYESMale63YESYESYESFemale64NOYESYESMale65YESNONOFemale66NONONOFemale67YESNOYESMale68NOYESYESFemale69YESNONOFemale70NONONOFemale71NONONOMale72NOYESNOFemale73YESYESYESFemale74NONONOFemale75NOYESYESFemale76YESNOYESMale77NONOYESFemale78YESNONOMale79YESYESYESMale80YESYESNOMale81NONOYESFemale82YESNOYESMale83NONONOFemale84YESYESNOMale85YESNONOMale86NOYESYESMale87NOYESYESFemale88YESYESYESFemale89NOYESYESFemale90YESYESNOMale