Market Trends

Workings
    PART A
    Growth Rates            Year    Stores    Sales (in Billion $)    Advertisement Spent (in Billion $)    Central Tendency (Actual till 2020)    Stores    Sales
    Adv    Sales    Stores    2010    8099    404.74    2.06    Mean    10643    470
    -11.7%    3.4%    6.2%    2011    8604    418.50    1.82    Median    11361    479
    -0.5%    6.0%    13.5%    2012    9766    443.42    1.81    Standard Deviation    1284    36
    6.6%    5.0%    6.6%    2013    10408    465.60    1.93    Co
elation        0.73
    0.5%    1.6%    5.1%    2014    10942    473.08    1.94
    7.7%    1.9%    4.7%    2015    11453    482.23    2.09
    3.8%    -0.8%    0.7%    2016    11528    478.61    2.17
    5.1%    0.6%    1.4%    2017    11695    481.32    2.28    Central Tendency (Forecasted till 2025)    Stores    Sales
    14.0%    3.0%    0.2%    2018    11718    495.76    2.60    Mean    11326    499
    5.8%    2.9%    -3.0%    2019    11361    510.33    2.75    Median    11515    489
    34.5%    1.9%    1.2%    2020    11501    519.93    3.70    Standard Deviation    1528    54
    6.6%    2.6%    3.7%    2021    11922    533.21    3.94    Co
elation        0.93
                2022    12358    546.82    4.20
                2023    12811    560.78    4.48
                2024    13280    575.10    4.78
                2025    13766    589.78    5.09
                Year    Walmart top selling products
                2010    Mead Composition Notebook
                    Apple iPod 8GB
                    SanDisk memory card        Row Labels    Count of Walmart top selling products
                    Ematic 10-in-1 accessory kit for Apple iPods and MP3 players        Apple iPad mini 16GB    2
                    Walmart site to store express membership        Apple iPad mini2 16GB    1
                2011    Apple iPod 8GB        Apple iPod 32GB    1
                    AT&T Gophone prepaid Samsung cell phone        Apple iPod 8GB    2
                    Philips Norelco Men's shaving system        Articulating Flat panel TV    2
                    Centon Memory Card        Assurance premium XL Disposable washcloths    1
                    Apple iPod 32GB        AT&T Gophone prepaid Samsung cell phone    1
                2012    Ematic 10-in-1 accessory kit for Apple iPods and MP3 players        Bounty select A size paper towels, 12 mega rolls     1
                    Sceptre 32" LCD TV        Bounty select A size paper towels, 24 regular rolls     1
                    Canon Pixma Inkjet photo printe
copie
scanner        Canon Pixma Inkjet photo printe
copie
scanner    2
                    Articulating Flat panel TV        Centon Memory Card    1
                    HP Deskjet Inkjet printe
copie
scanner        Crayola classic Crayons    2
                2013    Nextbook 7" 8GB Tablet        Ematic 10-in-1 accessory...