Question

Dr. Lillian folk in New Orleans psychologist specializes in treating patients who are agoraphobic afraid to leave their homes the following table indicates how many patients Dr. Faulk has seen each year for the past 10 years it also indicates what the robbery rate was in New Orleans during the same year the simple linear regression equation that shows the best relationship between the number of patients and year is?

Homework: Chapter 4 MHomework 42 41 58 39 S3 Robbery Rate per sa6 726 757 815 690 1015 942 1022 1162 decimal places)

Answer 1

In this case "year" is the independent variable i.e. x and number of patients is the dependent variable i.e. y

The simple linear regression equation is y = a +bx

Thus the data that we have is:

x	y
1	58.00
2	61.10
3	72.60
4	75.70
5	81.50
6	89.00
7	101.50
8	94.20
9	102.20
10	116.20

Using the above data in excel, go to "data" tab, select "data analysis" and then select "regression". The excel's output will be:

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	51.720	2.831609	18.26523	8.3E-08	45.1903	58.2497	45.1903	58.2497
X Variable 1	6.087	0.456355	13.33889	9.54E-07	5.034916	7.13963	5.034916	7.13963

Thus the simple linear regression equation will be:

y = 51.720 + 6.087x