This is an excel spreadsheet, I am currently needing help for these questions Modul 7 assignment

module_7_assignment.xlsx

10.9 phone

Time	Location	10.9 A problem with a telephone line that prevents a
1.48	1	customer from receiving or making calls is upsetting to
1.75	1	both the customer and the telephone company. The file
0.78	1	contains samples of 20 problems reported to two
2.85	1	different offices of a telephone company and the time to
0.52	1	clear these problems (in minutes) from the customers’
1.60	1	lines:
4.15	1
3.97	1	a. Assuming that the population variances from both offices
1.48	1	are equal, is there evidence of a difference in the
3.10	1	mean waiting time between the two offices? (Use a = 0.05.
1.02	1	b. Find the p-value in (a) and interpret its meaning.
0.53	1	c. What other assumption is necessary in (a)?
0.93	1
1.60	1
0.80	1
1.05	1
6.32	1
3.93	1
5.45	1
0.97	1
7.55	2
3.75	2
0.10	2
1.10	2
0.60	2
0.52	2
3.30	2
2.10	2
0.58	2
4.02	2
3.75	2
0.65	2
1.92	2
0.60	2
1.53	2
4.23	2
0.08	2
1.48	2
1.65	2
0.72	2

Subcompact	Compact	10.11 An important feature of digital cameras is battery life,
300	400	the number of shots that can be taken before the battery needs
310	450	to be recharged. The file contains the battery
290	450	life of 29 subcompact cameras and 16 compact cameras.
280	260	(Data extracted from “Digital Cameras,” Consumer Reports,
250	350	July 2009, pp. 28–29.)
200	240
330	330	a. Assuming that the population variances from both types
240	220	of digital cameras are equal, is there evidence of a difference
280	230	in the mean battery life between the two types of
240	260	digital cameras (a = 0.05)?
200	280	b. Determine the p-value in (a) and interpret its meaning.
220	400
280	500
210	200
260	150
220	130
240
210
205
290
160
280
200
140
230
220
200
170
150

Sample	In-Line	Analytical lab	10.21 In industrial settings, alternative methods often exist
1	8.01	8.01	for measuring variables of interest. The data in
2	7.56	7.29	(coded to maintain confidentiality) represent
3	7.47	7.54	measurements in-line that were collected from an analyzer
4	7.4	7.42	during the production process and from an analytical lab.
5	7.83	7.8	(Data extracted from M. Leitnaker, “Comparing Measurement
6	7.5	7.65	Processes: In-line Versus Analytical Measurements,”
7	6.86	6.93	Quality Engineering, 13, 2000–2001, pp. 293–298.)
8	7.31	7.46	a. At the 0.05 level of significance, is there evidence of a
9	7.45	7.6	difference in the mean measurements in-line and from an
10	7.23	7.4	analytical lab?
11	7.37	7.5	b. What assumption is necessary about the population
12	7.49	7.41	distribution in order to perform this test?
13	6.21	6.25
14	6.68	6.54
15	5.12	5.2
16	4.84	4.7
17	4.84	4.82
18	5.21	5.33
19	5.35	5.3
20	5.6	5.4
21	5.32	5.39
22	5.16	5.17
23	5.66	5.5
24	6.31	6.24

Magazine	2008	2009	10.23 In tough economic times, the business staff at
Details	72.31	48.42	magazines are challenged to sell advertising space in their
Esquire	66.69	42.79	publications. Thus, one indicator of a weak economy is the
Field & Stream	48.65	42.82	decline in the number of “ad pages” that magazines have
Flex	219.61	231.58	sold. The file contains the number of ad pages
GQ	99.21	60.35	found in the May 2008 and May 2009 issues of 12 men’s
Maxim	68.5	41.82	magazines. (Data extracted from W. Levith, “Magazine
Men's Fitness	99.43	67.63	Monitor,” Mediaweek, April 20, 2009, p. 53.)
Men's Health	90.88	74.45	a. At the 0.05 level of significance, is there evidence that
Men's Journal	183.1	88.34	the mean number of ad pages was higher in May 2008
Mucscle & Fitness	169.63	198.93	than in May 2009?
Outdoor Life	41.39	30.16	b. What assumption is necessary about the population
Outside	126.97	103.58	distribution in order to perform this test?
			c. Use a graphical method to evaluate the validity of the
			assumption in (b).
			d. Construct and interpret a 95% confidence interval
			estimate of the difference in the mean number of ad pages
			in men’s magazines between May 2008 and May 2009.

Subcompact	Compact	10.49 Do young children use cell phones? Apparently so,
300	400	according to a recent study (A. Ross, “Message to Santa;
310	450	Kids Want a Phone,” Palm Beach Post, December 16, 2008,
290	450	pp. 1A, 4A), which stated that cell phone users under
280	260	12 years of age averaged 137 calls per month as compared
250	350	to 231 calls per month for cell phone users 13 to 17 years of
200	240	age. No sample sizes were reported. Suppose that the results
330	330	were based on samples of 50 cell phone users in each group
240	220	and that the sample standard deviation for cell phone users
280	230	under 12 years of age was 51.7 calls per month and the sample
240	260	standard deviation for cell phone users 13 to 17 years of
200	280	age was 67.6 calls per month.
220	400	a. Using a 0.05 level of significance, is there evidence of a
280	500	difference in the variances of cell phone usage between
210	200	cell phone users under 12 years of age and cell phone
260	150	users 13 to 17 years of age?
220	130	b. On the basis of the results in (a), which t test defined in
240		Section 10.1 should you use to compare the means of the
210		two groups of cell phone users? Discuss.
205
290
160
280
200
140
230
220
200
170
150