Tuesday, December 10, 2024
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.

    Latest

    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...
    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...
    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....
    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...
    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...
    The Internal Rate of Return calculation has very real problems, no matter where it's calculated. But with its MIRR function, Excel could offer a solution.

    How Excel’s MIRR Function Can Fix the IRR Function

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

    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.