Volumen de Costo

A B A*B
produccion total($)
i x y 𝑥_𝑖−𝑥 ̅ 𝑦_𝑖−𝑦 ̅ (𝑥_𝑖−𝑥 ̅ )^2 x2
1 3.3 7.3 -0.28 -3.02 0.8456 0.0784 10.89
2 3.4 10.8 -6.92 0.8 -5.536 47.8864 11.56
3 3.4 13.1 -6.6 0.2836 -1.87176 43.56 11.56
4 3.5 10.4 -9.3164 10.4 -96.89056 86.795309 12.25
5 3.6 5.8 3.6 5.8 20.88 12.96 12.96
6 3.6 9.3 3.6 9.3 33.48 12.96 12.96
7 3.7 12.4 3.7 12.4 45.88 13.69 13.69
8 3.7 14.9 3.7 14.9 55.13 13.69 13.69
9 3.8 11.2 3.8 11.2 42.56 14.44 14.44
10 3.8 8 3.8 8 30.4 14.44 14.44
TOTALES 35.8 103.2 -0.9164 70.0636 -82.57272 191.280109 128.44

𝑥 ̅ 3.58 12.8164

𝑦 ̅ 10.32
N 10
x2 12.8164

(𝐵=∑128 370.08
▒𝑋𝑦−𝑛𝑋 ̅
/(𝛴𝑥^2
𝑌 ̅)𝑌/ ̅)/)
(𝑛𝑋 ̅ 369.456
/(𝑛𝑋 ̅ 2)
(𝛴𝑥^2−𝑛 128.44
𝑋 ̅2) 128.164
0.624
(𝐵=∑128▒𝑋𝑦−𝑛𝑋 ̅𝑌 ̅)/(𝛴𝑥^2−𝑛𝑋 ̅ 2)
/(𝛴𝑥^2−𝑛𝑋 ̅2) 2.26086957
0.276
y2 xy
53.29 24.09
116.64 36.72
171.61 44.54
108.16 36.4
33.64 20.88
86.49 33.48
153.76 45.88
222.01 55.13
125.44 42.56
64 30.4
1135.04 370.08

𝐴=𝑦 ̅−𝐵_𝑥^− 2.22608696

𝑦=𝐴+𝐵𝑥 2.22608696 2.26086957 x

2.22608696 2.26086957 4.2
2.22608696 9.49565217
 Brand and MoPrice Rating
i x y X2 Y2 XY 𝑥 ̅
1 99 28.8 9801 829.44 2851.2 𝑦 ̅
2 101.1 27 10221.21 729 2729.7 N
3 102.7 27 10547.29 729 2772.9
4 103 25.2 10609 635.04 2595.6 𝑏_1=(∑128▒(𝑥_𝑖−𝑥 ̅ )(𝑦_𝑖−𝑦 ̅ ) )/(∑1
5 105.4 22.8 11109.16 519.84 2403.12
6 107 21.5 11449 462.25 2300.5
7 108.7 20.9 11815.69 436.81 2271.83
8 110.8 19.6 12276.64 384.16 2171.68
9 112.1 17.1 12566.41 292.41 1916.91
10 112.4 19.9 12633.76 396.01 2236.76
11 113.6 16 12904.96 256 1817.6
12 113.8 16.7 12950.44 278.89 1900.46
13 115.1 13 13248.01 169 1496.3
14 115.4 13.6 13317.16 184.96 1569.44
15 120 10.8 14400 116.64 1296
TOTALES 1640.1 299.9 179849.73 6419.45 32330
(∑128▒𝑥)(∑128▒𝑦))/(√(𝑛(∑128▒𝑥^2 )−(∑128▒𝑥) ) √(2&𝑛(𝛴𝑦^2 )−(𝛴𝑦)^2 ))
n 15 (xi-pro..x) (yi-pro..y)
promedio x 109.34 -10.34 8.80666667
promedio y 19.9933333 -8.24 7.00666667
𝑛(∑𝑥𝑦) 484950 x2 11955.2356 -6.64 7.00666667
(∑𝑥)(∑𝑦) 491865.99 y2 41209338.3 -6.34 5.20666667
𝑛(∑𝑥𝑦)−(∑𝑥)(∑ -6915.99 -3.94 2.80666667
𝑛(∑𝑥^2 ) 2697745.95 -2.34 1.50666667
(∑𝑥)2 2689928.01 -0.64 0.90666667
(𝑛(∑𝑥^2 )−(∑𝑥 7817.94 10.66 -9.19333333
RAIZ 88.41911558 -27.82 24.0533333
𝑛(∑Y^2 ) 96291.75
(∑Y)2 89940.01
(𝑛(∑y^2 )−(∑y 6351.74
RAIZ 79.697804236
MULTI. DE RA7046.8093642
DIVISION -0.98143566
 1875
74
15

∑128▒(𝑥_𝑖−𝑥 ̅ )(𝑦_𝑖−𝑦 ̅ ) )/(∑128▒(𝑥_𝑖−𝑥 ̅

7.5019E+12) 2) 0.4999267
1.5006E+13

𝑏_0=𝑦 ̅−𝑏_1 𝑥 ̅ 785.2396

(prox)(yi-pro) (xi-pro.x)2
-91.06093333333 106.9156
-57.73493333333 67.8976
-46.52426666667 44.0896
-33.01026666667 40.1956
-11.05826666667 15.5236
-3.5256 5.4756
-0.580266666667 0.4096
-98.00093333333 113.6356
-341.4954666667 394.1428
 n 14

31280.2 x y xy x2
33464 1 12 3.3 39.6 144
2 30 3.2 96 900
-2183.8 3 36 3.4 122.4 1296
4 40 3 120 1600
5 45 2.8 126 2025
6 57 2.9 165.3 3249
7 62 2.7 167.4 3844
8 67 2.6 174.2 4489
9 71 2.5 177.5 5041
10 78 2.6 202.8 6084
11 93 2.2 204.6 8649
12 94 2 188 8836
13 100 2.3 230 10000
940548 14 105 2.1 220.5 11025
792100 totales 890 37.6 2234.3 67182
148448
RAIZ 385.289502
1449.56
1413.76
35.8
RAIZ 5.98331012
multipl. 2305.30657
division -0.94729266
 X 63.57142
Y 2.685714
X2

y2
10.89
10.24
11.56
9
7.84
8.41
7.29
6.76
6.25
6.76
4.84
4
5.29
4.41
103.54
 Calcular Error de Estimacion Sy
x1 x2 x3 x4 x5 𝑦 ̂ 𝑦−𝑦 ̂ (𝑦−𝑦 ̂ )^2
Prueba edad experienncia promedio perdidas
11 26.32 0 14.09 8 #REF! #REF! #REF!
20 26.07 1 14.7 7 #REF! #REF! #REF!
26 27.61 3 16.52 4 #REF! #REF! #REF!
32 26.87 2 15.69 6 #REF! #REF! #REF!
65 26.47 1 13.75 3 #REF! #REF! #REF!
81 27.34 3 14.07 4 #REF! #REF! #REF!
43 27.49 0 14.18 5 #REF! #REF! #REF!
66 25.17 2 14.74 6 #REF! #REF! #REF!
49 27.05 2 14.27 4 #REF! #REF! #REF!
65 27.56 1 13.63 2 #REF! #REF! #REF!
55 27.98 3 15.16 4 #REF! #REF! #REF!
95 26.71 0 14.8 5 #REF! #REF! #REF!
50 26.6 2 13.79 6 #REF! #REF! #REF!
94 27.98 1 13.84 7 #REF! #REF! #REF!
98 26.26 0 13.79 5 #REF! #REF! #REF!
59 30.49 2 14.4 5 #REF! #REF! #REF!
35 31.11 1 15.5 4 #REF! #REF! #REF!
59 26.26 2 12.97 6 #REF! #REF! #REF!
46 27.01 2 13.78 3 #REF! #REF! #REF!
26 27.89 1 14.4 5 #REF! #REF! #REF!
36 32.65 2 15.5 6 #REF! #REF! #REF!
16 31.11 1 12.5 5 #REF! #REF! #REF!
33 27.01 3 13.94 4 #REF! #REF! #REF!
90 26.98 4 15.75 5 #REF! #REF! #REF!
67 28.6 3 16.89 3 #REF! #REF! #REF!
48 34.5 5 17.4 4 #REF! #REF! #REF!
53 35.4 4 18.3 3 #REF! #REF! #REF!
62 43.6 5 19.9 4 #REF! #REF! #REF!
72 34.7 3 22.2 3 #REF! #REF! #REF!
#REF! #REF!
29
5

𝑠_𝑦⋅123…𝑘=√((∑128▒(𝑦−𝑦 ̂ )^2 )/(𝑛−(𝑘+1) ))

#REF! = RAIZ
#REF! =
23
#REF!
 Coeficientes
Intercepción 68.6498354
Prueba -0.02524895
edad 0.14505902
experienncia 2.50800123
promedio -0.75543008
perdidas -1.45489653

Y=68.499835-0.0252489X1+0.145059X2+2.5080012X3-0.7554302X4-1.4548965X5