Question

In: Statistics and Probability

Employee Number Age Salary Degree Gender 1. 32 $98,000 None Female 2. 35 $121,00 Bachelors Female...

Employee Number Age Salary Degree Gender
1. 32 $98,000 None Female
2. 35 $121,00 Bachelors Female
3. 48 $125,000 Masters Male
4. 40 $141,000 Masters Male
5. 43 $152,000 Masters Male

Visit with a company of your interest Your Task: 1. Collect the following Information a. Age of the employees b. Salary of each employee c. highest degree possible d. Gender of each employee Employee Table of Information Collected form #1 above.

2. Stem-and-Leaf Display for the age of the employee

3. Descriptive statistics for the salary

4. Histogram between degree and Salary

5. What is the probability that employee is female?

6. What is the probability that employee makes above the average salary (Look at the mean in number 2)?

Please post answer in excel spreadsheet as an attachment. Thank you.

Solutions

Expert Solution

1. a) Age of the employees:

Age
32
35
48
40
43

b) Salary of each employee

Salary
$98,000
$121,00
$125,000
$141,000
$152,000

c)  highest degree possible

Degree
None
Bachelors
Masters
Masters
Masters

d) Gender of each employee Employee

Gender
Female
Female
Male
Male
Male

2) Stem and leaf of age of employee

3.Descriptive Statistics for the salary

4. Histogram between degree and Salary

5. The probability that employee is female is 2/5 = 0.4

6. The probability that employee makes above the average salary is 2/5 = 0.4

since the number of employees above average salary (i.e. 127400) is 2


Related Solutions

Person Gender Married Age Children Salary Spent 1 Male Yes 35 1 78900 1610 2 Male...
Person Gender Married Age Children Salary Spent 1 Male Yes 35 1 78900 1610 2 Male Yes 53 1 114100 1960 3 Male Yes 36 2 84800 1470 4 Female Yes 51 2 87500 1210 5 Male Yes 39 2 85600 1320 6 Male Yes 66 3 112800 310 7 Male Yes 48 1 87300 1070 8 Male Yes 36 1 73800 2080 9 Female Yes 47 3 68500 900 10 Male Yes 50 1 110200 1950 11 Male No...
Person Gender Married Age Children Salary Spent 1 Male No 28 1 48600 750 2 Male...
Person Gender Married Age Children Salary Spent 1 Male No 28 1 48600 750 2 Male Yes 35 2 75500 1980 3 Female No 33 2 58900 1820 4 Female Yes 53 1 92200 990 5 Female No 49 1 100700 1990 6 Male Yes 57 1 128900 1900 7 Female Yes 53 1 84900 1000 8 Female No 34 2 62500 2470 9 Male Yes 55 3 142700 2400 10 Male No 33 1 92300 2460 11 Female Yes...
Female Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F...
Female Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F 60 5.5 27 R 3 F 64 7 31 R 4 F 67 7.5 19 R 5 F 65 8 20 R 6 F 66 9 29 R 7 F 62 9.5 30 L 8 F 63 8.5 18 R 9 F 60 5 19 L 10 F 63 7.5 42 R 11 F 61 7 20 R 12 F 64 7.5 17 R...
Student Gender Hours online/week Friends 1 Female 9 100 2 Female 5 60 3 Female 2...
Student Gender Hours online/week Friends 1 Female 9 100 2 Female 5 60 3 Female 2 50 4 female 12 110 5 male 4 50 6 female 2 80 7 male 10 450 8 female 7 90 9 female 2 30 10 female 4 150 11 female 12 380 12 male 7 120 13 female 6 80 14 male 3 200 15 male 8 430 16 female 7 170 17 male 4 90 18 female 6 240 19 female 4...
Age: 39 years Gender: Female Diagnosis: DVT with Arrythmia Rx Warfarin Tab 1 mg , one...
Age: 39 years Gender: Female Diagnosis: DVT with Arrythmia Rx Warfarin Tab 1 mg , one od Warfarin Tab 5 mg , 1.5 tab od Furosemide tabs 40 mg , 1.5 od Aspirin Tab 75 mg, one od Ketoprofen gel prn Amiodaron 200 mg od Note: what are the new anticoagulants? differentiate between them and warfarin? according to this prescription find the mistakes, the interaction, dose for adult and Paediatric , the toxicity level , antidotes , follow up,  the counselling...
Age: 45 year Gender: Male Diagnosis: Angina.P. Rx Trimetazidine tablets 35 mg MR , 1 bid...
Age: 45 year Gender: Male Diagnosis: Angina.P. Rx Trimetazidine tablets 35 mg MR , 1 bid Atenolol 100 mg , 1/2 tablet od Isoket 10 mg Tid according to this prescription find the mistakes, the interaction, dose for adult and Paediatric , the toxicity level , antidotes , follow up,  the counselling and what the suitable medication for this patient ?
Salary Years Age MBA? 35600 7.3 33 0 71100 24.1 61 0 42300 8.6 35 1...
Salary Years Age MBA? 35600 7.3 33 0 71100 24.1 61 0 42300 8.6 35 1 51200 11.5 43 1 41300 13.8 40 0 64900 18.1 55 0 54600 16.9 49 0 43800 9.4 37 1 46600 12.2 48 1 50100 16 50 0 32800 4.2 28 1 49300 11.5 49 0 38100 7.3 35 1 53500 14.4 52 1 46000 10.8 45 0 The data in the above table give the annual salary (Salary), number of years of employment...
Age: 63 years Diagnosis: asthma Gender: female Rx Symbicort Turbohaler 160/4.5 mcg 1 puff bid for...
Age: 63 years Diagnosis: asthma Gender: female Rx Symbicort Turbohaler 160/4.5 mcg 1 puff bid for 90 days Beclomethasone MDI 2 puff PRN for 90 days Theophylline 1 tabs bid for 90 days Co-codaprin for back pain 1 tabs prn for 5 days discuss this prescription and why give the patient this medication and what the recommendation for the patient?
1.Create a fictitious child with a name, an age during early childhood, and a gender. 2.Describe...
1.Create a fictitious child with a name, an age during early childhood, and a gender. 2.Describe one component of the fictional child’s physical development. 3.Explain one component of the fictitious child’s cognitive development using Piaget’s theory of cognitive development. 4.Explain one component of the fictitious child’s cognitive development using the information-processing approach to cognitive development. 5.Describe one environmental factor that affects the fictitious child’s physical development or cognitive development.
1.Create a fictitious child with a name, an age during early childhood, and a gender. 2.Describe...
1.Create a fictitious child with a name, an age during early childhood, and a gender. 2.Describe one component of the fictional child’s physical development. 3.Explain one component of the fictitious child’s cognitive development using Piaget’s theory of cognitive development. 4.Explain one component of the fictitious child’s cognitive development using the information-processing approach to cognitive development. 5.Describe one environmental factor that affects the fictitious child’s physical development or cognitive development.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT