pronosticos

Pronostico de ventas

1) Análisis de la matriz de correlación
Y= Ventas totales acreditadas al vendedor
Tabla hoja 3
X1 X2 X3 X4 X5 X6 X7 X8 X9
3669.880 30 74065.1 4582.90 2.51 74.86 15.050.2000 3.600
3473.950 62 58117.3 5539.80 5.51 107.32 19.97 0.2000 3.500
2295.100 60 21118.5 2950.40 10.91 96.75 17.34 0.0092 3.100
4675.560 240 68521.3 2243.10 8.27 195.12 13.4 0.1882 4.400
6125.960150 57805.1 7747.10 9.15 180.44 17.64 0.2973 4.552
2134.940 80 37806.9 402.40 5.51 104.88 16.22 -0.0028 3.380
5031.660 270 50935.3 3140.60 8.54 256.1 18.8 0.3000 3.800
3367.450 70 35602.1 2086.207.07 126.83 19.86 0.0899 3.742
6519.450 180 46176.8 8846.20 12.54 203.25 17.42 0.3269 4.667
4876.370 90 42053.2 5673.10 8.85 119.51 21.41 0.2033 4.185
2468.270 95 36829.7 2761.80 5.38 116.26 16.320.0223 3.478
2533.310 100 33612.7 1991.80 5.43 142.28 14.51 0.2500 3.497
2408.110 60 21412.8 1971.50 8.48 89.43 19.35 0.0177 3.460
2337.380 30 20416.9 1737.40 7.8 84.55 20.02 0.0124 3.100
4586.950100 36272 10694.20 10.34 119.51 15.26 0.3000 4.100
2729.240 80 23093.3 8618.60 5.15 80.49 15.87 0.0419 3.555
3289.400 120 26878.6 7747.90 6.64 136.58 7.81 0.0840 3.719
2800.780 24 39572 4565.80 5.4578.86 16 0.0473 3.576
3264.200 140 51866.1 6022.70 6.31 136.58 17.44 0.0821 3.712
3453.620 140 58749.8 3721.10 6.35 138.21 17.98 0.0963 3.767
1741.450 20 23990.8 861.00 7.37 75.61 20.99 -0.03243.265
2035.750 58 25694.9 3571.50 8.39 102.44 21.66 -0.0103 3.351
1578.000 30 23736.3 2845.50 5.15 76.42 21.46 -0.0447 3.600
4167.440 95 34314.3 5060.10 12.88 136.58 24.78 0.1500 4.500
2799.970 3822809.5 3552.00 9.14 88.62 24.96 0.0472 3.575

Pregunta de investigación: ¿Cuáles son las variables críticas que determinan las ventas totales acreditadas al vendedor?

Correlaciones: Velocidad de,Nivel de Pr, Flexibilidad, Imagen de f, ...

YI Ant. vend Pot.mer
Ant. vend 0.689
0.000...