preview

Regression Analysis

Decent Essays

Assignment # 1

Forecasting (Total marks: 100)

Following 10 Problems are for submission

Problem 1: [12]

Registration numbers for an accounting seminar over the past 10 weeks are shown below:

|Week 1 2 3 4 5 6 7 8 9 10 |
|Registrations 24 23 28 30 38 32 36 40 44 40 |

a) Starting with week 2 and ending with week 11, forecast registrations using the naive forecasting method. [2] b) Starting with week 3 and ending with week 11, forecast registration using a two-week moving average. [3] c) Starting with week 5 …show more content…

[3]

Problem 9 [8]

Given the following data, use least squares regression to develop a relation between the number of rainy summer days and the number of games lost by the Boca Raton Cardinal base ball team.

Year 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003
Rainy Days 15 25 10 10 30 20 20 15 10 25
Games Lost 25 20 10 15 20 15 20 10 5 20

Problem 10 [16]

Dr. Jerilyn Ross, a New York City psychologist, specializes in treating patients who are agoraphobic (afraid to leave their homes). The following table indicates how many patients Dr. Ross has seen each year for the past 10 years. It also indicates what the robbery rate was in New York City during the same year.

|Year |1 |2 |3 |4 |5 |6 |
|Actual Battery sales |20 |21 |15 |14 |13 |14 |
|Forecast |22 | | | | | |

Problem 6:
Use the sales data given below to determine: (a) the least squares trend line, and (b) the predicted value for 2000 sales.

|Year |1993 |1994 |1995 |1996 |1997 |1998 |1999 |
|Sales (units) |100 |110 |122 |130 |139 |152

Get Access