Determinants of Exports. Please provide the Excel file, so I can see the formula

Question

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.

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.