Find Leading Indicators Using Automated Cross Correlations in Excel, Part 2
In Part 1 of this discussion about automated cross correlations, I explained how to set up the cross-correlation Data Table shown below, in columns...
Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1
It all seems so simple...
To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...
How to Create Monte Carlo Models and Forecasts Using Excel Data Tables
(Download the workbook.)
(This is the second of two articles about normal distributions. The first article is, How to Return Random Numbers from a Normal...
How to Return Random Numbers from a Normal Distribution for Your Excel Forecasts
(This is the first of two articles about normal distributions. The second article is, How to Create Monte Carlo Models and Forecasts Using Excel Data...
An Introduction to Excel’s Normal Distribution Functions
(Download the workbook.)
When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
How to Create Normal Curves With Shaded Areas in Excel
Adding shaded areas to normal curves like this is a challenging task in Excel charting. But once you know how, it's not difficult to...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement