Last version published: 08/04/2021 07:51
Publication number: ELQ-77456-6
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 (27 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)' publication1,169add_shopping_cart$15.00by Andrei Okhlopkov
Price-Volume-Mix AnalysisA comprehensive full-scope model to analyse revenue and profit changes1,207add_shopping_cart$50.00by Andrei Okhlopkov
Inventory Analysis and ManagementInventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders405add_shopping_cart
Van Westendorp’s Pricing MethodDetermines optimal and acceptable price points, plots demand curves, estimates revenue maximisation points235add_shopping_cart$12.00by Andrei Okhlopkov
Profit Distribution and Carried Interest WaterfallA template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall1,165add_shopping_cart$30.00by Andrei Okhlopkov
Measuring and Modeling SeasonalityA set of very practical tools to analyse seasonal fluctuations299add_shopping_cart
Due Diligence Tools and MethodsA suite of best practices to perform financial and commercial due diligence516add_shopping_cart$150.00by Andrei Okhlopkov
Analyzing Sales and Product PerformanceTools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors1,080add_shopping_cart$19.00by Andrei Okhlopkov
Cap Table with Derivative Instruments, Investor Returns and ChartsAdvanced multiple round startup cap table56add_shopping_cart$35.00by Andrei Okhlopkov
Interim Budgeting (Reforecasting)Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts299add_shopping_cart
Cap Table with Investor Returns and ChartsCap table with 5 investment rounds for up to 10 investors366add_shopping_cart
Horizontal Waterfall ChartA smart and efficient chart with detailed step-by-step instructions176add_shopping_cart$7.00by Andrei Okhlopkov
Any questions on Descriptive Statistics For Grouped (weighted) Data?
The user community and author are here to help. Go ahead!