Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need a detailed response on this question. Q: 5 The number of visitors to a cycle track and the number of drinks sold by a

Need a detailed response on this question.

image text in transcribed
Q: 5 The number of visitors to a cycle track and the number of drinks sold by a cafe at the location are recorded in the table below. Monday Tuesday Wednesday Thursday Friday Saturday Sunday Number of visitors 32 45 39 43 58 84 65 Drinks sold 17 20 23 7 24 49 38 (a) Construct the scatter diagram in Excel. Steps: 1. Copy the data in two columns of excel and highlight the two columns. 2. Go to 'insert' tab and choose scatter plot. (b) Draw, by eye, a line of best fit on the scatter diagram. (c) Describe the relationship between the number of visitors and the number of drinks sold. (d) Which particular day does not fit the relationship

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Essentials of Business Analytics

Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

2nd edition

1305627733, 978-1305861817, 1305861817, 978-0357688960, 978-1305627734

More Books

Students also viewed these Mathematics questions

Question

critically compare make or buy alternatives

Answered: 1 week ago

Question

Explain the strength of acid and alkali solutions with examples

Answered: 1 week ago

Question

Introduce and define metals and nonmetals and explain with examples

Answered: 1 week ago