Question

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

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)?

Homework Answers

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%

Know the answer?
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
Similar Questions
QUESTION 21 A linear model is found to be y = 3.5x + 6. At a...
QUESTION 21 A linear model is found to be y = 3.5x + 6. At a value of x = 4, the equation yields y = 20. However, the actual data value for x =4 is found to be y = 22.3. The residual at x = 20 is a. 3.5 b. 6 c. 20 d. 22.3 e. 2.3 QUESTION 22 A regression equation is found to be y=2x+10. The prediction for the dependent variable when the independent variable is...
It has been speculated that there is a linear relationship between Oxygen and Hydrocarbon Levels. Specifically,...
It has been speculated that there is a linear relationship between Oxygen and Hydrocarbon Levels. Specifically, Oxygen purity is assumed to be dependent on Hydrocarbon levels. A linear regression is performed on the data in Minitab, and you get the following results: Regression Analysis: Purity-y versus Hydrocarbon level-X Predictor              Coef SE Coef      T      P Constant             74.283    1.593 46.62 0.000 Hydrocarbon level-X 14.947    1.317 11.35 0.000 S = 1.08653   R-Sq = 87.7%   R-Sq(adj) = 87.1% Analysis of Variance Source          DF      SS     ...
You use the data from the Medical Expenditure Panel Survey to analyse the medical expen- diture...
You use the data from the Medical Expenditure Panel Survey to analyse the medical expen- diture of those individuals, who are 65 years and older. This group of people are qualified for health care under the Australian Medicare program. You run a regression of total medi- cal expenditure (totexp:) against a dummy variable private, which takes the value of 1 if individual i has private health insurance and 0, otherwise. The regression model is . totexpi = Bo + B1...
You are testing the null hypothesis that there is no linear relationship between two variables, X...
You are testing the null hypothesis that there is no linear relationship between two variables, X and Y. You are given the following regression results, where the sample size is 10., Coefficient Standart error Intercept -1.2 1 X 2 2 a) What is the value of the t test statistic? b) At the α = 0.05 level of significance, what are the critical values? c) Based on your answer to (a) and (b), what statistical decision should you make ?
Normalization is the process that makes the numerical data independent of scale. True or False TrueFalse...
Normalization is the process that makes the numerical data independent of scale. True or False TrueFalse In excel, to construct a residual plot, input of a y range and an x range is needed. Aimee is examining the relationship between age and square foot range (sqft) of living space. In the scenario provided, what would be the y and what would be the x range data? Multiple Choice In selecting a regression, residual plot is the first selection before range...
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 – 7.7x3 + 2.4x4 Which number is the constant term? List the coefficients with their corresponding explanatory variables. constant x2 coefficient x3 coefficient x4 coefficient If x2 = 1, x3 = 8, and x4 = 9, what is the predicted value for x1? (Use 1 decimal place.) Suppose x3 and x4 were held at fixed but arbitrary values and x2 increased by 1 unit. What...
19) Use the following linear regression equation to answer the questions. x3 = −18.7 + 4.3x1...
19) Use the following linear regression equation to answer the questions. x3 = −18.7 + 4.3x1 + 8.6x4 − 1.0x7 (b) Which number is the constant term? List the coefficients with their corresponding explanatory variables. constant x1 coefficient      x4 coefficient x7 coefficient (c) If x1 = 5, x4 = -6, and x7 = 4, what is the predicted value for x3? (Round your answer to one decimal place.) x3 = (d) Suppose x1 and x7 were held at fixed...
Use the following linear regression equation to answer the questions. x1 = 1.5 + 3.5x2 –...
Use the following linear regression equation to answer the questions. x1 = 1.5 + 3.5x2 – 8.2x3 + 2.1x4 (a) Which variable is the response variable? A. x3 B. x1     C. x2 D. x4 (b) Which variables are the explanatory variables? (Select all that apply.) A. x4 B. x1 C. x3 D. x2 (c) Which number is the constant term? List the coefficients with their corresponding explanatory variables. constant ____________ x2 coefficient_________ x3 coefficient_________ x4 coefficient_________ (d) If x2 =...
Use the following linear regression equation to answer the questions. x1 = 1.1 + 3.0x2 –...
Use the following linear regression equation to answer the questions. x1 = 1.1 + 3.0x2 – 8.4x3 + 2.3x4 (a) Which variable is the response variable? x3 x1      x2 x4 Which variables are the explanatory variables? (Select all that apply.) x1 x2 x3 x4 (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 = 4, x3 = 10, and x4 = 6, what...
1. General features of economic time series: trends, cycles, seasonality. 2. Simple linear regression model and...
1. General features of economic time series: trends, cycles, seasonality. 2. Simple linear regression model and multiple regression model: dependent variable, regressor, error term; fitted value, residuals; interpretation. 3. Population VS sample: a sample is a subset of a population. 4. Estimator VS estimate. 5. For what kind of models can we use OLS? 6. R-squared VS Adjusted R-squared. 7. Model selection criteria: R-squared/Adjusted R-squared; residual variance; AIC, BIC. 8. Hypothesis testing: p-value, confidence interval (CI), (null hypothesis , significance...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT