0% found this document useful (0 votes)
8 views16 pages

Statistical Analysis of Employee Salaries

The document outlines various statistical tasks involving frequency distributions, calculations of means, medians, and percentages based on different datasets, including employee salaries, patient complaints, insurance commissions, student grades, and performance evaluations. It includes specific questions and solutions related to these datasets, such as determining class limits, frequencies, and average values. Additionally, it emphasizes the interpretation of statistical results in a practical context.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views16 pages

Statistical Analysis of Employee Salaries

The document outlines various statistical tasks involving frequency distributions, calculations of means, medians, and percentages based on different datasets, including employee salaries, patient complaints, insurance commissions, student grades, and performance evaluations. It includes specific questions and solutions related to these datasets, such as determining class limits, frequencies, and average values. Additionally, it emphasizes the interpretation of statistical results in a practical context.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DUTY OF STATISTICS

1.- The following table shows a frequency distribution of salaries


weekly data of 65 employees from company P&R. Determine the following from this table:
a) The lower limit of the sixth class.
b) The upper limit of the fourth class.
c) The class mark (or midpoint) of the third class.
d) The class boundaries of the fifth interval.
e) The width of the fifth class interval.
f) The frequency of the third class.
g) The relative frequency of the third class.
h) The class interval with the highest frequency, which is called the class interval
Its frequency is the modal class frequency.
The percentage of employees earning less than $280.00 a week.
j) The percentage of employees who earn less than $300.00 but at least $260.00 for
week Table
Salarios ($) Number of employees
250,00-259,99 8
260,00-269,99 10
270.00-279.99 16
280.00-289.99 14
290.00-299.99 10
300.00-309.99 5
310.00-319.99 2
Total 65

2.- The following table shows the number of claims and complaints filed by
patients in the emergency service over the course of a week. Calculate and interpret
the medium.

Day/Week Monday Tuesday Wednesday Thursday Friday Saturday


Claims /day 16 15 8 21 3 12

3.- A company that markets Medical Insurance has 3 representatives


for the Miraflores area, each of which charges a different commission per policy
sold, and makes a different number of contracts. Calculate and interpret the average value
from the commission.
Seller Policy number of Commission on sales
insurance Wi $ XI
Peter 40 28
Juan 32 36
Pablo 12 44
4.- The final grades in Thermal Engines of the students appear in
attached table.
36 71 84 74 77 81 55 86 100 53 73 85
76 80 83 65 89 93 44 72 82 74 78 84
55 87 99 51 76 85 73 79 82 63 88 98
46 72 82 74 78 85 55 87 92 54 77 86
73 80 83 66 90 62 46 72 82 74 79 85
56 87 85 52 73 85 76 80 83 64 88 85
54 73 86 77 80 84 70 92 48 87 79 79
72 82 76
the highest grade
The lowest
•c) The range, the class number, the width
The five highest
The five lowest
The tenth from highest to lowest
The number of students with a grade of 65 or higher
•h) Same below 65
The percentage of students with grades higher than 45 but not exceeding
a 75
The grades that do not appear
The frequencies
•l) The relative frequencies
Relative percentage frequency %
Average Value of Classes
•ñ) Graph separately with the frequencies a histogram and a polygon of
frequencies.
INPUT TABLE

Classes or
Intervals
(30 - 40)
(40 - 50)
(50 - 60)
(60 - 70)
(70 – 80)
(80 - 90)
(90 - 100)
5.- The following frequency distribution represents the scores obtained in a
performance evaluation, applied to the technical staff of a Health Center. The
The maximum score on the test is 62. Calculate and interpret the mean.

Performance Number of
(Points) technicians
12 - 16 6
17 - 21 10
22 - 26 14
27 - 31 12
32 - 36 20
TOTAL 62

6.- The following table shows the increase rate in complaints during the last
months. Calculate and interpret the average monthly rate.

Months January February March April May


Increase of 4.6% 8.4% 6.8% 0.5% 2.4%
complaints
7.- Determine the percentages (a), (b), and (c) of the students of the
School of Naval Mechanics according to the proposed table

  
(a)X MD,(c)X 3MD,(b)X 2MD,


f X X

Altura (In) 
XX X  67.45 Frequency
(f)
Brand of
class (x)
60 - 62 61 6.45 5 32.25
63 - 65 64 3.45 18 62.10
66 - 68 67 0.45 42 18.90
69 - 71 70 2.55 27 68.85
72 - 74 73 5.55 8 
f X X 226.5

44.40
N=∑f=
100
8.- Find the mean deviation of the sets of numbers

(a) 12, 6, 7, 3, 15, 18,10, 5 y (b) 9, 3, 8, 8, 9, 8,9, 18

9.- Determine from the presented table, the mean, median and
fashion

Frequency table reported by a group of 40 students regarding the


height.

INTERVAL (HEIGHT) MIDPOINT FREQUENCY (STUDENTS)


1.60 – 1.64 1.625 1
1.65 – 1.69 1.675 3
1.70 – 1.74 1.725 4
1.75 – 1.79 1.775 6
1.80 – 1.84 1.825 9
1.85 - 1.89 1.875 14
1.90 – 1.94 1.925 3
40

RESOLVED STATISTICS ASSIGNMENT


1.- The following table shows a frequency distribution of salaries
weekly data of 65 employees of company P&R. determine the following from this table:
a) The lower limit of the sixth class.
b) The upper limit of the fourth class.
c) The class mark (or midpoint) of the third class.
d) The class boundaries of the fifth interval.
e) The width of the fifth class interval.
f) The frequency of the third class.
g) The relative frequency of the third class.
h) The class interval with maximum frequency is called the class interval.
Its frequency is the modal class frequency.
i) The percentage of employees earning less than $280.00 per week.
j) The percentage of employees who earn less than $300.00 but at least $260.00 for
week Table
Salarios ($) Number of employees
250,00-259,99 8
260.00-269.99 10
270,00-279,99 16
280.00-289.99 14
290,00-299,99 10
300.00-309.99 5
310.00-319.99 2
Total 65
Solution

$300.00

$289.99.

c) The class mark (or midpoint) of the third class The class boundaries of
fifth interval = ½($270.00 + $279.99) = $274.99 ≈ $275.00.
d) The lower boundary of the fifth class = ½($290.00 + $289.99) =
$289.995. la superior = ½($299.99 + $300.00) = $299.995. La Inferior

e) The width of the fifth class interval is = upper boundary of the fifth class -
lower boundary of the fifth class = $299,995 - $289,985 = $10,00. In this case,
All class intervals are of the same width: $10

f) The frequency of the third class is 16.

g) 16/65 = 0.246 x 100 = 24.6%

h) $270.00 - $279.99

i) Number of employees earning less than $280 per week = 16 + 10 + 8 = 34.


Percentage of employees earning less than $280 per week = 34/65 = 52.3%
j) Number of employees who earn less than $300 but at least $260 per week =
10 + 14 + 16 + 10 = 50. Percentage of employees earning less than $300 but
less $260 per week = 50/65 = 76.9%

2.- The following table shows the number of complaints and grievances submitted by
patients in the emergency service over the course of a week. Calculate and interpret
the average.

Day/Week Monday Tuesday Wednesday Thursday Friday Saturday


Claims / day 16 15 8 21 3 12

Solution:

Arithmetic mean
= 6 6

x
12.5 complaints

b) Interpretation: If you randomly choose a day of the week, it is expected that the patients of the
Emergency service received 12.5 complaints that day.

3.- A company that markets Medical Insurance has 3 representatives.


for the Miraflores area, each of which charges a different commission per policy
sold, and carries out different numbers of contracts. Calculate and interpret the mean value
of the commission.
Seller Policy number of Commission for sales
insurance WI $ XI
Peter 40 28
Juan 32 36
Pablo 12 44
40(28) 32(36) 12(44) 2800
x 33.33
40 32 12 84

Interpretation:

If a representative is chosen at random, they are expected to charge a commission of $33.33 per policy.
sold.

4.- The final grades in Thermal Engines of the students are listed in
attached table.
36 71 84 74 77 81 55 86 100 53 73 85
76 80 83 65 89 93 44 72 82 74 78 84
55 87 99 51 76 85 73 79 82 63 88 98
46 72 82 74 78 85 55 87 92 54 77 86
73 80 83 66 90 62 46 72 82 74 79 85
56 87 85 52 73 85 76 80 83 64 88 85
54 73 86 77 80 84 70 92 48 87 79 79
72 82 76
The highest rating
the lowest
•c) The range, the class number, the width
The five highest
The five lowest
The tenth from highest to lowest
The number of students with a grade of 65 or higher
•h) Same below 65
The percentage of students with grades greater than 45 but not exceeding
a 75
The grades that do not appear
•k) The frequencies
•l) The relative frequencies
Relative percentage frequency %
Average Value of Classes
•ñ) Graph separately with the frequencies a histogram and a polygon of
frequencies.
TABLA DE ENTRADA
Classes or
Intervals
(30 - 40)
(40 - 50)
(50 - 60)
(60 - 70)
(70 – 80)
(80 - 90)
(91 – 100)

SOL:

3644 46 46 48 51 52 53 54 54 55 55 55 56 62 63 64 65 66 70 71 72 72 72
72 73 73 73 73 73 74 74 74 74 76 76 76 76 77 77 77 78 78 79 79 79 79 80
80 80 80 81 82 82 82 82 82 83 83 83 84 84 84 85 85 85 85 85 85 85 86 86 86
87 87 87 87 88 88 89 90 92 92 93 98 99 100=87

Classes or
Intervals
(30 - 40) 0 1 2 3 … 3536 =137 38 39 40
(40 - 50) 41 42 43444646 48 =44547 49 50
(50 - 60) 51 52 53 54 54 55 55 55 56 = 957 58 59 60
(60 - 70) 6162 63 64 65 6667 68 69 70 = 6
(70 - 80) 71 72 72 72 72 73 73 73 73 73 74 74 74747576 76 76 76 77 77
77 78 78 79 79 79 79 80 80 80 80 =31
(80 - 90) 81 82 82 82 82 82 83 83 83 84 84 84 85 85 85 85 85 85 85 86 86
86 87 87 87 878888 89 90 =30
(90 – 100) 9192 92 9394 95 96 97 98 99 100 = 6

a) The highest score 100


•b) The lowest 36
The range, the class number the width 100 - 36 = 64
The five highest 92 93 98 99 100
The five lowest 36 44 46 46 48
The tenth from highest to lowest88
The number of students with a grade of 65 or higher70
•h) Same below 6517
The percentage of students with grades higher than45 but not higher
75 is to 32/ 87 = 36.8%
The grades that do not appear0 1 2 3 ….., 3537 38 39 40 41 42 43
45 47 49 50 57 58 59 60 61 67 68 69 75 91 94 95 96 y 97
•k) The frequencies
Relative frequencies
Relative percentage frequency %
• n) Average Value of Classes

Classes or Frequencies Frequencies Frequencies Average Value


Intervals k) relativesl) relative % of classes n)
m)
(30 - 40) 1 0.011 1.1 35
(40 - 50) 4 0.046 4.6 45
(50 - 60) 9 0.103 10.3 55
(60 - 70) 6 0.069 6.9 65
(70 - 80) 31 0.356 35.6 75
(80 - 90) 30 0.345 34.5 85
(90 – 100) 6 0.069 6.9 95
87 0.999 99.9

•ñ) Graph separately with the frequencies a histogram and a polygon of


frequencies.

Frequencies k)
Frequencies k)

31 30

9
4 6 6
1
(30 - 40) (40 – 50) (50 - 60) (60 – 70) (70 – 80) (80 - 90) (90 – 100)
Frequencies k)
Frequencies k)

31 30

9
6 6
4
1
(30 - 40) (40 – 50) (50 - 60) (60 – 70) (70 – 80) (80 - 90) (90 – 100)

5.- The following frequency distribution represents the scores obtained in a


performance evaluation, applied to the technical staff of a Health Center. The
The maximum score on the test is 62. Calculate and interpret the average.

Performance Number of
Points technicians
12 - 16 6
17 - 21 10
22 - 26 14
27 - 31 12
32 - 36 20
TOTAL 62

Solution:

First, the class marks will be calculated (Xithat is, the intermediate value of each class

Class Class Mark (XI) Absolute Frequency (fI)


12 - 16 14 6
17 - 21 19 10
22 - 26 24 14
27 - 31 29 12
32 - 36 34 20
TOTAL 62

14(6) 19(10) 24(14) 29(12) 34(20) 1638


x 26,42
6  10 14 12 20 62

Interpretation: If a technical worker from this hospital is chosen at random, it is expected that
he/she has a score of 26.42 in their performance evaluation.

6.- The following table shows the rate of increase in complaints over the last
months. Calculate and interpret the average monthly rate.

Months January February March April May


Increase of 4.6% 8.4% 6.8% 0.5% 2.4%
complaints

The rate of 4.6% can also be expressed as 0.046, and since it refers to an increase
Based on a base of 100%, the variation factor will be 1.046. For the other data, it is operated.
same.

xg nx1 x2 , x3,......x
Solution:

Therefore, the geometric mean is calculated:

xg 5(1.046)(10084)(1.068)(1.050)(1.024)

5
xg 1.302031452 1.0542031452
(x g 1)x100 (1.054203115 1)x100 5.42%
Average Rate of
Variation:

Interpretation:

If a month is randomly selected between January and May, it is expected that sales will have
increased by 5.42% compared to the previous month.

7.- Determine the percentages (a), (b), and (c) of the students of the
Naval Mechanics Faculty according to the proposed table

  
(a)X MD,(c)X 3MD,(b)X 2MD


f X X

Height (In) 
XX X 67.45 Frequency
(f)
Brand of
class (x)
60 - 62 61 6.45 5 32.25
63 - 65 64 3.45 18 62.10
66 - 68 67 0.45 42 18.90
69 - 71 70 2.55 27 68.85
72 - 74 73 5.55 8 
f X X 226.5

44.40
N=∑f=
100


(a)X MD,
= 67.45 + 2.62 = 69.71 (27) 69.71 - 68.5 Border range

67.45 - 2.62 = 65.19 (18) 65.19 - 65.5 Border range

65.5−65,19 69,71−68.5
42 + 3 (18) + 3 (27) = 42 + 1.86 + 10.89 = 54.75

that is 55% of the total


(b)X 2MD

= 67.45 + 2(2.62) = 71.97 (8) 71.97 - 71.5 Border range

=67,45 – 2(2,26) = 62,93 (18) 62.93 - 62.5 Border range

62.93−62.5 71.97−71.5
18 3 (18) + 42 + 27 + 3 85.67% bone


(c)X 3MD
of the total

= 67,45 + 3(2,62) = 74,23 (8) 74.23 - 74.5 Border range

= 67,45 – 3(2,26) = 60,67 (5) 60.67 - 59.5 Border range

60.67−60,5 74.5−74.23
5- 3 (5) + 18 42 + 27 + 3 (8) = 90, which is 91% of

total

2.- Find the mean deviation of the sets of numbers

(a) 12, 6, 7, 3, 15, 18,10, 5 y (b) 9, 3, 8, 8, 9, 8,9, 18



12 6 7 3  15 10 18 5 76
X 8 8
9.5
Sol.
a) The arithmetic mean is:

__
X X
12 9.5 6 9.5 7  9.5 3  9.5 15 9.5 10 9.5 18 9.5 5  9.5
MD
N 8

The mean deviation is:

2.5 3.5 2.5 6.5 5.5 0.5 8.5 4.5 34


MD 4.25
8 8


9  3  8  8  9  8  9 18 18
X 8 8
9.5

b)

__
X X
9 9 3  9 8  9 8  9 9 9 8  9 9 9 18 9
MD
N 8

0 6 1  1  0 1  0 9 18
MD 2.25
8 8

The mean deviation indicates that set (b) has less dispersion than the
(a), as was to be expected.

9.- Determine from the presented table the mean, median, and
fashion
Frequency table reported by a group of 40 students regarding the
height.

INTERVAL (HEIGHT) MIDPOINT FREQUENCY (STUDENTS)


1.60 - 1.64 1.625 1
1.65 - 1.69 1.675 3
1.70 - 1.74 1.725 4
1.75 - 1.79 1.775 6
1.80 – 1.84 1.825 9
1.85 – 1.89 1.875 14
1.90 – 1.94 1.925 3
40

Solution:

Mode: It is between 1.85 and 1.89, and appears in 14 students.

Median: The median is between the data 19 and 20, between 1.80 and 1.84.

Media: The following procedure is followed: It is the same as the multiplication of the point.
mean and the frequency of each of the intervals, then they are summed up.
results of the multiplication in each interval, at the end the result is divided
between the amount of data or number of students = 1.81625.

INTERVAL POINT FREQUENCY (PM)*FREQUENCY


(HEIGHT) MEDIUM (STUDENTS CIA
1.60 – 1.64 1.625 1 1.625
1.65 - 1.69 1.675 3 5.025
1.70 - 1.74 1.725 4 6.9
1.75 - 1.79 1.775 6 10.65
1.80 - 1.84 1.825 9 16.425
1.85 – 1.89 1.875 14 26.25
1.90 - 1.94 1.925 3 5.775
40 72.65 SUM
Average 1.81625 SUM/ 40

You might also like