NUMERACY AND DATA ANALYSIS | My Assignment Tutor

NUMERACY AND DATA ANALYSIS PRACTICE SHEET 5 1Following data shows the annual sales of a company from 2000 to 2007 Year Annual Sales (£000) 2000 3.5 2001 3.2 2002 4.1 2003 4.6 2004 4.8 2005 3.9 2006 4.7 2007 4.9                                                                                                                  Using 2004 as the … Continue reading “NUMERACY AND DATA ANALYSIS | My Assignment Tutor”

NUMERACY AND DATA ANALYSIS PRACTICE SHEET 5 1Following data shows the annual sales of a company from 2000 to 2007 Year Annual Sales (£000) 2000 3.5 2001 3.2 2002 4.1 2003 4.6 2004 4.8 2005 3.9 2006 4.7 2007 4.9                                                                                                                  Using 2004 as the base year, calculate the index numbers for annual sales for the given period of time. Show the step by step calculations please.Now calculate the index numbers if the base year changes to 2001. If the index is 95.918 in 2006, calculate the sales of base year.If the index is 140 in 2007, calculate the sales of base year.If the index is 84.78 in 2005, calculate the sales of base year.  ANSWERS   1 a) 2004 as the base year   2000;   = 72.92       2001;   = 66.67   2002;   = 85.42       2003;   = 95.83   2004;   = 100           2005;   = 81.25   2006;   = 97.92       2007;   = 102.08     b) 2001 as the base year   2000;   = 109.375       2001;   = 100   2002;   = 128.125       2003;   = 143.75   2004;   = 150           2005;   = 121.875   2006;   = 146.875     2007;   = 153.125       c) Sales of the base year =   Sales of 2006 = £4.7 × 1000 = £4700      Sales of the base year =  = £4900.02         d) Sales of the base year =   Sales of 2007 = £4.9 × 1000 = £4900      Sales of the base year =  = £3500         e) Sales of the base year =   Sales of 2005 = £3.9 × 1000 = £3900      Sales of the base year =  = £4600.14      2Following data shows the individual earning of a person from 2014 to 2018   Year Individual Earnings (£000) 2014 2.8 2015 2.9 2016 3.5 2017 3.1 2018 3.8                 Using 2016 as the base year, calculate the index numbers for individual earnings from 2014 to 2018. Make sure to show the calculations.If the base year changes to 2014, calculate the index for the given period of time.If the index is 76.316 in 2015, find the individual earnings of base year.If the index is 122.58 in 2018, calculate the earnings of base year.  2 a) 2016 as the base year   2014;   = 80       2015;   = 82.86   2016;   = 100       2017;   = 88.57   2018;   = 108.57              a) 2014 as the base year   2014;   = 100       2015;   = 103.57   2016;   = 125       2017;   = 110.71   2018;   = 135.71            c) Earnings of base year =   Earnings of 2015 = £2.9 × 1000 = £2900      Earnings of the base year =  = £3799.99   d)  Earnings of base year =   Earnings of 2018 = £3.8 × 1000 = £3800      Earnings of the base year =  = £3100.02    3Following is the price index where base year is 2015   Year Price Index 2015 as base year 2014 98.2 2015 100 2016 108.5 2017 122.6 2018 141.5             If the base year is shifted to 2017, make the new price index for above data.If the base year is shifted to 2014, create the new price index for new base year.3 a) 2017 as the base year   2014;   = 80.10       2015;   = 81.57   2016;   = 88.50       2017;   = 100   2018;   = 115.42              b) 2014 as the base year   2014;   = 100            2015;   = 101.83   2016;   = 110.49  2017;   = 124.85   2018;   = 144.09