Determinants of Exports Please provide the Excel file so I c

Determinants of Exports. Please provide the Excel file, so I can see the formulas used. Thank you.

Sample Data for Exports. *Please use EXCEL to do this work. ** Period Foreign Income Relative PriceExchange-rate Export Risk 305 130 189 175 101 269 421 195 282 203 20 15 17 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 35 98 83 76 93 35 27 16 28 46 56 12 40 32 16 27 35 44. 57 31 92 23 Title: Determinants of Exports a) Run a multiple regression using the above data. with Export as the dependent variable) b) Compare the result of question (a) with another regression equation obtained without the Foreign Income variable. c) Which of the models do you prefer? Why? d) Interpret your results for (a) and (b). e) In writing your paper, you should start by indicating the purpose of the study. Also, discuss the methodology and conclusions.

Solution

I am not able to upload the excel file, and so I am copy pasting the table of calculated values.

Period	Export	Foreign Income	Relative Price	Ex.Rate Risk
1970	20	305	35	35
1971	15	130	98	22
1972	17	189	83	27
1973	9	175	76	16
1974	16	101	93	28
1975	27	269	77	46
1976	35	421	44	56
1977	7	195	57	12
1978	22	282	31	40
1979	23	203	92	32
				SUMMARY OUTPUT
				Regression Statistics
				Multiple R	0.992398792
				R Square	0.984855361
				Adjusted R Square	0.977283042
				Standard Error	1.249867779
				Observations	10
				ANOVA
					df	SS	MS	F	Significance F
				Regression	3	609.5269832	203.1756611	130.0599363	7.55516E-06
				Residual	6	9.373016791	1.562169465
				Total	9	618.9
					Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
				Intercept	-10.17024332	3.473128593	-2.928265696	0.026346428	-18.66868283	-1.671803801	-18.66868283	-1.671803801
				X Variable 1	0.027038115	0.012040996	2.245504802	0.065846812	-0.002425142	0.056501372	-0.002425142	0.056501372
				X Variable 2	0.097052345	0.030147122	3.219290578	0.018153389	0.023284996	0.170819694	0.023284996	0.170819694
				X Variable 3	0.524675168	0.059158249	8.869011174	0.000114333	0.379920148	0.669430188	0.379920148	0.669430188