Reference no: EM132666644
Question 1. Assume there are two explanatory variables (X1 and X2)in a logistic regression model.
X1 is a categorical variable with levels including very low, low, average, high and very high
X2 is a categorical variable with levels including Sydney, Melbourne, Hobart and Brisbane.
Explain how you will use these variables in developing a logistic regression model. How many coefficients will you have in the final model?
Question 2.
Assume that you are a business analyst in a manufacturing company. Your manager gave you a task to optimise scheduling of a project. You are asked to minimize the overall manufacturing time. There are three items to be manufactured and three different machineries are available to be used for the manufacturing task. Due to operational reasons every machinery can only be allocated to the manufacturing of one item. Every item can only be manufactured by one machine. Different machinery has different speeds in manufacturing different items. Let us say i and m represent item and machinery, respectively. i1 represents the first item i2 represents the second item and so on. m1 represents the first machine, m2 represents the second machinery and so on.The duration of manufacturing every item pertaining to every machinery is presented in the below table.
|
m1
|
m2
|
m3
|
i1
|
5
|
5
|
3
|
i2
|
4
|
9
|
4
|
i3
|
3
|
6
|
6
|
In this problem the sequence of manufacturing is important. Items i1 and i2 should be manufactured before manufacturing item i3.
a) Write the linear optimisation model for the company to make the best decision.
b) Solve the model, present the results and interpret them.
Hint: you can use a binary variable such as x_im which can take values of zero and one. Let us say xim=1 if machine m is engaged to manufacture item i otherwise xim=0.
Question 3.
The following screenshot is taken from the logistics regression output from the data set "credit card". You can find the data set here. The response variable that is called "card" is a binary variable which is considered as success (yes or 1) if the application of the customer for a credit card is accepted.
a. Write the logistics regression equation based on the output?

In the Excel sheet "Q6" you can find the actual values of dependent variable versus the prediction values. Calculate overall error, sensitivity, and specificity. Explain the steps of calculations.