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 £ 72. 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%?