text.skipToContent text.skipToNavigation
  1. Home
  2. Business & Economics
  3. FT Press
  4. Predictive Analytics: Microsoft Excel

Predictive Analytics: Microsoft Excel, 1st edition

  • Conrad Carlberg

Published by Que Publishing (July 2nd 2012) - Copyright © 2013

1st edition

Chosen format
View all
Predictive Analytics: Microsoft Excel

ISBN-13: 9780789749413

Includes: Paperback
Free delivery
$39.99

What's included

  • Paperback

    You'll get a bound printed text.

Overview

Table of contents

Introduction

Chapter 1 Building a Collector

Planning an Approach

    A Meaningful Variable

    Identifying Sales

Planning the Workbook Structure

    Query Sheets

    Summary Sheets

    Snapshot Formulas

    More Complicated Breakdowns

The VBA Code

    The DoItAgain Subroutine

    The GetNewData Subroutine

    The GetRank Function

    The GetUnitsLeft Function

    The RefreshSheets Subroutine

The Analysis Sheets

    Defining a Dynamic Range Name

    Using the Dynamic Range Name

Chapter 2 Linear Regression

Correlation and Regression

    Charting the Relationship

    Calculating Pearson’s Correlation Coefficient

    Correlation Is Not Causation

Simple Regression

    Array-Entering Formulas

    Array-Entering LINEST()

Multiple Regression

    Creating the Composite Variable

    Analyzing the Composite Variable

Assumptions Made in Regression Analysis

    Variability

Using Excel’s Regression Tool

    Accessing the Data Analysis Add-In

    Running the Regression Tool

Chapter 3 Forecasting with Moving Averages

About Moving Averages

    Signal and Noise

    Smoothing Versus Tracking

    Weighted and Unweighted Moving Averages

Criteria for Judging Moving Averages

    Mean Absolute Deviation

    Least Squares

    Using Least Squares to Compare Moving Averages

Getting Moving Averages Automatically

    Using the Moving Average Tool

Chapter 4 Forecasting a Time Series: Smoothing

Exponential Smoothing: The Basic Idea

Why “Exponential” Smoothing?

Using Excel’s Exponential Smoothing Tool

    Understanding the Exponential Smoothing Dialog Box

Choosing the Smoothing Constant

    Setting Up the Analysis

    Using Solver to Find the Best Smoothing Constant

    Understanding Solver’s Requirements

    The Point

Handling Linear Baselines with Trend

For teachers

All the material you need to teach your courses.

Discover teaching material