 Excel 2016 – Statistical Analysis

 A. Describing Data

 What you’ll learn in this training
 Finding the arithmetic mean
 AVERAGEA function
 AVERAGEIF function
 AVERAGEIFS function
 Find the geometric mean
 Find the median
 Find the mode
 Find the standard deviation
 Use the STDEVA functions
 Find the variance
 Use the VARA functions
 Find the kurtosis of a distribution
 Find the skewness of a distribution
 Find the confidence interval
 Use the FREQUENCY function
 Find the quartile of a data set
 Ranking values
 Finding a value’s standard score

 B. Comparing Variables

 Find the bivariate correlation coefficient
 Find the values associated with a linear regression
 Find linear slope
 Find the yintercept of a linear regression
 Predict a future value using an existing value
 TREND function
 Find the values associated with an exponential regression
 Predicting values along an exponential curve using existing values

 C. Tests of Significance

 Finding the probability of a onetailed ZTest
 Finding the probability associated with a Student’s TTest for paired samples
 Finding the critical value of the Student’s TTest for paired samples
 Examining data for homogeneity of variance using FTEST function
 Finding the critical value of the Ftest
 Finding the probability associated with a student’s TTest for independent samples
 Finding the critical value of the student’s TTest for independent samples
 Finding the probability associated with a chisquared test for independence
 Finding the critical value of the chisquared test for independence

 D. Data Analysis ToolPak

 Activating the data analysis ToolPak
 Finding descriptive statistics
 Create a histogram
 Performing a Ttest for paired or related samples
 Examining data for homogeneity of variance
 Performing a Ttest for independent or unrelated samples
 Performing a oneway analysis of variance (ANOVA)
 Performing a factorial analysis of variance (ANOVA)
 Performing a repeated measures analysis of variance (ANOVA)
 Finding the correlation of two or more variables
 Performing a linear regression