Reference no: EM13499085
Multiple Regression: The data in apple.xlsx tracks monthly performance of stock inApple Computer since its reception in 1980. The data include 300 monthly returns on AppleComputer, IBM stock returns as well as returns on the entire stock market. Formulate the modelwith Apple Return as the response and Market Return and IBM Return as explanatory variables.
(A) Examine scatterplots of the response versus the two explanatory variables as well as the scatterplot between the responses. Do you notice any unusual features in the data? Do the relevant plots appear straight enough for multiple regression?
(B) Fit the indicated multiple regression and show a summary of the estimated features of the model.
(C) The regression of Apple returns on market returns estimates β for this stock to be about 1.5.Does the multiple regression suggest a different slope for the market?
(D) Give a confidence interval for the coefficient of IBM returns and carefully interpret thisestimate.
(E) Does the inclusion of IBM returns improve the fit of the model with just market returns by a statistically significant amount? Does this imply that we've found an improved trading scheme?
Non-linear Transformation: Influential wine critics such as Robert Parker publishtheir personal ratings of wines and many consumers pay close attention. Do these ratings affectthe price? The data in wine.xlsx are a sample of ratings and prices found online at the website ofan internet wine merchant.
(A) Does the scatterplot of the price of wine on the rating suggest a linear or nonlinear relationship?
(B) Fit a linear regression equation to the data, regressing price on the rating. Does this fitted model make substantive sense?
(C) Create a scatterplot for the natural logarithm of the price on the rating. Does the relationship seem more suited to regression?
|
What is the new voltage across the capacitor
: a parallel plate capacitor has a capacitance of 10mF and its charge with a 20V power supply. What is the new voltage across the capacitor
|
|
Use a computer in his daily school and work activities
: Simon is a new foreign exchange student who has never used a personal computer. He will need help understanding how to use a computer in his daily school and work activities.
|
|
Determine the power output of the sun
: The intensity of sunlight reaching the earth is 1360 W/m^2, What is the power output of the sun
|
|
Define lower oxidation state compound is possible
: Give the formula of a product derived from the first-named substance that may be formed in the following reactions. Note, in the example that any lower oxidation state compound is possible
|
|
Create a scatterplot for the natural logarithm
: Fit a linear regression equation to the data, regressing price on the rating. Does this fitted model make substantive sense and create a scatterplot for the natural logarithm of the price on the rating. Does the relationship seem more suited to regr..
|
|
What will be the beta of indell stock after this transaction
: Indell stock has a current market value of $120 million and a beta of 1.50. Indell currently has risk-free debt as well. The firm decides to change its capital structure by issuing $30 million in additional risk-free debt, and then using this $30 mil..
|
|
A database to keep track of information for her business
: A database to keep track of information for her business
|
|
Evaluate du, dh, q, w, and the final temperature
: One mole of an ideal monoatomic gas initially at 300 K is expanded from an initial pressure of 10 atm to a final pressure of 1 atm. The molar heat capacity for constant volume for the gas is 32VCR=. Calculate dU, dH, q, w, and the final temperatur..
|
|
Explain the heat of combustion of graphite
: You can heat it with a charcoal fire. The heat of combustion of graphite (MW = 12 g/mol) is -393 kJ mol-1. How many grams of charcoal will have to burn to supply the heat
|