What’s your personality type?

Myers–Briggs test is the one you have probably already met on some of the job interviews, when completing the test where it seems that questions are repeated. It is a personality type indicator, on the basis of which the respondent is classified by four types and two subtypes: an extroverted-introvert, experienced-intuitive, thinking-feeling, judging-perceiving. The ideal tool for displaying the results of this test is the Radar chart.

The Myers-Briggs test consists of a series of questions filled by the respondent. There are no accurate or inaccurate answers, and a large number of questions allow for a greater probability that the user will give those answers that best show which type of person he belongs to. On the basis of the answer, it is possible to decide on which workplace should be placed in regard of his personality. For example. Someone who is an Extrovert-Sensing-Thinking-Judging is the ideal type for an entrepreneur or manager. If you put such a person in an administrative job, that does not mean that he would be a bad worker; it means that it is very likely that he would not be happy in that position! In addition to the link that is listed at the very beginning of the text, there are still many Internet sites where you can find out more about Myers-Briggs test. It may perhaps help you find the answer to the eternal question: Who am I?

Let’s get to the point! The respondent completed the survey, and the interviewer should enter the results into a table describing all subtypes of personality: extrovert, introvert, sensing, intuition, thinking, feeling, judging, perception. After selecting the results table, it is necessary to position it on the Insert ribbon and select an option to insert Radar chart. After we’ve listed eight properties, our chart will have eight key points, and the higher the score it will be more away from the center of the chart. By merging these points, a star formation is created which effectively emphasizes pronounced properties-subtypes, on the basis of which we can better understand the type of personality the respondent belongs to.

How do we determine the personality type? If the estimate of extroversion is greater than the estimate of the introvert, then the question is “E” type; Further, if someone is more experienced than intuitive, we add a “S” type. We continue the process until we reach all four dominant subtypes, whose merger gives us the type of personality. The type of personality can be determined using the following formula:

=IF(C2>C6,”E”,”I”)&IF(C3>C7,”S”,”I”)&IF(C4>C8,”T”,”F”)&IF(C5>C9,”J”,”P”)

Further we can continue to beautify the chart by changing the background, adding titles, changing fonts, colors, etc. In the end, it would be nice to see in the graph the very type of personality the respondent belongs to. This is accomplished by naming a link to a cell in which we have determined the type of personality. We need to go to the Insert ribbon and select the Text Box. After we insert the text, we click on this object, then click on the Formula Bar and enter the link to the cell where lies the formula for determining the personality type. The personality type designation should only be added to the desired part of the chart and maybe be slightly enhanced by changing the format or using some of the formatting styles.