Question 3: Analysing sales figures using Statistics (15% out of 45%) Two pet shops are known for their range of caged birds. As such, they sell large numbers of these birds over the course of a calendar year. Over a two-year period, the pet shop owners keep records of bird sales figures from month to month. During the first year, both pet shops sell a similar combination of bird species, but during the second year the second pet shop owner decides to simplify the combination of species sold in Shop 2 and focus more upon the sale of smaller birds, for which cages are easier to obtain and also sell. You are asked to analyse the bird sales figures from both pet shops, comparing sales performance (i) between shops and (ii) between years. Task Analyse the provided sets of data from the two pet shops and make relevant comparisons using appropriate measures of central tendency and spread. Useful Information The sales figures for the two pet shops over the two years are as follows: Birds sold per month by Pet Shop 1 MONTH Birds sold per month by Pet Shop 2 Year 1 Year 2 Year 1 Year 2 28 25 January 24 10 14 15 February 16 16 25 16 March 23 20 17 10 April 9 12 14 4 May 6 15 11 3 June 3 11 5 8 July 7 9 8 5 August 4 15 32 26 September 35 30 19 20 October 16 41 21 15 November 23 49 39 32 December 38 36 Steps to help answer the question: 1. Calculate appropriate descriptive statistics for all sets of data (HINT: Consider Measures of Spread and Measures of Central Tendency). Present full calculations showing how you obtain each of your statistic values (except for Standard Deviation, for which you can use Excel). 2. Put these values into a table (one column for each set of data). 3. Using these statistics, construct appropriate plots which allow you to compare: Year 1 vs Year 2 sales for Pet Shop 1 Year 1 vs Year 2 sales for Pet Shop 2 Year 1 sales for Pet Shop 1 vs Pet Shop 2 Year 2 sales for Pet Shop 1 vs Pet Shop 2 4. Write a Conclusion in which you interpret the results obtained and state in your own words the impact of the change in sales strategy by the second pet shop owner.