(Y) (X)
Ventas Publicidad YC YC B1K + K2 A
16,523.00 3,500.00 7,121.54 7,121.54142 9,401.46 B
6,305.00 10,073.00 10,690.57 10,690.57466 - 4,385.57
1,769.00 11,825.00 11,641.88 11,641.88247 - 9,872.88
30,570.00 33,550.00 23,438.21 23,438.20791 7,131.79
7,698.00 37,200.00 25,420.10 25,420.09918 - 17,722.10
9,554.00 55,400.00 35,302.41 35,302.40633 - 25,748.41
54,154.00 55,565.00 35,392.00 35,391.99868 18,762.00
54,450.00 66,501.00 41,330.07 41,330.07071 13,119.93
47,800.00 71,000.00 43,772.96 43,772.95532 4,027.04
74,598.00 82,107.00 49,803.88 49,803.87761 24,794.12
25,257.00 83,100.00 50,343.06 50,343.06063 - 25,086.06
80,608.00 90,496.00 54,358.97 54,358.96963 26,249.03
40,800.00 100,000.00 59,519.49 59,519.48870 - 18,719.49
63,200.00 102,100.00 60,659.75 60,659.75491 2,540.25
69,675.00 132,222.00 77,015.52 77,015.51624 - 7,340.52
98,715.00 136,297.00 79,228.18 79,228.17567 19,486.82
75,886.00 139,114.00 80,757.76 80,757.76134 - 4,871.76
83,360.00 165,575.00 95,125.66 95,125.65858 - 11,765.66
N 840,922.00 1,375,625.00 840,922.00 840,922.00 0.00
0.842 COEFICIENTE DE CORRELACIÓN
5.221.1
0.54 0.708 GRADO DE EXPLICACIÓN DE LAS VARIABLES
0.708 POTENCIA
0.708
0.590
0.385
ventas publicidad precio
ventas 1
publicidad 0.841508565742872 1
precio -0.768136283220995 -0.62046462 1
ventas publicidad precio
ventas 1
publicidad 0.708 1
precio 0.590 0.3850 1
Publicidad (X) Ventas (Y) 𝑋^2 𝑌^2 (X) (Y)
3,500.00 16,523.00 12,250,000.00 273,009,529.00 57,830,500.00
10,073.00 6,305.00 101,465,329.00 39,753,025.00 63,510,265.00
11,825.00 1,769.00 139,830,625.00 3,129,361.00 20,918,425.00
33,550.00 30,570.00 1,125,602,500.00 934,524,900.00 1,025,623,500.00
37,200.00 7,698.00 1,383,840,000.00 59,259,204.00 286,365,600.00
55,400.00 9,554.00 3,069,160,000.00 91,278,916.00 529,291,600.00
55,565.00 54,154.00 3,087,469,225.00 2,932,655,716.00 3,009,067,010.00
66,501.00 54,450.00 4,422,383,001.00 2,964,802,500.00 3,620,979,450.00
71,000.00 47,800.00 5,041,000,000.00 2,284,840,000.00 3,393,800,000.00
82,107.00 74,598.00 6,741,559,449.00 5,564,861,604.00 6,125,017,986.00
83,100.00 25,257.00 6,905,610,000.00 637,916,049.00 2,098,856,700.00
90,496.00 80,608.00 8,189,526,016.00 6,497,649,664.00 7,294,701,568.00
100,000.00 40,800.00 10,000,000,000.00 1,664,640,000.00 4,080,000,000.00
102,100.00 63,200.00 10,424,410,000.00 3,994,240,000.00 6,452,720,000.00
132,222.00 69,675.00 17,482,657,284.00 4,854,605,625.00 9,212,567,850.00
136,297.00 98,715.00 18,576,872,209.00 9,744,651,225.00 13,454,558,355.00
139,114.00 75,886.00 19,352,704,996.00 5,758,684,996.00 10,556,805,004.00
165,575.00 83,360.00 27,415,080,625.00 6,948,889,600.00 13,802,332,000.00
1,375,625.00 840,922.00 143,471,421,259.00 55,249,391,914.00 85,084,945,813.00
n= 18
RELACIÓN VENTAS Y PUBLICIDAD
180,000.00
160,000.00
140,000.00 f(x) = 1.30415773594807 x + 15496.1149095043
R² = 0.708136666218626
120,000.00
100,000.00
VENTAS
80,000.00
60,000.00
40,000.00
20,000.00
0.00
0.00 20,000.00 40,000.00 60,000.00 80,000.00 100,000.00 120,000.00
PUBLICIDAD
Resumen
Estadísticas de la regresión
Coeficiente de correlación múltiple 0.842
Coeficiente de determinación R^2 0.7081
R^2 ajustado 0.6899
Error típico 17064.40
Observaciones 18
ANÁLISIS DE VARIANZA
Grados de libertad Suma de cuadrados Promedio de los cuadrados
Regresión 1 11304191921.1408 11304191921.1408
Residuos 16 4659099432.63697 291193714.539811
Total 17 15963291353.7778
Coeficientes Error típico Estadístico t
Intercepción 5221.0977409461 7780.44872582854 0.671053550370919
Publicidad 0.5429839096142 0.08714815502386 6.23058410663418
Análisis de los residuales
Observación Pronóstico Ventas Residuos Residuos estándares
1 7,121.54 9,401.46 0.57
2 10,690.57 - 4,385.57 - 0.26
3 11,641.88 - 9,872.88 - 0.60
4 23,438.21 7,131.79 0.43
5 25,420.10 - 17,722.10 - 1.07
6 35,302.41 - 25,748.41 - 1.56
7 35,392.00 18,762.00 1.13
8 41,330.07 13,119.93 0.79
9 43,772.96 4,027.04 0.24
10 49,803.88 24,794.12 1.50
11 50,343.06 - 25,086.06 - 1.52
12 54,358.97 26,249.03 1.59
13 59,519.49 - 18,719.49 - 1.13
14 60,659.75 2,540.25 0.15
15 77,015.52 - 7,340.52 - 0.44
16 79,228.18 19,486.82 1.18
17 80,757.76 - 4,871.76 - 0.29
18 95,125.66 - 11,765.66 - 0.71
F Valor crítico de F
38.8201783 1.20224383306244E-05
Probabilidad Inferior 95% Superior 95% Inferior 90.0% Superior 90.0%
0.51175849 -11272.7167432571 21714.912225 -8362.6606836 18804.85616547
1.20224E-05 0.358238073961717 0.7277297453 0.39083336834 0.695134450888
Resultados de datos de probabilidad
Percentil Ventas
2.78 1769
8.33 6305
13.89 7698
19.44 9554
25.00 16523
30.56 25257
36.11 30570
41.67 40800
47.22 47800
52.78 54154
58.33 54450
63.89 63200
69.44 69675
75.00 74598
80.56 75886
86.11 80608
91.67 83360
97.22 98715
Publicidad Gráfico de los residuales Gráfico de pro
30,000.00 150000
20,000.00
100000
10,000.00
Ventas
Residuos
- 50000
(10,000.00)0.00 50,000.00 100,000.00 150,000.00 200,000.00
0
(20,000.00) - 20.00 40.0
(30,000.00) M
Publicidad
Publicidad Curva de regresión
ajustada
100,000.00
Ventas
0.00
Ventas
Pronóstico Ventas
Publicidad
Gráfico de probabilidad normal
150000
100000
50000
0
- 20.00 40.00 60.00 80.00 100.00 120.00
Muestra percentil
esión
Ventas
Pronóstico Ventas
Resumen (Resultados de Regresión)
Estadísticas de la regresión
Coeficiente de correlación múltiple 0.84150856574 Grado de Asociación que tiene la variable
Coeficiente de determinación R^2 0.7081
R^2 ajustado 0.6899
Error típico 17,064.40
Observaciones 18
ANÁLISIS DE VARIANZA
Grados de Promedio de los
Suma de cuadrados
libertad cuadrados
Regresión 1 11,304,191,921.14 11,304,191,921.14
Residuos 16 4,659,099,432.64 291,193,714.54
Total 17 15,963,291,353.78
Coeficientes Error típico Estadístico t
Intercepción 5221.10 7780.45 0.67
Publicidad 0.5430 0.0871 6.2306
2.1
1.7
1.4
Valor crítico de
F
F
38.8 0.00 0.9972738333
Probabilidad Inferior 95% Superior 95% Inferior 90.0% Superior 90.0%
0.51 -11272.72 21714.91 -8362.66 18804.86
0.0000 0.3582 0.7277 0.3908 0.6951
Ventas Precio
16,523.00 88.00 ventas publicidad precio
6,305.00 110.00 ventas 1
1,769.00 85.00 publicidad 0.708 1
30,570.00 28.00 precio 0.590 0.3850 1
7,698.00 101.00
9,554.00 71.00
54,154.00 7.00
54,450.00 82.00 RELACIÓN VENTAS Y PRECIOS
47,800.00 62.00 120.00
74,598.00 24.00
100.00
25,257.00 91.00
f(x) = − 0.000857916065528059 x + 94.024471869777
80,608.00 40.00 80.00 R² = 0.590033349600565
40,800.00 45.00
VENTAS
60.00
63,200.00 21.00
69,675.00 40.00 40.00
98,715.00 8.00
75,886.00 63.00 20.00
83,360.00 5.00 0.00
840,922.00 971.00 0.00 20,000.00 40,000.00 60,000.00 80,000.00 100,000.00 120,000.00
PRECIOS
Precio (Y) Ventas (X) 𝑋^2 𝑌^2 (X) (Y)
88.00 16,523.00 7,744.00 273,009,529.00 ###
110.00 6,305.00 12,100.00 39,753,025.00 693,550.00
85.00 1,769.00 7,225.00 3,129,361.00 150,365.00
28.00 30,570.00 784.00 934,524,900.00 855,960.00
101.00 7,698.00 10,201.00 59,259,204.00 777,498.00
71.00 9,554.00 5,041.00 91,278,916.00 678,334.00
7.00 54,154.00 49.00 2,932,655,716.00 379,078.00
82.00 54,450.00 6,724.00 2,964,802,500.00 ###
62.00 47,800.00 3,844.00 2,284,840,000.00 ###
24.00 74,598.00 576.00 5,564,861,604.00 ###
91.00 25,257.00 8,281.00 637,916,049.00 ###
40.00 80,608.00 1,600.00 6,497,649,664.00 ###
45.00 40,800.00 2,025.00 1,664,640,000.00 ###
21.00 63,200.00 441.00 3,994,240,000.00 ###
40.00 69,675.00 1,600.00 4,854,605,625.00 ###
8.00 98,715.00 64.00 9,744,651,225.00 789,720.00
63.00 75,886.00 3,969.00 5,758,684,996.00 ###
00,000.00 120,000.00 5.00 83,360.00 25.00 6,948,889,600.00 416,800.00
971.00 840,922.00 72,293.00 55,249,391,914.00 ###
Resumen (Resultados de Regresión)
Estadísticas de la regresión
Coeficiente de correlación múltiple 0.7681
Coeficiente de determinación R^2 0.5900
R^2 ajustado 0.5644
Error típico 20,224.39
Observaciones 18
ANÁLISIS DE VARIANZA
Grados de Promedio de los
Suma de cuadrados F
libertad cuadrados
Regresión 1 9,418,874,268.12 9,418,874,268.12 23.03
Residuos 16 6,544,417,085.66 409,026,067.85
Total 17 15,963,291,353.78
Coeficientes Error típico Estadístico t Probabilidad
Intercepción 83818.27962269 9082.79733086238 9.22824506255197 8.29705E-08
Precio -687.751836466 143.320314504991 -4.7987044882043 0.00019685
Valor crítico de
F
0.00 0.98896924
Inferior 95% Superior 95% Inferior 90.0% Superior 90.0%
64563.609429 103072.95 67960.7720278 99675.78721757
-991.57733067 -383.926342 -937.97243404 -437.531238893
