The following is the age distribution of 1000 working employees working in an organization
Age(years) | 20-25 | 25-30 | 30-35 | 35-40 | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
Number of persons | 30 | 160 | 210 | 180 | 145 | 105 | 70 | 60 | 40 |
Due to continuous losses, it is desired to bring down the manpower according the following scheme
1. Retrench the first 15% from the lower age group
2. Absorb the next 45% in the other branches.
3. Make 10% from the highest age group permanently retire, if necessary.
a) Calculate the age limits of the persons retained and those transferred to other departments.
b) Find the average age of those retained and those transferred to other branches
c) Calculate the standard deviation of the employee retained and transferred
d) Compute the coefficient of skewness of the employees retained and transferred
Comment on your result
Age(years) | 20-25 | 25-30 | 30-35 | 35-40 | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
Number of persons | 30 | 160 | 210 | 180 | 145 | 105 | 70 | 60 | 40 |
cumulative | 30 | 190 | 400 | 580 | 725 | 830 | 900 | 960 | 1000 |
we are retrenching, that is, laying off first 15% from the lower age group
thus 150 of the 1000 employee are cut off starting from the lower age group
so the lowest income group is gone.
and we are left with the following
Age(years) | 25-30 | 30-35 | 35-40 | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
Number of persons | 40 | 210 | 180 | 145 | 105 | 70 | 60 | 40 |
the next 45% is transferred
thus 450 of the next employees are transfered which looks like this
Age(years) | 25-30 | 30-35 | 35-40 | 40-45 |
Number of persons | 40 | 210 | 180 | 20 |
and we are left with the following
Age(years) | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
Number of persons | 125 | 105 | 70 | 60 | 40 |
also we are permanently retiring 10% from the highest age group,that is 4 persons, so we are left with
Age(years) | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
Number of persons | 125 | 105 | 70 | 60 | 36 |
a)the transfered employees are
Age(years) | 25-30 | 30-35 | 35-40 | 40-45 |
Number of persons | 40 | 210 | 180 | 20 |
the retained employees are
Age(years) | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
Number of persons | 125 | 105 | 70 | 60 | 36 |
b)for finding the average we calculate the midpoint of every class and we get the following
Age(years) | 20-25 | 25-30 | 30-35 | 35-40 | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 |
mid point | 22.5 | 27.5 | 32.5 | 37.5 | 42.5 | 47.5 | 52.5 | 57.5 | 62.5 |
Thus the average=
therefore average of the transfered employee= 34.5
average of the retained employees=49.68
c)Standard deviation=
, m.p=mid point of class, n=total frequency
therefore standard deviation of retained employees=6.56
standard deviation of transfered employees=3.56
d)skewness=
skewness of retained employee=(49.68-42.5)/6.56 = 1.09
skewness of transfered employee=(34.5-32.5)/3.56= 0.56
we can see that both the data set are positively skewed with retained employee being more positively skewed than transfered employee and transfered employee is quite close to symmetry
The following is the age distribution of 1000 working employees working in an organization Age(years) 20-25...
Be able to give traversals of the entire tree: Pre-Order: 45, 25, 15, 10, 20, 35, 30, 40, 65, 55, 50, 60, 75, 70, 80 (extra 45 removed). In-Order: 10, 15, 20, 25, 30, 35, 40, 45, 50, 55, 60, 65, 70, 75, 80 Post-Order: 10, 20, 15, 30, 40, 35, 25, 50, 60, 55, 70, 80, 75, 65, 45
The following data give the percentage of women working in five companies in the retail and trade industry. The percentage of management jobs held by women in each company is also shown. % Working 6745 73 54 61 % Management 51 2364 4632 (a Develop a scatter diagram for these data with the percentage of women working in the company as the independent variable. 20 20 50 . . 50 20 60 50! 60 50 40 60 50 40 Management...
17)An analyst at a local bank wonders if the age distribution of
customers coming for service at his branch in town is the same as
at the branch located near the mall. He selects 100 transactions at
random from each branch and researches the age information for the
associated customer. Here are the data:
17) An analyst at a local bank wonders if the age distribution of customers coming for service at his branch in town is the same as...
please assist
The following data give the percentage of women working in five companies in the retail and trade industry. The percentage of management jobs held by women in each company is also shown. % Worldng 67 45 73 54 61 % Management 50 206645 34 (a) Develop a scatter diagram for these data with the percentage of women working in the company as the independent variable 70 50 50 50 40+ 40 30 30 20 + 20+ 10+ Management...
Citizen registration and voting varies by age and gender. The following data is based on registration and voting results from the Current Population Survey following the 2012 election. A survey was conducted of adults eligible to vote. The respondents were asked in they registered to vote. The data below are based on a total sample of 760. We will focus on the proportion registered to vote for ages 18 to 24 compared with those 25 to 34. The expectation is...
Multiple Linear Regression
20. The Excel file Concert Sales provides data on sales dollars and
the number of radio, TV, and newspa-per ads promoting the concerts
for a group of cities. Develop simple linear regression models for
predict-ing sales as a function of the number of each type of ad.
Compare these results to a multiple linear regres-sion model using
both independent variables. State each model and explain R-Square,
Significance F, and p-values
from Business Analytics Methods, Models, and Decisions...
Citizen registration and voting varies by age and gender. The following data is based on registration and voting results from the Current Population Survey following the 2012 election. A survey was conducte of adults eligible to vote. The respondents were asked in they registere to vote. The data below are based on a total sample of 760. We will focus on the proportion registered to vote for ages 18 to 24 compared with those 25 to 34. The expectation is...
Using Python Estimate the 5th and the 2nd degree polynomial regressions for this data: Age Salary 25 135000 55 260000 27 105000 35 220000 60 240000 65 265000 45 270000 40 300000 50 265000 30 105000 Please show the coding used.
45 464 Exam 2-Chapter 8- Micro 50) Figure 8-13 (1.67pt 5 10 15 20 25 30 35 40 45 50 55 60 D Refer to Figure 8-13. Suppose the government places a $5 per-unit tax on this good. The loss of producer surplus resulting from this tax is $60. o Type here to search 5 10 15 20 25 30 35 40 45 50 55 60 B Refer to Figure 8-13. Suppose the government places a $5 per-unit tax on...
100- Relative Intensity T 10 15 20 25 30 35 50 55 60 65 70 75 40 45 m/z