Question

Identify ALL of the factors that are significant at a level of 1%.

Factor A	Factor B	Factor C	Factor D	Factor E	Factor F	Result
130	120.3	125	58.4	110	106.7	2336.8
125.4	93	147.5	145.4	109.5	103.8	2631.1
89.1	78.6	73.9	101.4	59.1	104.5	1788.3
139	56.5	85	143	101.8	99.2	1881
115.9	112	105.6	94.5	133.4	82.7	2182.1
148.6	145.8	83.8	122.6	125.7	130.3	2390.4
140.1	69.5	97.6	53.2	87.5	116.1	1823
67.9	103.1	130.8	67.6	141	81.3	2258.5
139.8	130.5	92.9	146.9	92.3	138.3	2475.3
81.8	138.8	147.8	117.9	97.9	59.7	2699.2
137.9	140.4	123.8	90.4	136.3	124.7	2592.4
134.7	148.3	142.8	99.9	115.8	90.3	2728.5
148.4	118.2	96.3	62.5	57.6	120.9	2126.1
77.5	127	109.8	78.9	105.6	105.4	2306.1
148.7	60.3	60.2	52	51.1	119.6	1452.3

Answer 1

Using Excel

data -> data analysis -> regression

SUMMARY OUTPUT
Regression Statistics
Multiple R	1.0000
R Square	1.0000
Adjusted R Square	0.9999
Standard Error	3.0148
Observations	15
ANOVA
	df	SS	MS	F	Significance F
Regression	6	1961899.8850	326983.3142	35976.2050	0.0000
Residual	8	72.7110	9.0889
Total	14	1961972.5960
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	136.3835	8.1234	16.7889	0.0000	117.6508
Factor A	-0.0174	0.0391	-0.4461	0.6673	-0.1075
Factor B	5.6549	0.0338	167.4285	0.0000	5.5770
Factor C	8.4379	0.0477	176.8953	0.0000	8.3280
Factor D	3.0803	0.0246	124.9727	0.0000	3.0235
Factor E	0.1588	0.0365	4.3540	0.0024	0.0747
Factor F	2.5361	0.0634	40.0126	0.0000	2.3899

if p-value < alpha (0.01) , the factor is significant otherwise not significant

here except Factor A , all other factors are significant

Please rate