Calculating a Team Profile

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.

Excel sheets

You can download two slightly different Group Profile Microsoft Excel (.xlsx) sheets right here. This first one is the sheet that calculates averages for both Meta Program and Graves scores. Click below to download this one:

Group_profile_EN_MP_and_Graves

The second sheet calculates averages for Meta Programs only (this second one is for when you had switched off the Graves questions when people did their profiles). Click below to download this sheet.

Group_profile_EN_MP_only

Update history

These Excel sheets were last updated on June 25, 2015
If you are still using older versions we suggest you download these new ones. The files are very small.

Please Note

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.

How-to Video
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.

MindSonar Metaprograms Pragramming Chief Jan Dirk Brobbel

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

.

 

 

 

 

4 Comments

  1. When you make a profile of a function with 6 tests what sheet do you use then; it isn’t the whole population but is a small number of measurements.

    • Hi Anita,

      Good to hear from you! Hope you are doing well!

      So with six people, you absolutely want to use the sheet as we have it now (with the whole population formula). The other (sample) formula is just for scientific samples of hundreds or thousands of people.

      All the best,
      Jaap

  2. Jan Dirk Brobbel van 306 in Volkel, 1978?
    vandaag vond ik de video terug die wij toen als dienstplichtigen hebben gemaakt met Jan Dirk Brobbel in een fraaie rol

Leave a Reply

Your email address will not be published. Required fields are marked *

*