Concept explainers
Absenteeism: Absenteeism can be a serious employment problem. It is estimated that absenteeism reduces potential output by more than 10%. Two economists launched a research project to learn more about the problem. They randomly selected 100 organizations to participate in a 1-year study. For each organization, they recorded the average number of days absent per employee and several variables thought to affect absenteeism. Management’s goal here is to analyze the data and determine which factors may be helpful in predicting absenteeism.
Perform a two-sample t-test analysis to determine if mean absenteeism is different between organizations which have a good Union management and those that do not. I have provided the F-test for two variances below:
Copy and paste the Two sample t-test output below AND provide a clear conclusion supported by key statistics in the output about how absenteeism is affected by the Union Management Relationship. (I just need to know how to perform the two sample t-test in excel. Thank you)
Data:
Wage | Pct PT | Pct U | Av Shift | U/M Rel | Absent |
22477 | 8.5 | 57.1 | 1 | 1 | 5.4 |
29939 | 1.9 | 41.5 | 0 | 1 | 4.1 |
22957 | 12.2 | 52.6 | 1 | 0 | 11.5 |
18888 | 30.8 | 65.1 | 0 | 1 | 2.1 |
15078 | 6.8 | 68.8 | 0 | 1 | 5.9 |
15481 | 5.1 | 46.4 | 0 | 0 | 12.9 |
21481 | 25.3 | 38.9 | 0 | 1 | 3.5 |
29687 | 9.2 | 17.2 | 0 | 0 | 2.6 |
13603 | 8.4 | 12.9 | 0 | 0 | 8.6 |
18303 | 4.9 | 18.1 | 0 | 1 | 2.7 |
20832 | 23.8 | 64.4 | 1 | 1 | 6.6 |
22325 | 24.1 | 63.7 | 1 | 1 | 2.1 |
19964 | 8.6 | 12.2 | 0 | 1 | 3.8 |
32496 | 5.9 | 11.8 | 1 | 0 | 4.3 |
15795 | 2.9 | 25.8 | 0 | 1 | 4.3 |
21138 | 24.3 | 53.2 | 0 | 0 | 2.2 |
18859 | 20.6 | 22.8 | 1 | 1 | 8.6 |
12023 | 9 | 49.8 | 1 | 1 | 10.8 |
33272 | 24 | 39.1 | 1 | 0 | 2.9 |
22325 | 11.9 | 32.6 | 1 | 0 | 5.3 |
26147 | 0 | 67.7 | 1 | 0 | 8.2 |
33229 | 11.7 | 10.8 | 0 | 0 | 2.8 |
37970 | 14.6 | 25.5 | 1 | 1 | 2.4 |
15281 | 27.2 | 31.8 | 0 | 0 | 2.8 |
19423 | 17.2 | 35 | 1 | 1 | 5 |
26587 | 13.9 | 41.9 | 1 | 1 | 9.5 |
22963 | 2.6 | 52.9 | 0 | 1 | 4.3 |
26404 | 6.4 | 64.4 | 0 | 1 | 8.9 |
16315 | 4.9 | 69.7 | 0 | 1 | 7.2 |
26759 | 23.2 | 61.8 | 1 | 1 | 5.6 |
30824 | 13.2 | 52.1 | 0 | 1 | 2.4 |
31979 | 27.7 | 57.4 | 1 | 1 | 2.7 |
23135 | 7 | 15.2 | 0 | 0 | 13.4 |
18014 | 0 | 38.7 | 1 | 0 | 14.8 |
18541 | 13.8 | 69.4 | 1 | 1 | 10.7 |
16747 | 9.9 | 67.2 | 1 | 0 | 10.3 |
13473 | 6.3 | 47.8 | 0 | 1 | 4.6 |
42986 | 13.4 | 24.5 | 1 | 0 | 3.9 |
23964 | 8.8 | 79.4 | 1 | 0 | 13.3 |
30794 | 0.4 | 12.1 | 1 | 0 | 2.2 |
21104 | 14.7 | 71 | 0 | 1 | 5.7 |
19137 | 7.7 | 28 | 1 | 0 | 11.8 |
26058 | 7.3 | 45.6 | 0 | 1 | 2.5 |
22085 | 6.8 | 25.4 | 0 | 1 | 2.1 |
29044 | 8.6 | 40.6 | 0 | 0 | 4.1 |
24205 | 19.6 | 25.1 | 1 | 1 | 4.9 |
17698 | 10.8 | 42.3 | 1 | 1 | 7.7 |
26399 | 4.5 | 63.3 | 1 | 1 | 6.3 |
40590 | 15.9 | 69.4 | 1 | 1 | 2.9 |
24805 | 5.7 | 17.7 | 1 | 1 | 2.6 |
18899 | 13.1 | 54.8 | 1 | 1 | 6.1 |
26802 | 15.5 | 46.5 | 0 | 1 | 6 |
30034 | 11.8 | 53.2 | 1 | 0 | 6.7 |
15713 | 16.6 | 41.2 | 1 | 0 | 11.9 |
18280 | 6.4 | 65 | 1 | 1 | 9.3 |
41009 | 6.7 | 54.9 | 0 | 1 | 3.6 |
24021 | 14 | 20.6 | 1 | 1 | 2.6 |
21836 | 27.6 | 29 | 0 | 1 | 2.1 |
21157 | 5.5 | 50.2 | 1 | 1 | 9 |
19529 | 14.5 | 56.6 | 1 | 0 | 11 |
31240 | 26.3 | 36.4 | 1 | 1 | 2.9 |
20963 | 0 | 0 | 1 | 1 | 2.2 |
33826 | 8.2 | 87.9 | 0 | 1 | 3.3 |
23349 | 0 | 38.5 | 1 | 1 | 5.9 |
22695 | 25.4 | 47 | 1 | 1 | 4 |
30475 | 0 | 69.3 | 1 | 0 | 10.8 |
16631 | 5.9 | 48.2 | 1 | 1 | 7.1 |
28996 | 18.6 | 29.3 | 1 | 1 | 2.9 |
15807 | 16.9 | 42.9 | 1 | 1 | 6.2 |
15585 | 0 | 59.4 | 1 | 0 | 10.3 |
18466 | 9 | 69.4 | 1 | 0 | 13.5 |
35140 | 21.1 | 37.1 | 1 | 1 | 6.7 |
33459 | 14.1 | 19.5 | 1 | 1 | 2.6 |
24357 | 0 | 21.5 | 1 | 1 | 5.2 |
19370 | 3.7 | 35 | 1 | 1 | 7.2 |
21820 | 6.3 | 0 | 1 | 1 | 3.5 |
23351 | 12.3 | 27.1 | 1 | 1 | 5.4 |
22938 | 6.8 | 68.5 | 1 | 1 | 5.8 |
16477 | 10 | 61.5 | 1 | 1 | 11.7 |
20790 | 28.5 | 59.9 | 1 | 0 | 5.6 |
20352 | 19.4 | 34.6 | 1 | 0 | 4.6 |
19743 | 14.3 | 39.7 | 1 | 0 | 8.6 |
22775 | 10.3 | 35.7 | 1 | 1 | 2.1 |
24229 | 0.9 | 26.7 | 1 | 0 | 9.6 |
41195 | 8.6 | 66.7 | 1 | 0 | 4 |
23143 | 4.2 | 63.1 | 0 | 1 | 10.6 |
13400 | 28.1 | 46.7 | 0 | 0 | 5.8 |
21371 | 14.9 | 78.9 | 1 | 0 | 7.4 |
28675 | 7.7 | 63.4 | 0 | 0 | 10.3 |
18171 | 6.9 | 47.9 | 0 | 1 | 6.3 |
23670 | 20.5 | 46.3 | 1 | 1 | 6.7 |
29745 | 6.1 | 53.9 | 1 | 0 | 6.7 |
14672 | 13.9 | 46 | 1 | 0 | 13.3 |
20382 | 0 | 38.6 | 1 | 1 | 4.1 |
24952 | 14.6 | 53.8 | 0 | 1 | 4.6 |
28878 | 7.4 | 12.2 | 1 | 1 | 2.7 |
24558 | 24.5 | 37 | 1 | 1 | 8 |
20447 | 0.9 | 27.4 | 1 | 1 | 4.2 |
27714 | 8.7 | 58.1 | 0 | 0 | 9 |
18116 | 3.5 | 47.5 | 1 | 1 | 7.7 |
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 1 images
- How I can do a financial hardship, the Nm Shoe Company feels they only need to make one size of shoes, regardless of gender or height. They have collected data on gender, shoe size, and height and have asked you to tell them if they can change their business model to include only one size of shoes—regardless of height or gender of the wearer. In no more than 5–10 pages (including figures), explain your recommendations, using statistical evidence to support your findings. The data found are given in the following table. I need help with this Shoe Size Height Gender 5.00 63.00 Female 7.50 70.00 Female 9.00 70.00 Female 7.00 64.00 Male 11.00 72.00 Male 12.00 72.00 Male 14.00 76.00 Male 7.00 66.00 Female 7.50 71.00 Female 8.00 68.00 Female 10.50 71.00 Male 11.00 71.00 Male 6.50 65.00 Female 7.00 67.00 Female 7.50 70.00 Female 10.00 69.00 Male 12.00…arrow_forwardWhat are the characteristics of a research question? How important is the research question to planning a study?arrow_forwardProfitability remains a challenge for banks and thrifts with less than $2 billion of assets. The business problem facing a bank analyst relates to the factors that affect return on assets (ROA), an indicator of how profitable a company is relative to its total assets. Data collected from a sample of 73 community banks include the ROA (%), the efficiency ratio (%), as a measure of bank productivity (the lower the efficiency ratio, the better), and total risk-based capital (%), as a measure of capital adequacy. Use the accompanying multiple linear regression results to complete parts (a) and (b) below. Variable Coefficient Standard Error 0.30408 0.00539 -0.24116 0.01953 0.04922 0.01517 Intercept Efficiency Ratio, X₁ Risk-Based Capital, X₂ t Statistic - 0.79 3.62 3.24 (Round to four decimal places as needed.) p-value 0.4304 0.0005 0.0018 C a. Construct a 95% confidence interval estimate of the population slope between ROA and efficiency ratio.arrow_forward
- Profitability remains a challenge for banks and thrifts with less than $2 billion of assets. The business problem facing a bank analyst relates to the factors that affect return on assets (ROA), an indicator of how profitable a company is relative to its total assets. Data collected from a sample of 20 community banks include the ROA (%), the efficiency ratio (%), as a measure of bank productivity (the lower the efficiency ratio, the better), and total risk-based capital (%), as a measure of capital adequacy. Complete parts (a) through (g) below. Click the icon to view the data table. a. State the multiple regression equation. Let X₁, represent the efficiency ratio (%) and let X₂; represent the total risk-based capital (%). Ý TO DX DX = + + (Round the constant to two decimal places as needed. Round the coefficients to four decimal places as needed.) Distribution Costs ROA (%) 1.13 1.22 0.82 1.15 0.81 1.23 0.67 1.35 0.95 0.71 0.69 1.10 0.87 1.02 0.86 1.74 1.02 1.76 0.90 0.68 Efficiency…arrow_forwardThe data used is from college campuses. The variables used in the analysis below include: crime, total campus crime; enroll, total enrollment; police, employed officers. Use the estimated OLS models to answer the questions below: Model A: In(crime) = -6.631 + 1.270ln(enroll), (1.034) (.110) n = 97; R² = .5804 Model B: In(crime) = -4.794 + .923ln(enroll) (.144) (1.112) n = 97; R² = .632 +.516ln(police), (.149) Using Model A, test the null hypothesis that elasticity of crime with respect to enrollment is unit elastic, i.e. equal to one (against a two-sided alternative). Calculate the t-statistic.arrow_forwardProfitability remains a challenge for banks and thrifts with less than $2 billion of assets. The business problem facing a bank analyst relates to the factors that affect return on assets (ROA), an indicator of how profitable a company is relative to its total assets. Data collected from a sample of 20 community banks include the ROA (%), the efficiency ratio (%), as a measure of bank productivity (the lower the efficiency ratio, the better), and total risk-based capital (%), as a measure of capital adequacy. Complete parts (a) through (g) below. Click the icon to view the data table. a. State the multiple regression equation. Let X₁¡ represent the efficiency ratio (%) and let X₂¡ represent the total risk-based capital (%). Ŷ₁=+X₁₁+Xzi (Round the constant to two decimal places as needed. Round the coefficients to four decimal places as needed.) Distribution Costs ROA (%) 1.04 0.77 0.14 1.44 0.90 1.16 1.07 1.58 1.45 1.15 1.17 3.40 0.86 0.66 0.81 1.14 0.83 0.86 1.14 1.04 TOlal Efficiency…arrow_forward
- Discuss the three types of longitudinal research methods. When is each method an appropriate choice of data collection? Discuss the difficulties of each method.arrow_forwardYou have the following two data points for a process undergoing learning: Y3 = 50 and Y7 = 35 What is the best equation to use for prediction? Group of answer choices Yx = 84.2 x-0.2324 Yx = 77.6 x-0.5323 Yx = 79.4 x-0.4210 Yx = 80.7 x-0.3365 insufficient informationarrow_forwardBody Fat. Where we considered the regression of percentage of body fat on nine body measurements: height, weight, hip, forearm, neck, wrist, triceps, scapula, and sup. Describe and discuss problems that could have arisen in the collection of the data for this regression analysis.arrow_forward
- Difference of Two Proportions Problem. Significance magazine had an article looking at the impact on the outcome of a soccer game when a player gets a Red Card. The Red Card is given to a player who commits a serious foul and that player is removed from the game. This leaves the team with a player short. The data shows the relative performance of home and away teams with red cards, English Premier League (EPL), seasons 2011 to 2021. The table shows the outcomes of the team receiving a Red Card as Win, Draw (a tie), or Lose by whether the match is Home or Away for the Red Card Team. • We will focus on the proportion with a Draw for Home and Away games • The expectation is that a Red Card team that is away will work harder for a draw. Express the difference as Away - Home. • We will do a one-tailed test. • Use an alpha level of .05 unless otherwise instructed. Location Home Away Result After Red Card Won 47 40 Total 87 Draw 37 66 103 Lost 100 153 253 Total 184 259 443 What is the Bound…arrow_forward5. The overnight shipping business has skyrocketed in the last ten years. The single greatest predictor of a company's success is customer service. A study was conducted to determine the customer satisfaction levels for one overnight shipping business. In addition to the customer's satisfaction level, the customers were asked how often they used overnight shipping. The results are shown below in the following table: Satisfaction level Frequency of Use 5 per month TOTAL High 250 Low Medium TOTAL 400 140 10 5. 5. 55 200 140 100 25 70 20 700 220 460 A customer is chosen at random. Given that the customer uses the company two to five times per month, what is the probability that the customer expressed medium satisfaction with the company?arrow_forwardDo you think the results of the study might be applicable to the whole population? Why or why not?arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman