Question

Provide a statistical trend analysis on the following data. Show this in a visual graph using excel. Explain in detail the trend comparing Toys R Us to the other two corporations, Amazon and Target. Can this information be used to provide future trends in sales and possibly prevented bankruptcy for Toys R Us. Do you see any underlying patterns or behaviors?

Net sales   In millions (other than stores)   
2008   2009   2010   2011   2012   2013   2014   2015   2016   2017
13,794   13,724   13,568   13,864   13,909   13,543   12,543   12,361   11,802   11,540 Toys R Us  
19166   24509   34204   48077   61093   74452   88988   107006   135987   177866 Amazon  
62884   63435   65786   68466   71960   71279   72618   73785   69495   71879 Target  

Answer 1

S.No.	year	R Us	Amazon	Target
1	2008	13794	19166	62884
2	2009	13724	24509	63435
3	2010	13568	34204	65786
4	2011	13684	48077	68466
5	2012	13909	61093	71960
6	2013	13543	74452	71279
7	2014	12543	88988	72618
8	2015	12361	107006	73785
9	2016	11802	135987	69495
10	2017	11540	177866	71879

FROM THE ABOVE GRAPH IT IS CLEAR THAT

• Net sale in R Us is almost same for every year. It seems that there is very little decline in net sale of R Us year to Year. So there is very small fluctuation (ups and down) in sale.
• In Target there is small increment of net sale year by year.
• Net sale of Amazon increasing very rapidly year by year.

COMPARISON

  Yearly net sale of Target is larger than R Us but both have not very fast increment of sale but initially (2008) Amazon's net sale is nearly equal to R us but due to continuously rapid increment Amazon yearly net sale become much much larger to both corporation.

PREDICTIONS

• In future years , it seems from data R Us yearly net sale lies between 11,500 million to 12,500 million.
• similarly for Target , yearly net sales lies between 67000 million to 73000 million and not have much more ups and down.
• Amazon's net increasing very fast and it seems that in future year it will cross 200,000 million per year

THIS IS ANOTHER FORMAT OF GRAPH WHICH CLEAR YOU MORE

thanks