A popular Canadian franchise, Kim Thorton's is looking to open a specialty line of shops that cater to coffee or tea drinkers, not both. The executive team has contracted you, as a statistics consultant, to help make the decision. You have collected data on the market for coffee and tea for the past 23 years. The data is the annual litres per person that has been consumed in Ontario. You will write a report (answer the questions on the test) that includes a one and two variable analysis of the given data and a recommendation to the executive team regarding which type of specialty shop to invest in. Year Tea L/person Coffee L/person 1994 42.4 95.85 1995 42.12 97.28 1996 47.61 87.62 1997 60.56 92.04 1998 55.58 99.21 1999 50.61 95.63 2000 49.89 97.42 2001 56.77 93.93 2002 62.53 95.67 2003 68.31 99.25 2004 69.88 101.31 2005 72.99 101.68 2006 71.36 104.02 2007 90.78 106.09 2008 74.7 105.8 2009 67.15 102.15 2010 67.03 101.15 2011 87.83 104.05 2012 93.4 102.7 2013 78.9 105.28 2014 111.32 108.3 2015 98.39 104.96 2016 105 103.57 1. Put the data given above in a Google spreadsheet or other type of spreadsheet. Be sure to hand in the work that you do on the spreadsheet with the rest of the task to dropbox when the task is completed. (10 marks)1f]. Calculate the mean, median and model interval for the data on tea and coffee using the spread sheet. [5 marks] Calculate the mean and median of the data from the years EDI]? to 216 by hand and shovuI all of your work. [6 marks] Compare the values for the mean and median in question 2 and 3 and indicate why the values might be different. Does the difference have any bean' ng when it comes to your recommendation? [4 marks] Calculate the standard deviation, range, minimum, {11, median, C13, maximum, and "lit values using the spreadsheet. [8 marks] Create histograms [on spreadsheet] for both tea and coffee displaying the number of years in each interval of consumption in Uperson and indicate what type of distribution the histogram shows. [3 marks] Draw box plots [using alcula.com] for both tea and coffee displaying the number of years in each interval of consumption in Uperson. Include these box plots in the dropbox submission. [2 marks] Make one statement about the information given in the box plots. [1 mark] Create scatterplofs for coffee versus year and tea versus year and coffee versus tea [label the axes and give the scatter plots a title]. [4 marks] Create and record the lines of best fit for each of the scatterplofs and show the it2 value for each scatterplot [4 marks] 11. What does the slope and y-intercept mean for each scatterplot? Describe how they pertain to this specific situation. (6 marks) 12. What does the R value reveal about this situation? (2 marks) 13. Use the line of best fit data to extrapolate tea and coffee consumption in the year 2030. Show your work. (4 marks) 14. What is your recommendation for the executive team. Reflect in writing how you used the analysis to come up with the recommendation and include any risks that you see with your recommendation. (10 marks)