statistic project 3

abbdis2008

Project3.xlsx

Home >Mathematics homework help >Statistics homework help >statistic project 3

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