Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 1 . There are a couple of ways get some basic summary statistics about a range of data. In cell A 2 on the

11. There are a couple of ways get some basic summary statistics about a range of data. In cell A2 on the Statistics worksheet, use the appropriate formula to find the average (mean) of the data in B2:B91 on your Yeti Sales worksheet. Use the named range you created in step 3 to create the formulas.
a.In Cell B2, use the appropriate formula to find the minimum of the Sales data.
b.In Cell C2, use the appropriate formula to find the maximum of the Sales data.
c.In Cell D2, use the appropriate formula to find the median of the Sales data.
12.In Cell E2, use the appropriate formula to find the Standard Deviation (of a sample) of the Sales data.The values rendered by the formulas in cells A2 and E2 respectively have, by default, more decimal places than are needed. Use ROUND to round the numbers in cells A2 and E2 to the nearest 10th (or 1 decimal place). HINT: For cells A2 and E2 you will need to "wrap" your functions in a ROUND function. This will end up looking like this:
=ROUND(AVERAGE(appropriate Range), number of digits to round to)
In cell B6 create a formula that counts up how many Sundays, Mondays, Tuesdays, etc that are included in the column C (Day of Week) on your Yeti Sales worksheet. In an earlier step you named this cell range as DayOfWeek so you should use that named cell range as the "range" parameter in your formula.
Copy the formula from B6 to B12 and each cell should accurately count how many occurrences of Sunday, Monday, etc appear in that cell range WITHOUT you having to edit the formula in each of those cells in any way!

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

Students also viewed these Databases questions