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.

Solution: Summarize and analyze business data

Solution: Summarize and analyze business data - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial

Solution: Summarize and analyze business data

“

(upbeat music) - [Instructor] In the previous movie, I described a set of challenges working with the skills that you learned in Chapter 1. Once again, we're working with 30 days of sales data, and we can see that over here on the left in columns A and B, I have the sales broken down by day and you see that we do in fact have 30 days of data. In column D, I have a list of summaries that I would like to perform and we can do that in column E. So in cell E5, the first thing I want to do is calculate the mean or average of the values in column B. So in E5, which I've already clicked, I will type an equal sign. And the average function is average. And, again, that's also called the mean. The range is B4 through B33, and that won't be copying this formula so I don't need to worry about absolute or relative references. Press Enter, and I see the average is about $1,319.47 of sales per day. If I were to sort those values…

Contents