Develop the equation of the regression model

Assignment Help Financial Management

Reference no: EM131963143

The file contains the selling prices (Y) and the appraised values (X) of the 148 homes.

Construct a 95% confidence interval for the average value of y. Use x = 130,000.

Construct a 95% prediction interval for a single value of y. Use x = 130,000.

Compare the results.

Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X_1) and annual dividend rate (X_2).

The stock price, returns on equity, and dividend rates on a randomly selected day for several electric utility stocks are provided in the file Dataset_stock prices.xlsx sheet named Data.

Use Excel to develop the equation of the regression model. Comment on the regression coefficients. Determine the predicted value of y for x1=12.1 and x2=3.18.

Study the ANOVA table and the t ratios and use these to discuss the strengths of the regression model and the predictors. Does this model appear to fit the data well? Use α = 0.05.

Comment on the overall strength of the regression model in light ofs_e, R2, and adjusted R2.

Attachment:- Data-stock price.rar

Reference no: EM131963143

Questions Cloud

Compare the standard deviation and standard error : Calculate the integral of function between 0 and 2p using the rejection method - Compare the standard deviation and standard error

Highest key value in a block of next level down : What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block

Discuss one professional journal and nursing care conference : Discuss one professional journal and one nursing or health care conference where you might present your project.

Some sort of switch case statement : Convert Program #1 into using some sort of switch- case statement this program should be name PrintNumberToWordie2

Develop the equation of the regression model : Use Excel to develop the equation of the regression model. Comment on the regression coefficients. Determine the predicted value of y.

Determining the comparing approaches : Outline the primary ways in which the traditional approach to modeling a use case differs from an object-oriented approach.

What is the present value of the annual cash flow : What is the present value of the annual cash flow that is expected in 4 years from today?

What obstacles could challenge this plan : What obstacles could challenge this plan? Discuss why EBP is an essential component of the practice of a BSN-prepared RN.

Advertising to generate revenue : If you are the CIO or an executive manager at a small company that depends on this type of advertising to generate revenue

User Account

All Pages