significantly large and as such the relationship isnt too strong the covariance

Significantly large and as such the relationship isnt

This preview shows page 10 - 14 out of 52 pages.

significantly large and as such the relationship isn't too strong. the covariance is again positive thus indicating a positive relationship.
Image of page 10
Year 2009 Year 2010 Year 2011 Year 2012 Year 2013 Product Price Quantity Price Quantity Price Quantity Price Quantity Price Quantity Bread £ 1.00 5 £ 1.10 4 £ 1.05 5 £ 1.10 5 £ 1.10 5 Milk £ 0.90 3 £ 0.95 3 £ 0.95 4 £ 0.90 5 £ 0.95 5 Meat £ 2.50 4 £ 2.50 4 £ 2.55 4 £ 2.60 3 £ 2.60 3 Fish £ 3.50 2 £ 4.00 1 £ 4.10 0 £ 4.00 3 £ 4.10 3 Clothing £ 15.00 6 £ 13.00 9 £ 14.00 11 £ 14.00 12 £ 14.00 12 Transport £ 8.00 10 £ 9.00 10 £ 9.10 10 £ 9.15 11 £ 9.15 11 a) 2009 base year 2,009 2010 2,011 2012 2,013 Laspeyres 100.00 99.82 103.49 103.80 103.98 Paasche 100.00 97.045068 101.31 101.2160229 101.4306151645 inflation rate(L) - 0.18 3.68% 0.30% 0.173% inflation rate(P) -2.95% 4.39% -0.09% 0.212% 2,009 2,010 2,011 2,012 2,013 92.00 94.00 96.00 98.00 100.00 102.00 104.00 106.00 -0.2 -0.15 -0.1 -0.05 0 0.05 0.1 Laspeyres Paasche inflation rate(L) inflation rate(P) The laspeyres index and Paschee are mostly similar, apart from in the latest years. the inflation rate calculated from both indexes are similar since they are overlapping eachother.
Image of page 11
Supermarket Total sales in 2012 (£000s) Supermarket Total sales in 2013 (£000s) 2012 position % of total sales % of markets Cummulative %of sales Cummulative % of maret Farm Foods £ 134,695 Farm Foods £ 173,905 £ 134,695 1 0.0055802187 0.08 0 0 Other supermarket chains £ 439,617 Iceland £ 491,597 £ 439,617 2 0.0182126953 0.08 0.0055802187 0.08 Iceland £ 479,105 Other supermarket chains £ 496,157 £ 479,105 3 0.0198486259 0.08 0.0237929139 0.17 Independent supermarkets £ 498,294 Independent supermarkets £ 520,051 £ 498,294 4 0.0206435983 0.08 0.0436415398 0.25 Lidl £ 660,351 Lidl £ 751,201 £ 660,351 5 0.027357385 0.08 0.0642851381 0.33 Aldi £ 733,061 Aldi £ 961,395 £ 733,061 6 0.0303696549 0.08 0.0916425231 0.42 Waitrose £ 1,104,036 Waitrose £ 1,201,202 £ 1,104,036 7 0.0457386116 0.08 0.1220121781 0.50 Co-operative £ 1,580,784 Co-operative £ 1,574,040 £ 1,580,784 8 0.0654895904 0.08 0.1677507897 0.58 Morrisons £ 2,814,236 Morrisons £ 2,855,745 £ 2,814,236 9 0.1165897193 0.08 0.2332403801 0.67 Sainsbury's £ 4,078,869 Sainsbury's £ 4,186,914 £ 4,078,869 10 0.1689816319 0.08 0.3498300994 0.75 Asda £ 4,242,670 Asda £ 4,276,248 £ 4,242,670 11 0.17576767 0.08 0.5188117314 0.83 Tesco £ 7,372,225 Tesco £ 7,427,304 £ 7,372,225 12 0.3054205986 0.08 0.6945794014 0.92 Total: £ 24,137,943 1 1.00 2,013 position % of total sales % of markets Cummulative %of sales Cummulative % of maret b)GINI £ 173,905 1 0.0069797191 0.08 0 0 Markets 2012 £ 491,597 2 0.0197303642 0.08 0.0069797191 0.08 1 £ 134,695 1616340 £ 496,157 3 0.0199133809 0.08 0.0267100834 0.17 2 £ 439,617 4835787 £ 520,051 4 0.0208723724 0.08 0.0466234643 0.25 3 £ 479,105 4791050 £ 751,201 5 0.0301496334 0.08 0.0674958367 0.33 4 £ 498,294 4484646 £ 961,395 6 0.0385858203 0.08 0.0976454701 0.42 5 £ 660,351 5282808 £ 1,201,202 7 0.0482105321 0.08 0.1362312904 0.50 6 £ 733,061 5131427 £ 1,574,040 8 0.0631744752 0.08 0.1844418225 0.58 7 £ 1,104,036 6624216 £ 2,855,745 9 0.1146160147 0.08 0.2476162978 0.67 8 £ 1,580,784 7903920 £ 4,186,914 10 0.1680428038 0.08 0.3622323125 0.75 9 £ 2,814,236 11256944 £ 4,276,248 11 0.1716282454 0.08 0.5302751162 0.83 10 £ 4,078,869 12236607 £ 7,427,304 12 0.2980966384 0.08 0.7019033616 0.92 11 £ 4,242,670 8485340 Total £ 24,915,759 1 1.00 12 £ 7,372,225 7372225 Total: £ 24,137,943 80021310 GINI £ 1 Wrong value-should be 0,53 but excel doesn't work Markets 2013 1 £ 173,905 2086860 2 £ 491,597 5407567 3 £ 496,157 4961570 4 £ 520,051 4680459 5 £ 751,201 6009608 6 £ 961,395 6729765 7 £ 1,201,202 7207212 8 £ 1,574,040 7870200 9 £ 2,855,745 11422980 10 £ 4,186,914 12560742 11 £ 4,276,248 8552496 12 £ 7,427,304 7427304 Total: £ 24,915,759 84916763 GINI 0.5153075376 c) Aldi and LIDL have merged in order to increase their total sales and be able to compete in the market. Together their sales are around 1712000. In this way they can compete with larger companies such as Morrisons and Waitrose. 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 L 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 i y i n ) 1 ( i y i n ) 1 (
Image of page 12
together 2012 2013 Cummulative %of salesCummulative %of salesCummulative % of maret 0 0 0 0.005580219 0.0069797191 0.0833333333 0.023792914 0.0267100834 0.1666666667 0.04364154 0.0466234643 0.25 0.064285138 0.0674958367 0.3333333333 0.091642523 0.0976454701 0.4166666667 0.122012178 0.1362312904 0.5 0.16775079 0.1844418225 0.5833333333 0.23324038 0.2476162978 0.6666666667 0.349830099 0.3622323125 0.75 0.518811731 0.5302751162 0.8333333333 0.694579401 0.7019033616 0.9166666667 1 1 1 Lorenz Curve 2012 Cummulative %of sales Cummulative % of maret Lorenz Curve 2013 Cummulative %of sales Cummulative % of maret 1 2 3 4 5 6 7 8 9 10 11 12 13 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 Lorenz curve 2012&2013 Column W Column X Column Y Lorenz curves are overlapping eachother in most of the times, as such this might indicate that there hasn't been much change in the market from 2012 to 2013.
Image of page 13
Image of page 14

You've reached the end of your free preview.

Want to read all 52 pages?

  • Spring '19
  • Economics, Sula, Flag carrier, Heathrow, Star Alliance, British Airways Plc, IATA members

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture