stats assignment

Sheet1

Long-Lasting Battery	Regular Battery
51	42				"36"	1			"27"	1
44	29				"37"	1			"29"	2
58	51				"38"	2			"35"	2
36	38				"40"	2			"36"	1
48	39				"41"	1			"38"	3
53	44				"44"	3			"39"	2
57	35				"45"	1			"40"	1
40	40				"48"	1			"41"	1
49	48				"49"	1			"42"	2
44	45				"50"	2			"44"	2
60	38				"51"	2			"45"	2
50	55				"53"	1			"48"	1
57	42				"57"	3			"49"	1
58	49				"58"	2			"50"	1
64	35				"60"	1			"51"	1
45	41				"63"	1			"55"	1
40	50				"64"	1
65	29				"65"	1
50	45
41	38
51	39
38	36
38	44
57	27
44
63
37
min=	36		min=	27
max=	65		max=	55				t-Test: Two-Sample Assuming Equal Variances
mean=	49.5555555556		mean=	40.7916666667
st dev=	8.8636393521		st dev=	7.0954925476					Variable 1	Variable 2
								Mean	49.5555555556	40.7916666667
								Variance	78.5641025641	50.3460144928
								Observations	27	24
								Pooled Variance	65.318877551
								Hypothesized Mean Difference	0
								df	49
								t Stat	3.8652707576
								P(T<=t) one-tail	0.0001633345
								t Critical one-tail	1.6765508931
								P(T<=t) two-tail	0.000326669
								t Critical two-tail	2.0095751993

Pie-Chart for Long-lasting battery

"36" "37" "38" "40" "41" "44" "45" "48" "49" "50" "51" "53" "57" "58" "60" "63" "64" "65" 1 1 2 2 1 3 1 1 1 2 2 1 3 2 1 1 1 1

Pie-Chart for Regular Battery

"27" "29" "35" "36" "38" "39" "40" "41" "42" "44" "45" "48" "49" "50" "51" "55" 1 2 2 1 3 2 1 1 2 2 2 1 1 1 1 1

Sheet2

Long-Lasting Battery	Regular Battery
51	42		30
44	29		40
58	51		50
36	38		60
48	39		70
53	44
57	35
40	40		Bin	Frequency
49	48		30	0
44	45		40	6
60	38		50	9
50	55		60	9
57	42		70	3
58	49		More	0
64	35
45	41
40	50
65	29
50	45
41	38					Bin	Frequency
51	39					30	3
38	36					40	9
38	44					50	10
57	27					60	2
44						More	0
63
37
min=	36
max=	65
mean=	49.5555555556
st dev=	8.8636393521

Histogram

Frequency 30 40 50 60 70 More 0 6 9 9 3 0

Bin

Frequency

Histogram

Frequency 30 40 50 60 More 3 9 10 2 0

Bin

Frequency

Sheet3