The excel file that contains mortality information from a nursing home during th

The excel file that contains mortality information from a nursing home during the year 2015. The variable “died” indicates that if the patient died before the end of the year. Given this data, develop a logistic regression model, which predicts probability of death of a guest during any year by the end of that year, given the age and the dummy variable “gender.”
The personnel director of a firm has developed two tests to help determine whether potential employees would perform successfully in a particular position. To help estimate the usefulness of the tests, the director gives both tests to 43 employees that currently hold the position. Table 5 gives the scores of each employee on both tests and indicates whether the employee is currently performing successfully or unsuccessfully in the position. If the employee is performing successfully, we set the dummy variable Group is set equal to 1; if the employee is performing unsuccessfully, we set Group equal to 0. Let x1 and x2 denote the scores of a potential employee on tests 1 and 2.
Perform a discriminant analysis on the data and interpret the result, including the confusion matrix. Include all required steps in assessing the final model. By trial and error, find the threshold, which minimizes prediction relative error.
Table 5
Results on the Tests Taken by Employees
Group
Test
Test 2
1
96
85
1
96
88
1
91
81
1
95
78
1
92
85
1
93
87
1
98
84
1
92
82
1
97
89
1
95
96
1
99
93
1
89
90
1
94
90
1
92
94
1
94
84
1
90
92
1
91
70
1
90
81
1
86
81
1
90
76
1
91
79
1
88
83
1
87
82
0
93
74
0
90
84
0
91
81
0
91
78
0
88
78
0
86
86
0
79
81
0
83
84
0
79
77
0
88
75
0
81
85
0
85
83
0
82
72
0
82
81
0
81
77
0
86
76
0
81
84
0
85
78
0
83
77
0
81
71
Please write this in APA style thank you.