The following table shows data on asthma-related visits. Is there evidence that these visits vary by quarter?

Question:

The following 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. (To do this, you will need the free Analysis ToolPak for your version of Excel. Microsoft [2018] offers guidance on how to load and use the Analysis ToolPak.) 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 data are for the second quarter and 0 otherwise, and a variable called Q4 that equals 1 if the data are for the fourth quarter and 0 otherwise. (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.Q3 1,513 2015 1,431 1,123 994 2016 1,485 886 1,256 2017 1,256 1,156 1,163 2018 1,200 1,072 1,563 2019 1,022

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: