Friday, July 1, 2022
Home Business & Economics Analytical Methods

# Analytical Methods

Excel techniques to analyze and display data in different ways, typically using economic data as examples.

### A Lesson in Excel Analysis Learned from Rising US Inflation

Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...

### Use Benford’s Law & Charts in Excel to Improve Business Planning

Unless you're a public accountant, you probably haven't experimented with Benford's Law. Auditors sometimes use this fascinating statistical insight to uncover fraudulent accounting data. But it might reveal...

### Should You Raise Prices? Should You Lower Them? Derivation of the Formula For Planning...

The article, Should You Raise Prices? Or Should You Lower Them? These Excel Charts Can Help You Answer Those Questions, introduces the Price-Change formula....

### Predict Business Bankruptcy Using Z Scores with Excel

"General Motors Corp. and Ford Motor Co., the two biggest U.S. automakers, have about a 46 percent chance of default within five years, according...

### How to Count the Occurrences of Items in a List

"I have a list of repair orders (RO). I want to know how many one line repair orders there are in the list. So...

### How Excel’s MIRR Function Can Fix the IRR Function

The calculation of an Internal Rate of Return is very appealing...at first glance. When you know the IRR of a prospective investment, you seem to...

### Two Business Uses for Excel’s New Chart Feature

For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...

### How to Show Recessions in Excel Charts

I showed you the following figures in Chart Your Rate of Change to Reveal Hidden Business Performance. The line in the first chart below shows Apple's...

### Chart Your Rate of Change to Reveal Hidden Business Performance

What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years? I see three things. First, their...

### What Inflation? How Excel Charts Can Help You Avoid Fake Economic News

The business news on Valentine's Day, 2018, was dominated by talk of rising inflation. A search of Google News showed 67,100 results for the...

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

### Consumer Sentiment Suggests a 2022 Recession

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...

### Simple Transformations Can Reveal Hidden Patterns in Your Data

Excel users have at least two significant advantages over business professionals who rely on other analytical and reporting tools. First advantage: We Excel users can...
Advertisement