### Description

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.

**Sample clip**

**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. Printing Options & Copying a Pivot Table**

Printing a Pivot Table with column and row field

Insert page breaks after each row item

Copy a Pivot Table

**E. 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