Overview

Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an example, the AVERAGE function calculates a simple average of ungrouped numbers, but calculating a weighted average requires a different approach.

This review compiles the formulae to perform statistical calculations for grouped data. They cover the same (and even greater) scope as Excel’s native statistical functions.

The file includes calculations for:

- single-array data (average, median, variance, standard deviation, percentiles, skewness, kurtosis)

- dual-array data (covariance, correlation, standard error, linear trend).

I have also given an overview of the basics of statistics and how it applies to financial analysis and included a method to assign weights to your numbers, depending on their relevance to your benchmarks.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Hotel Acquisition Financial Model
349
0
This is a detailed, well-structured and transparent cash flow model for an acquisition of a hotel. The model includes the…
Hotel Development Financial Model
361
1
This is a detailed, well-structured and transparent cash flow model for the development of a hotel. The model includes the…
Rent Roll Analysis and Stacking Plan
1,939
2
I. RENT ROLLA rent roll is a table listing the tenants of a real estate asset, showing how much area…
Complete Three-Statement Quarterly Budget
2,016
1
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Quarterly Budget with Scenarios
1,741
4
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Monthly Budget
1,691
0
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
See All