Puestos Valoración
Aprendiz 1
Obrero I 2
Mensajero 3
Archivista 4
Chart Title
Recepcionista
6,000.00 5
5,000.00
Auxiliar de Caja 6
4,000.00
Operario de Máquina 7
3,000.00
Transcriptor de Datos 8
2,000.00
Mecanógrafo
1,000.00 9
Auxiliar Contable
0.00 10
0 2 4 6 8 10 12 14
Secretaria 11
Column C Column E
Asistente Administrativo 12
coeficiente de correlacion
x y
1 2,200.00
2 2,350.00
3 2,950.00
4 2,600.00
5 3,100.00
6 3,000.00
7 3,700.00
8 3,400.00
9 4,000.00
10 4,500.00
11 4,750.00
12 5,100.00
78 41,650.00
y a
2,200.00 1812.94
2,350.00 1812.94
2,950.00 1812.94
2,600.00 1812.94
3,100.00 1812.94
3,000.00 1812.94
3,700.00 1812.94
3,400.00 1812.94
4,000.00 1812.94
4,500.00 1812.94
4,750.00 1812.94
5,100.00 1812.94
Y‘ (sueldo
Y (sueldo actual)
estimado)
Salarios
2,200.00
2,350.00
2,950.00
itle 2,600.00
3,100.00 Chart Title
6,000.00
3,000.00
5,000.00
3,700.00
4,000.00
3,400.00
3,000.00
4,000.00
2,000.00
4,500.00
8 10 12 14
1,000.00
4,750.00
olumn E
0.00
5,100.00 0 2 4 6 8 10
X² Y² X*Y
1 4840000 2200
4 5522500 4700
9 8702500 8850
16 6760000 10400
25 9610000 15500
36 9000000 18000
49 13690000 25900
64 11560000 27200
81 16000000 36000
100 20250000 45000
121 22562500 52250
144 26010000 61200
650 154507500 307200
1734722500
144560208.33
83166720000
9947291.6667
2206630.7132
b x y prima error
255.06 1 2068 132.00
255.06 2 2323.06 26.94
255.06 3 2578.12 371.88
255.06 4 2833.18 -233.18
255.06 5 3088.24 11.76
255.06 6 3343.3 -343.30
255.06 7 3598.36 101.64
255.06 8 3853.42 -453.42
255.06 9 4108.48 -108.48
255.06 10 4363.54 136.46
255.06 11 4618.6 131.40
255.06 12 4873.66 226.34
0
error individual
le
8 10 12 14
x y x2
100 10485 10000 11066.5 Bs.S11,067 -Bs.S582
150 11900 22500 11591 Bs.S11,591 Bs.S309
200 12500 40000 12115.5 Bs.S12,116 Bs.S385
250 12800 62500 12640 Bs.S12,640 Bs.S160
300 13200 90000 13164.5 Bs.S13,165 Bs.S36
350 13600 122500 13689 Bs.S13,689 -Bs.S89
400 14000 160000 14213.5 Bs.S14,214 -Bs.S214
1750 88485 507500 Bs.S5
