area under a curve.xls

XYTrapezoid Area111.5222322422.5532.562Area under curve:10.565432101234XYArea011.00111.50221.50310.834-2Area under curve:4.83Three trapezoids and two triangles43210-2-101243210-2-1012Incorrect11.51.5-0.53.5Three trapezoids and two trianglesUsing 9 data areas220.01 Area under curveXYAreas0012.85575219400.64278832.55190725800.98480837.016663141200.86602524.160910941600.342026.840402867200-0.3420224.16091094240-0.8660337.01666314280-0.9848132.55190725320-0.6427912.85575219360-2.5E-16229.16 Area under curveUsing 36 areasXYArea000.868240888100.1736482.578341605200.342024.210100717300.55.713938048400.6427887.044160264500.7660448.160349235600.8660259.028590123700.9396939.622501869800.9848089.9240387659019.9240387651000.9848089.6225018691100.9396939.0285901231200.8660258.1603492351300.7660447.0441602641400.6427885.7139380481500.54.2101007171600.342022.5783416051700.1736480.8682408881801.23E-160.868240888190-0.173652.578341605200-0.342024.210100717210-0.55.713938048220-0.642797.044160264230-0.766048.160349235240-0.866039.028590123250-0.939699.622501869260-0.984819.924038765270-19.924038765280-0.984819.6225018699 Areas36032028024020016012080400-1.00-0.75-0.50-0.250.000.250.500.751.00180 Areas36032028024020016012080400-1.00-0.75-0.50-0.250.000.250.500.751.00290-0.939699.028590123300-0.866038.160349235310-0.766047.044160264320-0.642795.713938048330-0.54.210100717340-0.342022.578341605350-0.173650.868240888360-2.5E-16Using 180 areasXYArea000.03489949720.0348990.1046559740.0697560.17428493760.1045280.24370156480.1391730.312821279100.1736480.381559868120.2079120.449833586140.2419220.517559251160.2756370.58465435180.3090170.651037138200.342020.716626737220.3746070.781343236240.4067370.84510779260.4383710.90784271280.4694720.969471563300.51.029919264320.5299191.089112168340.5591931.146978156360.5877851.203446728380.6156611.258449085400.6427881.311918216420.6691311.363788977440.6946581.413998171460.719341.462484626480.7431451.509189269500.7660441.554055197520.7880111.597027748540.8090171.638054567560.8290381.677085669580.8480481.7140735600.8660251.748972997620.8829481.781741639640.8987941.812339504660.9135451.840729312680.9271841.866876475700.9396931.890749137720.9510571.912318212740.9612621.931557422760.9702961.948443327780.9781481.962955354800.9848081.975075822820.9902681.984789964840.9945221.992085946860.9975641.996954877880.9993911.9993908279011.999390827920.9993911.996954877940.9975641.992085946960.9945221.984789964980.9902681.9750758221000.9848081.9629553541020.9781481.9484433271040.9702961.9315574221060.9612621.9123182121080.9510571.8907491371100.9396931.8668764751120.9271841.8407293121140.9135451.8123395041160.8987941.7817416391180.8829481.7489729971200.8660251.71407351220.8480481.6770856691240.8290381.6380545671260.8090171.5970277481280.7880111.5540551971300.7660441.5091892691320.7431451.4624846261340.719341.4139981711360.6946581.3637889771380.6691311.3119182161400.6427881.2584490851420.6156611.2034467281440.5877851.1469781561460.5591931.0891121681480.5299191.0299192641500.50.9694715631520.4694720.907842711540.4383710.845107791560.4067370.7813432361580.3746070.7166267371600.342020.6510371381620.3090170.584654351640.2756370.5175592511660.2419220.4498335861680.2079120.3815598681700.1736480.3128212791720.1391730.2437015641740.1045280.1742849371760.0697560.104655971780.0348990.0348994971801.23E-160.034899497182-0.03490.10465597184-0.069760.174284937186-0.104530.243701564188-0.139170.312821279190-0.173650.381559868192-0.207910.449833586194-0.241920.517559251196-0.275640.58465435198-0.309020.651037138200-0.342020.716626737202-0.374610.781343236204-0.406740.84510779206-0.438370.90784271208-0.469470.969471563210-0.51.029919264212-0.529921.089112168214-0.559191.146978156216-0.587791.203446728218-0.615661.258449085220-0.642791.311918216222-0.669131.363788977224-0.694661.413998171226-0.719341.462484626228-0.743141.509189269230-0.766041.554055197232-0.788011.597027748234-0.809021.638054567236-0.829041.677085669238-0.848051.7140735240-0.866031.748972997242-0.882951.781741639244-0.898791.812339504246-0.913551.840729312248-0.927181.866876475250-0.939691.890749137252-0.951061.912318212254-0.961261.931557422256-0.97031.948443327258-0.978151.962955354260-0.984811.975075822262-0.990271.984789964264-0.994521.992085946266-0.997561.996954877268-0.999391.999390827270-11.999390827272-0.999391.996954877274-0.997561.992085946276-0.994521.984789964278-0.990271.975075822280-0.984811.962955354282-0.978151.948443327284-0.97031.931557422286-0.961261.912318212288-0.951061.890749137290-0.939691.866876475292-0.927181.840729312294-0.913551.812339504296-0.898791.781741639298-0.882951.748972997300-0.866031.7140735302-0.848051.677085669304-0.829041.638054567306-0.809021.597027748308-0.788011.554055197310-0.766041.509189269312-0.743141.462484626314-0.719341.413998171316-0.694661.363788977318-0.669131.311918216320-0.642791.258449085322-0.615661.203446728324-0.587791.146978156326-0.559191.089112168328-0.529921.029919264330-0.50.969471563332-0.469470.90784271334-0.438370.84510779336-0.406740.781343236338-0.374610.716626737340-0.342020.651037138342-0.309020.58465435344-0.275640.517559251346-0.241920.449833586348-0.207910.381559868350-0.173650.312821279352-0.139170.243701564354-0.104530.174284937356-0.069760.10465597358-0.03490.034899497360-2.5E-16228.60 Area under curve36 Areas36032028024020016012080400-1.00-0.75-0.50-0.250.000.250.500.751.00180 Areas36032028024020016012080400-1.00-0.75-0.50-0.250.000.250.500.751.00XYArea CalcCumulative AreaComputed-3.000.0044320.0000450.00004500.0013500-2.990.0045670.0000460.00009130.0013950-2.980.0047050.0000480.00013910.0014413-2.970.0048470.0000490.00018830.0014891-2.960.0049930.0000510.00023900.0015383-2.950.0051430.0000520.00029120.0015889-2.940.0052960.0000540.00034490.0016411-2.930.0054540.0000550.00040030.0016949-2.920.0056160.0000570.00045730.0017502-2.910.0057820.0000590.00051590.0018072-2.900.0059530.0000600.00057630.0018659-2.890.0061270.0000620.00063850.0019263-2.880.0063070.0000640.00070250.0019884-2.870.0064910.0000660.00076840.0020524-2.860.0066790.0000680.00083610.0021183-2.850.0068730.0000700.00090580.0021860-2.840.0070710.0000720.00097760.0022557-2.830.0072740.0000740.00105130.0023275-2.820.0074830.0000760.00112720.0024012-2.810.0076970.0000780.00120530.0024771-2.800.0079150.0000800.00128560.0025552-2.790.008140.0000830.00136810.0026355-2.780.008370.0000850.00145300.0027180-2.770.0086050.0000870.00154030.0028029-2.760.0088460.0000900.00163000.0028901-2.750.0090940.0000920.00172220.0029798-2.740.0093470.0000950.00181690.0030720-2.730.0096060.0000970.00191430.0031668-2.720.0098710.0001000.00201440.0032641-2.710.0101430.0001030.00211720.0033642-2.700.0104210.0001060.00222280.0034670-2.690.0107060.0001090.00233130.0035726-2.680.0109970.0001110.00244280.0036812-2.670.0112950.0001140.00255730.0037926-2.660.01160.0001180.00267480.0039071-2.650.0119120.0001210.00279560.0040246-2.640.0122320.0001240.00291950.0041453-2.630.0125580.0001270.00304680.0042693-2.620.0128920.0001310.00317740.0043965-2.610.0132340.0001340.00331150.0045271-2.600.0135830.0001380.00344910.0046612-2.590.013940.0001410.00359030.0047988-2.580.0143050.0001450.00373520.0049400-2.570.0146780.0001490.00388390.0050850-2.560.015060.0001530.00403650.0052336-2.550.0154490.0001560.00419300.0053862-2.540.0158480.0001610.00435350.0055426-2.530.0162540.0001650.00451810.0057031-2.520.016670.0001690.00468690.0058678-2.510.0170950.0001730.00486000.0060366-2.500.0175280.0001770.00503750.00620973.002.001.000.00-1.00-2.00-3.0000.050.10.150.20.250.30.350.40.45-2.490.0179710.0001820.00521950.0063872-2.480.0184230.0001870.00540600.0065691-2.470.0188850.0001910.00559720.0067557-2.460.0193560.0001960.00579320.0069469-2.450.0198370.0002010.00599400.0071428-2.440.0203280.0002060.00619980.0073436-2.430.0208290.0002110.00641070.0075494-2.420.0213410.0002160.00662670.0077603-2.410.0218620.0002210.00684800.0079763-2.400.0223950.0002270.00707460.0081975-2.390.0229370.0002320.00730680.0084242-2.380.0234910.0002380.00754450.0086563-2.370.0240560.0002430.00778790.0088940-2.360.0246310.0002490.00803720.0091375-2.350.0252180.0002550.00829240.0093867-2.340.0258170.0002610.00855360.0096418-2.330.0264260.0002670.00882100.0099031-2.320.0270480.0002740.00909460.0101704-2.310.0276820.0002800.00937460.0104441-2.300.0283270.0002870.00966120.0107241-2.290.0289850.0002930.00995440.0110106-2.280.0296550.0003000.01025440.0113038-2.270.0303370.0003070.01056120.0116038-2.260.0310320.0003140.01087510.0119106-2.250.031740.0003210.01119610.0122244-2.240.032460.0003280.01152430.0125454-2.230.0331940.0003360.01186000.0128737-2.220.0339410.0003430.01220320.0132093-2.210.0347010.0003510.01255410.0135525-2.200.0354750.0003590.01291280.0139034-2.190.0362620.0003670.01327940.0142621-2.180.0370630.0003750.01365410.0146287-2.170.0378780.0003830.01403700.0150034-2.160.0387070.0003910.01442830.0153863-2.150.039550.0004000.01482810.0157776-2.140.0404080.0004080.01523650.0161773-2.130.041280.0004170.01565380.0165857-2.120.0421660.0004260.01607990.0170030-2.110.0430670.0004350.01651520.0174291-2.100.0439840.0004440.01695970.0178644-2.090.0449150.0004540.01741360.0183088-2.080.0458610.0004630.01787700.0187627-2.070.0468230.0004730.01835010.0192261-2.060.04780.0004830.01883300.0196992-2.050.0487920.0004930.01932600.0201821-2.040.04980.0005030.01982910.0206751-2.030.0508240.0005130.02034260.0211782-2.020.0518640.0005240.02086650.0216916-2.010.0529190.0005350.02140100.0222155-2.000.0539910.0005450.02194640.0227501-1.990.0550790.0005560.02250270.0232954-1.980.0561830.0005670.02307010.0238517-1.970.0573040.0005790.02364880.0244191-1.960.0584410.0005900.02423900.0249978-1.950.0595950.0006020.02484080.0255880-1.940.0607650.0006140.02545440.0261898-1.930.0619520.0006260.02608000.0268033-1.920.0631570.0006380.02671760.0274289-1.910.0643780.0006500.02736760.0280665-1.900.0656160.0006620.02803000.0287165-1.890.0668710.0006750.02870510.0293789-1.880.0681440.0006880.02939300.0300540-1.870.0694330.0007010.03009390.0307418-1.860.070740.0007140.03080790.0314427-1.850.0720650.0007270.03153520.0321567-1.840.0734070.0007410.03227610.0328841-1.830.0747660.0007550.03303060.0336249-1.820.0761430.0007680.03379910.0343794-1.810.0775380.0007820.03458150.0351478-1.800.078950.0007970.03537810.0359303-1.790.080380.0008110.03618920.0367269-1.780.0818280.0008260.03701480.0375379-1.770.0832930.0008400.03785510.0383635-1.760.0847760.0008550.03871040.0392039-1.750.0862770.0008700.03958080.0400591-1.740.0877960.0008860.04046640.0409295-1.730.0893330.0009010.04136750.0418151-1.720.0908870.0009170.04228420.0427162-1.710.0924590.0009330.04321680.0436329-1.700.0940490.0009490.04416530.0445654-1.690.0956570.0009650.04513000.0455139-1.680.0972820.0009810.04611100.0464786-1.670.0989250.0009980.04710860.0474597-1.660.1005860.0010140.04812290.0484572-1.650.1022650.0010310.04915400.0494715-1.640.1039610.0010480.05020220.0505026-1.630.1056750.0010650.05126760.0515507-1.620.1074060.0010830.05235040.0526161-1.610.1091550.0011000.05345080.0536989-1.600.1109210.0011180.05456890.0547993-1.590.1127040.0011360.05570490.0559174-1.580.1145050.0011540.05685910.0570534-1.570.1163230.0011720.05803150.0582076-1.560.1181570.0011910.05922230.0593800-1.550.1200090.0012090.06043170.0605708-1.540.1218780.0012280.06165990.0617802-1.530.1237630.0012470.06290710.0630084-1.520.1256650.0012660.06417330.0642555-1.510.1275830.0012860.06545880.0655217-1.500.1295180.0013050.06676370.0668072-1.490.1314680.0013250.06808830.0681121-1.480.1334350.0013440.06943250.0694367-1.470.1354180.0013640.07079670.0707809-1.460.1374170.0013840.07218090.0721451-1.450.1394310.0014040.07358540.0735293-1.440.141460.0014250.07501020.0749337-1.430.1435050.0014450.07645560.0763586-1.420.1455640.0014660.07792160.0778039-1.410.1476390.0014870.07940840.0792699-1.400.1497270.0015080.08091620.0807567-1.390.1518310.0015290.08244510.0822645-1.380.1539480.0015500.08399520.0837934-1.370.156080.0015720.08556670.0853435-1.360.1582250.0015930.08715980.0869150-1.350.1603830.0016150.08877450.0885081-1.340.1625550.0016360.09041100.0901227-1.330.164740.0016580.09206930.0917592-1.320.1669370.0016800.09374980.0934176-1.310.1691470.0017030.09545230.0950980-1.300.1713690.0017250.09717720.0968005-1.290.1736020.0017470.09892440.0985254-1.280.1758470.0017700.10069420.1002726-1.270.1781040.0017920.10248660.1020424-1.260.1803710.0018150.10430170.1038347-1.250.1826490.0018380.10613960.1056498-1.240.1849370.0018610.10800050.1074878-1.230.1872350.0018840.10988440.1093486-1.220.1895430.0019070.11179140.1112325-1.210.191860.0019300.11372160.1131395-1.200.1941860.0019540.11567510.1150697-1.190.196520.0019770.11765210.1170233-1.180.1988630.0020000.11965240.1190002-1.170.2012140.0020240.12167640.1210005-1.160.2035710.0020480.12372390.1230245-1.150.2059360.0020710.12579510.1250720-1.140.2083080.0020950.12789010.1271432-1.130.2106860.0021190.13000890.1292382-1.120.2130690.0021430.13215150.1313569-1.110.2154580.0021670.13431800.1334996-1.100.2178520.0021910.13650860.1356661-1.090.2202510.0022150.13872310.1378566-1.080.2226530.0022390.14096170.1400711-1.070.225060.0022630.14322430.1423097-1.060.227470.0022870.14551110.1445723-1.050.2298820.0023110.14782200.1468591-1.040.2322970.0023350.15015700.1491700-1.030.2347140.0023590.15251620.1515050-1.020.2371320.0023830.15489970.1538642-1.010.2395510.0024080.15730730.1562477-1.000.2419710.0024320.15973910.1586553-0.990.244390.0024560.16219510.1610871-0.980.2468090.0024800.16467530.1635431-0.970.2492280.0025040.16717960.1660232-0.960.2516440.0025290.16970810.1685276-0.950.2540590.0025530.17226080.1710561-0.940.2564710.0025770.17483750.1736088-0.930.2588810.0026010.17743840.1761855-0.920.2612860.0026250.18006320.1787864-0.910.2636880.0026490.18271210.1814112-0.900.2660850.0026730.18538490.1840601-0.890.2684770.0026970.18808160.1867329-0.880.2708640.0027210.19080220.1894296-0.870.2732440.0027440.19354650.1921502-0.860.2756180.0027680.19631450.1948945-0.850.2779850.0027920.19910610.1976625-0.840.2803440.0028150.20192130.2004541-0.830.2826940.0028390.20476000.2032693-0.820.2850360.0028620.20762200.2061080-0.810.2873690.0028850.21050730.2089700-0.800.2896920.0029080.21341580.2118553-0.790.2920040.0029320.21634730.2147638-0.780.2943050.0029540.21930180.2176954-0.770.2965950.0029770.22227920.2206499-0.760.2988720.0030000.22527920.2236272-0.750.3011370.0030230.22830190.2266273-0.740.3033890.0030450.23134690.2296499-0.730.3056270.0030670.23441430.2326950-0.720.3078510.0030900.23750390.2357624-0.710.310060.0031120.24061550.2388520-0.700.3122540.0031330.24374890.2419636-0.690.3144320.0031550.24690400.2450970-0.680.3165930.0031770.25008070.2482522-0.670.3187370.0031980.25327870.2514288-0.660.3208640.0032190.25649790.2546268-0.650.3229720.0032400.25973800.2578460-0.640.3250620.0032610.26299900.2610862-0.630.3271330.0032820.26628060.2643472-0.620.3291840.0033020.26958260.2676288-0.610.3312150.0033220.27290480.2709308-0.600.3332250.0033420.27624700.2742531-0.590.3352130.0033620.27960890.2775953-0.580.337180.0033820.28