Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Performance Analysis And Synthesis For Discrete-Time Stochastic Systems With Network-Enhanced Complexities

Authors: Derui Ding, Zidong Wang, Guoliang Wei

1st Edition

0429880022, 9780429880025

More Books

Students also viewed these Mathematics questions

Question

What is the difference between internal and external documentation?

Answered: 1 week ago

Question

Understand links between the university business model and HRM.

Answered: 1 week ago