Posted in Automotive, Data analysis, Excel on Jul 4th, 2008 6 Comments »
This is a short note to talk about Harmonic Averages. Most people are familiar with Weighted Averages, as they are a valuable tool for aggregation. For instance, with the data below, the average profitability (~1735) can be easily calculated using weighted averages.
Avg_Profit = (1000*1200 + 200*300 + 500*2500 + 10*600 + 100*300) / [...]
Posted in Business, Excel, Tools & methodologies on Dec 21st, 2007 1 Comment »
I have received a number of comments regarding the Simplified Excel Model for market adoption published a few months ago. Reader Vince asked how to extend the math behind it to comprehend effects like cross-segment interactions.
There is no simple answer, and this post is an attempt to point readers to ways to think about [...]
Posted in Business, Excel, Strategy, Tools & methodologies on Jul 30th, 2007 6 Comments »
The simplified market adoption model I described on previous postings (1,2) is an Excel implementation of a kind of logistic function. The Bass model is one of the most popular models used in marketing, and management of technology to think about product introductions. (See Wikipedia article). From a mathematical perspective, when the [...]
Posted in Business, Data analysis, Excel, Tools & methodologies on Jul 16th, 2007 3 Comments »
Mekko charts are two dimensional graphs that analyze how data is partitioned against two variables, the X and Y axes. The width of the columns is proportional to data represented by the columns. Individual segment height is a percentage of the respective bar total value.
Posted in Data analysis, Excel, Tools & methodologies on Jul 13th, 2007 No Comments »
Two improvements over the technique described by Juice Analytics and posted in Lifehacker: better resolution and solid-looking bars that show better at different font sizes.
If your values are integers in a range 0-9 or so, you can use the REPT formula as presented there, and perhaps you like the dashed type bars, so the formula [...]
Posted in Data analysis, Excel, Tools & methodologies on Jul 6th, 2007 10 Comments »
I’ve got a number of questions on the simplified Excel s-curve formula I published some time ago, so here are more details for those interested in the math behind it. The previous posting focused on how business analysts sometimes need to model market adoption, and provided a simple and easy to maintain formula to [...]
Posted in Business, Data analysis, Excel, Tools & methodologies on May 11th, 2007 No Comments »
The sites I refer to when I talk about charting, data analysis and good (and bad) charting techniques are normally quite different from the ones where I satisfy my gearhead lust with the news from the latest car models in the market. This time the guys at motortrend did it for me in their [...]
Posted in Business, Data analysis, Excel, Finance, Tools & methodologies on Apr 24th, 2007 23 Comments »
UPDATE 10/31/2007: Here is a screencast for this model
Often business analysts need to model the adoption of a new product or service for financial planning. There are several approaches, but a common one is the s-curve (see Wikipedia article). Here is a simple implementation in Excel that can be easily added to your [...]
Posted in Business, Data analysis, Excel, Tools & methodologies on Apr 8th, 2007 No Comments »
Martin Theus posts here an example of poor charting or “junk charts”. I’ve had the opportunity to work with many organizations as a management consultant, and it’s sad to report that is more the norm than the exception to see charts like that one in the workplace.
Feeding my bad habit of thinking anytime anytime [...]
Posted in Business, Excel, Tools & methodologies on Feb 23rd, 2007 No Comments »
If you receive Excel files from external sources (analyst reports, etc.), chances are that you will start encountering the Excel 2007 format. Those files will end in .xlsx, .xlsb or .xlsm instead of the current .xls
Office 2007 has a significant number of advantages, but some of us will be for a while stuck with [...]
Juan Carlos Méndez-García © 2008 Juan C. Mendez, All Rights Reserved. Contact: ![jcmendez [at] gmail [dot] com](http://jcandkimmita.info/jc/wp-content/themes/jc/img/jcaddr.gif)