Variance and Standard Deviation using EXCEL

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?

• 2

• 16

• 4

Open Ended

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

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).