Instructions: This is a technology only Assignment. Use google spreadsheet, desmos, excel or any other statistical software to get this done. 1. The number of customers that visited a coffee store was recorded for one day Coffee Store Number of Customers Country Style 283 Second Cup 467 Tim Hortons 692 Timothy's 330 Star bucks 196 Coffee time 150 Serious Coffee 278 Represent the data above in 2 ways. [10 marks] 2. A computer sale company wants to determine the effectiveness of their telemarketing division. The following data is collected each month over a 2 year period. Sales Period Sales Calls Deals Closed January 2019 20 53 February 2019 28 34 March 2019 40 67 April 2019 17 26 May 2019 45 73 April 2019 12 50 June 2019 30 60 July 2019 20 40 August 2019 35 55 September 2019 37 25 October 2019 15 40 November 2019 20 30 December 2019 42 65 January 2020 27 30 February 2020 48 80 March 2020 24 18 April 2020 30 60 May 2020 50 41 June 2020 13 41 July 2020 26 47 August 2020 50 74 September 2020 23 36 October 2020 35 70 November 2020 29 54i) Determine the mean, median and mode for the sales calls. Which do you think is the best measure of central tendency? Why? in) Determine the mean, median and mode for the deals closed. Which do you think is the best measure of central tendency? Why? iii) Determine the standard deviation for both sales calls and the deals made, Which data set is more consistent? How do you know? iv) Determine the quartiles and interquartile range for both sale calls and deals made. Display this information for each data set on a box-and-whiskers plot. Compare both box plots. Are there any similarities or differences you observe? PART B [10 marks] Perform linear regression analysis on your data. i) Create a scatter plot and line of best fit showing the relationship between the variables ii) What is the correlation co-efficient? What type of correlation exist? What does it tell you about the relationship that exist between the variables? iii) What is the equation of the line of best fit and co-efficient of determination? Use your equation to predict the number of deals closed if 65 calls are made? PART C [10 marks] Explore the non-linear regression models we have learnt. Which model is the best in your opinion? Explain why. Include a scatter plot, curve of best fit and the coefficient of determination? Is the non-linear model a better fit for your data than the linear model? Explain why