# Excel Statistics

Canonical URL: <https://training-nyc.com/courses/excel-statistics>

## Overview

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.

This course is available for private and corporate training. Email or call us for more information. For regularly scheduled courses, see all our [Excel classes in NYC](/course_groups/excel-classes-nyc).

## What you'll learn

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

## Curriculum

### 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

## Pricing

**Tuition:** $0