Complete the Chapter 6 Case 1 Problem Young Professional Magazine in the
Essentials of Business Analytics(4th ed.). A Managerial Report should be created summarizing your responses to all six questions at the end of the case problem. Please provide an interpretation for each table and graph.
Young Professional Magazine AgeGenderReal Estate Purchases?Value of Investments ($)Number of TransactionsBroadband Access?Household Income ($)Have Children? 38FemaleNo122004Yes75200Yes 30MaleNo124004Yes70300Yes 41FemaleNo268005Yes48200No 28FemaleYes196006No95300No 31FemaleYes151005No73300Yes. 32MaleNo397003Yes123400Yes 32MaleYes219002Yes73900Yes 26FemaleYes419002Yes54300Yes 26MaleYes161004Yes93100No 34FemaleYes1840011Yes60100No 33FemaleNo338003No48600No 35FemaleYes155006No43500No 28FemaleNo173007Yes73600Yes 30MaleNo479005Yes68200Yes 30FemaleNo282003No61900Yes 30MaleYes194006No57600No 33MaleYes3100012No82300No 28MaleNo213006No64600Yes 27FemaleNo2130010Yes61100Yes 23FemaleNo213007Yes31200Yes 30FemaleNo341006Yes92600No 28MaleNo326007Yes68300No 41MaleYes010Yes35100No 29MaleYes2080010Yes85700No 33FemaleYes231006Yes140300Yes 30MaleNo398009Yes108200Yes 29FemaleNo179002No61100No 33MaleNo333002No33900Yes 30FemaleYes218008Yes54400Yes 30MaleNo540007Yes61200No 36FemaleYes3480012No58000Yes 33FemaleYes361007Yes90700Yes 28FemaleYes443005Yes95200No 28MaleNo214005No50500Yes 28MaleYes86006Yes33800Yes 35MaleNo232003No147400No 31MaleNo248004No92600Yes 33FemaleNo266005Yes66200No 32MaleNo331008No45700No 28MaleNo270004No60500Yes 27MaleNo487006No110600No 30FemaleYes171004No60300Yes 29MaleNo199006No75700No 28MaleNo132009No70100Yes 29FemaleYes324006No42100Yes 32FemaleNo142005Yes41700Yes 33MaleNo201005No96900No 23MaleYes320005Yes65700No 29FemaleNo419003No50200No 31MaleNo120003No61700No 33FemaleNo140006No44500Yes 37FemaleNo100004Yes51900No 28FemaleNo272005Yes119100Yes 27FemaleYes345004Yes49200No 33FemaleNo260006Yes39000Yes 31FemaleNo534003Yes35000No 30MaleNo231007Yes104700Yes 23MaleNo249005No49300No 33MaleNo1090010Yes74000No 31FemaleNo525002Yes57100Yes 24FemaleNo2460016Yes51400Yes 35FemaleNo288006No62100Yes 36FemaleYes3730011Yes103000Yes 24MaleYes211009Yes97900No 25MaleNo409003No123100No 26FemaleNo247007Yes322500No 31MaleNo336008Yes54800Yes 26MaleYes200006No66500Yes 26MaleNo239002No33700Yes 28MaleYes117008No73600Yes 26FemaleNo192005Yes71300Yes 34MaleNo119006No74200No 32MaleNo177008Yes70000Yes 30MaleNo239006Yes40800No 29FemaleYes275004Yes72500Yes 23MaleYes253004No53300No 28FemaleNo669005No45600No 25MaleNo188005Yes73900Yes 35MaleNo244003Yes83600No 31MaleNo455009Yes124700No 35MaleYes547003Yes101600No 32FemaleNo322004No205900Yes 29MaleNo162003Yes69700No 34FemaleNo160009No95700No 30FemaleYes240003No46100Yes 29MaleNo288003Yes118600No 42MaleNo141005Yes65400No 37FemaleYes1770011Yes149300Yes 32MaleNo298007Yes125000No 33FemaleYes272003Yes39800No 36MaleYes430002No83500Yes 32FemaleYes155007Yes38700Yes 35MaleYes87006No102400No 20MaleNo1390014Yes57700No 30MaleNo142006Yes16200No 31FemaleYes271003No43100No 28MaleYes223003No43700No 24FemaleYes295004Yes39600Yes 30MaleNo188002Yes127500No 23FemaleYes264009Yes33500No 29MaleYes164005Yes48100Yes 33MaleNo395003Yes52800No 24MaleYes209006Yes54800No 25FemaleNo528005Yes46500No 38MaleNo365004Yes60400No 22FemaleNo3040011Yes202400Yes 32FemaleNo398007No71300No 28FemaleYes181009No62800No 32MaleYes695007No43900Yes 33FemaleNo330005Yes52200Yes 32FemaleYes321003No64400Yes 24MaleYes152008No77400Yes 23FemaleYes498003Yes65900No 23MaleNo281006No54100Yes 38MaleNo152006Yes77400Yes 29MaleNo308003Yes85900Yes 28MaleNo212003No148600No 29MaleNo246004Yes82100No 36MaleYes247009Yes64400Yes 35FemaleYes2630016No86200No 34FemaleYes322006No177100Yes 23MaleNo203006Yes68300No 31FemaleNo609006Yes67900Yes 28MaleNo1580011Yes57300Yes 33FemaleNo317006Yes83600No 31MaleYes05Yes77500No 26FemaleYes209009Yes61700Yes 38FemaleNo3790012No85600Yes 28MaleYes224007Yes59900Yes 27MaleNo266005Yes43100No 31MaleYes2080010No65700No 34MaleNo311007Yes80500Yes 29MaleNo312005Yes88400Yes 27MaleNo02No40200No 26MaleYes389007Yes84000Yes 33MaleYes295004Yes34400Yes 33MaleNo161005No55800Yes 34MaleNo158007Yes64900Yes 31MaleNo275004Yes41100Yes 37FemaleNo130007No39100Yes 27MaleYes681005No58200No 32MaleYes185007Yes46500Yes 25FemaleNo271002Yes45100Yes 31FemaleNo259005Yes69900Yes 38MaleNo184002No63700No 31FemaleNo592004Yes40500No 28FemaleNo679005No62600Yes 29FemaleNo367007Yes73400Yes 34FemaleNo324009Yes35000No 35FemaleYes103004Yes114000No 30MaleNo393007Yes70800No 32FemaleNo138006Yes60300Yes 31MaleNo111004Yes78700No 29FemaleNo286002No179700No 31MaleNo221006Yes157200Yes 31FemaleNo167006Yes67300No 22FemaleYes194006Yes49800No 19MaleYes546004Yes43400Yes 31FemaleYes415002Yes71100Yes 22FemaleNo233009No42100Yes 26MaleNo297008Yes42200Yes 34MaleYes332002Yes63300No 37MaleYes563005No55700No 36FemaleNo259005Yes107900No 27FemaleYes635006Yes44800Yes 32MaleYes187007Yes94700No 27FemaleNo497004Yes112700No 32MaleYes150005Yes114900Yes 24FemaleYes82007No112700Yes 38FemaleYes363009No60900No 33FemaleNo502007Yes137800No 19MaleNo1350010Yes47200Yes 33MaleYes375004Yes70900Yes 25FemaleNo268007No52000No 27MaleNo303005Yes166500Yes 35FemaleNo4630018Yes88000No 29MaleYes144009No41800No 31MaleYes04Yes60300No 29FemaleYes188005Yes53400Yes 31FemaleNo409005No46700Yes 32MaleYes233007Yes59600Yes 22FemaleNo119004Yes27700Yes 29MaleYes2810010No48900Yes 28FemaleNo204008No56600No 26MaleNo149007No32500No 33FemaleNo339003Yes74500Yes 35MaleNo151006No69800No 27MaleNo1334005Yes48100Yes 33FemaleYes183007Yes95900Yes 30FemaleYes2870010Yes76500No 28MaleYes509006Yes43700No 35FemaleNo256004Yes72700Yes 34FemaleYes307000Yes140100No 28MaleYes643005Yes76600No 30MaleYes672007No65300Yes 37MaleNo6220011Yes161100Yes 32MaleNo3310012No64900No 21MaleNo260004No59800Yes 31FemaleYes184005No87900Yes 31MaleYes5300012Yes174900Yes 23MaleNo463003Yes40700Yes 34MaleYes327005No36700Yes 31MaleNo509004Yes167800No 28FemaleNo192002Yes168500No 30MaleYes183003Yes112100Yes 25MaleNo178002Yes65500No 32FemaleYes418006Yes73500No 30MaleYes71007Yes59100Yes 28MaleYes155008Yes73900No 33MaleNo229004Yes120800Yes 34FemaleYes100004No25100Yes 34FemaleNo533006Yes137900Yes 33FemaleYes324007Yes70200Yes 26MaleNo856002Yes90900No 28FemaleYes264006No65500No 23MaleYes304005Yes86200No 31MaleYes240008Yes45900No 28FemaleNo175000No76000No 29MaleNo110005Yes82700Yes 30FemaleNo94005No57400Yes 30MaleNo3470012No53700No 31FemaleYes442003No29900Yes 22MaleNo207005No94800Yes 34MaleNo290003No67300Yes 30FemaleNo298003Yes41200Yes 34FemaleYes9520021No70400Yes 25MaleYes215005Yes120600Yes 32FemaleNo231004No63900No 31FemaleYes139005Yes98800Yes 29FemaleNo289007Yes53300Yes 28FemaleNo704008No30000Yes 26FemaleNo124004Yes93200Yes 26MaleYes278009Yes84100No 26FemaleNo199005Yes124000Yes 29FemaleNo280007Yes73400Yes 32FemaleYes750006Yes45500No 37FemaleNo140009Yes88400Yes 32MaleNo209004Yes74900No 33FemaleNo472006Yes51700Yes 36FemaleNo572005No78700Yes 30MaleYes429007Yes30700Yes 31MaleYes442001Yes56000Yes 28FemaleYes280004Yes88400Yes 25MaleYes245006Yes201700Yes 29MaleNo181009Yes71600Yes 31FemaleNo209007No59000Yes 32MaleNo321006No57300Yes 32MaleYes445006No91900Yes 38MaleYes201004Yes68300Yes 35MaleYes360008No93900No 34MaleNo1260012Yes61200No 33MaleYes193006No128800Yes 32FemaleYes3330013Yes77900No 26FemaleNo236002No67700Yes 23FemaleNo494007Yes63300Yes 32MaleNo237001Yes55000No 25FemaleYes357004No100700Yes 27MaleYes1990010No148000Yes 22MaleNo306009No59600No 33FemaleNo246002No51600No 33MaleYes180001Yes48400No 29MaleNo06Yes58500Yes 33FemaleNo276004Yes153000No 33FemaleNo488004No86800Yes 42MaleNo303004No46400Yes 28FemaleYes577006Yes36900No 27FemaleNo292003Yes46900Yes 35MaleYes166002Yes57400No 31FemaleNo168005No91200No 32FemaleYes214008Yes62100Yes 34MaleNo125007Yes38800Yes 24FemaleYes4930013No90200Yes 30MaleNo91005Yes47100Yes 28MaleNo192008No159200Yes 32FemaleYes159005Yes52700Yes 34MaleYes4020013Yes73400No 31MaleYes558005Yes58900No 33MaleYes272003Yes81100Yes 31FemaleYes201004No68400Yes 29MaleNo173003No55700Yes 25MaleYes421007No45400No 29MaleNo395005Yes59600No 25FemaleNo214002Yes47700Yes 30FemaleNo1020011Yes57200Yes 28FemaleYes1830011Yes47300Yes 32FemaleNo206004Yes58300Yes 34FemaleNo6340017Yes47800Yes 33FemaleYes382005Yes61600No 24MaleNo504007Yes64000Yes 30FemaleNo95005No87400Yes 25MaleNo279006Yes56200Yes 26MaleNo181004Yes100600No 31MaleNo395005Yes51100No 29MaleNo234005Yes90100No 31MaleNo341006Yes50800Yes 36MaleNo175006No62500No 34FemaleYes126007No37400No 24MaleNo292003Yes102700No 28MaleYes426004No68400No 34FemaleYes181004No68800No 31MaleNo112007Yes108000No 31MaleYes305009Yes200500No 30MaleNo393009No123000No 38FemaleNo231007Yes64300Yes 29MaleNo384002Yes72600No 21MaleYes353006Yes81500No 32FemaleNo158003No57000Yes 27MaleYes243006Yes101500No 29MaleYes247002Yes67600No 32MaleNo308007No70200No 32MaleYes174003No64800No 29FemaleNo91002Yes70800No 35MaleYes233002Yes50300Yes 36MaleYes150002Yes30300Yes 32MaleNo014No61700Yes 25FemaleYes313007No103500No 29MaleYes345008No33400No 22MaleYes263007Yes51700No 28MaleNo219007Yes76400Yes 29FemaleYes271007Yes47400Yes 29MaleNo5930011Yes118800Yes 29FemaleNo345009Yes61300Yes 32FemaleYes632008No97900No 30MaleNo70003Yes67400Yes 29FemaleNo181007No82000No 30FemaleNo155005Yes60700No 38MaleYes118004No98800Yes 32FemaleYes277003Yes61800No 27MaleNo146006No49600Yes 29MaleNo175003Yes54700Yes 28FemaleYes379007Yes153300No 33MaleYes138009Yes94400Yes 32MaleYes221009Yes39500Yes 35FemaleYes242006Yes72400Yes 27MaleYes195006Yes93200Yes 29MaleYes233004Yes161400No 30MaleNo290005No56100No 34FemaleNo532005No95000Yes 24MaleNo153006Yes94100Yes 30FemaleYes258008No24300Yes 28MaleNo342004Yes49400No 23FemaleNo250007Yes41200No 26FemaleYes245007No81800No 30MaleNo255006No62400No 26MaleNo1940014No117800Yes 24FemaleNo3060011Yes100100Yes 33FemaleNo211009No94100Yes 30FemaleNo8330013Yes59300Yes 25FemaleYes507005Yes89500Yes 24MaleNo296002No88900Yes 35MaleYes297006Yes53200No 34FemaleYes121006No58600No 36MaleNo250002No54200No 29MaleNo372005Yes38500No 27FemaleNo166001No69800Yes 30MaleNo580002Yes66200No 25MaleYes234004Yes78900No 32MaleYes215003No87200No 29MaleYes3380015Yes79300No 27MaleNo184007No51800No 27MaleYes1310011Yes70900No 33MaleNo1810018Yes110900No 29MaleYes343002No109400Yes 30MaleYes235008No43800No 32MaleYes192006No49700Yes 23FemaleYes169004Yes149300Yes 26MaleNo221005Yes68900No 34FemaleYes270003Yes50100No 35MaleYes652002No32400Yes 31FemaleYes112005Yes82700Yes 29FemaleNo2480012No104300Yes 25MaleYes465009Yes49600No 34MaleYes200007Yes36500No 38FemaleNo162001Yes65500Yes 34MaleNo272009Yes110800Yes 32FemaleNo111003No38100No 33FemaleYes185002Yes70700Yes 27MaleNo213001Yes39800Yes 30MaleNo194003Yes60600Yes 32FemaleYes170005No48200Yes 33MaleNo287004No108700Yes 26FemaleYes207004No71300Yes 29MaleNo171004Yes110800Yes 36MaleNo210005Yes120300Yes 38MaleYes219006Yes130000Yes 31FemaleYes612007Yes60300Yes 31FemaleNo102008No70300No 31MaleYes236005No100700No 30MaleNo239004No72300Yes 30MaleNo281005Yes45800No 24MaleNo236006No51600Yes 34MaleNo7080010Yes48200No 39MaleNo2510014No87900Yes 27MaleNo223007No89600No 31FemaleYes362006Yes56100Yes 32MaleYes2060012Yes93600Yes 37MaleYes383004No100300Yes 29MaleNo138005No96000No 31MaleYes4700010Yes105500No 27MaleNo303004No76400No 31FemaleYes371006Yes77100Yes 32FemaleYes641004Yes62300Yes 30MaleYes193006No52700No 26FemaleYes274004Yes59000No 32FemaleYes239002Yes42200No 32FemaleNo274007Yes83500No 26FemaleYes144003Yes28200Yes 24MaleYes360004Yes103500No 25FemaleYes303006No35100No 28FemaleYes3050011Yes36800Yes Case Problem 1. Young Professional Magazine Young Professional magazine was developed for a target audience of recent college graduates who are in their first 10 years in a business/professional career. In its two years of publication, the magazine has been fairly successful. Now the publisher is interested in expanding the magazine’s advertising base. Potential advertisers continually ask about the demographics and interests of subscribers to Young Professional. To collect this information, the magazine commissioned a survey to develop a profile of its subscribers. The survey results will be used to help the magazine choose articles of interest and provide advertisers with a profile of subscribers. As a new employee of the magazine, you have been asked to help analyze the survey results, a portion of which are shown in the following table. Age Sex Real Estate Purchases Value of Investments ($) Number of Transactions Broadband Access Household Income ($) Children 38 Female No 12,200 4 Yes 75,200 Yes 30 Male No 12,400 4 Yes 70,300 Yes 41 Female No 26,800 5 Yes 48,200 No 28 Female Yes 19,600 6 No 95,300 No 31 Female Yes 15,100 5 No 73,300 Yes ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ Some of the survey questions are as follows: 1. What is your age? 2. Are you: Male Female 3. Do you plan to make any real estate purchases in the next two years? Yes No 4. What is the approximate total value of financial investments, exclusive of your home, owned by you or members of your household? 5. How many stock/bond/mutual fund transactions have you made in the past year? 6. Do you have broadband access to the Internet at home? Yes No 7. Please indicate your total household income last year. 8. Do you have children? Yes No The file Professional contains the responses to these questions. The table shows the portion of the file pertaining to the first five survey respondents. Managerial Report Prepare a managerial report summarizing the results of the survey. In addition to statistical summaries, discuss how the magazine might use these results to attract advertisers. You might also comment on how the survey results could be used by the magazine’s editors to identify topics that would be of interest to readers. Your report should address the following issues, but do not limit your analysis to just these areas. 1. Develop appropriate descriptive statistics to summarize the data. 2. Develop 95% confidence intervals for the mean age and household income of subscribers. 3. Develop 95% confidence intervals for the proportion of subscribers who have broadband access at home and the proportion of subscribers who have children. 4. Would Young Professional be a good advertising outlet for online brokers? Justify your conclusion with statistical data. 5. Would this magazine be a good place to advertise for companies selling educational software and computer games for young children? 6. Comment on the types of articles you believe would be of interest to readers of Young Professional. 2 1. Tabular and graphical summaries Factors Opening Gross Sales ($ millions) Total Gross Sales ($ millions) Number of Theatres Weeks in Release Minimum 0.12 23.59 1213.00 7.00 Maximum 179.14 532.18 4381.00 46.00 Average 32.09 103.82 3282.36 14.73 Table 1: Minimum, Maximum, and average of each variable From the sample of 100 movies, the average gross sale is 103.82 million while the average opening sales of the movies is $32.09 million. Each movie has run for 14.73 weeks on average. $ 0.12 million is the lowest opening gross. while $23.059 is the lowest total gross for a movie. 1213 is the lowest number of theatres in which a film has been released. On the other hand, $179.14 is the maximum opening gross for a movie, while the highest total gross is $532.18 million. Figure 1: Graphical summary of top five movies The above diagram representing details of the top five movies (from the perspective of total gross sales). The diagram disclosed "Rogue One: A Star Wars Story" has earned maximum revenue of $ 532.18 million. However, the movie’s opening gross was lesser than "Captain America: Civil War". "Captain America: Civil War" earned an opening gross of $ 179.14 million. "The Secret Life of Pets" has been released in 4,381 theatres which is the maximum compared to the other four movies. The film has also run for 25 weeks which is the maximum. 2. Relationship between Total Gross Sales and Opening Weekend Gross Sales Figure 2: Scatter diagram 1 The above scatter diagram is representing there is a correlation between “Opening sales” and “Total gross sales” for most of the movies. However, some movies have a great opening sale but ended up with significantly lower total gross sales and vis-a-versa. 3. Relationship between Total Gross Sales and Number of Theaters Figure 3: Scatter diagram 2 A correlation can be found between the variables, “Number of theaters” and “Total gross sales”. In most cases, movies that have been released in more theaters have generated more sales. However, some movies have failed to gain high revenue despite releasing in more theaters. 4. Relationship between Total Gross Sales and Number of Weeks in Release Figure 4: Scatter diagram 3 The pattern in the scatter diagram representing, movies that have run for the lesser duration (weeks) have earned fewer total sales. Some exceptions also can be found, for example, there is a movie called “Hidden Figures” which has run for 46 weeks, but its total sales is “$ 169.61 million”. While “Rogue One: A Star Wars Story” earned $532.18 million by running for only 20 weeks. Graphical summary Rogue One: A Star Wars Story Opening Gross Sales ($ millions)Total Gross Sales ($ millions) Number of Theaters Weeks in Release155.08000000000001532.17999999999995415720Finding Dory Opening Gross Sales ($ millions)Total Gross Sales ($ millions) Number of Theaters Weeks in Release135.06486.3430525Captain America: Civil War Opening Gross Sales ($ millions)Total Gross Sales ($ millions) Number of Theaters Weeks in Release179.14408.08422620The Secret Life of Pets Opening Gross Sales ($ millions)Total Gross Sales ($ millions) Number of Theaters Weeks in Release104.35368.38438125The Jungle Book (2016) Opening Gross Sales ($ millions)Total Gross Sales ($ millions) Number of Theaters Weeks in Release103.26364414424Variables Title of the movies Relationship between Total Gross Sales and Opening Weekend Gross Sales Total Gross Sales ($ millions)155.08000000000001135.06179.14104.35103.26132.4375.06166.01133.6835.2656.6374.40000000000000685.060.5259.2259.2565.7746.580.8841.2846.0235.5438.5335.0323.8238.15999999999999741.0440.40999999999999724.0714.8734.2634.70000000000000335.2426.4128.8724.7135.3231.5226.8621.5124.5428.521.3124.7321.6915.1929.0322.3821.3723.5921.6414.8120.221117.8622.870.1318.7218.7821.7616.816.8910.2820.23999999999999816.1900000000000010.1219.4512.610.2624.1717.8816.6314.6915.1314.7912.79.449999999999999311.811.210.7811.1114.0710.3314.868.36999999999999920.1614.127.111.3614.213.840.410.296.60.6212.7411.28.80000000000000078.5711.77532.17999999999995486.3408.08368.38364363.07341.27330.36325.10000000000002270.39999999999998248.76234.04232.64169.61162.43158.85155.44153.71151.1143.53128.35127.44126.64125.07113.26107.51103.14102.47100.55100.0197.6993.4391.2289.2287.2486.2682.0579.20999999999999477.04000000000000676.2375.40000000000000673.20999999999999472.68000000000000772.0867.2767.20999999999999466.18000000000000765.0864.0663.2962.6861.7161.4360.3259.6958.757.6856.2555.4855.4655.1254.7754.6554.0352.8551.7448.3948.0247.747.3746.8446.0143.0342.1641.0140.138.5836.88000000000000336.2635.8235.59000000000000335.1434.9234.34000000000000332.4931.8931.1531.0230.529.7528.8527.8527.5727.3827.0126.5926.4125.1424.2523.59Opening sales Total gross sales Relationship between Total Gross Sales and Number of Theaters Number of Theaters 532.17999999999995486.3408.08368.38364363.07341.27330.36325.10000000000002270.39999999999998248.76234.04232.64169.61162.43158.85155.44153.71151.1143.53128.35127.44126.64125.07113.26107.51103.14102.47100.55100.0197.6993.4391.2289.2287.2486.2682.0579.20999999999999477.04000000000000676.2375.40000000000000673.20999999999999472.68000000000000772.0867.2767.20999999999999466.18000000000000765.0864.0663.2962.6861.7161.4360.3259.6958.757.6856.2555.4855.4655.1254.7754.6554.0352.8551.7448.3948.0247.747.3746.8446.0143.0342.1641.0140.138.5836.88000000000000336.2635.8235.59000000000000335.1434.9234.34000000000000332.4931.8931.1531.0230.529.7528.8527.8527.5727.3827.0126.5926.4125.1424.2523.594157430542264381414438563959425642554029387541443882341640393928415340663236398739633508359139553215393241303356311534783135369631923384383534024071282137633702324122993922342728352971374032323997349534923155340330083179378023682762339234162962321029962676291718023802327912133406335730083258237931043160253829152865267129123168290835763291312031173028224822463418156431431528150525093084220429302567Total gross sales Number of theater Relationship between Total Gross Sales and Number of Weeks in Release Weeks in Release532.17999999999995486.3408.08368.38364363.07341.27330.36325.10000000000002270.39999999999998248.76234.04232.64169.61162.43158.85155.44153.71151.1143.53128.35127.44126.64125.07113.26107.51103.14102.47100.55100.0197.6993.4391.2289.2287.2486.2682.0579.20999999999999477.04000000000000676.2375.40000000000000673.20999999999999472.68000000000000772.0867.2767.20999999999999466.18000000000000765.0864.0663.2962.6861.7161.4360.3259.6958.757.6856.2555.4855.4655.1254.7754.6554.0352.8551.7448.3948.0247.747.3746.8446.0143.0342.1641.0140.138.5836.88000000000000336.2635.8235.59000000000000335.1434.9234