a. Using trend (linear regression) analysis, predict the number of patients Dr. Fok will see in years 11 [Select] 12 [Select] b. What is the MAD? [Select] as a function of time. c. What is the correlation coefficient - r-value? [Select] % and

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
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:
2
3
Year
Number of
Patients
Robbery Rate
per 1000
Population
12 [Select]
1
36
33
58.3 61.1
[Select]
b. What is the MAD? [ [Select]
40
73.4
4
e. What is the MAD? [ [Select]
41
5
40
c. What is the correlation coefficient - r-value? [Select]
as a function of time.
6
55
7
60
f. What is the correlation Coefficient - r-value? [Select]
a. Using trend (linear regression) analysis, predict the number of patients Dr. Fok will see in years 11 [Select]
8
54
75.7 81.1 89.0 101.1 94.8 103.3 116.2
g. Based on the overall analysis, how well does each model fit the data?
%
d. Now based on regression analysis predict the number of patients that Dr. Fok will see in year 11 [Select]
9
58
do
10
based on the forecasted Robbery Rate - year 11 is 117.1 and year 12 is 120.8.
%
61
[Select]
>
and
and 12
Transcribed Image Text: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: 2 3 Year Number of Patients Robbery Rate per 1000 Population 12 [Select] 1 36 33 58.3 61.1 [Select] b. What is the MAD? [ [Select] 40 73.4 4 e. What is the MAD? [ [Select] 41 5 40 c. What is the correlation coefficient - r-value? [Select] as a function of time. 6 55 7 60 f. What is the correlation Coefficient - r-value? [Select] a. Using trend (linear regression) analysis, predict the number of patients Dr. Fok will see in years 11 [Select] 8 54 75.7 81.1 89.0 101.1 94.8 103.3 116.2 g. Based on the overall analysis, how well does each model fit the data? % d. Now based on regression analysis predict the number of patients that Dr. Fok will see in year 11 [Select] 9 58 do 10 based on the forecasted Robbery Rate - year 11 is 117.1 and year 12 is 120.8. % 61 [Select] > and and 12
Expert Solution
Step 1 Introduction:

As per this Q, I would consider the Year as an independent variable and the number of patients as the dependent variable, there are multiple sub-parts in one question, and as per the instruction, the first three sub-parts are taken for answering purposes, I would apply the linear regression forecasting technique, 

 

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

d. Now based on regression analysis predict the number of patients that Dr. Fok will see in year 11  and 12  based on the forecasted Robbery Rate - year 11 is 117.1 and year 12 is 120.8.

e. What is the MAD?  

f.  What is the correlation Coefficient – r-value?     %

g. Based on the overall analysis, how well does each model fit the data?   

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.