Question

Q4. You analyze the non-linear relationships of two financial securities by fitting both a linear and a quadratic function with EXCEL linear model ret_A = a + b1 * ret_B + error Coefficients...

Q4. You analyze the non-linear relationships of two financial securities by fitting both a linear and a quadratic function with EXCEL

  1. linear model

ret_A = a + b1 * ret_B + error

Coefficients

Standard Error of coefficients

A

0.0000

0.0006

b1

-1.978

0.025

and

  1. Nonlinear model

ret_A = a + b1 * ret_B + b2 * ret_B2 + error

variable

Coefficients

Standard Error of coefficients

a

0.0000

0.0006

b1

-1.850

0.0245

b2

4.45

0.382

  1. Calculate the t-stat for the coefficient for the quadratic term for the nonlinear model. Is there a significant non-linear effect, ie what is the probability that the coefficient is zero yet you observe 4.45? (2 points)

  

  1. Given ret_B = -1%, what is the predicted change in ret_A from the forecast based on linear regression model (1 point)?
  1. Given ret_B = -1%, what is the predicted change in ret_A from the forecast based on non-linear regression model (1 point)?

  2. Given ret_B = -5%, what are the predicted changes in ret_A based on linea regression? ( 1 point)?

  

  1. Given ret_B = -5%, what is the prediction based on nonlinear specifications of the regression functions (2 points)?

  

  1. Given ret_B = 5%, what are the predicted changes in ret_A based on linear specifications of the regression function (1 point)?

  1. Given ret_B = 5%, what are the predicted changes in ret_A based on quadratic specification of the regression functions (2 points)?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

t-stat = 4.45/0.382 = 11.649

p value for a two tailed t-test needs to be calculated, consider degrees of freedom = 100. Probability is less than 0.00001 as the critical values corresponding to such probability is lower than calculated t-statistic. Therefore the non-linear effect is significant

ret_A = -1.978*-1% = 1.978%
ret_A = -1.850*-1% + 4.45*(-1%)^2 = 1.850% + 0.0445% = 1.8945%

ret_A = -1.978*-5% = 9.89%
ret_A = -1.850*-5% + 4.45*(-5%)^2 = 9.25% + 1.1125% = 10.3625%

ret_A = -1.978*5% = -9.89%
ret_A = -1.850*5% + 4.45*(-5%)^2 = -9.25% + 1.1125% = -8.1375%

Add a comment
Know the answer?
Add Answer to:
Q4. You analyze the non-linear relationships of two financial securities by fitting both a linear and a quadratic function with EXCEL linear model ret_A = a + b1 * ret_B + error Coefficients...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • (13 points) Suppose you have a simple linear regression model such that Y; = Bo +...

    (13 points) Suppose you have a simple linear regression model such that Y; = Bo + B18: +€4 with and N(0,0%) Call: 1m (formula - y - x) Formula: F=MSR/MSE, R2 = SSR/SSTO ANOVA decomposition: SSTOSSE + SSR Residuals: Min 1Q Modian -2.16313 -0.64507 -0.06586 Max 30 0.62479 3.00517 Coefficients: Estimate Std. Error t value Pr(> It) (Intercept) 8.00967 0.36529 21.93 -0.62009 0.04245 -14.61 <2e-16 ... <2e-16 .. Signif. codes: ****' 0.001 '** 0.01 '* 0.05 0.1'' 1 Residual standard...

  • 2. Use the data in hpricel.wfl uploaded on Moodle for this exercise. We assume that all assump- tions of the Classical Linear Model are satisfied for the model used in this question....

    2. Use the data in hpricel.wfl uploaded on Moodle for this exercise. We assume that all assump- tions of the Classical Linear Model are satisfied for the model used in this question. (a) Estimate the model and report the results in the usual form, including the standard error of the regression. Obtain the predicted price when we plug in lotsize - 10, 000, sqrft - 2,300, and bdrms- 4; round this price to the nearest dollar. (b) Run a regression...

  • As a statistical consultant, you have been asked to develop a linear model which shall be...

    As a statistical consultant, you have been asked to develop a linear model which shall be given to first year executive MBA students. Variable           Name                                                   Description X1                   Gender                                                Male or Female X2                   GMAT Score                                      Score on GMAT Test X3                   College Degree Previously Earned     Bachelors, Masters, or PhD Y                     Income                                                            Annual Income in Thousand Dollars Where 1=Male and 2= Female for X1 and B = Bachelors Degree, M=Master’s Degree, and P= PhD for X3. Given this data, recode the variables...

  • Table 1: How to interpret logged models, table adapted from Bailey's textbook model equation Log-linear In...

    Table 1: How to interpret logged models, table adapted from Bailey's textbook model equation Log-linear In Y; = Bo + BiX; + ei Linear-log Y; = Bo + B, In Xi + ei interpretation A one-unit increase in X is associated with a B1 percent change in Y (on a 0-1 scale). A one percent increase in X is associated with a B1/100 change in Y. A one-percent increase in X is associated with a B1 percent change in Y...

  • Use the following linear regression equation to answer the questions. X1 = 1.7 + 3.6x2 -...

    Use the following linear regression equation to answer the questions. X1 = 1.7 + 3.6x2 - 8.4x3 + 1.5x4 (a) Which variable is the response variable? O X1 O X2 O X4 O X3 Which variables are the explanatory variables? (Select all that apply.) X3 X1 U X2 (b) Which number is the constant term? List the coefficients with their corresponding explanatory variables. constant X2 coefficient X3 coefficient X4 coefficient (c) If x2 = 8, X3 = 5, and x4...

  • please answer question 7 (confidence interval). (14 points) Birth weight and gestational age. The Child Health...

    please answer question 7 (confidence interval). (14 points) Birth weight and gestational age. The Child Health and Development Studies considered pregnancies among women in the San Francisco East Bay area. Researchers took a random sample of 50 pregnancies and used statistical software to construct a linear regression model to predict a baby's birth weight in ounces using the gestation age (the number of days the mother was pregnant). A portion of the computer output and the scatter plot is shown...

  • Use the following linear regression equation to answer the questions. x1 = 1.7 + 3.9x2 -...

    Use the following linear regression equation to answer the questions. x1 = 1.7 + 3.9x2 - 8.1X3 + 1.9x4 (a) Which variable is the response variable? O O O O Which variables are the explanatory variables? (Select all that apply.) o X3 O X4 Сх, (b) Which number is the constant term? List the coefficients with their corresponding explanatory variables. constant X2 coefficient Xz coefficient x4 coefficient (C) If x2 = 8, X3 = 3, and X4 = 1, what...

  • psy230 flipped assignment 4- linear regression. thank you PSY 230 Flipped Classroom Assignment: Linear Regressio...

    psy230 flipped assignment 4- linear regression. thank you PSY 230 Flipped Classroom Assignment: Linear Regression GRADED ASSIGNMENT Prompt: After finding an association between openness to experience and interest in statistics, the statistics instructor examined another personality trait: extraversion. Again, he hypothesizes that there would be a positive association between the two variables, such that greater levels of extraversion will be associated with greater levels of interest in statistics. To test this hypothesis, he used the same participants from his course...

  • The following ANOVA model is for a multiple regression model with two independent variables: Degrees of            Sum of                 Mean Source           Freedom            Squares              ...

    The following ANOVA model is for a multiple regression model with two independent variables: Degrees of            Sum of                 Mean Source           Freedom            Squares                Squares       F       Regression            2                    60 Error                   18                 120 Total                   20                 180 Determine the Regression Mean Square (MSR): Determine the Mean Square Error (MSE): Compute the overall Fstat test statistic. Is the Fstat significant at the 0.05 level? A linear regression was run on auto sales relative to consumer income. The Regression Sum of Squares (SSR) was 360 and...

  • STATS QUESTION PLEASE ONLY ANSWER G, H, and I. I have everything else answered 50 Points...

    STATS QUESTION PLEASE ONLY ANSWER G, H, and I. I have everything else answered 50 Points Total Percentages of public school students in fourth grade in 1996 and in eighth grade in 2000 who were at or above the proficient level in mathematics were given in the article "Mixed Progress In Math” (USA Today, August 3, 2001). The following data for eight Western states were given: State Arizona (AZ) California (CA) Hawaii (HI) Montana (MT) New Mexico (NM) Oregon (OR)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT