Perform a simple linear regression on your data (at least 20 points...

Perform a simple linear regression on your data (at least 20 points) to determine the relationship between an independent and dependent variable using Excel or StatCrunch. Prepare a report containing the following:

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.
2. The data collected. Give the names of the people if possible or the source of the data.
3. Use Excel or StatCrunch to plot the summary output.
Summary output
Simple linear regression statistics
ANOVA
Body Weight(lbs)          Hours Exercise/Day          Initials
4. Interpret b1 (and b0 if possible) including units, and r². The interpretations should refer to your specific project.
5. Test for significance of β1 at α = 0.05 and at α = 0.01 using the t value from the computer output, and the appropriate values from the t table. State clearly the null and alternate hypotheses. 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 and α = 0.01. What do these comparisons imply?
7. State and compare the calculated and table values of F for α = 0.05 and for α = 0.01. What do these comparisons imply?
8. Manually calculate a 95% and a 99% confidence interval on β1 using the computer’s values for sb1 and b1 and the table values of t and interpret them. Show the calculations.

                               Coefficients            Standard Error
Body Weight (lbs)    0.006322                0.006029

9. State clearly how the confidence intervals in part 8 is consistent with your conclusions in parts 5, 6 and 7.
10. 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?