From the course: Data Analytics for Business Professionals (2022)

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Solution: Make predictions

Solution: Make predictions

From the course: Data Analytics for Business Professionals (2022)

Start my 1-month free trial Buy for my team

Solution: Make predictions

“

- [Instructor] For challenge two, you're going to need the initial state data found in Excel file 02 02. If you'd like to skip right to the answers, you can look in Excel file 02 03. Challenge two asks you to figure out the amount of sales that are within 68% of the mean. To do this, you'll need to use both the average function and to calculate a standard deviation. I'll show you how to do that now. In cell B42, we're going to calculate our average. We're going to use the built-in AVERAGE function, the equal sign, AVERAGE, open parentheses, and then we're going to reference the data found between C7 and C21. We'll close the parentheses, and we'll see our average is 13.7833. Next, we're going to calculate the standard deviation for this data set. We're going to do that in B43. We're going to use the built-in standard deviation function, equal for the formula, and the formula is standard deviation, STDEV, and we're…

Contents