# a) Using data from Excel file MAE256_2016Tri2_USGrowth , estimate the following

01 / 10 / 2021 Economics

This paper circulates around the core theme of a) Using data from Excel file MAE256_2016Tri2_USGrowth , estimate the following together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.

Part 1: Descriptive Statistics and Hypothesis Testing ; a) Using Excel, compute and present the descriptive statistics for the volume of US exports to foreign markets (export in file MAE256_2016Tri2_USBilateralExports): mean, median, standard deviation, skewness and kurtosis. Provide a brief interpretation of these descriptive statistics.
b) Compute and present the same descriptive statistics above for annual US population growth (population in file MAE256_2016Tri2_USGrowth).
Test the hypothesis that the mean annual US population growth is less than 1%. Use the 1% level of significance. What conclusion do you reach if you choose the 10% level of significance instead? Explain your answer thoroughly.
Part 2: Simple Linear Regression Analysis and Hypothesis Testing .
a) Using data from Excel file MAE256_2016Tri2_USGrowth , estimate the following
regression model:Provide a full discussion of the regression results. Test the null hypothesis that the US annual domestic investment growth has no effect on the US annual GDP growth (i.e. Ho: 𝛼0_ _=0 vs. H1: 𝛼1_ _≠0). Use the level of significance α = 5%.
b) Using data from Excel file MAE256_2016Tri2_USBilateralExports, estimate the following regression of the US bilateral exports on the bilateral distance between the US and the foreign market.Present the regression results and provide a full interpretation of the intercept and the slope coefficient estimates of 𝛽0_ _and 𝛽1_._ _Given the regression results, what happens to the US exports if the bilateral distance between the US and foreign markets decreases by 50%?

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

Company # 11483120

## Benefits You Get

• Free Turnitin Report
• Unlimited Revisions
• Installment Plan
• Plagiarism Free Guarantee
• 100% Confidentiality
• 100% Satisfaction Guarantee
• 100% Money-Back Guarantee
• On-Time Delivery Guarantee

+44 7340 9595 39
+44 20 3239 6980
[email protected]
AKOSZTEC “International House, 12 Constance Street, London, United Kingdom, E16 2DQ”

Hire Researcher
Rated 4.7/5 based on 8956 Reviews

## Supporting Pages

FLAT 50% OFF ON EVERY ORDER. Use "FLAT50" as your promo code during checkout