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.

Transcribed Image Text:

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 1,169 Year 2014 Q1 Q2 Q4 1,060 679 975 1,062 531