Assignment

Ruth2014

ExcelAssignmentSpreadsheet62.xlsx

Home >Mathematics homework help >Statistics homework help >Assignment

ANOVA

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
Diastolic_2_Grp_1	23	2363	102.7391304348	11.3833992095
Diastolic_2_Grp2	27	2783	103.0740740741	14.1481481481
Diastolic_2_Grp3	29	2988	103.0344827586	10.3916256158
ANOVA
Source of Variation	SS	df	MS	F	F crit
Between Groups	1.6339242474	2	0.8169621237	0.0682859219	3.1169818374
Within Groups	909.2521517019	76	11.9638441013
Total	910.8860759494	78

Correlation

	Wt_Grp_3	Systolic BP_1_Grp3
Wt_Grp_3	1
Systolic BP_1_Grp3	0.2414792864	1

Descriptives

	Ht_Grp_1	Ht_Grp_2	Ht_Grp_3	Wt_Grp_1	Wt_Grp_2	Wt_Grp_3	Age_Grp_1	Age_Grp_2	Age_Grp_3	Group_1 Surv	Group_2 Surv	Group_3 Surv	Systolic BP_1_Grp1	Diastolic_1_Grp_1	Mean BP_1_Grp_1	Systolic BP_2_Grp1	Diastolic_2_Grp_1	Mean BP_2_Grp_1	Systolic BP_1_Grp2	Diastolic_1_Grp2	Mean BP_1_Grp2	Systolic BP_2_Grp2	Diastolic_2_Grp2	Mean BP_2_Grp2	Systolic BP_1_Grp3	Diastolic_1_Grp3	Mean BP_1_Grp3	Systolic BP_2_Grp3	Diastolic_2_Grp3	Mean BP_2_Grp3
Mean	69.652173913	66.4444444444	64.7142857143	182.347826087	183.1111111111	185.2142857143	65.7826086957	56.5185185185	44.75	0.4642857143	0.4761904762	0.4285714286	157.9130434783	100.9565217391	119.9420289855	162.1304347826	102.7391304348	122.5362318841	138.8518518519	101.1481481481	113.7160493827	166.6296296296	103.0740740741	124.2592592593	135.4285714286	99.3571428571	111.380952381	161	103.1071428571	140.9166666667
Standard Error	0.7507800835	0.6255102381	0.8275308189	3.9017623948	3.9199007682	4.3889462954	0.6740724024	0.5347480445	0.5810613351	0.0959792589	0.1116765657	0.0952380952	2.6613267839	1.2845667375	1.4500393243	2.3391363122	0.7035129	0.8813539935	2.0937457428	1.3276628392	1.041206064	2.2853105471	0.7238822328	0.8107252982	2.0602232962	1.0937705834	1.1626555241	1.6824648082	0.6157957937	1.3066808164	Variable	Coefficient of Variation
Median	71	66	64.5	184	180	195	67	57	44.5	0	0	0	158	101	120.6666666667	160	102	122.6666666667	136	103	114	169	103	125	136	100	112	160.5	103	140.8333333333	Ht_Grp_1	5.2
Mode	65	66	69	187	188	156	67	57	41	0	0	0	152	101	115	158	99	118	125	106	114.6666666667	169	107	126.6666666667	150	104	107.3333333333	149	101	133.6666666667	Ht_Grp_2	4.9
Standard Deviation	3.6006147916	3.250246539	4.3788814981	18.7121950893	20.3684018733	23.2241208307	3.2327376765	2.7786323472	3.0746875782	0.5078745002	0.5117663157	0.5039526307	12.7632748842	6.1605656534	6.9541443017	11.2181036634	3.3739293427	4.2268252652	10.8794220141	6.8987384783	5.4102654118	11.874821936	3.7614024177	4.2126522223	10.9016769741	5.7876899103	6.1521947542	8.902766944	3.2584850572	6.9143049664	Ht_Grp_3	6.8
Sample Variance	12.9644268775	10.5641025641	19.1746031746	350.1462450593	414.8717948718	539.3597883598	10.4505928854	7.7207977208	9.4537037037	0.2579365079	0.2619047619	0.253968254	162.9011857708	37.95256917	48.3601229688	125.8458498024	11.3833992095	17.8660518226	118.3618233618	47.5925925926	29.2709718265	141.0113960114	14.1481481481	17.7464387464	118.8465608466	33.4973544974	37.8495002939	79.2592592593	10.6177248677	47.8076131687	Wt_Grp_1	10.3
Kurtosis	-1.5840746686	-1.1998041757	-1.2038168366	-0.3504530552	-1.0428313054	-1.5846031099	-1.3288003683	-0.5066298662	-1.2254706258	-2.1352899408	-2.2105263158	-2.0596153846	-1.3701498485	-1.023091066	-1.0682807681	-0.7010044888	-1.3713265129	-1.2607343464	-1.1491447485	-1.5442934008	-0.6878750843	-1.187750661	-1.6555982145	0.1064622765	-1.0549392047	-0.9059789451	-0.7328648113	-1.0856754114	-1.2696402397	0.1829290545	Wt_Grp_2	11.1
Skewness	-0.3363851592	0.1855871166	0.1332054502	0.3846588796	0.2303830228	-0.1522567307	-0.3165556133	-0.6312643925	0.294851831	0.1514607977	0.1028429917	0.3052789974	0.1221852512	-0.1788752633	0.0449683718	0.3871803024	0.2468008092	-0.1468132877	0.429537413	-0.231528	-0.1640067578	-0.1908867475	0.0033127891	-0.3736955711	-0.2319929697	-0.2469432596	-0.4361527359	0.0668133707	-0.0682271006	-0.3180400626	Wt_Grp_3
Range	10	10	14	64	63	70	9	9	9	1	1	1	39	20	23	39	10	13.3333333333	33	20	18.6666666667	38	10	17.6666666667	35	19	21.3333333333	32	10	31	Age_Grp_1	4.9
Minimum	64	62	58	154	154	150	61	51	41	0	0	0	140	90	109.3333333333	145	98	115	125	90	104.3333333333	146	98	114	115	90	98.3333333333	146	98	123	Age_Grp_2	4.9
Maximum	74	72	72	218	217	220	70	60	50	1	1	1	179	110	132.3333333333	184	108	128.3333333333	158	110	123	184	108	131.6666666667	150	109	119.6666666667	178	108	154	Age_Grp_3	6.9
Sum	1602	1794	1812	4194	4944	5186	1513	1526	1253	13	10	12	3632	2322	2758.6666666667	3729	2363	2818.3333333333	3749	2731	3070.3333333333	4499	2783	3355	3792	2782	3118.6666666667	4508	2887	3945.6666666667	Group_1 Surv	109.4
Count	23	27	28	23	27	29	23	27	28	28	21	28	23	23	23	23	23	23	27	27	27	27	27	27	28	28	28	28	28	28	Group_2 Surv	107.5
Confidence Level(95.0%)	1.5570225879	1.2857546959	1.6979529681	8.0917599104	8.0574713465	9.005373841	1.3979405947	1.099190337	1.1922393656	0.1969331701	0.2329532333	0.1954124279	5.5192539166	2.6640283485	3.0071974882	4.8510717776	1.4589964494	1.8278163019	4.3037559692	2.7290500238	2.1402296952	4.6975230599	1.487961225	1.6664697007	4.2272289815	2.2442318354	2.3855720571	3.4521325967	1.263508587	2.6810875437	Group_3 Surv	117.6
Upper Limt CI	71.209196501	67.7301991404	66.4122386824	190.4395859974	191.1685824576	194.2196595553	67.1805492904	57.6177088555	45.9422393656	0.6612188844	0.7091437095	0.6239838565	163.4322973948	103.6205500876	122.9492264737	166.9815065602	104.1981268842	124.364048186	143.1556078211	103.8771981719	115.8562790779	171.3271526896	104.5620352991	125.92572896	139.6558004101	101.6013746926	113.7665244381	164.4521325967	104.3706514441	143.5977542104	Systolic BP_1_Grp1	8.1
Lower Limit CI	68.0951513251	65.1586897485	63.0163327462	174.2560661765	175.0536397646	176.2089118733	64.3846681009	55.4193281815	43.5577606344	0.2673525442	0.2432372429	0.2331590007	152.3937895617	98.2924933907	116.9348314973	157.279363005	101.2801339854	120.7084155821	134.5480958826	98.4190981244	111.5758196875	161.9321065697	101.586112849	122.5927895585	131.2013424471	97.1129110217	108.9953803239	157.5478674033	101.8436342701	138.2355791229	Diastolic_1_Grp_1	6.1
																															Mean BP_1_Grp_1	5.8
							2.7958811895	2.1983806741	2.3844787312																						Systolic BP_2_Grp1	6.9
																															Diastolic_2_Grp_1	3.3
																															Mean BP_2_Grp_1	3.4
																															Systolic BP_1_Grp2	7.8
																															Diastolic_1_Grp2	6.8
																															Mean BP_1_Grp2	4.8
																															Systolic BP_2_Grp2	7.1
																															Diastolic_2_Grp2	3.6
																															Mean BP_2_Grp2	3.4
																															Systolic BP_1_Grp3	8
																															Diastolic_1_Grp3	5.8
																															Mean BP_1_Grp3	5.5
																															Systolic BP_2_Grp3	5.5
																															Diastolic_2_Grp3	3.2
																															Mean BP_2_Grp3	4.9

Histogram

Weight Group 3	Frequency	Cumulative %
141-150	1	3.45%
151-160	5	20.69%
161-170	4	34.48%
171-180	2	41.38%
181-190	0	41.38%
191-200	7	65.52%
201-210	5	82.76%
211-220	5	100.00%

Histogram

Frequency 141-150 151-160 161-170 171-180 181-190 191-200 201-210 211-220 1 5 4 2 0 7 5 5 Cumulative % 141-150 151-160 161-170 171-180 181-190 191-200 201-210 211-220 3.4482758620689655E-2 0.20689655172413793 0.34482758620689657 0.41379310344827586 0.41379310344827586 0.65517241379310343 0.82758620689655171 1

Weight Classes

Frequency

Incidence

Participant	Diastolic_1_Grp_1	Diseased?	Diastolic_2_Grp_1
1	92	0	99	0
2	109	1	103	Diseased at Start
3	108	1	99	Diseased at Start
4	101	1	100	Diseased at Start
5	90	0	108	1
6	92	0	104	1
7	101	1	105	Diseased at Start
8	93	0	106	1
9	95	0	105	1
10	106	1	100	Diseased at Start
11	101	1	98	Diseased at Start
12	99	0	102	1
13	104	1	107	Diseased at Start
14	105	1	106	Diseased at Start
15	99	0	101	1
16	94	0	108	1
17	105	1	102	Diseased at Start
18	99	0	104	1
19	108	1	99	Diseased at Start
20	110	1	101	Diseased at Start
21	101	1	99	Diseased at Start
22	100	0	108	1
23	110	1	99	Diseased at Start
		13			9

PairedTtest

t-Test: Paired Two Sample for Means
	Diastolic_1_Grp2	Diastolic_2_Grp2
Mean	101.1481481481	103.0740740741
Variance	47.5925925926	14.1481481481
Observations	27	27
Pearson Correlation	0.0781174947
Hypothesized Mean Difference	0
df	26
t Stat	-1.3176011151
P(T<=t) two-tail	0.1991303141
t Critical two-tail	2.0555294185

PercentileRank

Point	Wt_Grp_3	Rank	Percent
8	220	1	100.00%
17	216	2	96.40%
15	213	3	89.20%
27	213	3	89.20%
4	211	5	85.70%
2	209	6	82.10%
10	205	7	75.00%
13	205	7	75.00%
29	202	9	71.40%
3	201	10	67.80%
11	200	11	64.20%
7	196	12	57.10%
14	196	12	57.10%
25	195	14	50.00%
26	195	14	50.00%
19	193	16	46.40%
5	191	17	42.80%
12	174	18	39.20%
21	172	19	35.70%
24	165	20	32.10%
22	163	21	28.50%
9	162	22	25.00%
23	161	23	21.40%
18	159	24	17.80%
1	157	25	14.20%
6	156	26	7.10%
28	156	26	7.10%
16	152	28	3.50%
20	150	29	0.00%

RawData

Ht_Grp_1	Ht_Grp_2	Ht_Grp_3	Wt_Grp_1	Wt_Grp_2	Wt_Grp_3	Age_Grp_1	Age_Grp_2	Age_Grp_3	Group_1 Surv	Group_2 Surv	Group_3 Surv	Systolic BP_1_Grp1	Diastolic_1_Grp_1	Mean BP_1_Grp_1 dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.	Systolic BP_2_Grp1	Diastolic_2_Grp_1	Mean BP_2_Grp_1 dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.	Systolic BP_1_Grp2	Diastolic_1_Grp2	Mean BP_1_Grp2 dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.	Systolic BP_2_Grp2	Diastolic_2_Grp2	Mean BP_2_Grp2 dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.	Systolic BP_1_Grp3	Diastolic_1_Grp3	Mean BP_1_Grp3 dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.	Systolic BP_2_Grp3	Diastolic_2_Grp3	Mean BP_2_Grp3 dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.	dmbarton2: dmbarton2: This is not an "average" blood pressure but a calculation.													Wt_Grp_3	Systolic BP_1_Grp3	Diastolic_2_Grp_1	Diastolic_2_Grp2	Diastolic_2_Grp3	Diastolic_1_Grp2	Diastolic_2_Grp2	Diastolic_1_Grp_1	Diastolic_2_Grp_1
73	66	59	174	188	157	69	55	45	0	1	1	152	92	112.0	156	99	118.0	137	90	105.7	161	107	125.0	118	94	102.0	167	101	123.0		157	118	99	107	101	90	107	17	+	92	0	99	0
68	66	58	186	157	209	67	57	50	0	0	0	179	109	132.3	145	103	117.0	125	106	112.3	151	108	122.3	129	91	103.7	160	107	142.3		209	129	103	108	107	106	108	2	+	109	1	103	Diseased at Start
65	72	69	154	191	201	62	60	49	0	0	0	173	108	129.7	184	99	127.3	136	109	118.0	169	100	123.0	142	107	118.7	154	103	137.0		201	142	99	100	103	109	100	-9	-	108	1	99	Diseased at Start
65	64	66	202	179	211	65	57	45	1	0	1	147	101	116.3	161	100	120.3	134	108	116.7	154	99	117.3	140	91	107.3	149	106	134.7		211	140	100	99	106	108	99	-9	-	101	1	100	Diseased at Start
70	64	63	218	175	191	62	59	41	0	0	1	158	90	112.7	165	108	127.0	151	95	113.7	179	100	126.3	131	104	113.0	146	103	131.7		191	131	108	100	103	95	100	5	+	90	0	108	1
65	70	67	185	156	156	65	57	46	1	0	0	166	92	116.7	160	104	122.7	131	94	106.3	184	103	130.0	122	100	107.3	178	106	154.0		156	122	104	103	106	94	103	9	+	92	0	104	1
74	66	64	187	214	196	61	55	47	0	1	1	143	101	115.0	174	105	128.0	132	102	112.0	168	106	126.7	134	93	106.7	149	103	133.7		196	134	105	106	103	102	106	4	+	101	1	105	Diseased at Start
71	66	72	187	166	220	69	60	44	1	1	0	142	93	109.3	154	106	122.0	125	94	104.3	170	108	128.7	137	97	110.3	161	98	140.0		220	137	106	108	98	94	108	14	+	93	0	106	1
73	68	67	184	177	162	67	52	44	1	1	1	141	95	110.3	169	105	126.3	143	106	118.3	172	107	128.7	138	99	112.0	168	101	145.7		162	138	105	107	101	106	107	1	+	95	0	105	1
71	63	61	187	180	205	66	54	49	1	1	1	149	106	120.3	178	100	126.0	152	93	112.7	169	99	122.3	130	100	110.0	153	101	135.7		205	130	100	99	101	93	99	6	+	106	1	100	Diseased at Start
64	62	65	172	155	200	67	57	42	0	1	1	173	101	125.0	158	98	118.0	158	92	114.0	159	100	119.7	150	101	117.3	170	99	146.3		200	150	98	100	99	92	100	8	+	101	1	98	Diseased at Start
70	70	59	193	214	174	68	51	42	1	1	0	169	99	122.3	170	102	124.7	157	103	121.0	181	98	125.7	149	104	119.0	154	100	136.0		174	149	102	98	100	103	98	-5	-	99	0	102	1
66	71	60	180	180	205	61	58	44	1	1	0	162	104	123.3	166	107	126.7	139	99	112.3	174	101	125.3	121	90	100.3	159	105	141.0		205	121	107	101	105	99	101	2	+	104	1	107	Diseased at Start
74	66	60	217	187	196	61	57	49	0	0	1	168	105	126.0	158	106	123.3	132	106	114.7	170	100	123.3	131	109	116.3	164	102	143.3		196	131	106	100	102	106	100	-6	-	105	1	106	Diseased at Start
72	62	72	215	202	213	70	59	41	0	0	1	178	99	125.3	162	101	121.3	126	109	114.7	179	107	131.0	145	104	117.7	158	99	138.3		213	145	101	107	99	109	107	-2	-	99	0	101	1
73	62	60	172	154	152	61	54	48	0	0	0	140	94	109.3	146	108	120.7	149	110	123.0	164	108	126.7	121	104	109.7	169	108	148.7		152	121	108	108	108	110	108	-2	-	94	0	108	1
72	63	69	157	170	216	69	58	41	1	0	1	152	105	120.7	181	102	128.3	126	97	106.7	156	106	122.7	129	103	111.7	174	98	148.7		216	129	102	106	98	97	106	9	+	105	1	102	Diseased at Start
74	64	62	168	195	159	68	55	42	1	0	1	146	99	114.7	177	104	128.3	134	105	114.7	172	98	122.7	148	105	119.3	168	108	148.0		159	148	104	98	108	105	98	-7	-	99	0	104	1
72	69	68	192	177	193	70	57	46	1	0	0	155	108	123.7	151	99	116.3	138	105	116.0	147	104	118.3	150	101	117.3	163	107	144.3		193	150	99	104	107	105	104	-1	-	108	1	99	Diseased at Start
65	62	72	155	215	150	63	60	41	0	1	0	159	110	126.3	158	101	120.0	135	110	118.3	181	107	131.7	136	100	112.0	162	98	140.7		150	136	101	107	98	110	107	-3	-	110	1	101	Diseased at Start
65	64	64	184	217	172	65	59	41	1	1	0	143	101	115.0	156	99	118.0	125	105	111.7	152	108	122.7	147	97	113.7	149	107	135.0		172	147	99	108	107	105	108	3	+	101	1	99	Diseased at Start
67	68	62	164	211	163	67	56	43	0		0	165	100	121.7	153	108	123.0	131	92	105.0	153	106	121.7	133	90	104.3	172	103	149.0		163	133	108	106	103	92	106	14	+	100	0	108	1
73	66	62	161	165	161	70	57	50	0		0	172	110	130.7	147	99	115.0	156	91	112.7	146	98	114.0	141	109	119.7	153	106	137.3		161	141	99	98	106	91	98	7	+	110	1	99	Diseased at Start
	70	69		155	165		52	41	1		0							143	110	121.0	181	101	127.7	115	90	98.3	159	105	141.0		165	115		101	105	110	101	-9	-
	70	66		188	195		59	45	0		1							150	99	116.0	169	103	125.0	150	95	113.3	172	107	150.3		195	150		103	107	99	103	4	+	Disease=>	13	Disease=>	9
	68	69		203	195		51	46	1		0							154	107	122.7	184	98	126.7	149	103	118.3	171	101	147.7		195	149		98	101	107	98	-9	-	Disease Free=>	10	Disease Free=>	1
	72	68		173	213		60	43	0		0							130	94	106.0	154	103	120.0	136	102	113.3	150	101	133.7		213	136		103	101	94	103	9	+
		59			156			48	0		0													120	99	106.0	156	104	138.7		156	120			104
		61			202			45	1		1										166.6296296296			130	99	109.3	150	101	133.7		202	130			101			Positive=>	16
																																						Negative=>	11
																															220

Regression

SUMMARY OUTPUT
Regression Statistics
R Square	0.0583122458
Standard Error	10.6258516145
Observations	29
ANOVA
	df	SS	MS	F	Significance F
Regression	1	188.7748364223	188.7748364223	1.6719242959	0.2069559114
Residual	27	3048.5355084052	112.9087225335
Total	28	3237.3103448276
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	114.2828213329	16.3285425008	6.9989603375	0.0000001597	80.779419924	147.7862227419	80.779419924	147.7862227419
Wt_Grp_3	0.1128058985	0.0872415765	1.2930291164	0.2069559114	-0.0661990283	0.2918108254	-0.0661990283	0.2918108254

ScatterPlot

Systolic BP_1_Grp3 157 209 201 211 191 156 196 220 162 205 200 174 205 196 213 152 216 159 193 150 172 163 161 165 195 195 213 156 202 118 129 142 140 131 122 134 137 138 130 150 149 121 131 145 121 129 148 150 136 147 133 141 115 150 149 136 120 130

Wt_Grp_3

Systolic BP

SignTest

Participant	Diastolic_1_Grp2	Diastolic_2_Grp2
1	90	107	17	+
2	106	108	2	+
3	109	100	-9	-
4	108	99	-9	-
5	95	100	5	+
6	94	103	9	+
7	102	106	4	+
8	94	108	14	+
9	106	107	1	+
10	93	99	6	+
11	92	100	8	+
12	103	98	-5	-
13	99	101	2	+
14	106	100	-6	-
15	109	107	-2	-
16	110	108	-2	-
17	97	106	9	+
18	105	98	-7	-
19	105	104	-1	-
20	110	107	-3	-
21	105	108	3	+
22	92	106	14	+
23	91	98	7	+
24	110	101	-9	-
25	99	103	4	+
26	107	98	-9	-
27	94	103	9	+
			Positive=>	16
			Negative=>	11

SurvivalGraph

0 1 2 3 5 6 9 10 11 12 13 14 17 17 18 19 21 23 24 24 24 1 0.95 0.95000000000000007 0.89722222222222237 0.84444444444444455 0.84444444444444455 0.84 444444444444455 0.84444444444444444 0.84444444444444444 0.84444444444444444 0.84444444444444455 0.76000000000000012 0.67555555555555569 0.67555555555555569 0.67555555555555569 0.6755555555555558 0.6755555555555558 0.50666666666666682 0.50666666666666682 0.50666666666666682 0.50666666666666682

Time (months)

% Survived

Survival Analysis

Year of Death	Year of Last Contact	Time	Event (1=death, 0=censored)	Number at Risk	Number of Deaths Dt	Number Cesored
		0					1
1		1	1	20	1	0	0.95
	2	2	0	19	0	1	0.95
3		3	1	18	1	0	0.8972222222
4		5	1	17	1	0	0.8444444444
	6	6	0	16	0	1	0.8444444444
	9	9	0	15	0	1	0.8444444444
	10	10	0	14	0	1	0.8444444444
	11	11	0	13	0	1	0.8444444444
	12	12	0	12	0	1	0.8444444444
	13	13	0	11	0	1	0.8444444444
14		14	1	10	1	0	0.76
17		17	1	9	1	0	0.6755555556
	17	17	0	9	0	1	0.6755555556
	18	18	0	7	0	1	0.6755555556
	19	19	0	6	0	1	0.6755555556
	21	21	0	5	0	1	0.6755555556
23		23	1	4	1	0	0.5066666667
	24	24	0	3	0	1	0.5066666667
	24	24	0	3	0	1	0.5066666667
	24	24	0	3	0	1	0.5066666667

TwoSampleTtest

t-Test: Two-Sample Assuming Equal Variances
	Wt_Grp_1	Wt_Grp_2
Mean	182.347826087	183.1111111111
Variance	350.1462450593	414.8717948718
Observations	23	27
Pooled Variance	385.2059178744
Hypothesized Mean Difference	0
df	48
t Stat	-0.1370569504
P(T<=t) two-tail	0.8915590602
t Critical two-tail	2.0106347219