Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The table shows data on asthma-related visits. Is there evidence that these visits vary by quarter? Can you detect a trend? A powerful tool 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 tool 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 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.

Year

Q1

Q2

Q3

Q4

2001

1513

1060

2002

1431

1123

994

679

2003

1485

886

1256

975

2004

1256

1156

1163

1062

2005

1200

1072

1563

531

2006

1022

1169

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra 1

Authors: Mary P. Dolciani, Richard A. Swanson

(McDougal Littell High School Math)

9780395535899, 0395535891

More Books

Students also viewed these Mathematics questions