From the course: Complete Guide to Excel Statistics with Copilot
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Descriptive tool exercise
From the course: Complete Guide to Excel Statistics with Copilot
Descriptive tool exercise
- [Instructor] All right, we've just learned about how to use Excel's Descriptive tool with a few different datasets. Now let's put many of the topics we've covered in this course to work by using Excel's Descriptive tool and also the Histogram tool. So here are a few datasets that we've looked at at least a little bit throughout this course. The Rainfall, NBA Player Heights, and some Exam Scores. But instead of building our means, our medians, our modes, our kurtosis, doing all of those one at a time, let's use the Descriptive tool. So again, we go up to our Data menu, Data Analysis. We go to our Descriptive Statistics, click OK. We want our Input Range to yes, be B. Columns. We do have a label in the first row. We want our Summary statistics and we're going to put our data into, let's say D1. We click OK. And here we go. Our summary statistics. And we can adjust our decimals if we'd like. Notice we don't have a mode. Our mean is 46.23, our median 43.79. And we can even see from our…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.