Do some Excel Work

lease read the attached 'ABB electric' case study and answer the following questions. This time only consider the logistic regression output. Also, whenever needed please follow the below decision rule, choice probability segment type 0.9 - 1 Loyal 0.5 - 0.9 Switchable 0.1 - 0.5 Winnable 0 - 0.1 Lost 1. Based on the logistic regression output as generated by MEXL, manually write down the logistic regression equation for the choice probability of the ABB customers. 2. If you (ABB electric) do not do any choice modeling before targeting the top 20% customers but later learn their actual choice segment types, how much money will you actually generate as company's revenue? Assume that loyal and lost will not generate any revenue for you and you can keep the winnable and switchable segments with only 0.5 probabilities. 3. Now, if you target them on the basis of choice probabilities, how much additional money (compared to question 2) will you make? 4. If you instead target on the basis of expected revenue, how much additional money (compared to question 2 and 3) will you make? 5. Are you happy with the decision rule as suggested at the beginning of this assignment? If yes, explain why. If not, explain why not