I need some help, I'm not quite sure what to do.

Objectives:

Formulate hypothesis test for the population mean

Identify appropriate and

Identify an appropriate test to use

Conduct the test using Excel (SPSS when appropriate)

Interpret the results in the context of the problem

Data Sets:

I.UsedCars: A manager of Kansas City used car dealership reviewed a sample of 50 recent used car sales at the dealership in an attempt to determine whether the population mean price for used cars at this particular dealership differed from the national mean. The prices form the sample of 50 cars are include in the dataset UsedCars.

II.Bayview: An anonymous exit survey was administered to a sample of 90 graduating business students at Bayview University.

Description of Variables:

Student: control number to identify the responses of each participant.

Copied from Internet: Participants answer to the question: During your time at Bayview, did you ever present work copied off the Internet as your own? Possible answers were Yes or No.

Copied on Exam: Participants answer to the question: During your time at Bayview, did you ever copy answers off another student's exam? Possible answers were Yes or No.

Collaborated on Individual Project: Participants answer to the question: During your time at Bayview, did you ever collaborate with other students on projects that were supposed to be completed individually? Possible answers were Yes or No.

Involved in some type of cheating?: Any student who answered Yes to one of more of preview three questions is considered to have been involved in some type of cheating.

Gender: Identifies the participant's gender (Male or Female).

Exercise 1. According to the National Automobile Dealers Association, the mean price for used cars is $10,192. Using the sample data from UsedCars, complete the following tasks:

a)Formulate the hypotheses that can be used to determine whether a difference exists in the mean price for used cars at the dealership. Identify Ho and Ha.

b)Identify the appropriate test to conduct (z or t) and find the test statistic. Explain.

c)Conduct the test. What is the p-value?

d)At ? = .05, what is our conclusion? Interpret your results

Exercise 2. In an article that appeared in Chronicle of Higher Education on February 10, 2009 claimed that part of the reason for unethical behavior by Wall Street executives, financial managers, and other corporate officers is due to the fact that cheating has become more prevalent among business students. The article reported that 56% business students admitted to cheating at some time during their academic career.

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 help the dean to address these issues, conduct the following task using the dataset Bayview. Note: Any student who answered Yes to one of more of these questions is considered to have been involved in some type of cheating.

a)Use graphs (pie chart or bar chart) or frequency tables to summarize each variable (one graph or table per variable) and comment on your findings (compare the responses for each of the questions).

b)Use this sample of 90 students to develop a 95% confidence intervals for the proportion of business students at Bayview University who were involved in some type of cheating.

c)Conduct a hypothesis test to determine whether the proportion of business students at Bayview University who were involved in some type of cheating is equal to 56% as reported by the Chronicle of Higher Education. Use ? = .05.

d)Compare your results for Parts b and c. Describe your findings.

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

E Formatting as Table Styles FO 122 X V fx A B C D E F G H Copied from Collaborated on involved in some Student Internet Copied on Exam Individual Project type of cheating? Gender 1 No No C N No No Female 2 No No No No Male 3 Yes No Yes Yes Male 4 Yes Yes No Yes Male 6 5 No No Yes Male 6 Yes No No Yes Female 8 7 Yes Yes Yes Yes Female 9 8 Yes Yes Yes Yes Male 10 9 No No No No Male 11 10 Yes No No Yes Female 12 11 No No No No Male 13 12 No Yes Yes Yes Female 14 13 No No Yes Yes Male 15 14 No No No No Male 16 15 No Yes Yes Yes Male 17 16 No No No No Male 18 17 No No No No Male 19 18 No No No No Female 20 19 No No No No Female 21 20 No No Yes Yes Male 22 21 No No No No Male 22 Yes No No Yes Female 23 No No No No Female 24 No No No No Male 25 No No Yes Yes Female 27 26 No Yes No Yes Female 28 27 No No No No Female 29 28 No No Yes Yes Male 30 29|No No Yes Yes Male 31 30 No No No No Male Exercise 1 UsedCars Exercise 2 Bayview Sheet3 +Paste B I v $ % 00 90 Conditional Format Formatting as Table Sty 122 X V fx A B C D E F G 32 31 No No No No Male 33 32 Yes Yes Yes Yes Female 34 33 No Yes Yes Yes Male 35 34 No No No No Male 36 35 No No No No Female 37 36 Yes No Yes Yes Female 38 37 Yes No Yes Yes Male 39 38 No No No No Female 40 39 Yes Yes Yes Yes Male 41 40 Yes Yes Yes Yes Female 42 41 No Yes Yes Yes Male 42 No No No No Female 44 43 No No Yes Yes Female 45 44 No No Yes Yes Male 46 45 No No Yes Yes Male 46 No No No No Female 48 47 No No No No Male 49 48 Yes No No Yes Male 50 49 No No No No Male 51 50 Yes No No Yes Female 52 51 No No No No Male 53 52 No No No No Male 54 53 Yes Yes No Yes Male 55 54|No No No No Male 56 5| No No No No Female 57 56 No No Yes Yes Male 58 57 No No No No Male 59 58 No No No No Female 60 59 No No No No Female 61 60 No No No No Female 62 61 No No No No Female 63 62 No No No No Male Exercise 1 UsedCars Exercise 2 Bayview Sheet3 + ReadyPaste B I U v A $ v % 9 00 .00 Conditional Format Cell Formatting as Table Styles 122 X V fx A B C D E F G H 64 63 No No No No 65 64 No Female No No No 66 Female 65 No No No No 67 66 No Male Yes Yes Yes 68 67 No Female No No No 69 68 Yes Female Yes Yes Yes 70 69 No Female No No No 71 Male 70 No No No No 72 71 No Female No No No 73 72 No Female No No No 74 73 No Male No No 75 No 74 No Male Yes Yes 76 Yes 75|No Female No No No 77 76 No Female Yes Yes Yes 78 77 No Female No No No 79 78 No Female No No No 80 79 No Male No No No 81 80 No Female No No No 82 81 No Female No No No 83 82 No Female No No No 84 83 No Male No No No 85 84 No Male No No No 86 85 No Female Yes Yes Yes 87 86 No Male No No No 88 87 No Male No Yes Yes 89 88 No Male No No No 90 89 No Male Yes Yes Yes 91 90 No Male No No No 92 Female 93G5 X V fx A B C D E F 1 Sale Price 2 12400 3 10400 12100 10000 6 1 1000 8895 8 7675 9 9975 10 6350 11 10470 12 9895 13 1 1250 14 8795 15 12500 16 9340 17 10150 18 9200 19 9395 20 1 1000 21 10640 22 10000 23 7500 24 8000 25 10440 26 10200 27 10300 28 9740 Exercise 1 UsedCars Exercise 2 Bayview Sheet3 + ReadPaste BIUV A v G5 X V fx A B C D E F 29 9280 30 10930 31 8000 32 9000 33 7680 34 9400 35 10730 36 7350 37 12240 38 11970 39 8240 40 9910 41 10080 42 9440 43 8970 44 9500 45 10050 46 10130 47 1 1400 48 8500 49 7500 50 9090 51 10500 52 53 54 55 56 Exercise 1 UsedCars Exercise 2 Bayview Sheet3 +