3. The ABX Company is interested in conducting a study to identify factors that affect absenteeism...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. The ABX Company is interested in conducting a study to identify factors that affect absenteeism among its production employees. After reviewing the literatures on absenteeism and interviewing several production supervisors and a number of employees, the researcher in charge of the project defined the variables shown as below ABSENT =the number of distinct occasions that the worker was absent during the year COMPLX = a measure of job complexity, ranging from 0 to 100 PAY = basic hourly pay rate in dollars SENIOR = number of complete years with the company AGE - age of the employee DEPEND employee response to the question "how many individuals other than yourself depend on you for most of their financial support? A sample of 77 employees was randomly selected, the data was contained in the file named "PS2A.xlsx" (sheet = "PS2A.Q3"). Consider a multiple regression model with absenteeism as the response and all other variables as the covariates. The R output is given below with some missing figures. Estimate Std. Error t value Pr(>|t|) 3.626609 1.387114 2.615 (Intercept) 0.0109 COMPLX PAY SENIOR AGE -0.015955 0.006883 -2.318 0.044839 0.166481 -0.038100 0.048240 -0.790 -0.025584 0.032503 -0.787 0.4338 0.0233 0.4323 DEPEND -0.040499 0.123385 -0.328 0.7437 Residual standard error: 1.38 on _ degrees of freedom Multiple R-squared: 0.1874, Adjusted R-squared: F-statistic: 3.276 on and DF, p-value: (a) Write down the fitted regression model. (b) Interpret the meaning of the estimated slope coefficient for COMPLX. (c) What is the residual degree of freedom. (d) Compute the adjusted R. (e) Compute the SSR of the model. (f) Test the slope coefficient of PAY. Use 5% level of significance. ABSENT COMPLX PAY SENIOR AGE DEPEND 2 0 45 6 3 28 2 3. 1 76 8 10 42 1 0 56 5 9 40 5 2 76 8 7 34 2 5 0 70 8 14 39 2 7 1 69 6 9 44 0 B 1 56 6 3 40 1 9 1 56 5 1 35 0 0 2 43 7 9 32 0 1 1 76 6 1 41 1 3 30 5 1 27 1 3 2 50 7 9 40 0 4 1 10 5 1 30 1 5 3 69 6 4 35 0 6 2 67 8 3 33 1 7 0 69 6 4 32 1 8 4 70 7 8 37 1 9 7 13 6 1 26 2 20 3 16 8 3 36 2 21 2 52 7 5 28 2 22 2 52 7 16 40 1 13 4 3 6 2 26 0 24 2 6 5 4 38 2 25 0 67 8 6 33 1 26 3 10 5 1 26 0 27 3 89 10 18 48 0 28 3 21 5 2 34 1 9 0 34 6 4 26 1 0 2 12 8 6 40 2 1 3 70 7 2 34 2 2 1 69 6 11 49 2 3 4 13 6 1 35 1 4 2 30 6 13 51 5 55 1 43 5 1 25 1 6 3 8 6. 2 29 0 7 2 69 7 3 34 2 8 4 30 5 T 36 2 9 4 23 5 1 31 2 0 4 16 7 1 28 2 1 3 11 6 1 32 2 2 2 16 6 1 30 2 3 6 50 6 2 30 2 4 3 50 6 2 28 0 5 1 69 9 4 31 4 -6 2 10 6 2 34 1 7 1 43 7 26 54 1 8 1 12 6 1 28 0 -9 3 76 7 5 28 2 0 2 56 5 2 35 2 1 0 6 6 8 43 4. 0 8 7 3 29 4 3 1 45 5 2 32 3 4 3 43 6 5 31 3. 55 6 23 5 1 26 1 6 3 1 7 7 46 1 7 2 82 8 1 23 1 8 2 1 6 1 20 0 9 4 1 6 1 35 3 0 3 70 8 4 32 2 51 0 76 7 6 34 0 2 0 82 9 7 38 0 3 1 50 6 9 33 2 4 1 70 9 8 45 1 5 1 81 7 5 27 1 6 2 70 8 9 33 4 57 3 1 7 2 30 3 58 2 8 6 1 32 2 9 2 23 5 2 24 3 20 2 21 6 12 47 4 2 82 9 7 33 5 1 67 9 28 54 3 13 0 81 7 18 45 2 "4 1 43 8 6 40 0 5 4 6 6 3 21 1 "6 3 13 7 8 29 4 7 2 52 7 7 31 1 8 3 52 5 1 27 1 3. The ABX Company is interested in conducting a study to identify factors that affect absenteeism among its production employees. After reviewing the literatures on absenteeism and interviewing several production supervisors and a number of employees, the researcher in charge of the project defined the variables shown as below ABSENT =the number of distinct occasions that the worker was absent during the year COMPLX = a measure of job complexity, ranging from 0 to 100 PAY = basic hourly pay rate in dollars SENIOR = number of complete years with the company AGE - age of the employee DEPEND employee response to the question "how many individuals other than yourself depend on you for most of their financial support? A sample of 77 employees was randomly selected, the data was contained in the file named "PS2A.xlsx" (sheet = "PS2A.Q3"). Consider a multiple regression model with absenteeism as the response and all other variables as the covariates. The R output is given below with some missing figures. Estimate Std. Error t value Pr(>|t|) 3.626609 1.387114 2.615 (Intercept) 0.0109 COMPLX PAY SENIOR AGE -0.015955 0.006883 -2.318 0.044839 0.166481 -0.038100 0.048240 -0.790 -0.025584 0.032503 -0.787 0.4338 0.0233 0.4323 DEPEND -0.040499 0.123385 -0.328 0.7437 Residual standard error: 1.38 on _ degrees of freedom Multiple R-squared: 0.1874, Adjusted R-squared: F-statistic: 3.276 on and DF, p-value: (a) Write down the fitted regression model. (b) Interpret the meaning of the estimated slope coefficient for COMPLX. (c) What is the residual degree of freedom. (d) Compute the adjusted R. (e) Compute the SSR of the model. (f) Test the slope coefficient of PAY. Use 5% level of significance. ABSENT COMPLX PAY SENIOR AGE DEPEND 2 0 45 6 3 28 2 3. 1 76 8 10 42 1 0 56 5 9 40 5 2 76 8 7 34 2 5 0 70 8 14 39 2 7 1 69 6 9 44 0 B 1 56 6 3 40 1 9 1 56 5 1 35 0 0 2 43 7 9 32 0 1 1 76 6 1 41 1 3 30 5 1 27 1 3 2 50 7 9 40 0 4 1 10 5 1 30 1 5 3 69 6 4 35 0 6 2 67 8 3 33 1 7 0 69 6 4 32 1 8 4 70 7 8 37 1 9 7 13 6 1 26 2 20 3 16 8 3 36 2 21 2 52 7 5 28 2 22 2 52 7 16 40 1 13 4 3 6 2 26 0 24 2 6 5 4 38 2 25 0 67 8 6 33 1 26 3 10 5 1 26 0 27 3 89 10 18 48 0 28 3 21 5 2 34 1 9 0 34 6 4 26 1 0 2 12 8 6 40 2 1 3 70 7 2 34 2 2 1 69 6 11 49 2 3 4 13 6 1 35 1 4 2 30 6 13 51 5 55 1 43 5 1 25 1 6 3 8 6. 2 29 0 7 2 69 7 3 34 2 8 4 30 5 T 36 2 9 4 23 5 1 31 2 0 4 16 7 1 28 2 1 3 11 6 1 32 2 2 2 16 6 1 30 2 3 6 50 6 2 30 2 4 3 50 6 2 28 0 5 1 69 9 4 31 4 -6 2 10 6 2 34 1 7 1 43 7 26 54 1 8 1 12 6 1 28 0 -9 3 76 7 5 28 2 0 2 56 5 2 35 2 1 0 6 6 8 43 4. 0 8 7 3 29 4 3 1 45 5 2 32 3 4 3 43 6 5 31 3. 55 6 23 5 1 26 1 6 3 1 7 7 46 1 7 2 82 8 1 23 1 8 2 1 6 1 20 0 9 4 1 6 1 35 3 0 3 70 8 4 32 2 51 0 76 7 6 34 0 2 0 82 9 7 38 0 3 1 50 6 9 33 2 4 1 70 9 8 45 1 5 1 81 7 5 27 1 6 2 70 8 9 33 4 57 3 1 7 2 30 3 58 2 8 6 1 32 2 9 2 23 5 2 24 3 20 2 21 6 12 47 4 2 82 9 7 33 5 1 67 9 28 54 3 13 0 81 7 18 45 2 "4 1 43 8 6 40 0 5 4 6 6 3 21 1 "6 3 13 7 8 29 4 7 2 52 7 7 31 1 8 3 52 5 1 27 1
Expert Answer:
Answer rating: 100% (QA)
Step1 total sample size n 77 number of independent variables k 5 COMPLX PAY SENIOR AG... View the full answer
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Posted Date:
Students also viewed these mathematics questions
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
A random sample of data was collected on residential sales in a large city. The following table shows the sales price Y (in $ 1,000s), area X1 (in hundreds of square feet), number of bedrooms X2,...
-
A psychologist conducts an experiment on rats. She puts a rat in a cage having three rooms labeled 1, 2, and 3, as shown in Figure below. L Figure: a cage with 3 rooms and 5 doors. The rats are...
-
Digital Camera Shop Inc. uses the lower-of-cost-or-market basis for its inventory. The following data are available at December 31. Instructions What amount should be reported on Digital Camera...
-
Let X1,... ,Xn be iid n(,2). Find a function of S2, the sample variance, say g(S2), that satisfies Eg(S2) = . (Hint: Try g(S2) = cS2, where c is a constant.)
-
Locate the state bar website for California. What information is provided there? Are there research sites available on the state bar website?
-
Christina Reis is a photographer who owns Lola Lemon Photography. This is the first month of operations. The following are the transactions for the month of September. a. On September 1, Reis...
-
Exco plc is planning to separate one of its subsidiaries ('SplitCo'), through a split-off of the entire share capital of SplitCo, amounting to 1 million shares outstanding. The estimated value of...
-
Glenn Foreman, president of Oceanview Development Corporation, is considering submitting a bid to purchase property that will be sold by sealed bid at a county tax foreclosure. Glenns initial...
-
A taxpayer earned $45,000 from employment, $15,000 net rental income, $500 from Employment Insurance benefits and $2,500 investment income. The taxpayer does not belong to a pension plan and always...
-
Timberly Construction makes a lump-sum purchase of several assets on January 1 at a total cash price of $900,000. The estimated market values of the purchased assets are building, $508,800; land,...
-
< Elisa needs money to repair her home air conditioner, so she pawns her bicycle. The pawnbroker loans Elisa $270. Twenty three days later, Elisa gets her bicycle back by paying the pawnbroker...
-
Vernon Car Wash, Incorporated expected to wash 1,000 cars during the month of August. Washing each car was expected to require 0.3 hour of labor. The company actually used 319 hours of labor to wash...
-
Suppose that Jacob's assets include a motorcycle worth $12,000 and a checking account with a $3,000 balance, while his liabilities include a credit card balance of $4,000, a motorcycle loan balance...
-
Explain the pattern in the simplification of imaginary numbers (Hint: 11, 12, 13, 14, 15.....) '
-
How do you interpret the coefficient of a dummy variable? Why do you only need to create k-1 dummy variables for a variable with k categories?
-
Show that gj concave AHUCQ Abadie For nonnegative variables, we have the following corollary.
-
Refer to the BMW Company case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet that will allow BMW management to estimate the cost of disposal a decade into the...
-
A small engineering firm has 4 senior designers available to work on the firms 4 current projects over the next 2 weeks. The firms manager has developed the following table of quality scores, which...
-
Consider the stylized example of Figure 7.3, in which there is a jump in the mean value. Using the same worksheet as a template, enter the exponential smoothing calculations for these periods. Assume...
-
A nurse at a medical center claims that the median number of flu shots they give per day is 30. To test the claim, the nurse randomly selects 20 days during the months of September, October, and...
-
A medical researcher believed the number of ear infections in swimmers can be reduced if the swimmers use earplugs. A sample of 10 people was selected, and the number of infections for a four-month...
-
The Pennsylvania Turnpike Commission allows travelers to use a purchased Easy Pass for tolls on the Pennsylvania Turnpike. A researcher hypothesizes that the median of the number of Easy Pass users...
Study smarter with the SolutionInn App