+1 (208) 254-6996 essayswallet@gmail.com
  

Q1:

Assigned Problem 1:  Perform a categorical analysis on fees for this sample of mutual funds. Describe your findings 

Assigned Problem 2:  Create a frequency distribution and a histogram of the NAV’s.  Use eight classes of data.  Edit the graph to make it professional looking.  Describe your findings 

Assigned Problem 3:  Compute the descriptive statistics for the 1-year return of the mutual funds.   Describe your findings 

Q2

Assigned Problem 1:  Create a pivot table (also known as crosstabulation or a contingency table) of Race and Low Birth Weight on Excel so you can answer the following:

  1. What is the probability of randomly choosing a Black woman?
  2. What is the probability of randomly choosing a White woman AND a Low birth weight?
  3. What is the probability of randomly choosing a Black woman OR a Low birth weight?
  4. Given that the mother you selected is a White, what is the probability she had Low birth weight?
  5. Given that the mother had Low birth weight, what is the probability she is Black?

Assigned Problem 2:  Let us assume that the Low_Birth_Weight. is a random sample from the Concordia Hospital in 2018.  We are given that the mean birth weight is approximately 6.5 pounds with a standard deviation of 1.6 pounds.  Note: The national standard is that a birth weight below 5.5 pounds is low.  Using Microsoft Excel compute the following:

  1. What is the probability of a low birth weight (< 5.5 pounds) occurring at Concordia?
  2. What is the probability of a birth weight being above the national average of 7.5 pounds?
  3. What is the probability of a birth weight being between 5 and 6 pounds?
  4. The bottom 10% of births by weight are below what weight?

Q3

Assigned Problem 1:  First compute the mean total weight and standard deviation of the garbage disposed each week by the sample.  Then, compute the 95% confidence interval of the mean total garbage disposed of in a week on Concordia St.  Describe your findings.

Assigned Problem 2:  First compute the proportion of homes in the sample that recycle.  Then, compute the 95% confidence interval of the proportion of homes on Concordia St. that recycle.    Describe your findings.

Assigned Problem 3:  You wish to learn the average number of pounds of garbage disposed of in a week by the people on Concordia St. within two pounds.  Using the standard deviation from problem 1 as an estimate, how large of a sample should you obtain?

Assigned Problem 4:  You wish to learn the proportion of homes on Concordia St. that recycle within 10% of the true population proportion and be 99% confident of the results.  How large of a sample should you obtain?

LowBirthWt

BirthWt (pounds)LowBirthWtAgeOfMomWeightOfMomAtLastMenstrPdRaceSmokedAtPregPrematureLaborHistoryOfHypertensionUterineIrritability
5.56No19182BlackNoNoNoYes
5.62No33155OtherNoNoNoNo
5.63No20105WhiteYesNoNoNo
5.71No21108WhiteYesNoNoYes
5.73No18107WhiteYesNoNoYes
5.78No21124OtherNoNoNoNo
5.81No22118WhiteNoNoNoNo
5.81No17103OtherNoNoNoNo
5.87No29123WhiteYesNoNoNo
5.87No26113WhiteYesNoNoNo
6.00No1995OtherNoNoNoNo
6.02No19150OtherNoNoNoNo
6.06No2295OtherNoNoYesNo
6.06No30107OtherNoYesNoYes
6.10No18100WhiteYesNoNoNo
6.10No18100WhiteYesNoNoNo
6.12No1598BlackNoNoNoNo
6.13No25118WhiteYesNoNoNo
6.18No20120OtherNoNoNoYes
6.21No28120WhiteYesNoNoNo
6.24No32121OtherNoNoNoNo
6.24No31100WhiteNoNoNoYes
6.25No36202WhiteNoNoNoNo
6.31No28120OtherNoNoNoNo
6.34No25120OtherNoNoNoYes
6.34No28167WhiteNoNoNoNo
6.40No17122WhiteYesNoNoNo
6.43No29150WhiteNoNoNoNo
6.43No26168BlackYesNoNoNo
6.43No17113BlackNoNoNoNo
6.43No17113BlackNoNoNoNo
6.49No2490WhiteYesYesNoNo
6.49No35121BlackYesYesNoNo
6.56No25155WhiteNoNoNoNo
6.56No25125BlackNoNoNoNo
6.56No29140WhiteYesNoNoNo
6.56No19138WhiteYesNoNoNo
6.59No27124WhiteYesNoNoNo
6.62No31215WhiteYesNoNoNo
6.68No33109WhiteYesNoNoNo
6.70No21185BlackYesNoNoNo
6.74No19189WhiteNoNoNoNo
6.74No23130BlackNoNoNoNo
6.74No21160WhiteNoNoNoNo
6.78No1890WhiteYesNoNoYes
6.78No1890WhiteYesNoNoYes
6.78No32132WhiteNoNoNoNo
6.81No19132OtherNoNoNoNo
6.81No24115WhiteNoNoNoNo
6.81No2285OtherYesNoNoNo
6.83No22120WhiteNoNoYesNo
6.84No23128OtherNoNoNoNo
6.90No22130WhiteYesNoNoNo
6.93No3095WhiteYesNoNoNo
6.99No19115OtherNoNoNoNo
6.99No16110OtherNoNoNoNo
7.06No21110OtherYesNoNoYes
7.06No30153OtherNoNoNoNo
7.06No20103OtherNoNoNoNo
7.10No17119OtherNoNoNoNo
7.10No17119OtherNoNoNoNo
7.12No23119OtherNoNoNoNo
7.12No24110OtherNoNoNoNo
7.12No28140WhiteNoNoNoNo
7.18No26133OtherYesNoNoNo
7.21No20169OtherNoYesNoYes
7.21No24115OtherNoNoNoNo
7.28No28250OtherYesNoNoNo
7.31No20141WhiteNoNoNoYes
7.31No22158BlackNoYesNoNo
7.31No22112WhiteYesNoNoNo
7.31No31150OtherYesNoNoNo
7.34No23115OtherYesNoNoNo
7.43No16112BlackNoNoNoNo
7.43No16135WhiteYesNoNoNo
7.49No18229BlackNoNoNoNo
7.52No25140WhiteNoNoNoNo
7.56No32134WhiteYesYesNoNo
7.59No20121BlackYesNoNoNo
7.62No23190WhiteNoNoNoNo
7.62No22131WhiteNoNoNoNo
7.65No32170WhiteNoNoNoNo
7.65No30110OtherNoNoNoNo
7.68No20127OtherNoNoNoNo
7.81No23123OtherNoNoNoNo
7.87No17120OtherYesNoNoNo
7.87No19105OtherNoNoNoNo
7.90No23130WhiteNoNoNoNo
7.93No36175WhiteNoNoNoNo
7.96No22125WhiteNoNoNoNo
7.96No24133WhiteNoNoNoNo
7.99No21134OtherNoNoNoNo
7.99No19235WhiteYesNoYesNo
8.01No2595WhiteYesNoNoYes
8.02No16135WhiteYesNoNoNo
8.04No29135WhiteNoNoNoNo
8.04No29154WhiteNoNoNoNo
8.04No19147WhiteYesNoNoNo
8.04No19147WhiteYesNoNoNo
8.15No30137WhiteNoNoNoNo
8.21No24110WhiteNoNoNoNo
8.27No19184WhiteYesNoYesNo
8.30No24110OtherNoYesNoNo
8.30No23110WhiteNoNoNoNo
8.30No20120OtherNoNoNoNo
8.35No25241BlackNoNoYesNo
8.37No30112WhiteNoNoNoNo
8.43No22169WhiteNoNoNoNo
8.49No18120WhiteYesNoNoNo
8.50No16170BlackNoNoNoNo
8.50No32186WhiteNoNoNoNo
8.56No18120OtherNoNoNoNo
8.56No29130WhiteYesNoNoNo
8.62No33117WhiteNoNoNoYes
8.68No20170WhiteYesNoNoNo
8.68No28134OtherNoNoNoNo
8.68No14135WhiteNoNoNoNo
8.74No28130OtherNoNoNoNo
8.77No25120WhiteNoNoNoNo
8.80No1695OtherNoNoNoNo
8.80No20158WhiteNoNoNoNo
8.93No26160OtherNoNoNoNo
8.93No21115WhiteNoNoNoNo
9.06No22129WhiteNoNoNoNo
9.15No25130WhiteNoNoNoNo
9.18No31120WhiteNoNoNoNo
9.19No35170WhiteNoYesNoNo
9.33No19120WhiteYesNoNoNo
10.12No24116WhiteNoNoNoNo
10.99No45123WhiteNoNoNoNo
1.56Yes28120OtherYesYesNoYes
2.25Yes29130WhiteNoNoNoYes
2.50Yes34187BlackYesNoYesNo
2.93Yes25105OtherNoYesYesNo
3.25Yes2585OtherNoNoNoYes
3.50Yes27150OtherNoNoNoNo
3.50Yes2397OtherNoNoNoYes
3.75Yes24128BlackNoYesNoNo
3.81Yes24132OtherNoNoYesNo
3.94Yes21165WhiteYesNoYesNo
4.00Yes32105WhiteYesNoNoNo
4.15Yes1991WhiteYesYesNoYes
4.17Yes25115OtherNoNoNoNo
4.18Yes16130OtherNoNoNoNo
4.25Yes2592WhiteYesNoNoNo
4.25Yes20150WhiteYesNoNoNo
4.25Yes21200BlackNoNoNoYes
4.26Yes24155WhiteYesYesNoNo
4.34Yes21103OtherNoNoNoNo
4.53Yes20125OtherNoNoNoYes
4.53Yes2589OtherNoYesNoNo
4.59Yes19102WhiteNoNoNoNo
4.59Yes19112WhiteYesNoNoYes
4.59Yes26117WhiteYesYesNoNo
4.63Yes24138WhiteNoNoNoNo
4.68Yes17130OtherYesYesNoYes
4.68Yes20120BlackYesNoNoNo
4.82Yes22130WhiteYesYesNoYes
4.82Yes27130BlackNoNoNoYes
4.87Yes2080OtherYesNoNoYes
4.90Yes17110WhiteYesNoNoNo
4.93Yes25105OtherNoYesNoNo
4.93Yes20109OtherNoNoNoNo
5.03Yes18148OtherNoNoNoNo
5.06Yes18110BlackYesYesNoNo
5.06Yes20121WhiteYesYesNoYes
5.07Yes21100OtherNoYesNoNo
5.12Yes2696OtherNoNoNoNo
5.18Yes31102WhiteYesYesNoNo
5.18Yes15110WhiteNoNoNoNo
5.21Yes23187BlackYesNoNoNo
5.24Yes20122BlackYesNoNoNo
5.24Yes24105BlackYesNoNoNo
5.24Yes15115OtherNoNoNoYes
5.28Yes23120OtherNoNoNoNo
5.31Yes30142WhiteYesYesNoNo
5.31Yes22130WhiteYesNoNoNo
5.32Yes17120WhiteYesNoNoNo
5.34Yes23110WhiteYesYesNoNo
5.37Yes17120BlackNoNoNoNo
5.38Yes26154OtherNoYesYesNo
5.40Yes20105OtherNoNoNoNo
5.43Yes26190WhiteYesNoNoNo
5.43Yes14101OtherYesYesNoNo
5.43Yes2895WhiteYesNoNoNo
5.50Yes14100OtherNoNoNoNo
5.50Yes2394OtherYesNoNoNo
5.50Yes17142BlackNoNoYesNo
5.50Yes21130WhiteYesNo

Sheet1

NameNAV1-Yr ReturnFeesObjectiveSize
AARP Investment GrowInc47.1927.4No loadBlendLarge
Accessor Growth20.4928.7No loadBlendLarge
Aetna Select Grow14.6936.3No loadBlendLarge
Aetna Select GrowInc14.6334.4No loadBlendLarge
AIM BlueCh A25.7532.3MultipleGrowthLarge
Alger CapAppr23.0631.5MultipleGrowthMid cap
Alger SmCapRet18.9729.3No loadGrowthMid cap
Alliance Capital A GrowInc2.9930.8MultipleBlendLarge
Alliance Capital A Quesar25.7144.6MultipleGrowthSmall
Alliance Capital B Quesar23.7043.6MultipleGrowthSmall
Alliance Capital C Quesar23.7143.5MultipleGrowthSmall
Amcore Vintage Equity17.0732.2Fund assetsBlendLarge
American Expr IDS A BlueChip8.8828.9Front loadBlendLarge
American Expr IDS A Growth28.8540.7Front loadGrowthLarge
American Fundmlnv25.4426.0MultipleBlendLarge
American Performance Equity15.0933.5MultipleBlendLarge
Baron Funds Asset37.6029.5Fund assetsGrowthSmall
Baron Funds BanRosSC7.3535.5DeferredBlendSmall
Benchmark EqIndx A16.3430.5No loadBlendLarge
Berger SmCoGrow4.3729.9Fund assetsGrowthSmall
BT InstEqIdx17.4930.7No loadBlendLarge
BT InvEqIdx17.3230.7No loadBlendLarge
BT InvSmCap19.0120.4No loadGrowthSmall
Calif Investment SP500Idx17.2530.4No loadBlendLarge
Chicago Trust GrowInc17.0632.4Fund assetsBlendLarge
Citizens Trust CloverEqV17.3028.2No loadBlendSmall
Columbia Growth31.6528.8No loadGrowthLarge
Compass Capital Inst IndexEq15.0230.0No loadBlendLarge
Compass Capital Inst SmCapGr19.8543.4No loadGrowthSmall
Compass Capital Inv SmCapGrA19.6042.9MultipleGrowthSmall
Compass Capital Svc IndexEq15.0229.7No loadBlendLarge
Compass Capital Svc SmCapGr19.7343.3No loadGrowthSmall
CoreFund EqIdx Y32.7830.7No loadBlendLarge
Delaware A DecatTot16.0826.9MultipleBlendLarge
Delaware Inst DecatTot16.0927.3No loadBlendLarge
DFA US9-Large0Sm11.6225.6No loadBlendSmall
DFA USLgCo23.0430.5No loadBlendLarge
Dodge & Cox DominiSo20.3030.5Fund assetsBlendLarge
Dreyfus Apprecia26.8432.9No loadGrowthLarge
Dreyfus DiscStkA27.5332.7No loadBlendLarge
Dreyfus IsSP50016.6731.0No loadBlendLarge
Dreyfus SP500Idx23.2930.1DeferredBlendLarge
Enterprise Grow A13.8644.7MultipleGrowthLarge
Evergreen GrowInc Y23.1329.1No loadBlendMid cap
Excelsior Busindus16.6436.2Front loadBlendMid cap
Federated Institut MaxCap16.7430.5No loadBlendLarge
Federated Institut MaxCapSvc16.7230.1Fund assetsBlendLarge
Fidelity Adv Inst EqGrowth44.4626.2No loadGrowthLarge
Fidelity Adv Inst EqIncome22.7819.9No loadBlendLarge
Fidelity Adv T EqIncome22.6119.2MultipleBlendLarge
Fidelity BlChGrow34.1423.8Front loadGrowthMid cap
Fidelity Contra44.0829.9Front loadBlendMid cap
Fidelity DivGrow20.5435.4No loadBlendMid cap
Fidelity GrowInc31.7525.2No loadBlendLarge
Fidelity MktIndex56.0130.4DeferredBlendLarge
Fidelity NewMile21.4141.1Front loadGrowthMid cap
Fidelity OTC33.8134.7Front loadGrowthMid cap
Fidelity USEqIndx28.2630.6No loadBlendLarge
First Funds GroInc I15.5033.6No loadBlendLarge
First Funds GroInc III15.4832.1Fund assetsBlendLarge
First Omaha Equity13.9420.9No loadBlendLarge
FPA Fasciano26.1034.5No loadBlendSmall
Franklin Group I CAGrowth20.7938.1MultipleBlendMid cap
Franklin Group I SmCapGro21.2338.2MultipleGrowthSmall
Franklin Group Large Growth24.0122.3MultipleBlendLarge
Freemont Growth13.2833.8No loadGrowthLarge
Galaxy Retail EqGrow20.9628.8Front loadBlendLarge
Galaxy Retail IILrgCo23.6230.5No loadBlendLarge
Galaxy Retail SmCapVal14.0734.5Front loadBlendSmall
Galaxy Trust SmCapVal14.0934.8No loadBlendSmall
General Electric ElfTrusts48.3329.6No loadBlendLarge
General Electric S&SProg47.5929.9No loadBlendLarge
Goldman Sachs SelEq A23.0629.3MultipleBlendLarge
GT Global Equity AmerGroA21.6928.1MultipleBlendSmall
GT Global Equity AmerGroB21.1727.2MultipleBlendSmall
Harbor CapApr27.8434.8No loadGrowthLarge
Harris Insight Inst Haven13.8835.2Fund assetsBlendMid cap
Heritage SmCapStkA24.0133.7MultipleBlendSmall
HighMark Fid HomePAGr20.3428.5MultipleBlendSmall
HighMark Fid HrdLynG23.2422.1MultipleBlendLarge
Janus GrowInc19.9535.0No loadGrowthLarge
Janus Mercury17.2527.6No loadGrowthMid cap
Jurika & Voyles Kaufmann5.9328.9MultipleGrowthSmall
Kent Institutional IndexEq15.4230.0No loadBlendLarge
Large784 GrowInc16.8933.0Fund assetsGrowthLarge
Lazard Equity20.0026.6No loadBlendLarge
Longleaf Partners LongPart23.3924.0No loadBlendMid cap
Lord Abbett A DevGrow12.8739.0MultipleGrowthSmall
Lutheran Brotherhood MAPEquity21.2128.1Front loadBlendMid cap
MainStay A Eqindex24.4929.8MultipleBlendLarge
MainStay Inst GrowthEq22.8931.9No loadGrowthMid cap
MainStay Inst IndxEq22.0630.3No loadBlendLarge
MainStay Inst MainPwrGr71.3136.1No loadBlendMid cap
Managers SpecialEq51.2232.4No loadGrowthSmall
MarketWatch Equity16.6532.2MultipleBlendLarge
MasterWorks SP500Stk16.6930.6No loadBlendLarge
Mentor Merger14.1410.0Fund assetsBlendMid cap
Merrill Lynch A Growth27.9248.0Front loadGrowthMid cap
Merrill Lynch B Growth25.9346.6MultipleGrowthMid cap
MFS A MAInv14.9731.6MultipleBlendLarge
MFS A Research19.0432.3MultipleGrowthMid cap
MFS B MAInv14.8630.6MultipleBlendLarge
MFS B Research18.6931.6MultipleGrowthMid cap
MFS B ResearchC18.7031.6MultipleGrowthMid cap
MFS Inst EmergEq19.0829.3No loadGrowthMid cap
Montgomery Growth20.7628.9No loadGrowthMid cap
Morgan Stanley Inst EqGrow A15.4538.1No loadBlendLarge
Morgan Stanley Inst MunderIxA18.4030.1MultipleBlendLarge
Munder K Index50018.4029.9No loadBlendLarge
Munder K SmCoGrow19.7645.4No loadGrowthSmall
Munder Y Index50018.4230.2No loadBlendLarge
Munder Y SmCoGro19.9445.7No loadGrowthSmall
Nations Primary A EqIndx16.3030.4No loadBlendLarge
Neuberger&Berman26.2032.4No loadBlendMid cap
Neuberger&Berman Tr15.5932.4No loadBlendMid cap
Nicholas Nichol68.1226.4No loadBlendMid cap
Northeast Investors Growth38.6035.8No loadBlendLarge
One Group A EqIndex19.1330.0MultipleBlendLarge
One Group Fiduciary EqIndex19.1230.3No loadBlendLarge
One Group Fiduciary IncomeEq19.0422.6No loadBlendLarge
Oppenheimer A CapitalAp32.8639.4MultipleGrowthMid cap
Oppenheimer A Growth34.9232.4MultipleBlendLarge
Oppenheimer B Growth34.1631.3MultipleBlendLarge
Pasadena Nifty50A27.5734.7Front loadGrowthLarge
Pasadena Nifty50B26.9233.7MultipleGrowthLarge
PBHG EmgGrow24.1527.7No loadGrowthSmall
Pegasus Institut EqIndex17.5530.3No loadBlendLarge
Pilgram America Magna A14.2123.8MultipleBlendLarge
PIMCo CadMidCap18.3831.4No loadBlendMid cap
PIMCo StkPlus11.9130.7No loadBlendLarge
Piper GrowInc15.7027.0MultipleBlendLarge
Portico Institut EqIndex53.7730.6No loadBlendLarge
Portico Institut GrowInc32.7730.1No loadBlendLarge
Preferred Value18.6330.9No loadBlendLarge
Principal Preserv S&PLarge00Pl23.2430.5MultipleBlendLarge
Princor EmgGro A37.6126.3MultipleBlendSmall
Provident Inv Coun23.5832.1No loadGrowthMid cap
Prudential Z StkIndex17.7630.0No loadBlendLarge
Putnam A CapApr17.5437.4MultipleBlendMid cap
Putnam A GrowInc18.7428.2MultipleBlendLarge
Rainler Reich Tang18.2320.6Fund assetsBlendMid cap
Rembrandt ReynBluCh25.9442.8No loadGrowthLarge
RIMCo Monument Stock15.2225.2Front loadBlendLarge
Riverfront IncEq A12.4326.1MultipleBlendLarge
Robertson Stephens ValGrow25.2228.6Fund assetsGrowthMid cap
RSI Retirement Trust CoreEq63.5930.1No loadGrowthLarge
RSI Retirement Trust EmgGroEq69.2443.7No loadGrowthSmall
Safeco Equity17.3232.4No loadBlendLarge
Salomon Brothers19.5836.8No loadBlendLarge
Schwab Large00021.2629.6DeferredBlendLarge
Scudder GrowInc24.1427.9No loadBlendLarge
Seafirst Retirement BlueChip24.0932.4No loadBlendLarge
Security Equity A7.4427.5Front loadBlendLarge
SEI Inst Style Mgd IdxSPIdx24.6330.5No loadBlendLarge
Sentinel Sentry19.3330.6No loadBlendMid cap
Sit LrgCapGr35.2134.0No loadGrowthLarge
South Trust Vulcan Stock15.6930.5Front loadBlendLarge
SSgA S&P500Idx16.3230.5Fund assetsBlendLarge
SSgA SmallCap18.6038.0Fund assetsBlendSmall
Stagecoach CorpStk50.8629.4Fund assetsBlendLarge
State St Research EqInc C13.7630.7No loadBlendMid cap
Stein Roe CapOpp29.4534.3No loadGrowthMid cap
Stein Roe GrowInc19.4428.4No loadBlendLarge
Stein Roe GrowStk29.6933.4No loadGrowthLarge
STI Classic ValLn Iv12.7224.6MultipleBlendLarge
STI Classic ValLn Tr12.7425.1No loadBlendLarge
Strong CmnStock20.8926.8No loadBlendMid cap
Strong Grow19.3733.3No loadGrowthMid cap
T Rowe Price BlChpGro19.7435.3No loadBlendLarge
T Rowe Price DivGrow16.8130.1No loadBlendLarge
T Rowe Price EqIncome23.2424.7No loadBlendLarge
T Rowe Price EqIndex21.3230.5DeferredBlendLarge
T Rowe Price GrowInc23.4131.1No loadBlendLarge
T Rowe Price Mid CapGr24.9331.8No loadGrowthMid cap
T Rowe Price NewHoriz22.4428.3No loadGrowthMid cap
T Rowe Price OTCSec18.2626.8No loadBlendSmall
Tower CapApr19.3431.6MultipleBlendLarge
UAM C&BEq14.1227.4No loadBlendLarge
USAA GrowInc15.8229.8No loadBlendLarge
Vanguard Index 50072.5230.8No loadBlendLarge
Vanguard Index Growth17.8532.9No loadGrowthLarge
Vanguard Index Inst72.1930.9No loadBlendLarge
Vanguard Primecap31.6231.6No loadBlendMid cap
Vanguard USGrowth24.8634.0No loadGrowthLarge
Victory DivrStkA15.5033.1Front loadBlendLarge
Victory GrowStk15.3032.8Front loadGrowthLarge
Victory StockIdx15.9530.0Front loadBlendLarge
Victory Value14.8228.7Front loadBlendLarge
Warburg Pincus CapAprCmn17.4130.0No loadBlendMid cap
Wasatch Growth16.9517.7No loadBlendSmall
Westwood Eq R7.8237.1Fund assetsBlendLarge
Westwood WhiteOak25.3348.6No loadGrowthLarge
William Blair Growth13.7925.6No loadGrowthMid cap
Wright Yacktman13.5328.6Fund assetsBlendMid cap

Sheet1

HHSIZEMETALPAPERPLASGLASSFOODYARDTEXTOTHERTOTALRECYCLE
21.092.410.270.861.040.380.054.6610.76NO
31.047.571.413.463.6800.462.3419.96NO
32.579.552.194.524.430.240.53.627.6NO
53.028.822.834.922.980.632.2612.6538.11YES
41.58.722.196.316.30.150.552.1827.9YES
22.16.961.812.491.464.580.362.1421.9YES
53.5711.423.055.819.624.760.2110.8349.27YES
52.3216.083.421.964.410.130.814.1433.27YES
41.896.382.117.672.733.860.660.2535.54YES
43.2613.052.933.219.310.70.3711.6144.44NO
53.9911.362.444.943.5913.454.251.1545.17YES
32.0415.092.173.15.360.740.424.1533.07YES
50.992.81.411.391.470.820.441.0310.35NO
52.966.4425.217.066.140.214.4344.44YES
21.55.860.932.032.521.370.279.6524.13NO
42.4311.082.971.741.7514.70.392.5437.6YES
42.9712.432.043.995.640.222.479.238.96YES
31.426.050.656.261.9300.86017.17YES
33.613.612.133.526.4600.961.3231.6NO
24.486.980.632.016.7220.110.1823.11YES
21.3614.331.532.215.760.580.171.6227.56NO
42.1113.314.690.259.720.020.460.430.96YES
42.026.671.456.855.5200.680.0323.22NO
53.2717.652.682.3311.920.830.284.0342.99YES
54.9512.733.535.454.6800.6719.8951.9YES
319.831.492.044.760.420.540.1220.2YES
41.5516.392.314.987.852.040.21.4836.8YES
31.416.330.923.542.93.850.030.0419.02YES
21.059.190.891.062.870.330.010.0315.43YES
21.319.410.82.75.090.640.050.7120.71NO
22.59.450.721.143.1700.020.0117.01NO
42.3512.322.6612.242.47.874.730.7845.35YES
53.6920.124.375.6713.201.151.1749.37YES
23.617.720.922.432.070.680.63018.06NO
21.496.161.44.0240.30.04017.41YES
21.367.981.456.454.270.020.122.0223.67NO
21.739.641.681.891.870.011.730.5819.13YES
20.948.081.531.788.130.360.120.0520.99NO
31.3310.991.442.933.5100.390.5921.18YES
32.6213.111.441.824.214.730.640.4929.06YES
21.253.261.362.893.342.6900.1614.95YES
20.261.650.380.990.770.340.0404.43NO
34.41101.741.931.140.920.084.624.82YES
53.228.962.353.611.4500.091.1220.8YES
41.869.462.32.536.5400.652.4525.79YES
41.765.881.143.760.921.1200.0414.62YES
32.838.262.881.325.145.60.352.0328.41NO
32.7412.452.132.644.591.070.411.1427.17YES
54.6310.585.2812.332.940.122.9415.6554.47YES
31.75.871.481.791.4200.270.5913.12YES
53.298.783.363.9910.440.91.7113.345.77NO
51.2211.032.834.4434.31.956.0234.79YES
43.212.292.879.255.911.321.870.5537.26NO
53.0920.582.964.0216.810.471.522.1351.58YES
52.5812.561.611.385.0100.211.4624.81NO
41.679.921.581.599.960.130.21.1326.18YES
20.853.451.150.853.8900.021.0411.25NO
41.529.091.288.874.8300.951.6128.15YES
21.373.690.583.641.780.080011.14NO
21.322.610.743.033.370.1700.4611.7YES

Sheet2

Sheet3