Friday, July 1, 2022
Home Formulas & Functions Statistical Functions

# Statistical Functions

At last count, about one-fourth of all Excel functions a statistical functions. This category shows statistical functions in use.

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

### Using the Hidden Power of Excel’s FILTER Function

When you take the time to explore a new worksheet function, it's amazing what you can discover! And I won't tell you about the really...

### Show Top and Bottom Results in a Chart-Table

The workbook that supports the following figure does a lot of work! First, it uses Power Query to download the weekly unemployment claims and the...

### Highlight Normal Results in Line Charts to Make Exceptional Results Stand Out

Line charts that show trends in performance are the most useful type of chart that management reports can contain. All managers want good performance to...

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

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