stats 502

• Week 3 Homework

Assignment

Top of Form

 Due September 10 at 11:59 PM

Bottom of Form

Below you find two data sets.

1. Combine the two files into one excel file with two sheets.  Each data set will be on its own sheet.

   • The first data set comes from Chapter 14 question 19 and the second data set is associated with question 54 in the same chapter.

2. For each problem develop a scatter plot.  For Question 19 we want to understand if there is a relationship between years of experience and sales.  Sales is Why we are doing to regression.  For Question 54 we want to know if annual revenue in baseball is related to the value of the team.  Value is why we are doing this.

3. Once you create your scatter plot add the regression equation and R-squared.

4. Do a regression analysis using the Excel Data Analysis tool.

5. Highlight the "important" numbers:  R-squared value, F-test number, Coefficients.

6. Create the regression equation.

7. For Years of experience tell me what sales should be if years of experience is 10 years.

8. For Value tell me what a team would be worth is revenue was $250 million.

9. Write a more than 100 word interpretation of what we have learned for each of the regression models.

Submit your completed assignment in this dropbox.

• Sales - CH modified

Excel Spreadsheet

• MLBValues CH modified

Excel Spreadsheet

• Week 3 Discussion

Discussion Topic

Top of Form

 Due September 10 at 11:59 PM

Bottom of Form

Using Regression, we are able to create statistical models to predict the future.

What future would you like to predict and what independent variables do you think might be helpful in creating a regression model that accurately predicts the future?

Your own post is due by Wednesday 11:59. You  need to reply to at least one student's post by Sunday at 11:59 pm. Please note that your initial post must be at least 400 words and reply at least 50 words.