- 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 y-intercept 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 one-tailed Z-Test
- Finding the probability associated with a Student’s T-Test for paired samples
- Finding the critical value of the Student’s T-Test for paired samples
- Examining data for homogeneity of variance using F-TEST function
- Finding the critical value of the F-test
- Finding the probability associated with a student’s T-Test for independent samples
- Finding the critical value of the student’s T-Test for independent samples
- Finding the probability associated with a chi-squared test for independence
- Finding the critical value of the chi-squared test for independence
-
- D. Data Analysis ToolPak
-
- Activating the data analysis ToolPak
- Finding descriptive statistics
- Create a histogram
- Performing a T-test for paired or related samples
- Examining data for homogeneity of variance
- Performing a T-test for independent or unrelated samples
- Performing a one-way 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