The Complete Excel Guide: Beginners to Advanced - Statistical Functions for Description - Part 2

The Complete Excel Guide: Beginners to Advanced - Statistical Functions for Description - Part 2

Assessment

Interactive Video

Information Technology (IT), Architecture, Mathematics

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers statistical measures of spread, including median, quartiles, interquartile range, standard deviation, and variance. It explains how to calculate these measures using Excel 2019, with a focus on understanding the differences between quartile functions and the importance of choosing the correct standard deviation function. The tutorial also includes a practical example comparing sales data from two branches, highlighting the use of descriptive statistics to analyze and compare data sets.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF