Question

Using the following information, how would you write the models regression equation?

BirthRate	Literacy Rate	HDI
29.0	73	44
19.5	88	96
14.1	93	99
21.2	80	81
13.7	95	99
17.8	59	70
14.5	77	94
12.4	92	99
28.7	61	36
13.0	93	99
11.0	92	99
27.8	44	35
43.6	62	41
20.4	91	95
10.7	94	99
28.0	75	82
26.6	84	86
43.3	41	42
41.8	48	63
30.4	68	94
12.6	85	99
33.4	67	70
11.2	98	93
13.2	92	99
15.2	94	99

Answer 1

using excel for multiple regression,step are

write data in excel>menu>data>data analysis>regression>enter required labels>ok

o/p obtained is

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.860599
R Square	0.740631
Adjusted R Square	0.717052
Standard Error	12.39721
Observations	25
ANOVA
	df	SS	MS	F	Significance F
Regression	2	9655.042	4827.521	31.4106	3.57E-07
Residual	22	3381.198	153.6908
Total	24	13036.24
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	23.79861	28.57143	0.832951	0.413824	-35.4549	83.05212	-35.4549	83.05212
BirthRate	-0.52908	0.425905	-1.24225	0.227224	-1.41235	0.354192	-1.41235	0.354192
Literacy Rate	0.87907	0.259284	3.390368	0.002631	0.341347	1.416792	0.341347	1.416792

so, predicted HDI = 23.7986 -0.5291*birthrate + 0.8791*literacy rate