Team Profile Excel Sheet
You can comfortably calculate a team profile, using the Excel lines in your MindSonar user panel (they are next to the .rtf and . pdf files in the download area). How does it work? Copy and paste the Excel file for each group member to one of the Excel sheets shown below. The sheet will automatically calculate the averages and the standard deviations of both the Meta Programs and Graves scores. It shows these averages in two separate graphs.
The Excel sheet (Format Cells > Number) needs to be set to 2 decimal places. Make sure it is set to that and NOT to whole numbers. If it is set to whole numbers, errors will occur in the scores.
In this short video Jan Dirk Brobbel, MindSonar’s Chief Programmer, explains exactly how to do this. We now have a newer version of the Excel sheet (which also displays the Graves drives in the team), but the way to fill it has stayed the same.
Jan Dirk Brobbel
Using a different Excel Formula for Standard Deviation
This part is just for the statistics buffs…. In our Excel sheet for calculating group profiles, we used the Excel function STDEV to calculate the standard deviation. But recently, an alert MindSonar user pointed out to us, how this can lead to strange numbers. He was coaching a team where the standard deviation (for the meta program proactive in this case) could easily be calculated by hand as being 2. And yet the sheet showed 2.2…. This was obviously wrong. What was going on?
When we looked into this, we discovered that the STDEV formula in Excel divides the sum of distances to the mean by N-1 (the number of measurements minus 1). For thousands of measurements this is apparently a good idea, statistically. If you know why this is a good idea, please leave a reply at the bottom of this post! The definition of this function is: “Estimates standard deviation based on a sample“. But for smaller numbers, like 8 team members, this gives a big, like 10% error.
When we work with a team, we have the whole population we are interested in. If we have profiled a whole team, then we literally have the complete population right there. So we want to use STDEVP. Definition of this function: “Calculates standard deviation based on the entire population“. This formula divides the sum of distances to the mean simply by N (the number of measurements). That’s the right one for us! So we adjusted the sheet accordingly, it now uses STDEVP