Variance and Standard Deviation using EXCEL

Presentation

•

Mathematics

•

10th - 11th Grade

•

Hard

•

CCSS

6.SP.B.5C, 6.SP.A.3

Standards-aligned

Elizabeth Borres

Used 3+ times

FREE Resource

14 Slides • 11 Questions

Variance and Standard Deviation using EXCEL

Elizabeth Borres

At the end of the lessons, students should be able to:

find the MEAN, VARIANCE, and Standard Deviation using EXCEL.

Multiple Choice

To find the _________ you add up all the numbers and then divide by how many numbers you have.

Mean

Median

Mode

Range

Multiple Choice

Which of the following is a measure of variability?

mean

median

mode

standard deviation

Multiple Choice

the square of this value will give the variance

standard deviation

variance

mean

median

Multiple Choice

What does this symbol represent?

Standard Deviation

Variance

Mean Absolute Deviation

Sigma

Multiple Choice

How do you calculate the standard deviation?

Divide the variance by 2.

Its a long process and I can't explain it right now.

Find the mean and multiply it by the variance.

Take the square root of the variance.

Multiple Choice

Before you can begin calculating the variance, you must first:

find the mean

find the median

find the mode

find the range

Multiple Choice

What does variance represent?

How many different variations are in the data set.

How the population varies compared to the sample.

How spread out each data value is from the mean.

The range, but with a bunch of other stuff going on.

Multiple Choice

What does this symbol represent?

Variance

Standard Deviation

Mean Absolute Deviation

Sigma

Multiple Choice

If the standard deviation of a data set is 4, what is the variance?

Open Ended

Any clarifications in finding for the measures of variability for ungrouped data?

Type response here

How to find the mean, the variance and standard deviation using Excel?

Please prepare, take down notes and ask if you are confused.

Step #1

Get the total of the frequency (N).

Step #2

Make a Column for Lower Limit (LL) and the Upper Limit (UL).

Step #3

Get the midpoint (Xm). Add the LL and the UL then divide by 2.

Step # 4

Multiply the frequency (f) and the midpoint (Xm)

Step # 5

Make a Column for the Mean

Poll

Do you have any questions or clarifications?

Step # 6

Subtract the midpoint and the mean.

Step #7

Get the square of the product of the midpoint and the mean.

Step #8

Multiply the frequency by the square of the product of the midpoint and the mean. Then add.

Step #9

Finally, plug in the value in the formulas.

Now, manual computations were given, you decide which solution or process is easier for you.

(If you have any questions, please type it in the chat box, if none, please RAISE YOUR HAND).

Variance and Standard Deviation using EXCEL

Elizabeth Borres

Show answer

Auto Play

Slide 1 / 25

SLIDE

Similar Resources on Wayground

19 questions

Verify Trig Identities (Adv. Ex.)

Presentation

•

11th Grade

20 questions

Factoring Review Lesson

Presentation

•

10th Grade

18 questions

Matrices

Presentation

•

9th - 11th Grade

18 questions

Writing Linear Equations

Presentation

•

9th - 11th Grade

20 questions

Solving equations

Presentation

•

9th - 12th Grade

20 questions

Operations on Functions

Presentation

•

10th - 11th Grade

20 questions

Points, Lines and Planes

Presentation

•

9th - 11th Grade

Popular Resources on Wayground

10 questions

Safety Day 2026 – Student Review

Quiz

•

9th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

Discover more resources for Mathematics

10 questions

Exploring the Basics of Exponents

Interactive video

•

6th - 10th Grade

20 questions

Unit 5 Test RSC (25-26)

Quiz

•

10th Grade

12 questions

Identify Rigid Transformations

Quiz

•

8th - 12th Grade

10 questions

Complementary, Supplementary, Vertical, and Linear Pairs

Quiz

•

9th - 12th Grade

10 questions

Solving Two-Step Equations with Negatives

Interactive video

•

6th - 10th Grade

22 questions

Identify Vertical and Horizontal Translations

Quiz

•

9th - 12th Grade

10 questions

Exploring Equivalent Ratios and Ratio Tables

Interactive video

•

6th - 10th Grade

10 questions

Graphing Inequalities on a Number Line

Quiz

•

9th - 12th Grade