assignment 7

.docx

School

Radford University *

*We aren’t endorsed by this school

Course

651

Subject

Business

Date

Jun 23, 2024

Type

docx

Pages

Uploaded by Zambianguy

HADM 651 Assignment 7- Linear Regression Analysis Introduction: Linear Regression Analysis is one way of analyzing data from research studies. Purpose: To practice using linear regression analysis. Instructions: · For this test you will do a simple linear regression. If you have never done one, don’t worry the two videos for this test will help you immensely. You will complete the entire exercise using Microsoft excel. · For your grade please provide the answers after reading the passage below. A small town in southwest Virginia started a flu vaccine program ten years ago. They had observed that the number of flu cases had decreased over the past ten years. They knew you were a health science administration master student and asked you to see if there was a correlation between the flu vaccinations and the decrease in the number of flu cases. The health department gave you the following data from the last ten years: Flu vaccinations Flu cases 25 400 50 278 70 256 100 200 132 176 154 155 175 132 202 110 226 87 252 66 1. What is the correlation between the number of flu vaccinations and reported cases of the flu? The number of reported flu cases has decreased as the number of vaccinations have increased. This type of correlation is known as a strong negative correlation. 2. Provide a graph of the data 3. What is the r 2 value for the trend line?

The R2 for the the trend line is 0.913 4. What is the equation of the line? The equation for the line was -1.27* X + 362 5. If only 120 people receive the flu shot in year 11, using the slope of the graph, how many people would you expect will get the flu? 209 6. What is the dependent variable in this problem? The dependent variable is the number of flu cases. 7. From your r 2 value, what percentage of the decrease in the number of flu cases be attributed to the vaccination? At least 91% of the flu case decrease an be attributed to the vaccinations. 8. What percentage is due to some other factor? 9% can be attributed to some other factors. 9. Using your graph, what would have been the predicted number of flu cases in year 1 According to the graph, at least 400 cases could have occurred in year 1. 10. State a health problem or health issue that you could use linear regression to analyze the data One Public Health issue that could be analyzed using linear regression is the number of gun violence deaths over the past 40 years.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version