Questions: Please answer each of the following questions and provide examples for better clarity wherever applicable. Provide in-text citations. In answering the following questions please include choice of significance level and the effect of p values 1 Logistic Regression Explain the logistic regression model, the independent variables and the dependent variable, assumptions of the model, as well as the objectives Given the data, what approach is taken to construct the model? Explain the effect of multicollinearity in logistic regression, and how multicollinearity is detected? Explain the hypotheses on coefficients of the regression and how the results of testing these hypotheses are interpreted about significance of these coefficients? Include both unidirectional and bidirectional situations How do you interpret the effect of significant coefficients? How are the distribution of the observed residuals of the constructed model tested for normality?  What is the coefficient of determination, and what is its significance? How can the regression model be used for prediction? 2 Discriminant Analysis Explain the discriminant analysis model, the independent variables and the dependent variable, assumptions of the model, as well as the objectives Given the data, what approach is taken to construct the model? Explain the effect of multicollinearity in discriminant analysis, and how multicollinearity is detected? Explain the hypotheses on coefficients of the model and how the results of testing these hypotheses are interpreted about significance of these coefficients? Include both unidirectional and bidirectional situations How do you interpret the effect of significant coefficients? How the distribution of the observed residuals of the constructed model are tested for normality?  What is the coefficient of determination, and what is its significance? How can the model be used for prediction? What is the confusion matrix in discriminant analysis? In answering the above questions, you can provide examples formulated according to the model’s setting without actually constructing the solution.

Do the following problems from chapters 8 and 9 and the regression analysis CH8PROBLEM 18 AND 13CH9PROBLEM 4 AND 20Assignment - Regression AnalysisComplete the regression assignment on page 272 (PLE case). Do only the part pertaining to employee retention, and also pay attention to the final paragraph. The Employee Retention worksheet is in the Excel file called Performance Lawn Equipment.

Every question must be answered in excel and using excel equations. Please see the attached document Thanks