# CIS111E Chapter 8-Statistical Functions

The flashcards below were created by user davecowman on FreezingBlue Flashcards.

1. SUMIF function (p. 467)

=SUMIF(range,criteria,sum_range)
Calculates the total of a range of values when a specified condition is met.
2. AVERAGEIF function (p. 467)

=AVERAGEIF(range,criteria,average_range)
Calculates the average of values in a range when a specified condition is met.
3. COUNTIF function(p. 467)

=COUNTIF(range,criteria)
Counts the number of cells in a range when a specified condition is met.
4. SUMIFS function (p. 468)

=SUMIFS(sum_range,criteria_range1 ,criteria1 ,criteria_range2,criteria2...)
Calculates the total value of cells in a range that meet multiple criteria.
5. AVERAGEIFS function (p. 468)

AVERAGEIFS(average_range,criteria_range1 ,criteria1 ,criteria_range2,criteria2...)
Calculates the average value of cells in a range that meet multiple criteria.
6. COUNTIFS function (p.468)

COUNTIFS(criteria_range1 ,criteria1,criteria_range2,criteria2...)
Counts the number of cells in a range that meet multiple criteria.
7. RANK.EQ function (p. 469)

=RANK.EQ(number,ref,[order])
Identifies the rank of a value, omitting the next rank when tie values exist.
8. RANK.AVG function (p. 469)

=RANK.AVG(number,ref,[order])
Identifies the rank of a value but assigns an average rank when identical values exist.
9. PERCENTRANK.INC function (p. 470)

=PERCENTRANK.INC(array,x,[significance])
Identifies a value's rank as a percentile between 0 and 1, of a list of values
10. PERCENTRANK.EXC function (p. 470)

=PERCENTRANK.EXC(array,x,[significance])
Identifies a value's rank as a percentile, excluding 0 and 1, of a list of values.
11. Quartile (p. 471)
Is a value used to divide a range of numbers into four equal groups.
12. QUARTILE.INC function (p. 471)

=QUARTILE.INC(array,quart)
Identifies the value at a specific quartile.
13. QUARTILE.EXC function (p. 471)

=QUARTILE.EXC(array,quart)
Identifies the value at a specific quartile, exclusive of 0 and 4.
14. PERCENTILE.INC function (p. 472)

=PERCENTILE.INC(array,k)
Identifies the kth percentile of a specified value within a list of values, including the 0th and 100th percentile
15. PERCENTILE.EXC function (p. 472)

=PERCENTILE.EXC(array,k)
Identifies a value at a specified percentile; however, the .EXC excludes 0th and 100th percentile.
16. Population (p. 479)
Is a dataset that contains all the data you would like to evaluate.
17. Sample (p. 479)
Is a smaller, more manageable portion of the population.
18. Variance (p. 479)
A descriptive statistic tool that determines the summation of the squared deviations divided by the amount of the n-1.
19. Standard Deviation (p. 479)
Measures how far the data sample is spread around the mean.
20. CORREL function (p. 480)

=CORREL(Array1,Array2)
Calculates the correlation coefficient of two data series.
21. Frequency function (p. 480)

=FREQUENCY(Data_array,Bins_array)
Determines the number of occurrences of numerical values in a dataset based on predetermined bins.
22. Analysis ToolPak (p. 486)
An add-in program that contains tools for performing complex statistical analysis.
23. ANOVA (p. 486)
A statistical tool that compares the means between two data samples to determine if they were derived from the same population
24. Covariance (p. 488)
Measure of how two sample sets of data vary simultaneously
25. Histogram (p. 488)
A tabular display of data that displays the frequencies of occurrence organized into bins.
 Author: davecowman ID: 310653 Card Set: CIS111E Chapter 8-Statistical Functions Updated: 2015-10-30 20:41:00 Tags: Chapter8 Folders: Description: Statistical Functions Show Answers: