How can I best visualize performance data by tenure?
March 7, 2009 12:31 PM Subscribe
Excel charting help: Help me analyze sales stats based on salesperson tenure.
posted by samuelad to computers & internet (6 answers total) 1 user marked this as a favorite
I have an Excel file with the names, start dates, sales volumes, margins, and average unit selling prices for a sales team of 1,300 people dating as far back as 11 years.
I want to understand the performance differences between subgroups with different tenures (for example, how much better or worse on average do those with 1 -1.5 years experience perform than those with 2-2.5 years experience?).
I would really like to represent this data graphically in a chart. It seems like a histogram or a scatter plot with a trend line makes the most sense, but I am not a statistician and would describe my charting capability as “just above basic”. What is the best way to represent this stuff graphically and how do I build that chart?
Should I create a “sales performance index” of the sales metrics so that I can simplify the data into three variables: name, start date, and sales performance index? If so, how would you recommend creating such an index?