Explore BrainMass

# Regression Analysis

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

These assignments will help you learn about statistical models for forecasting. You will learn about time series methods, such as the moving average, exponential smoothing, and linear trend line and, regression, which is used for forecasting by establishing a mathematical relationship between two or more variables.

Read Chapters 6 and 7 in your text and solve the following problems found in the Problems and Applications section:
Chapter 6: 1 through 3

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. What is the coefficient of determination? What does this mean? 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?