Chips Ahoy Lab Data Turn In Example

	B	C	D	F	G	H	L	M
1		Number of Chocolate Chips in Chips Ahoy Cookie	Number of Chocolate Chips in Other Brand

2		33	50	t-Test: Two-Sample Assuming Equal Variances			Number of Chocolate Chips in Chips Ahoy Cookie	Number of Chocolate Chips in Other Brand
3		24	44				28.0	53.0
4		30	45		33	50
5		28	68	Mean	28	53
6		27	40	Variance	69	87
7		45	64	Observations	15	15
8		24	37	Pooled Variance	78
9		24	58	Hypothesized Mean Difference	0
10		19	56	df	28
11		39	55	t Stat	-8	absolute value = 8
12		27	51	P(T<=t) one-tail	0
13		40	55	t Critical one-tail	2
14		23	65	P(T<=t) two-tail	0.0	the results are not the same, there is a significant different
15		21	51	t Critical two-tail	2	critical value!
16		30	63
17		14	50
18	mean	28	53	Graph
19	std. dev	8	9
20	variance (stdev^2)	66	82
21	n (sample size)	17	17
22
23
24
25	T.TEST(range1, range2, tails, type)		0.000000002813871669
26
27	range1 - The first sample of data or group of cells to consider for the t-test.
28	range2 - The second sample of data or group of cells to consider for the t-test.
29	tails - Specifies the number of distribution tails.
30	If 1: uses a one-tailed distribution.
31	If 2: uses a two-tailed distribution.
32	type - Specifies the type of t-Test.
33	If 1: a paired test is performed.
34	If 2: a two-sample equal variance (homoscedastic) test is performed.
35	If 3: a two-sample unequal variance (heteroscedastic) test is performed.
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100