Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following data that is relevant for this decision: The data is also in this Excel Spreadsheet The data is the annual litres per

Consider the following data that is relevant for this decision: The data is also in this Excel Spreadsheet

The data is the annual litres per person that has been consumed in Ontario.

Year Tea (L per person) Coffee (L per person)
1998 42.4 95.85
1999 42.12 97.28
2000 47.61 87.62
2001 60.86 92.04
2002 55.58 99.21
2003 50.61 95.63
2004 49.89 97.42
2005 56.77 93.93
2006 62.53 95.67
2007 68.31 99.25
2008 69.88 101.31
2009 72.99 101.68
2010 71.36 104.02
2011 90.78 106.09
2012 74.7 105.8
2013 67.15 102.15
2014 67.03 101.15
2015 87.83 104.05
2016 93.4 102.7
2017 78.9 105.28
2018 111.32 106.3
2019 98.39 104.96
2020 105.25 103.57
  1. Calculate all the measures of central tendency and spread for coffee and tea.
  2. Create Histograms and Box-Plots for both coffee and tea, displaying the number of years in each interval of consumption in L/person.

Place this information in your report (word processing document), you don't need to include the original data.

Use all the information you have created to answer the following questions.

  1. Use your measures of central tendency. measures of spread, histograms and box plots to compare the amount of coffee and tea consumed in Ontario over the time span. Clearly justify your thoughts.
  2. Compare your scatterplots, lines of best fit and correlation coefficients. In your comparison discuss the relevance of the slopes and values of the correlation coefficients. Extrapolate the appropriate lines to estimate the amount of each beverage consumed in 2022 and comment on the accuracy or reliability of the estimate by referring to the correlation coefficients. Give your thoughts on the type of correlation (Activity 5) that you believe is present.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Mathematics questions

Question

What is cost incurred?

Answered: 1 week ago

Question

Compute cost of goods sold using the following information

Answered: 1 week ago

Question

Determine Leading or Lagging Power Factor in Python.

Answered: 1 week ago