business analytics 2

(atron', Mri: 7, 2012\} Oorintine takitie isgs ts icferovethe torix. DATA (1) (ii) () Does a simple linear regression model appear to be appropriate? A regression model appears to be more appropriate. b) Develop an estimated quadratic regression equation with years to maturity and squared values of years to maturity as the independent variables. If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the biank. (Example: 300 ) y=+x+x2 How much variation in the sample values of yield is explained by this regression model? If required, round your answer to one decimal places, Test the relationship between each of the independent variables and the dependent variable at a 0.05 level of significance. How would you interpret this model? 1=0 and conclude there a relationship between years to maturity would you interpret this model? and yield. 1=0 and conclude there 2=0 and conclude there a relationship between years to maturity values of years to maturity and yieid. a relationship between squared (c) Use Excel to create a plot of the linear and quadratic regression lines overlaid on the scatter chart of years to maturity and yleld. Choose the correct chart below. Does this helps you better understand the difference in how the quadratic regression model and a simple linear regression model fit the sample data? The graph shows difference between the fit of the linear and quadratic regression models to the Does this helps you better understand the difference in how the quadratic regression model and a simple linear regression model fit the sample data? The graph shows difference between the fit of the linear and quadratic regression models to the data. Which model does this chart suggest provides a superior fit to the sample data? (d) What other independent variables could you include in your regression model to explain more variation in yield? The input in the box below will not be graded, but may be reviewed and considered by your instructor. (atron', Mri: 7, 2012\} Oorintine takitie isgs ts icferovethe torix. DATA (1) (ii) () Does a simple linear regression model appear to be appropriate? A regression model appears to be more appropriate. b) Develop an estimated quadratic regression equation with years to maturity and squared values of years to maturity as the independent variables. If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the biank. (Example: 300 ) y=+x+x2 How much variation in the sample values of yield is explained by this regression model? If required, round your answer to one decimal places, Test the relationship between each of the independent variables and the dependent variable at a 0.05 level of significance. How would you interpret this model? 1=0 and conclude there a relationship between years to maturity would you interpret this model? and yield. 1=0 and conclude there 2=0 and conclude there a relationship between years to maturity values of years to maturity and yieid. a relationship between squared (c) Use Excel to create a plot of the linear and quadratic regression lines overlaid on the scatter chart of years to maturity and yleld. Choose the correct chart below. Does this helps you better understand the difference in how the quadratic regression model and a simple linear regression model fit the sample data? The graph shows difference between the fit of the linear and quadratic regression models to the Does this helps you better understand the difference in how the quadratic regression model and a simple linear regression model fit the sample data? The graph shows difference between the fit of the linear and quadratic regression models to the data. Which model does this chart suggest provides a superior fit to the sample data? (d) What other independent variables could you include in your regression model to explain more variation in yield? The input in the box below will not be graded, but may be reviewed and considered by your instructor