Please give step by step instructions on how to analyze it on Microsoft Excel

A personnel manager for a large corporation feels that there may be a relationship between absenteeism, age and life status (single, married, divorced and other) of workers He would like to develop a model to predict the number of days absent during a calendar year for workers using the independent variables above. A random sample of 20 workers was selected with the results presented below Life Status Age Days Absent Single 15 40 10 18 27 61 37 23 Married Married Other Other Other 20 14 32 26 58 29 67 64 Sin 57 28 60 39 Married Other Married Divorced Divorced 18 35 24 35 45 23 48 Single Single Other Other Divorced Single 21 5 9 39 Use Excel to analyze the data, print out the summary output and attach it to your submission Use the following: Y Dependent variable; X1 - Age; X2- Single X3- Married; X4-Divorced. a) b) c) d) e) f) What is the prediction equation? What is the correlation coefficient? Is the overall model significant? Why? What is the coefficient of determination? What is the MSE? List the p-value of each independent variable and say whether it is significant to the model or not. Use a 0.05 level of significance. What is the predicted number of days absent for a 54 year old widower? g)