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...
CW 2 List 5 assumptions of the simple linear regression model. You have estimated the following...
CW 2 List 5 assumptions of the simple linear regression model. You have estimated the following equation using OLS: ŷ = 33.75 + 1.45 MALE where y is annual income in thousands and MALE is an indicator variable such that it is 1 for males and 0 for females. a) According to this model, what is the average income for females? b) According to this model, what is the average income for females? c) What does OLS stand for? How...
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...
3. Given the linear regression equation: y = 1.6 + 3.5x1 – 7.9x2 + 2.0x3 a....
3. Given the linear regression equation: y = 1.6 + 3.5x1 – 7.9x2 + 2.0x3 a. Which variable is the response variable? How many explanatory variables are there? b. If x1 = 2, x2 = 1 and x3 = 5, what is the predicted value for y? c. Supposed the n = 12 data points were used to construct the given regression equation above, and that the standard error for the coefficient x1 is 0.419. Construct a 90% confidence interval...
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     ...
QUESTION 3 The mathematical function in which each variable appears in a separate term and is...
QUESTION 3 The mathematical function in which each variable appears in a separate term and is raised to the first power is known as a a. nonlinear function b. power function c. linear function d. what-if function e. None of the above QUESTION 5 The confusion matrix for a classification method with Class 0 and Class 1 is given below. Confusion Matrix Actual\Predicted 0      1             0 108 50             1 32 110   What is the percent overall error rate? a. 37.6%...
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 ?
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...
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...
The table below gives the list price and the number of bids received for five randomly...
The table below gives the list price and the number of bids received for five randomly selected items sold through online auctions. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting the number of bids an item will receive based on the list price. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make...