INSTRUCTIONS: Use a 5% level of significance. A hospital administrator is studying the relationship between patient satisfaction with patient's gender, age in years, severity of illness and anxiety level. She randomly selected 23 patients and collected the data presented below, where larger values are associated with more satisfaction, increased severity of illness, and more anxiety, respectively. Suppose further that patient 6, 8, 9, 11, 12, 17, 20, 22 are males (i.e., Gender = 0). Assume that the multiple linear regression model with normal random error terms is appropriate. Severity of Anxiety Patient Age Illness Level Satisfaction 51 2.3 48 46 2.3 57 48 2.2 66 4 41 44 1.8 70 5 28 43 1.8 89 6 49 54 2.9 7 42 50 45 48 52 62 50 48 53 Patient I r r r 1 50 2 36 3 40 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 8 9 10 11 12 29 29 43 24 2.2 2.4 2.9 2.1 2.4 2.4 36 46 54 26 77 89 67 Patient Age 13 38 14 34 15 53 16 36 17 18 29 19 33 20 55 21 29 22 44 23 43 a. Forward Stepwise Procedure b. Backward Stepwise Procedure PP 33 Severity of Anxiety Patient Illness Level Satisfaction 55 2.2 47 51 2.3 51 54 2.2 57 49 2 66 56 2.5 79 46 1.9 88 49 51 52 Are there outliers in the given data? Justify. Are there influential points in the given data? Justify. Independent Variables in Model 58 50 Find the estimated regression (i.e., full) model. Interpret the coefficient for gender. N - Is multicollinearity present among the variables in the given model? Support your answer by calculating relevant statistic(s). Compare the following models by filling-up the table below: Model Adjusted R 2.1 2.4 2.3 2.9 2.3 Determine which among patient's gender, age in years, severity of illness and anxiety level are significant predictors for patient satisfaction using Full Using Forward Stepwise Using Backward Stepwise Which is the best model in predicting patient satisfaction? Why? 60 49 77 52 60 MSE

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Work in excel solve for me all dont reject ok.
INSTRUCTIONS: Use a 5% level of significance.
A hospital administrator is studying the relationship between patient satisfaction with
patient's gender, age in years, severity of illness and anxiety level. She randomly
selected 23 patients and collected the data presented below, where larger values are
associated with more satisfaction, increased severity of illness, and more anxiety,
respectively. Suppose further that patient 6, 8, 9, 11, 12, 17, 20, 22 are males (i.e.,
Gender = 0). Assume that the multiple linear regression model with normal random
error terms is appropriate.
Patient
1
2
3
4
5
6
7
8
9
10
11
12
J
Severity of Anxiety Patient
Age Illness Level Satisfaction
50
51
2.3
48
36
46
2.3
57
48
2.2
66
44
1.8
70
43
1.8
89
54
2.9
36
50
48
52
62
29
50
29
48
43 53
40
41
28
49
42
45
2.2
2.4
2.9
2.1
2.4
2.4
46 54 26 7 89 67
77
67
Find the estimated regression
gender.
Severity of Anxiety Patient
Illness Level Satisfaction
Age
13 38
55
2.2
14
34
51
2.3
15
53
54
2.2
16 36 49
17
33
56
18
29
46
19
33
49
55
51
29
52
44
58
43
50
Patient
20
21
22
23
a. Forward Stepwise Procedure
b. Backward Stepwise Procedure
Are there outliers in the given data? Justify.
Are there influential points in the given data? Justify.
N N
Compare the following models by filling-up the table below:
Model
Adjusted R²
2
Independent
Variables in
Model
2.5
1.9
(i.e., full) model. Interpret the coefficient for
Full
Using Forward Stepwise
Using Backward
Stepwise
Which is the best model in predicting patient satisfaction? Why?
15
2.1
2.4
2.3
Is multicollinearity present among the variables in the given model? Support your
answer by calculating relevant statistic(s).
2.9
2.3
Determine which among patient's gender, age in years, severity of illness and
anxiety level are significant predictors for patient satisfaction using
47
51
57
66
79
88
60
49
77
52
60
MSE
L
Transcribed Image Text:INSTRUCTIONS: Use a 5% level of significance. A hospital administrator is studying the relationship between patient satisfaction with patient's gender, age in years, severity of illness and anxiety level. She randomly selected 23 patients and collected the data presented below, where larger values are associated with more satisfaction, increased severity of illness, and more anxiety, respectively. Suppose further that patient 6, 8, 9, 11, 12, 17, 20, 22 are males (i.e., Gender = 0). Assume that the multiple linear regression model with normal random error terms is appropriate. Patient 1 2 3 4 5 6 7 8 9 10 11 12 J Severity of Anxiety Patient Age Illness Level Satisfaction 50 51 2.3 48 36 46 2.3 57 48 2.2 66 44 1.8 70 43 1.8 89 54 2.9 36 50 48 52 62 29 50 29 48 43 53 40 41 28 49 42 45 2.2 2.4 2.9 2.1 2.4 2.4 46 54 26 7 89 67 77 67 Find the estimated regression gender. Severity of Anxiety Patient Illness Level Satisfaction Age 13 38 55 2.2 14 34 51 2.3 15 53 54 2.2 16 36 49 17 33 56 18 29 46 19 33 49 55 51 29 52 44 58 43 50 Patient 20 21 22 23 a. Forward Stepwise Procedure b. Backward Stepwise Procedure Are there outliers in the given data? Justify. Are there influential points in the given data? Justify. N N Compare the following models by filling-up the table below: Model Adjusted R² 2 Independent Variables in Model 2.5 1.9 (i.e., full) model. Interpret the coefficient for Full Using Forward Stepwise Using Backward Stepwise Which is the best model in predicting patient satisfaction? Why? 15 2.1 2.4 2.3 Is multicollinearity present among the variables in the given model? Support your answer by calculating relevant statistic(s). 2.9 2.3 Determine which among patient's gender, age in years, severity of illness and anxiety level are significant predictors for patient satisfaction using 47 51 57 66 79 88 60 49 77 52 60 MSE L
Expert Solution
steps

Step by step

Solved in 4 steps with 14 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman