Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Statistical Charting | Data Visualization and Automation
Data Analysis with Excel
course content

Course Content

Data Analysis with Excel

Data Analysis with Excel

1. Data Management and Manipulation
2. Basic Data Analysis
3. Data Visualization and Automation
4. Advanced Data Analytics Techniques

book
Statistical Charting

In addition to the general purpose charts discussed in the previous chapter, there are also statistical charts that do more than just display raw data — they calculate statistical insights.

These charts are crucial for visualizing data distributions and uncovering underlying patterns, which are key for thorough data analysis.

By understanding these visualizations, you can gain deeper insights into dataset variability, central tendency, and outliers.

Task

Now, let's create some visualizations:

  • Plot a histogram for the Marketing_Expense column.
  • Generate a box plot using the Region and Units_Sold columns. Remember, you can select multiple columns by holding the Ctrl key while clicking.
Which type of chart would you use to compare median values across different categories?

Which type of chart would you use to compare median values across different categories?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 2
We're sorry to hear that something went wrong. What happened?
some-alt