Chapter 11

Rolling the Dice on Predictions and Probability

IN THIS CHAPTER

Bullet Understanding linear and exponential models

Bullet Using SLOPE and INTERCEPT to describe linear data

Bullet Predicting future data from existing data

Bullet Working with normal and Poisson distributions

When you’re analyzing data, one of the most important steps is usually to determine what model fits the data. No, I'm not talking about a model car or model plane! This is a mathematical model or, put another way, a formula that describes the data. The question of a model is applicable to all data that comes in X-Y pairs, such as the following:

  • Comparisons of weight and height measurements
  • Data on salary versus educational level
  • Number of fish feeding in a river by time of day
  • Number of employees calling in sick as related to day of the week

Modeling

Suppose now that you plot all the data points on a chart — a scatter chart, in Excel terminology. What does the pattern look like? If the data is linear, the data points fall more or less along a straight line. If they fall along a curve rather than a straight line, they aren’t ...

Get Excel Formulas & Functions For Dummies, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.