Fit a regression line relating age to sbp

Question

QUESTION 1:

Fit a regression line relating age to SBP using the data ishown below. Please explain in your own words what the answer means.

Age(x)   SBP(y)       Age(x)   SBP(y)
1             99           10           115
2            102           11           117
3            105           12           120               
4            107           13           122
5            108           14           125
6            110           15           127
7            111           16           130    
8            112           17           132
9            114

QUESTION 2:

What is the predicted blood pressure (in mm Hg) for an average 13-year-old boy as estimated from the regression line?

QUESTION 3:

What is the association between bone density of the lumbar spine and bone density of the femoral neck? Please explain in your own words what the answer means.

QUESTION 4:

What test procedure would you use to test for the significant differences?

QUESTION 5:

Implement the test in the above in the textbook and report the p-value. What were the null and alternative hypotheses? Please explain in your own words what the answer means.

QUESTION 6:

Identify which pairs of groups are different from each other using t-tests with critical values based on LSD procedure. Report the p-values in your Excel spreadsheet. What were the null and alternative hypotheses? Explain in your own words what the answer means.

QUESTION 7:

Which non-parametric method would you use to compare MAXFWT among the three exposure groups defined by the variable LEAD_Group and why? (no need to analyze)

QUESTION 8:

Using the WK7_VALIDGroup.xls dataset, what is the relationship between saturated fat (sfat_dr) and alcohol consumption (alco_dr) for all groups? Please state the hypotheses and explain what the answer means.

QUESTION 9:

Using the WK7_VALIDGroup.xls dataset, regression with alcohol consumption (also_dr) as the dependent variable and saturated fat (sfat_dr) as the independent variable. What were the null and alternative hypotheses? Explain in your own words what the answer means.

QUESTION 10:

Using the WK7_VALIDGroup.xls dataset, consumption (alco_dr) difference among the three groups? Please state the hypotheses and explain in your own words what the answer means.

Attachment:- wk7_validgroup.xls