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

module_7_assignment.xlsx

2

>

1

0.

9

phone

.9 A problem with a telephone line that prevents a

1

1

1

problems reported to two

1

1

0

1

1

.97

1

1.48 1

1

1

1

1

1.60 1

1

1

1

1

5

1

1

5

2

2

2

2

2

0.52 2

2

2

2

2

3.75 2

2

2

0.60 2

2

2

2

1.48 2

2

2

																																																																																										Time	Location		10
		1.	4	8	customer from receiving or making calls is upsetting to
1.	7	5	both the customer and the telephone company. The file
0.78	contains samples of	20
2.85	different offices of a telephone company and the time to
	0.52	clear these problems (in minutes) from the customers’
	1.	6	lines:
4.	15
	3	a. Assuming that the population variances from both offices
are equal, is there evidence of a difference in the
3.10	mean waiting time between the two offices? (Use a = 0.05.
1.02	b. Find the p-value in (a) and interpret its meaning.
0.53	c. What other assumption is necessary in (a)?
0.93
0.80
1.05
6.32
3.93
	5.4
0.97
		7.5
	3.75
0.10
1.10
	0.60
3.30
2.10
0.58
4.02
0.65
1.92
1.53
4.	23
0.08
1.65
0.72

10.

11

Digitalcameras

450

compact cameras.

9, pp. 28–29.)

200

0

330

0

280

240 260

200 280

400

280

0

200
260

220

0

240

290
280

200

0

230
220

200

0

150

	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	life of 29 subcompact cameras and	16
									280						260	(Data extracted from “Digital Cameras,” Consumer Reports,
	250		350	July										200
				24
			330	a. Assuming that the population variances from both types
			240					22	of digital cameras are equal, is there evidence of a difference
			230	in the mean battery life between the two types of
digital cameras (a = 0.05)?
b. Determine the p-value in (a) and interpret its meaning.
			220
	500
		21
			150
	13
	210
	205
	160
	14
	17

10.21Measurement

1

8.01

2

3

7

4 7.4

5

3

7.8

6 7.5

5

7

8

9

7.6

10

7.4

11

7.5

13

14

15

16

17 4.84

3

5.3

20

5.4

21

22

23

24

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

10.23 Ad Pages

b. What assumption is necessary about the population

distribution in order to perform this test?

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
Outside	126.97	103.58
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.

10.49 Digital Cameras

Subcompact Compact

300 400

310 450

290 450

280 260

250 350

200 240

330 330

240 220

280 230

240 260

200 280

220 400

280 500

210 200

260 150

220

240

210

205
290
160
280
200

230
220
200

150

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