• Excel 2016 Statistical Analysis

Excel 2016 for PC – Statistical Analysis

$49.99

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.

Length: 1 hr 20 min

This title is available in the
Total Training All-Access library.

Subscribe Now

Product 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