PLEASE THE FOLLOWING USING EXCEL IF POSSIBLE ADDING A WORKSHEET ATTACHED

Testing Claims Using Sample Data. Use the given data set to test the stated claim.

Second-Hand Smoke Refer to Data Set CONTININE.XLS (in the References, Media and Data Files section of the course) and use the measured levels of serum cotinine (in ng/ml) in people who are nonsmokers and have no exposure to environmental tobacco smoke at home or at work (NOETS). Test the claim of tobacco company spokesmen that these people have positive levels of cotinine, suggesting that this measure is not a good indicator of exposure to tobacco smoke. Use a significance level of 0.05.

and

Testing for Uniformly Distributed Industrial Accidents A study was made of 147 industrial accidents that required medical attention. Among those accidents, 31 occurred on Monday, 42 on Tuesday, 18 on Wednesday, 25 on Thursday, and 31 on Friday (based on results from Counted Data CUSUMs by Lucas, Technometrics, Vol 27, No. 2). Test the claim that accidents occur with equal proportions on the five workdays. If the proportions are not the same, what factors might explain the differences? Use a 0.05 significant level.

and

Is Scanner Accuracy the Same for Specials? In a study of store checkout scanning systems, samples of purchases were used to compare the scanned prices to the posted prices. The accompanying table summarizes results for a sample of 819 items. When stores use scanners to check out items, are the error rates the same for regular-priced items as they are for advertised-special items? How might the behavior of consumers change if they believe that disproportionately more overcharges occur with advertised-special items?

Regular-Priced Items Advertised-Special Items

Undercharge 20 7

Overcharge 15 29

Correct price 384 364

Based on data from "UPC Scanner Pricing Systems: Are They Accurate?" by Ronald

Goodstein, Journal of Marketing, Vol. 58.

DATA SET: COTININE

Data Set: Passive and Active Smoke
All values are measured levels of serum cotine (in
ng/ml), a metabolite of nictotine. (When nictotine is
absorted by the body, cotinine is produced.)
NOETS:	Subjects are nonsmokers who have no
	environmental tobacco smoke (ETS) ex-
	posure at home or work.
ETS:	Subjects are nonsmokers who are ex-
	posed to environmental tobacco smoke
	at home or work
SMOKERS:	Subjects report tobacco use.
NOETS	ETS	SMOKERS
0.03	0.03	0.08
0.05	0.07	0.14
0.05	0.08	0.27
0.06	0.08	0.44
0.06	0.09	0.51
0.06	0.09	1.78
0.07	0.10	2.55
0.08	0.11	3.03
0.08	0.12	3.44
0.08	0.12	4.98
0.08	0.14	6.87
0.08	0.17	11.12
0.08	0.20	12.58
0.08	0.23	13.73
0.08	0.27	14.42
0.08	0.28	18.22
0.09	0.30	19.28
0.09	0.33	20.16
0.10	0.37	23.67
0.10	0.38	25.00
0.10	0.44	25.39
0.10	0.49	29.41
0.12	0.51	30.71
0.13	0.51	32.54
0.13	0.68	32.56
0.15	0.82	34.21
0.15	0.97	36.73
0.16	1.12	37.73
0.16	1.23	39.48
0.18	1.37	48.58
0.19	1.40	51.21
0.20	1.67	56.74
0.20	1.98	58.69
0.20	2.33	72.37
0.22	2.42	104.54
0.24	2.66	114.49
0.25	2.87	145.43
0.28	3.13	187.34
0.30	3.54	226.82
0.32	3.76	267.83
0.32	4.58	328.46
0.37	5.31	388.74
0.41	6.20	405.28
0.46	7.14	415.38
0.55	7.25	417.82
0.69	10.23	539.62
0.79	10.83	592.79
1.26	17.11	688.36
1.58	37.44	692.51
8.56	61.33	983.41