Have Fun With The Excel Correl Feature

October 13, 2016 Comments Off on Have Fun With The Excel Correl Feature

It’s not causation, but it might suggest a possible relationship (or non-relationship).

Take whatever key metric you’re tracking (ideally leads generated, retention, CSAT etc..) and drop it into Google Sheets.

Now pull as many data points from Google Analytics/your platform data package as you can and see what correlates with what you’re tracking.

This is easy enough to do using the =CORREL feature. Highlight the first array, then the second array and see what happens. What has the strongest relationship?

For example, we recently found the level of activity has no correlation to the likelihood of a newcomer participating for the first time. However, the quantity of off-topic or ‘small talk’ discussions is strongly correlated.

This might suggest we should guide newcomers towards off-topic discussions to get them started. We could then adapt our onboarding emails to guide newcomers towards these discussions, interview newcomers to uncover their unique motivations, and pursue this approach (over personal welcomes or @mentions) to engage them for the first time.

You might be surprised by what you find and how you might use it.

P.S. You could take this to a more advanced level by running a regression (or multiple regression) analysis in a more advanced statistics package.

Comment on this post at FeverBee Experts

©2018 FeverBee Limited, 1314 New Providence Wharf, London, United Kingdom E14 9PJ FEVERBEE

We’d like you to join us.

We’re a group of community professionals who push each other to the cutting edge of our work. Every day we share our experiences, highlight new expertise, and push one another to become the best community builders we can be.

The day you join, you’ll get access to 1000+ practical tips, dozens of resources, and unlimited access to the top experts in our space. You’ll also get to see how we go about building a community amongst our own audience.

It takes just 30 seconds and doesn’t cost a thing.

CLICK HERE AND JOIN FEVERBEE

Level Price  
ALL COURSES The price for membership is $750.00 per month or $7,200.00 per year
Select
Community Development Program The price for membership is $1,100.00 per month or $10,560.00 per year
Select
Director of Community The price for membership is $8,770.00 per month
Select