Chapter 8 - Statistical Function Flashcards
A statistical tool that compares the means between two data samples to determine if they were derived from the same population.
ANOVA
The** level of accuracy** of the forecast
Standard error
Statistical function that returns the square of the Pearson product moment correlation coefficient through the given data points.
RSQ Function
Add-in program that contain tools for performing compex statistical analysis.
Analysis ToolPak
A measure of data set’s dispersion such as different between highest and the lowest point in the data.
Variance
A measure of how far** **the data sample is spread around the mean.
Standard Deviation
A calculation of the number of occurences of numeric values in a data set based on predetermined bins.
FREQUENCY Function
Statistical function that determines** the strength of relationship between 2 variables.
CORREL Function
Visualization that shows patterns in the data
Trendline
Statistical function that **return kth smallest value **in the data set
SMALL Function
S.F that returns the standard error of the predicted y-value for each x in a regression.
STEYX Function
Dataset that contains all the information you would like to evaluate.
Population
Statistical function that retuns the** slope of the linear regression** through the given points.
SLOPE Function
S.F that returns the kth largest value in the dataset.
LARGE Function
S.F that 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**.
INTERCEPT Function
