ejercicio base.xlsx

2
CLINTES VENTAS($000) TIENDA X Y (X - MEDIA) (Y - MEDIA) ( ). ( ) 1 907 11.2 175.85 2.4125 424.238125 2 926 11.05 194.85 2.2625 440.848125 3 506 6.48 -225.15 -2.3075 519.533625 4 741 9.21 9.85 0.4225 4.161625 5 789 9.42 57.85 0.6325 36.590125 6 889 10.08 157.85 1.2925 204.021125 7 874 9.45 142.85 0.6625 94.638125 8 510 6.73 -221.15 -2.0575 455.016125 9 529 7.24 -202.15 -1.5475 312.827125 10 420 6.12 -311.15 -2.6675 829.992625 11 679 7.63 -52.15 -1.1575 60.363625 12 872 9.43 140.85 0.6425 90.496125 13 924 9.46 192.85 0.6725 129.691625 14 607 7.64 -124.15 -1.1475 142.462125 15 452 6.92 -279.15 -1.8675 521.312625 16 729 8.95 -2.15 0.1625 -0.349375 17 794 9.33 62.85 0.5425 34.096125 18 844 10.23 112.85 1.4425 162.786125 19 1010 11.77 278.85 2.9825 831.670125 20 621 7.41 -110.15 -1.3775 151.731625 TOTAL 14623 175.75 5446.1275 MEDIA 731.15 8.7875 n 20 COV(X,Y) 272.306375 SIGMA X 175.300107 VAR X 30730.1275 SIGMA Y 1.62632677 VAR Y 2.64493875 R 0.95514173 B 0.00886122 A 2.30862008 MODELO Y = 2.31 + 0.0089X

Upload: elizabeth-sutton

Post on 21-Nov-2015

216 views

Category:

Documents


3 download

TRANSCRIPT

Hoja1CLINTESVENTAS($000)TIENDAXY(X - MEDIA)(Y - MEDIA)( ). ( )( X - MEDIA)2(Y - MEDIA)2( Y - )(y - )2190711.2175.852.4125424.23812530923.22255.8201562510.34574527720.85425472280.7297511315292611.05194.852.2625440.84812537966.52255.1189062510.51410842910.53589157090.287179775835066.48-225.15-2.3075519.53362550692.52255.324556256.7923966497-0.31239664970.097591666747419.219.850.42254.16162597.02250.178506258.87478300240.33521699760.112370435457899.4257.850.632536.5901253346.62250.400056259.30012149150.11987850850.0143708568688910.08157.851.2925204.02112524916.62251.6705562510.1862433438-0.10624334380.011287648178749.45142.850.662594.63812520406.12250.4389062510.0533250659-0.60332506590.364001135285106.73-221.15-2.0575455.01612548907.32254.233306256.8278415238-0.09784152380.009572963895297.24-202.15-1.5475312.82712540864.62252.394756256.99620467570.24379532430.0594361602104206.12-311.15-2.6675829.99262596814.32257.115556256.03033185670.08966814330.0080403759116797.63-52.15-1.157560.3636252719.62251.339806258.3253874541-0.69538745410.4835637113128729.43140.850.642590.49612519838.72250.4128062510.0356026289-0.60560262890.3667545441139249.46192.850.6725129.69162537191.12250.4522562510.4963859921-1.03638599211.0740959245146077.64-124.15-1.1475142.46212515413.22251.316756257.6873797204-0.04737972040.0022448379154526.92-279.15-1.8675521.31262577924.72253.487556256.31389084950.60610915050.3673683024167298.95-2.150.1625-0.3493754.62250.026406258.76844838020.18155161980.0329609907177949.3362.850.542534.0961253950.12250.294306259.3444275841-0.01442758410.00020815521884410.23112.851.4425162.78612512735.12252.080806259.78748851030.44251148970.195816418619101011.77278.852.9825831.67012577757.32258.8953062511.2584507850.5115492150.2616825994206217.41-110.15-1.3775151.73162512133.02251.897506257.8114367798-0.40143677980.1611514881TOTAL14623175.755446.1275614602.5552.898775175.7504.6394491214MEDIA731.158.7875

n20COV(X,Y)272.306375SIGMA X175.3001069595VAR X30730.1275SIGMA Y1.6263267661VAR Y2.64493875R0.9551417262B0.0088612185A2.3086200773MODELOY = 2.31 + 0.0089X

Hoja2

Hoja3