From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Challenge: Summarize operational data visually

Challenge: Summarize operational data visually - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Challenge: Summarize operational data visually

“

(upbeat music) - [Instructor] To close out this chapter, I would like to ask you to practice some of the skills that you have learned. In this workbook, named Chapter two Challenge, which you can find in the chapter two folder of your Exercise Files collection, I have set up a workbook and I would like you to perform three tasks. The first in column D is to calculate a running average for sales data that is found in column C. To remind you what a running average is in cell D5, you would calculate the average for cells C4 and C5. In D6, it would be C4 through C6 and so on. Then I would like you to create a histogram based on sales data, which divides daily sales into a number of bins, and then also to create an XY scatter chart that would indicate the relationship, if any, between the number of customers in column B and the corresponding sales level in column C. With that in mind, go ahead and perform these tasks and I will come back in the next movie and show you one way to solve it.

Contents