DATA: https://docs.google.com/spreadsheets/d/1Pihhb0lU_Jg8lb5c79_QHW0zZKN9FwkD4spZPM3mgSA/edit?usp=sharing

Refer to the Excel file uploaded. Read the descriptions of the HHV study. Let DV = HHV. Conduct various runs of multiple linear regression at 0.01 level of significance. Answer each of the following four questions. Which of the following IVs is eliminated at first run? [ Select ] Which of the following IVs is eliminated at second run? [ Select ] Which of the following IVs is eliminated at third run? [ Select ] Which of the following IVs is eliminated at fourth and final run? [ Select ] (Note: All questions below that are labeled with [[HHV]] are based on the final model generated from the questions above.) Question 6 1 pts [[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the intercept of the final model. Question 7 1 pts [[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the coefficient of the significant IV which is LAST ALPHABETICALLY (that is, if more than one IV remain in the final model) (If one IV remains, indicate the coefficient of that IV) (If no IV remains, write 0)[[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the test statistic value of the significant IV which is LAST ALPHABETICALL (that is, if more than one IV remain in the final model) (If one IV remains, indicate the test stat value of that IV) (If no IV remains, write 0) Question 9 1 [[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the R^2 value in proportion (NOT percentage) form Question 10 1 [[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the tolerance value of the significant IV which is LAST ALPHABETICALLY (that is, if more than one IV remain in the final model) (If one IV remains, indicate the tolerance value of that IV) (If no IV remains, write 0)[[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the residual value of the 46th sampled unit. Question 12 1 pts [[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the Cook's distance value of the 20th sampled unit. Question 13 2 pts [[HHV]] Rounded off to ONLY FOUR DECIMAL PLACES, indicate the MAPE value. Question 14 7 pts [[HHV]] In 14 sentences or less, provide explanations/interpretations for the above results on significance tests, coefficients, R^2, and tolerance. Include explanations/interpretations on graphs for normality and variance constancy (no need to insert actual graphs)Refer to the Excel file uploaded. Read the descriptions of the TRAIN study. Let DV = TRAINCOLL and IV - TRAINKM, where TRAINCOLL - 1 if train has gotten into a collision, 0 otherwise TRAINKM - number of kilometers travelled by the train Conduct one run of simple logistic regression at 0.10 level of significance. Which of the following is the appropriate conclusion? (Note: All questions below that are labeled with [[TRAIN]] are based on the final model generated from the scenario above.) O Do not reject Ho. The IV is a significant predictor of the DV O Reject Ho. The IV is a significant predictor of the DV O Reject Ho. The IV is not a significant predictor of the DV O Do not reject Ho. The IV is not a significant predictor of the DV Question 16 1 pts [[TRAIN]] Rounded off to ONLY FOUR DECIMAL PLACES, what is the p value of the test statistic? Question 17 2 pts [[TRAIN] For every kilometer increase in total distance travelled by the train, what is the increase in the log odds of entering into collision? Round off final answer to ONLY FOUR DECIMAL PLACES[ITRAIN]] For every kilometer increase in total distance travelled by the train, what is multiplied to the odds of entering into collision? Round of final answer to ONLY FOUR DECIMAL PLACES Question 19 3 p [ITRAIN]] What is the probability of a train NOT entering into collision its total distance travelled is 400 kms? Question 20 4 p [ITRAIN]] In 8 sentences or less, provide explanations/interpretations for the above results on significance tests and coefficients