http://vvernon.sunyempirefaculty.net/courses/analytics/ColumnBar 1llustrate Census labor force statistics by education with any 2 column/bar charts. Label/format/color/design/style this and all your charts. Add shapes, effects and arrows as you wish. Census Education Data Not a High School GradHigh School GraduateSome College No DegreeAssociate's DegreeBachelor's DegreeAdvanced Degree Employed0.3940.6220.6900.7660.7830.801 Unemployed0.0360.0310.0270.0250.0160.013 Not in Labor Force0.5690.3440.2770.2030.1980.185 PieArea 2Ilustrate the data with an area chart. Label, format, style. 3Make a pie chart for 2016. Split out one of the pie slices. Origins of the U.S. immigrant population, 1960-2016 % of foreign-born population residing in the U.S. who were born in … YearEurope/CanadaSouth & East AsiaLatin AmericaMexicoOther 196084%4%4%6%2% 197068%7%11%8%6% 198042%15%16%16%11% 199026%22%21%22%9% 200019%23%22%29%7% 201015%25%24%29%7% 201115%25%24%29%7% 201214%26%24%28%8% 201314%26%24%28%8% 201414%26%24%28%8% 201514%27%24%27%8% 201613%27%25%26%9% http://www.pewhispanic.org/2018/09/14/facts-on-u-s-immigrants/ Line 4Construct a line chart to illustrate the two treasury yield curves. Format properly. Daily Treasury Yield Curve Rates Date 1 mo 30 yr 1/1/183.094.35 1/2/183.194.37 1/3/183.224.36 1/6/183.274.34 1/7/183.314.35 1/8/183.344.32 1/9/183.374.44 1/10/183.234.39 1/13/183.24.37 1/14/183.154.28 1/15/183.144.32 1/16/183.074.25 1/17/182.634.28 1/21/182.154.23 1/22/182.074.23 1/23/182.194.36 1/24/182.074.28 1/27/182.124.29 1/28/182.134.34 1/29/181.934.44 1/30/181.644.35 1/31/181.754.32 2/3/182.154.37 2/4/182.224.33 2/5/182.124.37 2/6/182.194.51 2/7/182.244.43 2/10/182.354.41 2/11/182.554.46 2/12/182.54.52 2/13/182.54.67 2/14/182.44.58 2/18/182.374.66 2/19/182.44.65 2/20/182.354.54 2/21/182.334.58 2/24/182.344.67 2/25/182.344.66 2/26/182.214.65 2/27/182.084.55 2/28/182.074.41 3/3/181.994.42 3/4/182.014.52 3/5/181.914.6 3/6/181.734.57 3/7/181.654.55 3/10/181.634.45 3/11/181.824.53 3/12/181.684.4 3/13/181.564.47 3/14/181.24.35 3/17/181.164.29 3/18/180.714.35 3/19/180.264.22 3/20/180.374.17 3/24/180.674.33 3/25/181.474.3 3/26/181.364.33 3/27/181.324.38 3/28/181.294.33 3/31/181.224.3 4/1/181.554.4 4/2/181.554.38 4/3/181.564.4 4/4/181.54.32 4/7/181.424.36 4/8/181.344.37 4/9/181.064.31 4/10/180.984.34 4/11/180.94.3 4/14/180.854.35 4/15/180.844.42 4/16/180.864.54 4/17/180.874.54 4/18/180.94.51 4/21/180.94.48 4/22/180.724.46 4/23/180.784.49 4/24/180.814.56 4/25/180.84.61 4/28/180.944.57 4/29/181.284.55 4/30/181.174.49 5/1/181.234.49 5/2/181.254.57 5/5/181.344.58 5/6/181.534.64 5/7/181.574.61 5/8/181.554.5 5/9/181.64.53 5/12/181.734.53 5/13/181.864.62 5/14/181.864.63 5/15/181.844.56 5/16/181.854.58 5/19/181.934.56 5/20/181.974.53 5/21/181.954.55 5/22/181.974.63 5/23/181.924.57 5/27/181.914.65 5/28/182.074.71 5/29/182.024.76 5/30/181.984.72 6/2/181.944.68 6/3/181.964.63 6/4/181.854.71 6/5/181.794.75 6/6/181.754.65 6/9/181.84.64 6/10/1824.7 6/11/181.914.72 6/12/181.924.77 6/13/181.864.79 6/16/181.894.77 6/17/181.824.78 6/18/181.74.72 6/19/181.594.76 6/20/181.494.71 6/23/181.554.71 6/24/181.584.65 6/25/181.494.65 6/26/181.424.62 6/27/181.294.53 6/30/181.64.53 Sparklines 5Add 3 types of sparklines to illustrate these data Sales Performance by Region - 2018 RegionJanFebMarAprMayJunJulAugSepOctNovDec USA7854231254184144102-44100201145222 Europe-47339114-15127248373227-35251201201 South America125-20257420300250128-5043136258250 Asia93500251-1175203341416345234380320 Total249873853648686845944549453822984993 3-D 6Make a 3D chart to show the revenue and the number of employees at the top 10 Fortune 500 companies RevenueEmployees 1Walmart$500,3002,300,000 2State Grid$348,903913,546 3Sinopec$326,953667,793 4China National Petroleum$326,0081,470,193 5Royal Dutch Shell$311,87084,000 6Toyota$265,172369,124 7Volkswagen$260,028642,292 8BP$244,58274,000 9Exxon Mobil$244,36371,200 10Berkshire Hathaway$242,137377,000 https://en.wikipedia.org/wiki/List_of_largest_companies_by_revenue https://en.wikipedia.org/wiki/Walmarthttps://en.wikipedia.org/wiki/Berkshire_Hathawayhttps://en.wikipedia.org/wiki/State_Grid_Corporation_of_Chinahttps://en.wikipedia.org/wiki/China_Petrochemical_Corporationhttps://en.wikipedia.org/wiki/China_National_Petroleum_Corporationhttps://en.wikipedia.org/wiki/Royal_Dutch_Shellhttps://en.wikipedia.org/wiki/Toyotahttps://en.wikipedia.org/wiki/Volkswagen_Grouphttps://en.wikipedia.org/wiki/BPhttps://en.wikipedia.org/wiki/ExxonMobil Scatter 7Illustrate age and salary relationship with a scatterplot 8Construct a bubble chart to include ratings AgeSalaryRating 2654,0135 2457,9213 3669,4134 3168,7017 3385,7566 2776,5167 2748,5676 3378,7682 2878,0565 4474,7476 3263,2532 2240,8673 2770,9535 2466,3335 4082,5616 4793,3417 2878,0563 2371,7814 2965,6214 2857,0934 3357,8076 3662,4273 3683,3885 5192,5135 3981,0212 2552,4732 3371,7816 2958,6336 4698,7889 3683,3884 Picture 9Create a bar chart with pictures (for example, of a smart phone) as elements in columns. This task is descrined in video 1 in Module 5 of Charts in Depth. Social media use by country % of adults who use online social networking sites, 2017 http://www.pewglobal.org/2018/06/19/social-media-use-continues-to-rise-in-developing-countries-but-plateaus-across-developed-ones/#table United States69 France53 Germany40 United Kingdom60 Russia66 Nigeria35 Brazil53 TreeMap 10Illustrate these data with a TreeMap chart. DepartmentStatusComp ManufacturingContract384,636 ManufacturingFull Time350,899 ManufacturingHourly92,538 ManufacturingContract2,310,852 ManufacturingFull Time3,879,383 ManufacturingHalf-Time593,051 ManufacturingHourly628,511 OperationsContract315,705 OperationsFull Time1,073,859 OperationsHalf-Time603,057 OperationsContract851,708 OperationsFull Time1,488,549 OperationsHalf-Time428,420 OperationsHourly252,009 LogisticsContract425,155 LogisticsFull Time215,371 LogisticsHalf-Time42,861 LogisticsHourly90,194 LogisticsContract375,989 LogisticsFull Time1,006,681 LogisticsHalf-Time264,615 EngineeringContract385,199 EngineeringFull Time1,204,283 EngineeringHalf-Time314,806 EngineeringHourly355,808 EngineeringContract579,079 EngineeringFull Time1,382,635 EngineeringHalf-Time422,381 EngineeringHourly216,027 Quality ControlContract1,661,631 Quality ControlFull Time910,852 Quality ControlHalf-Time591,270 Quality ControlHourly123,149