Perform a simple linear regression on your data (at least 20 points) using Excel. Be as creative and original


Perform a simple linear regression on your data (at least 20 points) using Excel. Be as creative and original in your work product as you can. You may certainly add to the list below.

Prepare a report containing the following:

Page 1 1. A description of the problem you're investigating. Describe fully the independent and dependent variables. Include your expectations on β 1 (positive or negative) and why. Describe how the sample was taken and the population from which it was taken.

Page 2 2. The data collected. Give the names of the people or the source of the data.

Page 3 3. Plot the dependent vs. the independent variable. Plot the regression line and show the regression equation on the computer output.

4. Interpret b 1 (and b 0 if possible) including units, and r 2 . The interpretations should refer to your specific project.

Page 4 5. Test for significance of β 1 at α = 0.05 using the t value from the computer output, and the appropriate value from the t table. State clearly the null and alternate hypothesis. Show the computer table with the t values. State the table and calculated values of t and your conclusion.

6. State and compare the p value from the computer printout with α = 0.05. What does this comparison tell you?

7. State and compare the calculated and table values of F for α = 0.05. What does this comparison tell you.

  1. Calculate a 95% confidence interval on β 1 using the computer’s values for s b1 and b 1 and the table value of t and interpret it.
  2. State clearly how the confidence interval in part 8 is consistent with your conclusions in parts 5, 6 and 7.
  3. Explain what % of total variation has been explained by your regression analysis, and justify the value of your study in light of this information.

Page 5 11. What other quantifiable independent variables [at least 2] might be included to improve the model and what effect [+ or -] do you think each of them would have on Y?

NOTE: All interpretations should relate to your specific independent and dependent variables and their units. Be sure to name the Y and X columns when entering the data . Do not use Y or X in any of your interpretations.

Price: $9.01
Solution: The downloadable solution consists of 5 pages, 401 words and 1 charts.
Deliverable: Word Document


log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in