Question: Please answer accordingly A store manager wishes to study whether there is a relationship between the number of medical leaves her employee takes each year

Please answer accordingly

Please answer accordingly A store manager wishes to study whether there isa relationship between the number of medical leaves her employee takes each

A store manager wishes to study whether there is a relationship between the number of medical leaves her employee takes each year and their age. She collected data for a random sample of six employees and records the data as in Table 2. The regression analysis using Microsoft Excel was conducted and shown in Figure 2. Table 2 Employee 1 2 3 4 5 6 Medical Leaves 16 12 9 5 6 2 Age 18 26 39 48 53 58 SUMMARY OUTPUT Regression Statistics Multiple R 0.9791 R Square 0.9586 Adjusted R Square 0.9482 Standard Error 1.1570 Observations 6 ANOVA Significance df SS MS F F Regression 123.9785 123.9785 92.6112 0.0007 Residual 5.3548 1.3387 Total 129.3333 Lower Upper Coefficients Standard Error t Stat P-value 99.0% 99.0% Intercept 21.1005 1.4082 14.9835 0.0001 14.6168 27.5842 Age -0.3165 0.0329 -9.6235 0.0007 -0.4680 -0.1651 Figure 2ii) iii) iv) vi]I What is the type of variable for the independent variable? [1 Mark] Determine the level of measurement for the dependent variable. [1 Mark] Based. on Table 2= show that the correlation coefcient is 41979]. Hence. interpret the value. [11 Marks] Based on Figure 2, state the regression equation. [1 Mark] Test the hypothesis that there is a signicant linear relationship between the variables at 1% level of signicance by using ANOVA table in Figure 2. [5 Marks] Predict the number of medical leaves the employee will take if the age of employee is 50 years old. [2 Marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!