excel22 It has to be in 1 Excel workbook with the appropriate worksheets.

Question

Mohd · Accepted Answer

data
	A	B	C	D
	1	2	5	9
	2	5	11	20
	3	7	14	31
	4	8	22	41
	5	9	25	48
	6	10	28	59
	7	20	34	68
	8	22	40	82
	9	26	51	90
	10	30	56	99
	Average	13.9	28.6	54.7
	Standard Deviation	9.7	16.8	30.3
	Median	9.5	26.5	53.5
Line Chart
Descriptives Over Groups
Average	13.9	28.6	54.7	Standard Deviation	9.7233967544497766	16.827226615088879	30.250987128062814	Median	9.5	26.5	53.5	
reg1
	A	B	C	D									SUMMARY OUTPUT
	1	2	5	9
	2	5	11	20									Regression Statistics
	3	7	14	31									Multiple R	0.974
	4	8	22	41									R Square	0.949
	5	9	25	48									Adjusted R Square	0.935
	6	10	28	59									Standard Error	2.486
	7	20	34	68									Observations	10
	8	22	40	82
	9	26	51	90									ANOVA
	10	30	56	99										df	SS	MS	F	Significance F
	Average	13.9	28.6	54.7									Regression	2	807.645	403.823	65.352	0.000
	Standard Deviation	9.7	16.8	30.3									Residual	7	43.255	6.179
	Median	9.5	26.5	53.5									Total	9	850.9
														Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
													Intercept	-2.266	1.772	-1.279	0.242	-6.455	1.924	-6.455	1.924
													C	0.532	0.346	1.537	0.168	-0.287	1.351	-0.287	1.

excel22 It has to be in 1 Excel workbook with the appropriate worksheets.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment