Peltier Tech Blog

Excel Chart Add-Ins | Training | Charts and Tutorials | Peltier Tech Blog

 

Main menu:

Peltier Tech Chart Utilities for Excel Peltier Tech Panel Chart Utility Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

 
Excel Dashboards
 

 
Amazon Books
 

Subscribe

Site search

Subscribe

Site search


Recent Posts

Popular Posts

Privacy and License

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

You Have 1 New Notification On Klout!

 
by Jon Peltier
Monday, January 16th, 2012
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Every so often I get an email with a subject line that’s something like “Jon, you have 1 new notification on Klout!” Wow, another social network thing, to go with all the other ones. Sure, I follow a bunch of people on Twitter every day, and I have a neglected Facebook account and a LinkedIn account that I don’t know what it’s useful for yet. So I also have a Klout account.

My current Klout ranking?

Klout

I dunno, I guess that’s pretty good. Some of my colleagues, and the people I follow on Twitter mostly fall in the range between 25 and 55. So who else has a 43? My fellow Excel chart master, Jorge Camoes, has a 43. An old college buddy, Joel Foner, has a 43. So does fellow Microsoft Excel MVP Ken Puls. Annmariastat has a 43, and she doesn’t even have a Klout account, but she has a Wikipedia entry. So I’m in good company.

There’s some kind of algorithm that determines this score, based on how many people I influence through my internet presence (I guess, how many people follow me), how much I influence them (how often they repeat what I say), and how influential the people I influence are.

The first thing I noticed when I followed the link in the email this morning (I delete most Klout emails without following the link) was this chart showing my score over the past month.

Klout Timeline

Wow, a few days ago, I really got a huge boost in my score.

Then I looked a little more closely, and read the axis labels. Over the past month, my score has ranged from about 42 to about 43.

Klout Timeline with Axis Labels

This is a good example of how the scale of a value axis can exaggerate or play down the variability in a signal. Here I’ve reproduced the Klout timeline in Excel:

Klout Timeline Reproduced in Excel

The total variation in the displayed data is about ±1.8% from the mean. It looks ginormous when the visible Y axis scale is less than 5% of the maximum value. It doesn’t look so substantial when the Y axis scale starts at zero:

Klout Timeline with Full Scale Y Axis

Maybe there’s a reasonable intermediate scale. This scale shows some variation, but it doesn’t look like a tsunami:

Klout Timeline with Reasonable Y Axis Scale

Another funny thing about Klout is the listing of topics that I’m influential about. Data Visualization is rated Strong, and Visualization is rated High. Well, that’s good, those are topics I’d like to think I’m influential about. New England is rated High? Well, in season I will occasionally tweet about the Red Sox, but that’s the extent of my internet discussion about my home region. Statistics, Technology, good to see both of these here.

Klout Topics

But further down the list. Disease? Why am I listed for Disease? Sure, I’m a doctor, but not of medicine. As Randy Pausch‘s mother said of him, “He’s a doctor, but not the kind that helps people.”

Jorge Camoes (who also has a Klout score of 43) says Klout must think I’m sick (insert a pun here for influence/influenza). Klout tells Jorge that he is influential for Coffee, from which he abstains in real life.

Microsoft Excel falls far down my list of topics. Not lowest, but as far as the screen shot could capture. Why am I only Medium for Excel? I’m a Microsoft MVP for Excel, and Excel is one thing I talk a lot about.

I guess this Topics of Influence algorithm needs a bit of work.

Related Posts:

Learn how to create Excel dashboards.

Comments


Comment from derek
Time: Monday, January 16, 2012, 7:45 am

I think a reasonable intermediate scale would be one that shows your other colleagues, the ones who range from 25 to 55, in context. But for that you’d need to get time series for those other colleagues too, then put them on the graph in light grey. Who ever said good graphing practice would be cheap or easy?


Comment from Ken Puls
Time: Monday, January 16, 2012, 12:49 pm

Jon, you fix diseased charts in your “Chart Doctor” articles. :)


Comment from Jon Peltier
Time: Monday, January 16, 2012, 2:47 pm

Ken – That must be it.


Comment from Jorge Camoes
Time: Monday, January 16, 2012, 3:34 pm

Agree with Derek. We must define scales that prevent this kind of slopes and at the same time, compare several series. Slope comparison is better than the slope itself.


Comment from Jon Peltier
Time: Wednesday, January 18, 2012, 9:24 am

Update: Today I had 2 New Notifications on Klout!

Look how much my score has changed:

Updated Klout Timeline

Oh wait, check the scale, it’s only half a point. Whatever that means.


Comment from jonmcrawford
Time: Friday, January 20, 2012, 4:10 pm

You’re obviously obsessed with Excel. Obsession is a disease. (http://medical-dictionary.thefreedictionary.com/obsession)

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Chart Utilities for Excel Peltier Tech Waterfall Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Panel Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.