excel chapter 8 terms

An add-in program that contains tools for performing complex statistical analysis, such as ANOVA, correlation, and histogram.

Stands for Analysis of Variance and is a statistical tool that compares the means between two data samples to determine if they were derived from the same population.

Data ranges in which values can be categorized and counted.

A statistical function that determines the strength of a relationship between two variables.

A business intelligence feature that creates a forecast worksheet to detail trends based on historical data.

A statistical function that calculates, or predicts, a future value along a linear trend by using existing values.

A statistical function that determines the number of occurrences of numeric values in a dataset based on predetermined bins.

A chart that is similar to a column chart. The category axis shows bin ranges (intervals) where data are aggregated into bins, and the vertical axis shows frequencies.

A statistical function that calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted through the known x-values and y-values.

A statistical function that returns the kth largest value in a data set.

A dataset that contains all the information you want to evaluate.

A value used to divide a range of numbers into four equal groups.

Short for R-square, the RSQ function is a statistical function that returns the square of the Pearson product moment correlation coefficient through the given data points.

A smaller portion of the population that is easier to evaluate.

A statistical function that returns the slope of the linear regression line through the given data points.

A statistical function that returns the kth smallest value in a dataset.

A statistic that measures how far the data sample is spread around the mean.

The level of accuracy of the forecast.

A statistical function that returns the standard error of the predicted y-value for each x in a regression.

a visualization that shows patterns in your data.

A measure of a dataset's dispersion, such as the difference between the highest and lowest points in the data.