Question
The table shows data on asthma-related visits. Is there evidence that these visits vary by quarter? Can you detect a trend? A powerful test would
The table shows data on asthma-related visits. Is there evidence that these visits vary by quarter? Can you detect a trend? A powerful test would be to run a multiple regression in Excel. If the function is already loaded, you will find it in Data> Data Analysis> regression. If not get help in adding the Analysis Tool Pak. To test for quarterly differences, create a variable called Q1 that equals 1 if the data are for the first quarter and 0 otherwise, a variable called Q2 that equals 1 if the date are for the second quarter and 0 otherwise and a variable called Q4 that equals 1 if the date are for the forth quarter and 0 other wise. ( Because you will accept the default, which is to have a constant term in your regression equation, do not include an indicator variable for quarter 3). Also create a variable called Trend that increases by 1 each quarter.
Year | Q1 | Q2 | Q3 | Q4 |
2001 |
|
| 1,513 | 1,060 |
2002 | 1,431 | 1,123 | 994 | 679 |
2003 | 1,485 | 886 | 1,256 | 975 |
2004 | 1,256 | 1,156 | 1,163 | 1,062 |
2005 | 1,200 | 1,072 | 1,563 | 531 |
2006 | 1,022 | 1,169 |
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started