Assignments must be done on time: file is attached for the
second assignment
First assignment:
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 ?= 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.
