Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. (1 hour for a, b,
Create an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. (1 hour for a, b, c).
Year | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | |||
NorthAmerica | 334631961 | 337755696 | 340727208 | 343560742 | 346144589 | 348677083 | 351137211 | 353721841 | 356272836 | 358753905 | 361188269.3 | 363576385.2 | 365918726.9 | 368215785.2 | 370468066.5 | 372676090.6 | 374840390.3 | 376961509.5 | 379040002.2 | 381076431.7 | 383071368.9 | 0.95 | 0.93 | 0.88 | 0.83 | 0.75 | 0.73 | 0.71 | 0.74 | 0.72 | 0.70 | 0.0256 | 0.9744 | 0.0068 | 0.0066 | 0.006443 | 0.006278 | 0.006117 | 0.00596 | 0.005807 | 0.005659 | 0.005514 | 0.005373 | 0.005235 | |
SouthAmerica | 378698120 | 382972825 | 387178319 | 391292863 | 395356222 | 399363652 | 403315709 | 407214928 | 411048237 | 414820735 | 418536695.6 | 422196168.9 | 425799247.5 | 429346064.2 | 432836790 | 436271632.5 | 439650833.6 | 442974667.9 | 446243440.9 | 449457487.1 | 452617168.4 | 1.16 | 1.13 | 1.10 | 1.06 | 1.04 | 1.01 | 0.99 | 0.97 | 0.94 | 0.92 | 0.0239 | 0.9761 | 0.0090 | 0.0087 | 0.008534 | 0.00833 | 0.00813 | 0.007936 | 0.007746 | 0.00756 | 0.007379 | 0.007202 | 0.00703 | |
Europe | 531286471 | 533547851 | 535259060 | 536637433 | 538034200 | 539450451 | 540869193 | 542271457 | 543650430 | 544977560 | 546284826.7 | 547572473 | 548840740.6 | 550089870.2 | 551320101.1 | 552531671.6 | 553724818.3 | 554899776.9 | 556056781.1 | 557196063.5 | 558317855 | 0.42 | 0.43 | 0.32 | 0.26 | 0.26 | 0.26 | 0.26 | 0.26 | 0.25 | 0.24 | 0.0174 | 0.9826 | 0.0024 | 0.0024 | 0.002316 | 0.002276 | 0.002236 | 0.002198 | 0.002159 | 0.002122 | 0.002085 | 0.002049 | 0.002013 | |
Asia | 3619591055 | 3655869215 | 3692046596 | 3727619599 | 3762966294 | 3798044939 | 3832757410 | 3867132739 | 3901252933 | 3935009039 | 3968494713 | 4001707411 | 4034644769 | 4067304589 | 4099684842 | 4131783662 | 4163599344 | 4195130337 | 4226375244 | 4257332815 | 4288001948 | 1.03 | 1.00 | 0.99 | 0.96 | 0.95 | 0.93 | 0.91 | 0.90 | 0.88 | 0.87 | 0.0165 | 0.9835 | 0.0085 | 0.0084 | 0.008231 | 0.008095 | 0.007961 | 0.00783 | 0.0077 | 0.007573 | 0.007448 | 0.007325 | 0.007204 | |
Oceania | 32711412 | 33179288 | 33631780 | 34068164 | 34500576 | 34929688 | 35355412 | 35777697 | 36196437 | 36611968 | 37019532.59 | 37419146 | 37810832.65 | 38194625.52 | 38570565.64 | 38938701.55 | 39299088.8 | 39651789.39 | 39996871.36 | 40334408.26 | 40664478.74 | 1.45 | 1.43 | 1.36 | 1.30 | 1.27 | 1.24 | 1.22 | 1.19 | 1.17 | 1.15 | 0.0303 | 0.9697 | 0.0111 | 0.0108 | 0.010468 | 0.01015 | 0.009843 | 0.009544 | 0.009255 | 0.008975 | 0.008703 | 0.008439 | 0.008183 | |
Africa | 927456695 | 950872112 | 974828441 | 999112106 | 1023600955 | 1048913714 | 1075191939 | 1101881896 | 1128861290 | 1156131034 | 1183749518 | 1211713881 | 1240021120 | 1268668099 | 1297651550 | 1326968074 | 1356614149 | 1386586125 | 1416880236 | 1447492597 | 1478419209 | 2.53 | 2.52 | 2.52 | 2.49 | 2.45 | 2.47 | 2.51 | 2.48 | 2.45 | 2.42 | 0.0111 | 0.9889 | 0.0239 | 0.0236 | 0.023361 | 0.023102 | 0.022846 | 0.022592 | 0.022341 | 0.022093 | 0.021848 | 0.021605 | 0.021366 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started