Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Using Statistical Functions in Excel | Excel Basic Data Analysis
Data Analysis with Excel
course content

Course Content

Data Analysis with Excel

Data Analysis with Excel

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

book
Using Statistical Functions in Excel

Statistical functions in Excel are essential tools for analyzing data to uncover underlying patterns and trends.

These functions help in making informed decisions based on quantitative data analysis.

Task

Let's get some hands-on practice with these functions. Here's what you need to do:

  • Determine the average Total Sales for Electronics in New York.
  • Calculate the standard deviation of the Total Sales population.

1. What is the average Total Sales for Electronics in New York that you calculated? (select the nearest number)

2. What is the standard deviation of the Total Sales population that you calculated? (select the nearest number)

question mark

What is the average Total Sales for Electronics in New York that you calculated? (select the nearest number)

Select the correct answer

question mark

What is the standard deviation of the Total Sales population that you calculated? (select the nearest number)

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

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