Answered step by step
Verified Expert Solution
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
There are a couple of ways get some basic summary statistics about a range of data. In cell A on the Statistics worksheet, use the appropriate formula to find the average mean of the data in B:B on your Yeti Sales worksheet. Use the named range you created in step to create the formulas.
aIn Cell B use the appropriate formula to find the minimum of the Sales data.
bIn Cell C use the appropriate formula to find the maximum of the Sales data.
cIn Cell D use the appropriate formula to find the median of the Sales data.
In Cell E use the appropriate formula to find the Standard Deviation of a sample of the Sales data.The values rendered by the formulas in cells A and E respectively have, by default, more decimal places than are needed. Use ROUND to round the numbers in cells A and E to the nearest th or decimal place HINT: For cells A and E you will need to "wrap" your functions in a ROUND function. This will end up looking like this:
ROUNDAVERAGEappropriate Range number of digits to round to
In cell B 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 B to B 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started