Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
NATURAL SCIENCE GURU ONLY
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****