From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

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

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_2_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…

Contents