Use Excel to complete Exercise 1 on page 247 (Regression Analysis) in the textbook. Answer the questions at the end of the exercise.

While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines.

1. 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:

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.

Chapter 9 Exercise 2 information

2. Suppose that we are interested in

the relationship between the age

of the individuals who are members

of our managed-care organization

and the use of physician

care, as measured by visits. Suppose

also that after selecting 15

members at random we obtained

the following paired observations:

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 32

42 68 19 23 30 61

Use these data to find the covariance

between age and the number

of visits.

***PLEASE SEE ATTACHMENT FOR WHAT THE ASSIGNMENT SHOULD LOOK LIKE****