.ZIP

# 1)Use Excel to complete -Exercise 1- on page 247 (Regression Analysis)…

1)Use Excel to complete "Exercise 1" on page 247 (Regression Analysis) in the textbook.

2) Answer the questions at the end of the exercise.

Use the “Regression” function in Excel and the data presented in Exercise 2 of Chapter 9 to estimate the linear relation between the number of visits and the age of the patient. Examine the results of the analysis by

Sample Data :

Visits: 3 5 4 2 1 3 6 7 4 5 10 1 2 3 8

Age: 28 45 50 19 16 27 54 63 3242 68 19 23 30 61

1)Interpreting the coefficient of determination
2)Interpreting the square root of the coefficient of determination.
3)Interpreting findings presented in the ANOVA table
4)Determining whether the intercept and slope of the sample regression line are significant in your evaluation, let a= 0.05.
3) APA format is not required, but solid academic writing is expected.

Second Assignment

1) Use Excel to complete "Exercise 7" on page 208 (ANOVA) in the textbook.

2) Answer the questions at the end of the exercise.

3) APA format is not required, but solid academic writing is expected.