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.

OBJECTIVE

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.

CONTENT

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

LENGTH

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.