Question

In: Statistics and Probability

3.Below is the regression input and output (from Excel) for the regression in which the percentage...

3.Below is the regression input and output (from Excel) for the regression in which the percentage change in the exchange rate is the dependent variable (Y) and the inflation differential (inflation rate home – inflation rate foreign) is the independent variable (X). According to the Purchasing Power Parity theory, the hypothesized coefficients (null hypothesis) in the regression are 0 (intercept coefficient) and 1 (inflation differential coefficient).   The directions for Problem Set 1 instruct you to first read sections of the Madura textbook. You will need to do this to learn how to test if a coefficient is different from 1; it will explain how you calculate the t Statistic to test your null hypothesis from the Excel output. Excel will only directly provide a t statistic for the test of whether a coefficient is different from 0.   

%chg ex rate

Inf h - Inf f

0.01

0.009

0.02

0.015

0.01

0.015

0.02

0.022

-0.01

-0.005

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.944392193

R Square

0.891876615

Adjusted R Square

0.855835487

Standard Error

0.004650234

Observations

5

ANOVA

df

SS

MS

F

Significance F

Regression

1

0.000535126

0.000535126

24.74607916

0.015609229

Residual

3

6.4874E-05

2.16247E-05

Total

4

0.0006

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Intercept

-0.002751938

0.003300932

-0.833685033

0.465627737

-0.013256988

Inf h - Inf f

1.138565891

0.228878485

4.974543111

0.015609229

0.410171719

3a.       Is there evidence to reject the null hypothesis that the intercept coefficient is equal to 0 at the 5% level of significance? (Hint: you will need a table with the t distribution to determine the critical t.) (10 points)

3b.       Is there evidence to reject the null hypothesis that the inflation differential coefficient (Inf h – Inf f) is equal to 1 at the 5% level of significance? (Hint: you will need a table with the t distribution to determine the critical t. You will not use the t Statistic given in the Excel output, because it corresponds to the null hypothesis that the inflation differential is equal to 0.) (10 points)

3c.       Overall, is there any evidence inconsistent with the Purchasing Power Parity theory? (Hint: The answer to this questions is yes, if you can reject at least one of the two above null hypotheses.) (10 point)

Solutions

Expert Solution


Related Solutions

Use the data set which is labeled below and answer using regression output in excel i....
Use the data set which is labeled below and answer using regression output in excel i. Find the correlation coefficients between Y and X1, X2 and X3 and test the significance of population correlation coefficient using the value of r calculated for X2 and X3. ii. Estimate the regression equation for Y and X1, Y and X2 and report the results and explain the intercept and slope coefficients. iii. Check the significance or insignificance of the independent variables? and explain...
The multiple regression model is estimated in Excel and part of the output is provided below....
The multiple regression model is estimated in Excel and part of the output is provided below. ANOVA df SS MS F Significance F Regression 3 3.39E+08 1.13E+08 1.327997 0.27152899 Residual 76 6.46E+09 85052151 Total 79 6.8E+09 Question 8 (1 point) Use the information from the ANOVA table to complete the following statement. To test the overall significance of this estimated regression model, the hypotheses would state there is    between attendance and the group of all explanatory variables, jointly. there is...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F Regression   60 Residual Total 19 140 Coefficients Standard Error Intercept 10.00 2.00 x1 -2.00 1.50 x2 6.00 2.00 x3 -4.00 1.00 a. Use the above results and write the regression equation. [4 Marks] b. Compute the coefficient of determination and fully interpret its meaning. [4 Marks] c. Is the regression model significant? Perform the test at let α = 0.05. [4 Marks] d. At...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F...
Shown below is a partial Excel output from a regression analysis. ANOVA df SS MS F Regression   60 Residual Total 19 140 Coefficients Standard Error Intercept 10.00 2.00 x1 -2.00 1.50 x2 6.00 2.00 x3 -4.00 1.00 a. Use the above results and write the regression equation. [4 Marks] b. Compute the coefficient of determination and fully interpret its meaning. [4 Marks] c. Is the regression model significant? Perform the test at let α = 0.05. [4 Marks] d. At...
The summary output of Paradise Retreats' model in Excel is in the tables below: Regression Statistics...
The summary output of Paradise Retreats' model in Excel is in the tables below: Regression Statistics Multiple R 0.764437898 R Square 0.5843653 Adjusted R Square 0.555700838 Standard Error 315.8931794 Observations 60 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 413 317.1379944 0.110883586 0.912472524 -613.4546286 683.785425 x1 15 7.187801286 1.304664049 0.202266328 -5.323038326 24.07837018 x2 5 9.990263453 3.509123492 0.001488311 14.62468522 55.48945112 According to the tables, which of the following statements about this regression model are true? Select all correct...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? (2 Points) 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this question. (2...
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in...
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year. (10 points) Hint: I suggest you use formulas with an IF function regarding the gross profit section of your speadsheet because your spreadsheet should be able to calculate correct answers whether a contract generates a profit or loss. 2- Using...
The input-output (consumption) matrix for a closed economy is given below. Solve the associated input- output...
The input-output (consumption) matrix for a closed economy is given below. Solve the associated input- output model. Use r if you need a variable in your answer. [0.07 0.05 0.27] [0.17 0.48 0.19] [0.76 0.47 0.54]
The following is part of regression output produced by Excel ( for Y vs X1 and...
The following is part of regression output produced by Excel ( for Y vs X1 and X2): Y 12.9 6.1 1.1 39.7 3.4 5.9 8.9 15 7.3 X1 0.9 0.8 1.0 0.3 0.4 0.7 0.71 0.5 0.9 X2 4.2 3.1 1.2 15.7 2.5 0.7 5.0 6.4 3.0 A) write out the estimated regression equation showing that depends on X1 and X2. b)if. X1=0.58 and X2=7.0, what is the value predicted for y c)write the number which is the standard error...
Below you are given a partial computer output from a multiple regression analysis based on a...
Below you are given a partial computer output from a multiple regression analysis based on a sample of 16 observations. Coefficients Standard Error Constant 12.924 4.425 x1 -3.682 2.630 x2 45.216 12.560 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Mean Square F Regression 4853 2426.5 Error 485.3 ​ Carry out the test of significance for the variable x1 at the 1% level. The null hypothesis should be options: be tested for β₃ instead. be rejected....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT