Carrier Air has been marketing that their new air conditioners will last more than 35,000 hours (about 4 years) before needing service. A random sample of recent vehicles was collected and the usage at the first service was measured. As the program is new, no information is known about the standard deviation of the population. Carrier would like be 95

Instructions

Excel Project #3
General Instructions
1. Responses to each page should be contained within that page.
2. Responses should be placed in the cell with the orange background.
3. Any tables needed for calcuations or answering questions should be clearly identified/labeled.
4. Calculations and tables must use cell references and appropriate functions (i.e., #s shouldn’t simply be typed w/o work or procedures evident)
5. Reminder: this is an individual (not group) project.
6. No external resources except for your book/notes and instructor may be utilized

Page1

Carrier Air has been marketing that their new air conditioners will last more than 35,000 hours (about 4 years) before needing service.
A random sample of recent vehicles was collected and the usage at the first service was measured.
As the program is new, no information is known about the standard deviation of the population.
Carrier would like be 95% certain that their air conditioners are, in fact, running more than 35,000 hours before needing service.
What are the null and alternative hypotheses?
Calculate the appropriate test statistic based on the data.
Determine the p-value (upper tail, lower tail, or two-tailed). Indicate which value is appropriate for the present test.
Include all relevant supporting data and statistics.
Hours Before Service
58401 H0 :
29908 Ha :
36034 a :
26750
42644 n
26267 Mean
46428 St. Dev.
50884
12533 Hypothesized Value
39647
69057 St. Error
32045 Test Statistic
31718 df
47887
38549 p-value (Lower Tail)
32272 p-value (Upper Tail)
26701 p-value (Two Tail)
16232
42546
39892
32171
37138
37212
35511
28769
26154
44820
30989
33499
33601
44670
44399
29732
47109
33999
20000
59222
36670
38718
32802
60676
34961
43406
42793
29951
42930
34784
32831
58134
41128

Page2

Fleisher Inc. is interested in comparing the salaries of its employees.
They have collected a random sample of salaries and are concerned that the women and men in the company are not being paid equally.
The variance of the population is known to be 80,000.
What are the null and alternative hypotheses?
Determine the 95% Confidence Interval estimate of the difference between the test scores.
Include all relevant supporting data and statistics.
If a = .05, perform the appropriate analysis (hint: Analysis Toolpak) to determine the observed test statistic value and corresponding p-value
Salary Women Salary Men
1100 750 H0 :
1050 700 Ha :
925 825
1000 1400 Women Men
950 900 Mean
900 1400 n
975 900 St. Dev.
1025 800 s2
935 900
975 1200 St. Error
1100 1500 a
1100 1500 z
1050 1000 Margin of Error
1075 1000 Interval Estimates
1050 1050
950 1300
1000 800 Test Statistic Value
1000 800 p-value
1050 1100
1000 1400
1075 1025
1015 675
950 825
925 1150
950 850
1050 825
950 675
1050 850
1100 1675
1050 1500
1000 1450
900 1000
885 1500
1100 575
1075 1750
1100 1500
1050 1000
950 1200
950 1500
1100 800
985 1700
885 875
950 1750
975 900
900 975
1000 1400
1075 675
950 1400
1085 900
900 935

Page3

Del Greco Sleep Experts is testing three new sleep programs.
Individuals were randomly assigned to a program and the number of hours slept were measured for each participant.
Del Greco would like to determine if the sleep systems produce different results.
What are the null and alternative hypotheses? (a = .05)
Calculate the mean and variance for each program.
Perform the appropriate test to determine if the sleeps systems produce different results.
Identify the degrees of freedom within in each source.
What are the values of the Mean Square due to Treatment and Error?
What is the value of the Test Statistic?
What is the appropriate p-value?
Program 1 Program 2 Program 3 H0 :
8 6 6 Ha :
5 5 5
11 10 6 Program 1 Program 2 Program 3
9 5 7 Mean
12 6 7 Variance
6 9 10
11 9 9 Degrees of freedom treatment
11 5 9 Degrees of freedom error
9 9 4 Degrees of freedom total
8 5 7
11 8 7 Mean Square Treatment
10 7 12 Mean Square Error
9 8 4
8 6 10 Test Statistic
6 9 7
11 8 6 p-value
10 9 10
5 6 10
8 10 10
12 8 12

Page4

Budweiser is interested in determining if their three types of beers are preferred differently by men and women.
Below is the data from a sample of 200 beer drinkers. The data is summarized in the crosstabs.
What are the null and alternative hypotheses?
What are the expected frequencies for each group (Beer Preference vs. Male/Female)? Display your results in a table.
What are the degrees of freedom for testing the equality of the proportions?
Perform the appropriate test to determine if drink preference differs across the sexes. What is the p-value for this test?
Drinker Beer Preference Sex H0:
1 Regular Male Ha:
2 Light Female
3 Regular Male Sex
4 Regular Male Beer Preference Female Male Grand Total
5 Regular Female Dark 10 23 33
6 Regular Male Light 40 50 90
7 Dark Female Regular 22 55 77
8 Dark Male Grand Total 68 132 200
9 Dark Female
10 Light Female
11 Light Male Expected Frequencies
12 Dark Female
13 Regular Female
14 Regular Female
15 Light Female
16 Regular Female
17 Dark Male
18 Regular Male
19 Light Female
20 Regular Male df
21 Regular Male
22 Light Male p-value
23 Regular Male
24 Light Female
25 Light Male
26 Dark Male
27 Light Male
28 Light Male
29 Regular Male
30 Light Male
31 Light Male
32 Light Female
33 Regular Male
34 Dark Male
35 Regular Male
36 Regular Female
37 Regular Male
38 Dark Male
39 Regular Female
40 Dark Male
41 Light Female
42 Dark Female
43 Dark Male
44 Regular Female
45 Light Male
46 Light Male
47 Regular Male
48 Light Female
49 Light Male
50 Regular Male
51 Light Male
52 Light Male
53 Light Female
54 Regular Female
55 Light Male
56 Regular Male
57 Dark Male
58 Light Female
59 Light Male
60 Dark Male
61 Regular Male
62 Regular Male
63 Light Female
64 Dark Male
65 Light Male
66 Light Female
67 Regular Female
68 Light Male
69 Light Male
70 Regular Male
71 Light Male
72 Regular Male
73 Regular Male
74 Regular Male
75 Light Female
76 Dark Male
77 Regular Male
78 Light Female
79 Regular Male
80 Regular Male
81 Light Female
82 Light Female
83 Light Male
84 Regular Male
85 Light Male
86 Light Female
87 Light Male
88 Light Male
89 Regular Female
90 Regular Male
91 Regular Female
92 Light Male
93 Regular Male
94 Light Male
95 Light Male
96 Regular Male
97 Regular Male
98 Light Female
99 Light Female
100 Dark Male
101 Light Male
102 Regular Male
103 Dark Male
104 Light Female
105 Dark Male
106 Regular Male
107 Light Male
108 Light Male
109 Light Male
110 Regular Female
111 Regular Male
112 Regular Male
113 Light Male
114 Regular Male
115 Light Female
116 Dark Male
117 Light Female
118 Light Female
119 Regular Male
120 Light Female
121 Light Male
122 Light Female
123 Light Female
124 Light Male
125 Regular Female
126 Regular Male
127 Regular Male
128 Dark Male
129 Regular Male
130 Dark Female
131 Light Female
132 Dark Male
133 Dark Female
134 Light Male
135 Light Female
136 Light Female
137 Dark Female
138 Regular Male
139 Light Female
140 Dark Male
141 Dark Male
142 Light Male
143 Light Male
144 Light Male
145 Light Female
146 Light Male
147 Regular Female
148 Light Female
149 Light Female
150 Dark Male
151 Light Male
152 Light Female
153 Regular Female
154 Regular Male
155 Regular Female
156 Regular Female
157 Regular Male
158 Dark Male
159 Light Female
160 Regular Male
161 Regular Male
162 Light Male
163 Light Male
164 Light Male
165 Regular Male
166 Light Male
167 Dark Female
168 Dark Male
169 Regular Male
170 Light Female
171 Regular Female
172 Regular Male
173 Dark Female
174 Dark Female
175 Light Female
176 Regular Male
177 Light Female
178 Regular Male
179 Regular Male
180 Light Female
181 Regular Female
182 Regular Female
183 Regular Male
184 Light Male
185 Regular Male
186 Light Female
187 Regular Female
188 Regular Male
189 Regular Male
190 Regular Female
191 Dark Male
192 Light Male
193 Light Male
194 Regular Male
195 Light Male
196 Light Male
197 Regular Male
198 Light Male
199 Light Male
200 Light Male

Order This Solution

Ask your homework question

 

INDIVIDUAL APPROACH:
Chat with every writer who applies to your request, and view their skills and portfolio. Make the choice that’s right for you.
MANAGE YOUR ORDER:
Monitor progress and see any changes made. Have full control over every phase of the process.
COMMUNICATE:
Ask your writer questions and provide your ideas about your paper. Produce the exact result that you want.
ENJOY THE OUTCOME:
Get everything done on time with high quality. Writing papers is much simpler with us.

Ask your homework question

 

© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
Loading...