Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Microsoft Excel 2016 PC : Statistical Analysis Online Training Course

Microsoft Excel 2016 PC : Statistical Analysis Online Training Course

[ TTEX2016STAT ]

£27.00 £48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


Course Description

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 course 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.

This training course is for Microsoft Office Excel 2016 for Windows.

Course Outline

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

PACKAGE INCLUDES:
  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 1h 20min
  • Platform:  Windows
  • Level: Beginner to Advanced
  • Project Files: Included


Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.

If you'd like a Free Demo of this product then please complete the form here :

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.


More from this collection