Thursday, November 13, 2025
Linkedin
Linkedin
Home Business & Economics Analytical Methods

Analytical Methods

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

    Random
    When you include recessions and economic downturns in your charts, you can show your company's performance in a much better context. Here's how to set up your Excel charts to display those recessions and downturns.

    How to Show Recessions in Excel Charts

    Analytical Methods Charley Kyd - 0
    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...
    Beginning in Excel 2016 in Office 365, your formulas can set gaps in your line and scatter charts. Here are two ways to use the feature in your reports.

    Two Business Uses for Excel’s New Chart Feature

    Analytical Methods Charley Kyd - 0
    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...
    In a list of items that could appear in a worksheet any number of times, here's how to count the number of items that appear only once. Or twice. And so on.

    How to Count the Occurrences of Items in a List

    Analytical Methods Charley Kyd - 0
    "I have a list of repair orders (RO). I want to know how many one line repair orders there are in the list. So...
    Benford's Law reveals an amazing characteristic of data. Not only does it help to identify fraud, it could help you to improve budgets and forecasts.

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

    Analytical Methods Charley Kyd - 0
    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...

    A Lesson in Excel Analysis Learned from Rising US Inflation

    Analytical Methods Charley Kyd - 0
    Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...
    How healthy is your company? Here's a mathematical method that can help you to predict whether a business is headed for bankruptcy…if it's still accurate.

    Predict Business Bankruptcy Using Z Scores with Excel

    Analytical Methods Charley Kyd - 0
    "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...
    By charting the annual Rate Of Change (ROC) of key measures, you can uncover significant information about your time-series data. And by using the right recession measure, you can put that information into better context.

    Chart Your Rate of Change to Reveal Hidden Business Performance

    Analytical Methods Charley Kyd - 0
    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...
    On Valentine's Day, 2018, tens of thousands of major sites warned their readers that inflation is rising. But that might not be true. These analytical Excel charts suggest a different conclusion.

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

    Analytical Methods Charley Kyd - 0
    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...
    Here's how I created the formula that calculates the breakeven sales volume for a prospective change in product prices.

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

    Analytical Methods Charley Kyd - 0
    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....
    You can uncover new insights about your company by transforming your data before you chart it. This method of data transformation has revealed a long-term weakness in the U.S. economy.

    This Excel Analytical Charting Strategy Reveals an Economic Warning

    Analytical Methods Charley Kyd - 0
    With normal charts, you find data and then you plot it. But with analytical charts, you transform your data in various ways to discover...
    12Page 1 of 2

    Latest Articles

    Excel Flowbook Revolution

    Getting Radical with Excel

    Excel Data Plumbing Revolution Charley Kyd - 0
    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,...
    Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

    How Fast Is Too Fast?

    Accounting & Finance Charley Kyd - 0
    (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

    Aggregation Functions Charley Kyd - 0
    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
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.