70
 Nc Clases Frecuencia Mc FA FR % 1 53-58 2 55.5 2 2.5 2 58-63 12 60.5 14 15 3 63-68 9 65.5 23 11.25 4 68-73 10 70.5 33 12.5 5 73-78 21 75.5 54 26.25 6 78-83 8 80.5 62 10 7 83-88 9 85.5 71 11.25 8 88-93 4 90.5 75 5 9 93-98 5 95.5 80 6.25 80 100 Media Mediana Moda 74.625 74.6666667 75.3913043 74.625 74.625 M ! !"2 8.278125 10.3614369 107.359375 10.3614369 4.24079886 0 5 10 15 20 25 Pastel

Derecho a Examen 2.xls

Embed Size (px)

Citation preview

P1NcClasesFrecuenciaMcFAFR %Mc*FMc-A=dF*dUF*UMc-MediaF(Mc-Media)Mc-Media^2F(Mc-Media^2)Mc^2Mc^2*Fd^2153-58255.522.5111-20-40-4-8-19.12538.25365.765625731.531253080.256160.5400258-631260.51415726-15-180-3-36-14.125169.5199.5156252394.18753660.2543923225363-68965.52311.25589.5-10-90-2-18-9.12582.12583.265625749.3906254290.2538612.25100468-731070.53312.5705-5-50-1-10-4.12541.2517.015625170.156254970.2549702.525573-782175.55426.251585.500000.87518.3750.76562516.0781255700.25119705.250678-83880.56210644540185.8754734.515625276.1256480.255184225783-88985.57111.25769.5109021810.87597.875118.2656251064.3906257310.2565792.25100888-93490.5755362156031215.87563.5252.0156251008.06258190.2532761225993-98595.5806.25477.52010042020.875104.375435.7656252178.8281259120.2545601.25400801005970-70-14662.251506.8906258588.754541001500MediaMedianaModa74.62574.666666666775.391304347874.62574.625MDSS^28.27812510.3614369177107.35937510.36143691774.240798863402129102189453CuartilDecilPercentil5768.551.662597658.6726085.559.779609860976160.59761616261.362626262626363656565666767686868697171717273737373737474747575757575757565767676767777787878787879797979798081828283848585858686878888888990939394959597979797979797979798

P1212910218945

Histograma

P221423335462717580

Ojiva

P3212910218945

Pastel

P40212910218945

Poligono

P11NcClaseFrecuenciaMcFAFRelativaF1*X1X1-AF*dUF*UX1-MediaF(x1-Media)(X1-Media)^2F(X1-Media)^2X1^2X1^2*Fd^2F*d^21125-1368130.58201044-11-88-1-8-17.325138.6300.1556252401.24517030.251362421219682136-14714141.5223519810000-6.32588.5540.005625560.0787520022.25280311.5003147-15810152.532251525111101104.67546.7521.855625218.5562523256.25232562.512112104158-1695163.53712.5817.52211021015.67578.375245.7056251228.52812526732.25133661.2548424205169-1802174.539534933663626.67553.35711.5556251423.1112530450.2560900.5108921786180-1910185.539004404037.67501419.405625034410.250193607191-2021196.5402.5196.555555548.67548.6752369.2556252369.25562538612.2538612.253025302540591325323454.38200.7758822909801MediaMedianaModaDesviacn M.SS^2147.825145.4285714286142.611.357514.3184976516205.019375147.82514.3184976516147.82514.3184976516081410520125CuartilDecilPercentil12614064.39134.7128147103.78142132157.25126.34150135199127.12168.5135127.9176135129.36138130.92138132.36140133.53140142142144144145145146146147147148149150150152153154156157158161163164165168173176176199

P11

Histograma

P12

Grafico de Pastel

P13

Ojiva

P14

Poligono

N ClaseIntervalosFrecuencias (fi)Marca de clase (xi)Frecuencia AbsolutaFrecuencia Relativa (%)(fi)(xi)d=xi-Ad2(fi)(d)(fi)(d)2u(fi)(u)xi-Xf(xi-X)(xi-X)2f(xi-X)2(xi)211.7251.72871.7265711.6712.0855-0.0090.000081-0.0630.000567-3-210.0080.0566.48E-054.54E-042.980821.7281.73171.72951411.6712.1065-0.0060.000036-0.0420.000252-2-140.00510.0352.55E-051.79E-042.991231.7311.734121.73252620.0020.79-0.0030.000009-0.0360.000108-1-120.00210.0254.20E-065.04E-053.001641.7341.737171.73554328.3329.503500.0000000000.00100.0169.03E-071.53E-053.012051.7371.7491.73855215.0015.64650.0030.0000090.0270.000081190.00400.0361.56E-051.40E-043.022461.741.74351.7415578.338.70750.0060.0000360.030.000182100.00700.0354.83E-052.42E-043.0328271.7431.74631.7445605.005.23350.0090.0000810.0270.000243390.00990.0309.90E-052.97E-043.0432860100.00104.073-0.0570.001431-190.2331.38E-03Media1.73461.734559.9318Desviacion media0.003877Mediana2.6752Desviacion estandar0.004790Moda2.1186Varianza2.29E-0507712179531.725CuartilDecilPercentil1.7251.7321.7251.7281.7261.7351.725161.7321.7271.7381.725741.7361.7271.7581.726321.74121.7281.72691.74411.7281.7271.7291.727061.7291.727641.731.7281.731.731.7311.7311.7321.7321.7321.7321.7321.7331.7331.7331.7341.7341.7341.7341.7351.7351.7351.7351.7351.7351.7351.7351.7361.7361.7361.7361.7361.7361.7371.7371.7371.7381.7381.7391.7391.7391.741.741.741.7411.7411.7421.7431.7441.7451.7461.758

771217953

Histograma

7142643525760

intervalosfrec. abs.Ojiva

0771217953

Poligono

Pastel

7.267.27Rango =0.147.29NC=67.3TC =0.02333333337.317.31NCLiLsFXiFAFxid= Xi-AFdUFUFR(Xi-)F(Xi-)(Xi-)2F(Xi-)2Xi2FXi2Fxid2Fd2Fd7.3217.267.283333333327.2716666667214.5433333333-0.07-0.14-3-66.250.06489583330.12979166670.00421146920.008422938452.8771361111105.754272222214.54333333330.00490.0098-0.147.3227.28333333337.306666666727.295414.59-0.0466666667-0.0933333333-2-46.250.04156250.0831250.00172744140.003454882853.217025106.4340514.590.00217777780.0043555556-0.09333333337.3237.30666666677.3387.31833333331258.5466666667-0.0233333333-0.1866666667-1-8250.01822916670.14583333330.00033230250.000208420153.5580027778428.464022222258.54666666670.00054444440.0043555556-0.18666666677.3247.337.3533333333137.34166666672595.4416666667000040.6250.00510416670.06635416670.00002605250.000338682753.9000694444700.700902777895.44166666670007.3257.35333333337.376666666737.3652822.0950.02333333330.07139.3750.02843750.08531250.00080869140.002426074254.243225162.72967522.0950.00054444440.00163333330.077.3267.37666666677.447.38833333333229.55333333330.04666666670.18666666672812.50.05177083330.20708333330.00268021920.010720876754.5874694444218.349877777829.55333333330.00217777780.00871111110.18666666677.3332234.77-0.1633333333-70.71750.00978617620.0255718751722.4328234.770.0288555556-0.16333333337.337.337.33Media=7.33656257.33656257.33656257.33Mediana=7.3371794872Desviacin media:0.0224218757.33Moda=7.3377777778Desviacin estandar:0.028268730.02959195150.02959195157.33CuartilDecilPercentilVarianza:0.00079912117.337.327.26317.3017.337.337.26627.327.347.357.26937.337.347.47.27487.3797.357.2817.38457.357.28727.357.29177.377.29487.377.29797.387.387.397.402281334

2281334

Histograma

6.256.252540.6259.37512.5

Pastel

2412252832

Ojiva

Poligono

DatosNUMERO DE CLASES:660RANGO:3863TAMAO DE CLASE:6.333333333364NUMERO DE DATOS:4066CLASES66LILSFRECUENCIAMARCA DE CLASEFREC. AFREC. RFI-XiDESVIACINFR.DUF*UFRMCXi- xf(xi-x)(xi-x)f(xi-x)xx*fifi*xid6716066.3333333333563.1666666667512.5315.8-18.99-94.95-3-15565.16-14.8774.35221.111105.553989.185619945.92315.8360.6268266.333333333372.66666666671069.51525694.9-12.66-122.6-2-201069.49-8.5785.472.93729.34828.860148288.601694.9160.2769372.666666666779275.8333333333175151.64-6.53-16.66-1-2275.82-2.214.424.889.765748.672411497.34151.6440.066947985.33333333331582.16666666673237.51232.2500001582.154.1261.816.97254.556748.6225101229.331232.25070585.333333333391.6666666667588.53712.5442.46.3331.6515586.488.4542.2571.43577178.790437393.95432.440.0670691.666666666798394.8333333333407.5284.4312.6637.9826394.8116.7850.34278.89836.678988.93626966.8284.43160.27713121.42-164.58-2640318.563292.83245321.9413111.427272MD7.9647274MEDIA.78.035574CuartilDecilPercentil78.0521666667807061.176682.8166666667808162.3471.7MEDIANA80.2666666667818563.1781.4MODA82.5797101449819863.5689.1S9.07307830898163.9593.1S9.07307830898164.68S08165.46S82.320758266826683848485FRECUENCIA85085587108828915895903939598

51021553

Histograma

51021553

Poligono

51517323740

Ojiva

051021553

Pokigono

NUMERO DE CLASECLASESColumna1FRECUENCIAXFXFRFAGRADOSD=X-Af(D)UF(U)|(X-MEDIA)|f|X-MEDIA|(X-Media)^2F(X-Media)^2X^2F(X^2)D^2f(D^2)INTERVALOSFRECUENCIAFA10.310.3750.3471.73513.8888888889550-0.053-0.265-1-50.12119444440.60597222220.01468809340.07344046680.1204090.6020450.0028090.0140450.31-0.375520.370.43120.44.833.33333333331712000000.06819444440.81833333330.00465048230.0558057870.161.92000.37-0.43121730.430.4980.463.6822.222222222225800.060.48180.00819444440.06555555560.00006714890.00053719140.21161.69280.00360.02880.43-0.4982540.490.5540.522.0811.111111111129400.120.48280.05180555560.20722222220.00268381560.01073526230.27041.08160.01440.05760.49-0.5542950.550.6110.580.582.777777777830100.180.18330.11180555560.11180555560.01250048230.01250048230.33640.33640.03240.03240.55-0.6113060.610.6740.642.5611.111111111134400.240.964160.17180555560.68722222220.02951714890.11806859570.40961.63840.05760.23040.61-0.6743470.670.7520.711.425.555555555636200.310.625100.24180555560.48361111110.05846992670.11693985340.50411.00820.09610.19220.67-0.752363616.8552.455402.97972222220.38802763898.2794450.555445MEDIAMEDIANAMODA0.46819444440.43750.40818181820.46819444440.4666666667DM0.0827700617SS^20.10381977420.01077854550.10381977420.10381977420.31CuartilDecilPercentil0.350.40750.3240.3650.360.4450.3380.4150.360.540.35050.470.370.750.3540.660.380.35750.67250.40.360.40.360.40.360.410.36150.410.420.420.420.420.420.430.440.450.460.460.470.480.480.480.510.540.540.550.580.620.660.660.670.680.75

51284142

FRECUENCIAHistograma

51284142

FRECUENCIAPoligono

5172529303436

FAOjiva

51284142

FRECUENCIAPastel

NcClasesFMcFAFRMc*FDesviacinF*dUF*UMc-MediaF(Mc-Media)(Mc-Media)2F(Mc-Media)2Mc2Mc2*FD2d2*f1122.2-125.383123.7931.9607843137371.37-12.72-38.16-4-12-11.639215686334.9176470588135.4713417916406.414025374915323.964145971.8923161.7984485.39522125.38-128.568126.97115.22875816991015.76-9.54-76.32-3-24-8.459215686367.673725490271.5583300269572.466640215316121.3809128971.047291.0116728.09283128.56-131.7415130.15269.80392156861952.25-6.36-95.4-2-30-5.340392156980.105882352928.5197883891427.796825836216939.0225254085.337540.4496606.7444131.74-134.9245133.337129.41176470595999.85-3.18-143.1-1-45-2.099215686394.46470588244.4067064975198.301792387517776.8889799960.000510.1124455.0585134.92-138.142136.5111327.45098039225733.4200001.080784313745.39294117651.168094732849.059978777418634.9801782669.1642006138.1-141.2825139.6913816.3398692813492.253.1879.51254.2607843137106.519607843118.1542829681453.857074202219513.2961487832.402510.1124252.817141.28-144.4611142.871497.18954248371571.576.3669.962227.440784313781.84862745155.3652712034609.017983237220411.8369224530.205940.4496444.94568144.46-1474146.051532.614379085584.29.5438.1631210.620784313742.4831372549112.8010594387451.204237754721330.602585322.4191.0116364.046415310020720.67-165.36-52553.40627450983168.11855778552809342.46013337.092MediaMedianaModaMDSS2135.4292156863135.2686666667134.29090909093.61703447394.550456816720.7066572404135.42921568634.543452882135.49039215694.54345288203815454225114

Histograma

Ojiva

Pastel

Poligono

NCClasesFMcFAFrMc*FDesviacionF*dUF*UMc-Mediaf(Mc-Media)Mc-Media2f(Mc-Media)2Mc2Mc2*Fd2d2*F12.2-4.28143.241410.852713178345.36-4.16-58.24-2-28-4.417984496161.851782945719.518587008273.260218111910.4976146.966417.3056242.278424.28-6.38345.324826.3565891473180.88-2.08-70.72-1-34-2.337984496179.49147286825.4661715041185.8498311428.3024962.28164.3264147.097636.38-8.44387.48629.4573643411281.20000-0.25798449619.80341085270.06655600022.529128009154.762080.880048.44-10.52239.4810917.8294573643218.042.0847.841231.822015503941.90635658913.319740496476.354031416489.87042067.01924.326499.5072510.52-12.61111.561208.5271317829127.164.1645.762223.902015503942.922170542615.2257249925167.4829749174133.63361469.969617.3056190.3616612.6-14.68413.641243.100775193854.566.2424.963125.982015503923.928062015535.7845094886143.1380379544186.0496744.198438.9376155.7504714.68-16.76415.721283.100775193862.888.3233.284168.062015503932.248062015564.9960939847259.9843759389247.1184988.473669.2224276.8896816.76-18.9117.81290.775193798417.810.410.45510.142015503910.1420155039102.8604784809102.8604784809316.84316.84108.16108.16129987.8833.2816302.29333333331211.4590759698776.62881220.0448MediaMedianaModaMDSS27.65798449617.26315789476.79789473682.34335917313.06449924589.39115562777.65798449613.06449924587.65798449613.064499245801434382311441

Histograma

Ojiva

Pastel

Poligono