Microsoft® Excel® boasts a robust collection of statistical functions. This Excel 2016 for PC – Statistical Analysis online training series will demonstrate some of these functions from the simple to the complex, as well as how to perform more complex analysis by activating Excel’s Data Analysis ToolPak.

In this in-depth Excel 2016 for PC – Statistical Analysis online training series presented by Dan Fanella, PhD, you’ll learn about describing data, comparing variables, tests of significance, performing a liar regression, and so much more. By the time you’ve completed this course, you’ll be an expert on topics such as creating a histogram, finding the linear slope, and finding the geometric mean.

- 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

- 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

- 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

- Printing a Pivot Table with column and row field
- Insert page breaks after each row item
- Copy a Pivot Table

- 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

1 hr 20 min

Frequently Asked Questions

**Total Training**

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.