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)
The answer provided below has been developed in a clear step by step manner Step 1 total sample size ... 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
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
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...
-
The following comparative information is available for Rose Company for 2017. Instructions (a) Determine net income under each approach. Assume a 30% tax rate. (b) Determine net cash provided by...
-
Candy Canes weekly gross earnings for the week ended May 23 were $1,370, and her federal income tax withholding was $187.88. Assuming that the social security rate is 6% and Medicare is 1.5% of all...
-
A steam engine of \(100 \mathrm{~kW}\) runs at \(100 \mathrm{rpm}\). The speed of the engine is to be maintained within \(1 \%\) variation in mean speed. The flywheel has a mass of \(2000...
-
On January 1, 2012, Norma Smith and Grant Wood formed a computer sales and service enterprise in Soapsville, Arkansas, by investing $90,000 cash. The new company, Arkansas Sales and Service, has the...
-
Property worth $330,500.00 can be purchased for 6% down and mortgage payments of $1620.00 at the end of each month for 30 years. What is the nominal annual rate of interest compounded monthly? The...
-
What are the triads using roman numerals and figured bass numbers for this excerpt? 30-3. Use Roman numerals and figured bass numbers to identify triads in these works. a. Schubert, "Death and the...
-
The viscous force of a spherical ball moving viscous liquid may depend on viscocity of liquid [m], radius of sphere [*) derive stocks through a formula for the viscous force acting on spherical ball
-
1. How does inflation impact the economy? 2. What are the key factors to consider when investing in real estate? 3. How do interest rates affect consumer spending? 4. What is the role of a financial...
-
Discuss how you would report a repayment in a HELP loan scheme
-
A new video game has a variable cost of $0.50 per unit and a fixed cost of $6000. The cost, C, of selling g games can be written as: C(g)=0.50g+6000 How many games were sold when the cost is $7000 ?
-
Carol buys a couch from Company X. Company X retains a security interest in the couch until Carol pays off the balance of the purchase price. In this scenario, Company X is the
-
8 months from now, your organization is planning to purchase new video conferencing equipment for a cost of $12,000. The equipment will have a useful life of 10 years and no salvage value. To pay for...
-
If a company sells its treasury stock for more than it cost and records a gain on the income statement, then income and shareholders' equity are overstated . only income is overstated . only...
-
Chloroplasts are illuminated until the levels of the Calvin cycle intermediates reach a steady state. The light is then turned off. How does the level of RuBP vary after this point?
-
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...
-
Participating preference shares entitle shareholders to: A. Participate in the decision-making process of the company. B. Convert their shares into a specified number of common shares. C. Receive an...
-
In defining asset classes as part of the strategic asset allocation decision, pairwise correlations within asset classes should generally be: A. Equal to correlations among asset classes. B. Lower...
-
Investing the majority of the portfolio on a passive or low active risk basis while a minority of the assets is managed aggressively in smaller portfolios is best described as: A. The coresatellite...
Study smarter with the SolutionInn App