Jerilyn Ross, a New York City psychologist, specializes in treating patients who are phobic and afraid to leave their homes. The following table indicates how many patients Dr. Ross has seen each year for the past ten years. It also indicates what the robbery rate was in New York City during the same year.
YEAR NUMBER OF PATIENTS CRIME RATE
(ROBBERIES PER 1,000 POPULATION)
1 36 58.3
2 33 61.6
3 40 73.4
4 41 75.7
5 40 81.1
6 55 89.0
7 60 101.1
8 54 94.8
9 58 103.3
10 61 116.2
a. Using trend analysis (regression over time), how many patients do you think Dr. Ross will see in years 11, 12, and 13?
b. How well does the model fit the data? The model data follows the trend line closely over time.
c. Apply linear regression to study the relationship between the crime rate and Dr. Ross's patient load. Determine the regression equation.
Please see attached files
a. Using Excel (file attached) to find the trendline, we have:
Hence Patient = ...
The solution provides very detailed explanations on the concept of linear regression. It uses Excel for solving the linear regression problem and for producing associated charts.