Question

Please help me complete this.

I have been struggling for quite some time, and mainly I need the answer.

Thank you!

A B С D E F G H 1 WinterRain HarvestRain 160 Age 31 2 600 3 690 80 4. 502 130 Year 1952 1953 1955 1957 1958 1959 1960 5 420 110 187 30 28 26 25 24 23 6 7 582 485 763 830 8 9 1961 22 10 1962 697 21 20 11 12 1963 1964 608 402 19 13 602 18 Price 7.495 8.0393 7.6858 6.9845 6.7772 8.0757 6.5188 8.4937 7.388 6.7127 7.3094 6.2518 7.7443 6.8398 6.2435 6.3459 7.5883 7.1934 6.2049 6.6367 6.2941 7.292 7.1211 6.2587 7.186 1965 1966 1967 1968 AGST 17.1167 16.7333 17.15 16.1333 16.4167 17.4833 16.4167 17.3333 16.3 15.7167 17.2667 15.3667 16.5333 16.2333 16.2 16.55 16.6667 16.7667 14.9833 17.0667 16.3 16.95 17.65 15.5833 15.8167 14 15 16 France Pop 43183.569 43495.03 44217.857 45152.252 45653.805 46128.638 46583.995 47128.005 48088.673 48798.99 49356.943 49801.821 50254.966 50650.406 51034.413 51470.276 51918.389 52431.647 52894.183 53332.805 53689.61 53955.042 54159.049 54378.362 54602.193 187 290 38 52 155 96 267 86 118 292 244 89 112 158 123 184 819 714 610 575 622 551 17 16 15 14 1969 17 18 19 13 12 11 20 536 10 21 22 23 1970 1971 1972 1973 1974 1975 1976 1977 1978 376 574 9 572 418 171 247 8 7 24 6 821 763 87 51 5 25 26 27 28 29 30 31 Sheet 1 Sheet 2 +

Answer 1

Answer 1:

option B is the correct answer

Price	WinterRain	AGST	Harvest Rain	Age	France pop
Price	1
WinterRain	0.136651	1
AGST	0.659563	-0.32109	1
Harvest Rain	-0.56332	-0.27544	-0.0645	1
Age	0.447768	-0.01697	0.246916	-0.02801	1
France pop	-0.46686	-0.00162	-0.25916	0.041264	-0.99449	1

Answer 2:

option A is the correct answer

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.910691
R Square	0.829359
Adjusted R Square	0.79523
Standard Error	0.294289
Observations	25
ANOVA
	df	SS	MS	F	Significance F
Regression	4	8.41852	2.10463	24.30124	1.95E-07
Residual	20	1.732118	0.086606
Total	24	10.15064
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	-0.37683	2.180432	-0.17282	0.864529	-4.92513	4.171476
France pop	-5.1E-05	1.7E-05	-2.97806	0.007434	-8.6E-05	-1.5E-05
WinterRain	0.001042	0.000507	2.054751	0.053202	-1.6E-05	0.002099
AGST	0.601095	0.098978	6.073043	6.17E-06	0.394632	0.807559
Harvest Rain	-0.00396	0.000852	-4.64642	0.000156	-0.00573	-0.00218

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.723516
R Square	0.523476
Adjusted R Square	0.428171
Standard Error	0.491784
Observations	25
ANOVA
	df	SS	MS	F	Significance F
Regression	4	5.313611	1.328403	5.492642	0.003764
Residual	20	4.837027	0.241851
Total	24	10.15064
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	21.09789	15.46744	1.364019	0.187717	-11.1666	53.3624
Age	-0.07706	0.126841	-0.60756	0.550313	-0.34165	0.187521
France pop	-0.00024	0.000266	-0.90039	0.378629	-0.0008	0.000316
WinterRain	-0.00015	0.000798	-0.18553	0.85468	-0.00181	0.001517
Harvest Rain	-0.00473	0.001409	-3.358	0.00313	-0.00767	-0.00179

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.910256
R Square	0.828566
Adjusted R Square	0.794279
Standard Error	0.294971
Observations	25
ANOVA
	df	SS	MS	F	Significance F
Regression	4	8.410476	2.102619	24.16578	2.04E-07
Residual	20	1.740162	0.087008
Total	24	10.15064
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	-3.42998	1.765898	-1.94234	0.066311	-7.11358	0.253617
WinterRain	0.001076	0.000507	2.120148	0.046694	1.73E-05	0.002134
AGST	0.607209	0.098702	6.151932	5.2E-06	0.40132	0.813099
Harvest Rain	-0.00397	0.000854	-4.65161	0.000154	-0.00575	-0.00219
Age	0.023931	0.008097	2.955564	0.007819	0.007041	0.040821

-------------------------------

Hope this will help, please comment if you need any further explanation, Please Encourage us by Up Voting the Answer which is Very Helpful to us. Thank You!

-------------------------------