{"id":1101,"date":"2020-12-11T15:03:44","date_gmt":"2020-12-11T15:03:44","guid":{"rendered":"https:\/\/sellingsherpa.com\/?p=1101"},"modified":"2020-12-12T15:31:29","modified_gmt":"2020-12-12T15:31:29","slug":"stats-for-sellers-comparing-proportions","status":"publish","type":"post","link":"https:\/\/sellingsherpa.com\/index.php\/2020\/12\/11\/stats-for-sellers-comparing-proportions\/","title":{"rendered":"Stats for Sellers: Comparing Proportions"},"content":{"rendered":"
\n

In the last several years, the use of statistics has come under attack most likely due to presidential polling in the last two U.S. elections (regardless of political persuasion). While I’m sad as a statistician to see this, the good news is that sellers who grasp a few basics can zig while others zag.<\/p>\n\n\n\n

In this post, I’m going to teach you how to compare two proportions (i.e. two percentages). <\/p>\n\n\n\n

Let’s take a set of findings from the HubSpot Research Global Sales Enablement Survey<\/a> published in October 2020. Check out the very provocative figure below.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

According to the figure, outperforming companies focused on pipeline velocity and on competitive & market data. In contrast, underperforming companies focused on rep activity data, performance against quota, cross\/upsell, forecasting, and ABM. What the fcuk?#%<\/p>\n\n\n\n

Well, just because it does not make sense does not necessarily mean it is wrong. However, the authors of the study do have a duty to publish findings that are actually statistically valid. How should they have assessed validity? How can you, a normal B2B sales professional with maybe one stats class assess validity? Well, I show you how now.<\/p>\n\n\n\n

Let’s take the first set of columns – 46% of outperforming companies focus on rep activity data while 52% of underperforming companies focus on rep activity data. Is the 46% statistically different than the 52%? Well, the answer is that it depends on sample sizes. If one sampled a million people, then yes. Let’s look at HubSpot’s sample.<\/p>\n\n\n\n

The report says that there were “over 500” survey responses. I’ll use 500 here since I know that not every respondent answers every question so 500 might even more above the sample size (“n”) for this question.<\/p>\n\n\n\n

HubSpot showed that 38% of respondents reported overperforming against revenue goals this year and 40% underperformed. That means 190 (=500 x 38%) overperformed and 200 underperformed.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

(As an important side note, I imagine that whether or not a company outperformed or underperformed in the last year has almost everything to do with an external factor – COVID – and rather little to do with internal factors. But, we will ignore that little detail for now.)<\/p>\n\n\n\n

So, 46% of 190 overperforming companies, or 87, focused on rep activity data. 52% of 200 underperforming companies, or 104 focused on rep activity.<\/p>\n\n\n\n

There is a somewhat intimidating formula for comparing two proportions that looks like this:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

But, we don’t need to use that since this is the 21-st century and there is a site for everything on the Internet. We will use this calculator<\/a> where anyone (yes, even math-phobic people) can get quick answers to complex questions.<\/p>\n\n\n\n

Here are the results of inputting the #s we just got:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

OK, so how do we interpret this? Just look at the red text. You can see that comparing 46% (87 of 190 overperforming companies) to 52% (104 of 200 underperforming companies) is not significant<\/em><\/span><\/strong>. In other words, with this sample size, one cannot conclude there is a difference between 46% and 52! In even more other words, it is incorrect and untrue to say that underperforming companies focused more on rep activity than overperforming ones.<\/p>\n\n\n\n

With a z-test and a standard 95% confidence interval, any time the p-value is greater than 0.05, we say the results are non-significant. Here the p-value was 0.2187 for the rep activity proportion comparison.<\/p>\n\n\n\n

What about all the other data in chart? Here is a summary:<\/p>\n\n\n\n

Test<\/strong><\/td>Over<\/strong><\/td>Under<\/strong><\/td>p-value<\/strong><\/td>Significant?<\/strong><\/td><\/tr>
Rep activity data<\/td>46%<\/td>52%<\/td>0.22<\/td>no<\/td><\/tr>
Pipeline velocity<\/td>31%<\/td>23%<\/td>0.08<\/td>marginal<\/td><\/tr>
Competitive & market data<\/td>44%<\/strong><\/td>34%<\/td>0.04<\/td>yes<\/td><\/tr>
Performance against quota<\/td>38%<\/td>56%<\/strong><\/td>0.00<\/td>yes<\/td><\/tr>
cross-upsell<\/td>30%<\/td>42%<\/strong><\/td>0.01<\/td>yes<\/td><\/tr>
Forecasting<\/td>47%<\/td>56%<\/td>0.08<\/td>marginal<\/td><\/tr>
ABM<\/td>30%<\/td>33%<\/td>0.52<\/td>no<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

So, what can we really conclude from this survey (again, ignoring the fact that the researchers did not control for the impact of COVID).<\/p>\n\n\n\n

  • Over-performing companies focused disproportionately on competitive & market data.<\/li>
  • Under-performing companies focused disproportionately on performance against quota and on cross\/upsell. <\/li>
  • There is only marginal evidence that under-performing companies focused more on forecasting and that over-performing companies focused more on pipeline velocity. To confirm, they should pursue a second, larger study.<\/li>
  • There is ZERO evidence to say anything one way or the other about whether a company outperforms or underperforms by focusing more\/less on rep activity data or ABM.<\/li><\/ul>\n\n\n\n

    My hypothesis is that, adjusting for COVID, the highest performing companies focus on leading indictors, especially activity, measures of effectiveness, and customer health.<\/p>\n\n\n\n

    Hope that helps.<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

    In the last several years, the use of statistics has come under attack most likely due to presidential polling in the last two U.S. elections (regardless of political persuasion). While I’m sad as a statistician to see this, the good news is that sellers who grasp a few basics can zig while others zag. In […]<\/p>\n","protected":false},"author":1,"featured_media":1104,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":{"0":"post-1101","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-uncategorized","8":"entry"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/sellingsherpa.com\/wp-content\/uploads\/2020\/12\/z_score.jpg?fit=260%2C105&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9j2qV-hL","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/posts\/1101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/comments?post=1101"}],"version-history":[{"count":3,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/posts\/1101\/revisions"}],"predecessor-version":[{"id":1109,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/posts\/1101\/revisions\/1109"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/media\/1104"}],"wp:attachment":[{"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/media?parent=1101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/categories?post=1101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sellingsherpa.com\/index.php\/wp-json\/wp\/v2\/tags?post=1101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}