please answer all parts and show work in excel Dr. Lillian Fok, a New Orleans ps
ID: 353025 • Letter: P
Question
please answer all parts and show work in excel
Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year:
Year
1
2
3
4
5
6
7
8
9
10
Number of Patients
3636
3232
4040
4040
4242
5656
6262
5555
5757
6060
Robbery Rate per 1,000 Population
58.358.3
61.461.4
73.073.0
76.176.1
81.181.1
89.589.5
101.1101.1
94.894.8
103.2103.2
117.2117.2
The simple linear regression equation that shows the best relationship between the number of patients and year is (round your responses to three decimal places):
ModifyingAbove y with carety
=
nothing
+
nothingx
where
ModifyingAbove y with carety
= Dependent Variable and x = Independent Variable.
Observation,1,2,3,4,5,6,7,8,9,10
Year,1,2,3,4,5,6,7,8,9,10
Number of Patients,36,32,40,40,42,56,62,55,57,60
Year
1
2
3
4
5
6
7
8
9
10
Number of Patients
3636
3232
4040
4040
4242
5656
6262
5555
5757
6060
Robbery Rate per 1,000 Population
58.358.3
61.461.4
73.073.0
76.176.1
81.181.1
89.589.5
101.1101.1
94.894.8
103.2103.2
117.2117.2
Secure https://www.mathxl.com/Student/PlayerHomework.aspx?homeworkld-472996141&questionid;=3&flushedefalse;&cld-4912944;¢erwinsyes; MANAGEMENT OF OPERATIONS (1) Vincent Amoia 3/22/18 2:43 PM Homework: Homework 4 Score: 0 of 1 pt Problem 4.30 Save 6 of 10 (6 complete) Hw Score: 50%, 5 of 10 pts Question Help Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year: 10 60 Year Number of Patients Robbery Rate per 1,000 Population 36 32 40 56 57 58.361.4 73.0 76.1 81.1 89.5 101.1 94.8 103.2 117.2 The simple linear regression equation that shows the best relationship between the number of patients and year is (round your responses to three decimal places) y 8.2451.611 where y Dependent Variable and x-Independent Variable Enter your answer in the edit fields and then click Check Answer. Clear All Final Check remainingExplanation / Answer
As understood , we have to solve the problem related to Dr. Fok and his patients ( since problem related to Number of patients and robbery rate per 1000 population ) .
The details of years and corresponding number of patients seen by Dr Fok are given below :
Year,1,2,3,4,5,6,7,8,9,10
Number of Patients,36,32,40,40,42,56,62,55,57,60
Let the linear regression equation is :
Y = a + b.X
Where,
X ( independent variable ) = Serial number of year
Y ( Dependent variable ) = Number of patients
a,b are constants
We place serial number of year and corresponding number of patients in two parallel columns in excel and apply the formula LINEST ( ) to get values of a and b.
Accordingly the values are :
A = 29.8
B = 3.309
Therefore ,
Y = 29.8 + 3.309.X
THE LINEAR REGRESSION EQUATION IS Y = 29.8 + 3.309.X
THE LINEAR REGRESSION EQUATION IS Y = 29.8 + 3.309.X
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.