Last version published: 21/03/2020 21:17
Publication number: ELQ-77456-4
View all versions & Certificate
Descriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data
Andrei Okhlopkov offers you this Best Practice for free!
download for free
Add to bookmarks
Calculate statistical parameters of the data to get a better feeling and insight of the numbers and sense the 'story behind the numbers'
Grouped or weighted data (e.g. a sales plan for a product portfolio)
4.9 / 5 (19 votes)
Write a review
- Excellent model
People using this Best Practice also downloaded
Unlocking Full Potential of Excel Data Tables (Part 2)This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication830add_shopping_cart
Profit Distribution and Carried Interest WaterfallA template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall212add_shopping_cart$30.00by Andrei Okhlopkov
Horizontal Waterfall ChartA smart and efficient chart with detailed step-by-step instructions48add_shopping_cart$7.00by Andrei Okhlopkov
Controlling Outlook from Excel (full version)Explains how to programmatically link Excel to Outlook147add_shopping_cart
Analyzing Sales and Product PerformanceTools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors801add_shopping_cart
Interim Budgeting (Reforecasting)Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts106add_shopping_cart
Price-Volume-Mix AnalysisTools and methods to calculate and depict price, volume and mix effects219add_shopping_cart$39.00by Andrei Okhlopkov
VBA Interface Collection (full version)A set of Excel VBA macros aimed at enhancing user interface125add_shopping_cart
Sensitivity analysis Excel Model with indifference curves (unlocked)An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model251add_shopping_cart$10.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)Explains the basics of designing professional charts in Excel with practical examples (full version)265add_shopping_cart
A Chart Showing Three Dimensions of DataA professionally-designed chart which can show data in three measurements26add_shopping_cart$5.00by Andrei Okhlopkov
Measuring and Modeling SeasonalityA set of very practical tools to analyse seasonal fluctuations60add_shopping_cart
Any questions on Descriptive Statistics For Grouped (weighted) Data?
The user community and author are here to help. Go ahead!