Question: . A small hospital is planning for future needs for Covid 19. The data below show the number of cases in each of the past

. A small hospital is planning for future needs for Covid 19. The data below show the number of cases in each of the past eight years.

Year

Cases

Year

Cases

1

565

5

615

2

590

6

611

3

583

7

610

4

597

8

623

a. Use simple linear regression to forecast the annual number of cases for each of the next three years.

b. Determine the correlation coefficient for the data and interpret its meaning.

c. Find the coefficient of determination for the data and interpret its meaning.

2. Sunshine Heaters Inc. is a mid-sized manufacturer of residential water heaters. Sales have grown during the last several years, and the company's production capacity needs to be increased. The company's management wonders if national housing starts might be a good indicator of the company's sales:

National

Sunshine Heaters'

Housing Starts

Annual Sales

Year

(millions)

(millions of dollars)

I

6.2

57

2

5.1

59

3

6.5

65

4

7.9

78

5

6.3

72

6

7.4

80

7

7.0

86

a. Develop a simple linear regression analysis between Sunshine Heaters' sales and national housing starts. Forecast Sunshine Heaters' sales for the next two years. The National Home Builders Association estimates that national housing starts will be 7.1 million and 8.0 million for the next two years.

b. What percentage of variation in Sunshine Heaters' sales is explained by national housing starts?

c. Would you recommend that Sunshine Heaters management use the forecast from Part a to plan facility expansion? Why or why not? What could be done to improve the forecast?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!