Shared Flashcard Set

Details

Review of Formulas and Mircosoft Excel
Reviewing these will help refresh what each formula stands for and how to solve for these statistics on Microsoft Excel
22
Mathematics
10th Grade
10/05/2014

Additional Mathematics Flashcards

 


 

Cards

Term
Review of some Statistic formula's and key terms
Definition
Term
[image]
Definition
Mean or Average Formula
Term
[image]
Definition
Sample Standard Deviation
Term
What is the Mode of a set of data?
Definition
Mode is the value that appears most often in a set of data.
Term

True or False

You have to rewrite the data in order from least to greatest first before figuring out the median.

Definition
True
Term
[image]
Definition
Sample Variance
Term
[image]
Definition
Population Variance
Term
[image]
Definition
Population Standard Deviation
Term

What is the percentage of the values that are within the range of 1 standard deviation of the mean when dealing with a bell curve?

[image]

 

Definition
68 %
Term

What is the percentage of the values that are within the range of 2 standard deviation of the mean when dealing with a bell curve?

[image]

Definition
95 %
Term

What is the percentage of the values that are within the range of 3 standard deviation of the mean when dealing with a bell curve?

[image]

Definition
99.7 %
Term
How do you Calculate some of these Statistics in Microsoft Excel?
Definition
Term
Sample Standard Deviation
Definition
=STDEV(
Term
Population Standard Deviation
Definition
=STDEVP(
Term
Mean or Average
Definition
=AVERAGE(
Term
Population Variance
Definition
=VARP(
Term

Sample Variance

 

Definition
=VAR(
Term
Median
Definition
=MEDIAN(
Term
Mode
Definition
=MODE(
Term

True or False

=SQRT(VAR(

Will also get you the sample standard deviation in Excel?

Definition
True
Term
Square Root
Definition
=SQRT(
Term

The operation of Multiplication

 

Definition
shift key + 8 which is the symbol *
Supporting users have an ad free experience!