Excel Statistics

Excel Statistics Training in NYC

The best decisions in business are those that are backed up by data.

Learn how to use statistics in Excel to analyze trends, calculate probability, and accurately forecast results to help you make better decisions.

  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Class 
Call for pricing 7 Hours Mac and PC provided 185 Madison Avenue, NYC In-person classroom training

Corporate & private training available

Email us for information

What you'll learn

  • Statistical & Ranking Functions
  • Statistical Analysis
  • Charts
  • Probability and Forecast Modelling

Full Course Syllabus

Download PDF Outline

Basic Statistics

Statistical Functions

  • These foundational statistical functions can be used to perform basic caluclations on ranges of values

Ranking Functions

  • Rank values to establish percentages and percentiles

Data Analysis Toolpack

  • Quickly and easily perform statistical calculations with the Data Analysis Toolpack add-in

Statistical Analysis

Descriptive Statistics

  • Compare two sets of data by 16 different, statistical measures

t tests

  • Calculates whether the means of two groups are statistically different from each other

Straight Line Analysis

  • Graphically estimate the relationship between two variables

Simple Linear Regrssion

  • Estimate the relationship between two variables

Multiple Regression

  • Estimate the relationship between more than two variables

Charts

Histogram

  • Divide values into intervals and represent the frequency of data values in each interval with a bar

Waterfall chart

  • Visually display how an intitial value is affected by a series of positive and negative values

Probability and Forecast Modelling

POISSON Distribution

  • Calculate the probability of a given number of events occurring in a fixed interval of time or space

Solver

  • Calculate optimal solutions to multi-variable decision problems

Monte Carlo simulation

  • Better understand the impact of risk and uncertainty in forecasting models

Resampling

  • Make statistical inferences from data by sampling with replacement