Share
Explore BrainMass

Home Market Value vs Age: Scatter Chart, Trendline, Regression

See attached data file for data tables

1.
Using the data in the Excel in the file Home Market Value, construct a scatter chart for market value versus age and add a linear trendline. Compare the coefficient of determination with the model developed in this chapter. What do you conclude?

2.
Using the data in the Excel file Demographics, determine if a linear relationship exists between unemployment rates and cost of living indexes by constructing a scatter chart and adding a trendline. What is the regression model and R1?

3.
Using the data in the Excel file Student Grades, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the regression model and R2? If a student scores 85 on the midterm, what would you estimate her grade on the final exam to be?

6.
The Excel file Hypothetical Stock Data shows daily closing prices for a particular stock and the S&P 500 index.

a. Apply regression analysis to find the beta associated with the stock.
b. Test the hypothesis that beta is equal to one.
c. Find a 95% confidence interval for beta.

Attachments

Solution Summary

The solution provides step by step method for the calculation of coefficient of determination and regression analysis. Formula for the calculation and Interpretations of the results are also included. Answers attached as a 6-page Word document report with calculations in Excel.

$2.19