{"id":5323,"date":"2013-05-15T06:46:08","date_gmt":"2013-05-15T10:46:08","guid":{"rendered":"http:\/\/www.jasonapollovoss.local\/?p=5323"},"modified":"2018-09-21T02:04:09","modified_gmt":"2018-09-21T06:04:09","slug":"an-r-squared-chart-taxonomy-seeing-is-not-believing","status":"publish","type":"post","link":"https:\/\/jasonapollovoss.com\/web\/2013\/05\/15\/an-r-squared-chart-taxonomy-seeing-is-not-believing\/","title":{"rendered":"An R-Squared Chart Taxonomy: Seeing Is Not Believing"},"content":{"rendered":"<p><span style=\"font-size: 16px;\">Often financial analysts are presented with statistical charts that purport to demonstrate an important \u2014 and, of course, investable \u2014 relationship between data points. These charts are supposed to be worth a thousand words and thousands of shares traded. But invariably these charts do not have an r-squared for the data displayed, or any other descriptive statistical data; just the seductive image. What is needed to help the (often) beleaguered analyst is an r-squared taxonomy, or catalog.<\/span><\/p>\n<p><span style=\"font-size: 16px;\">Take-aways:<\/span><\/p>\n<ul style=\"margin-left: 5%;\">\n<li style=\"padding-bottom: 3%;\"><span style=\"font-size: 16px;\">A better sense of what different r-squareds actually look like.<\/span><\/li>\n<li style=\"padding-bottom: 3%;\"><span style=\"font-size: 16px;\">How radically different looking charts generate similar r-squareds.<\/span><\/li>\n<li style=\"padding-bottom: 3%;\"><span style=\"font-size: 16px;\">Why it is crucial to use multiple tools, including charts, when analyzing data.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 16px;\"><strong><!--more-->A Better Sense of What Different R-Squareds Actually Look Like<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\">As an introduction take a look at the following chart:<\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18092\" title=\"R-Squared Example\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart.png\" alt=\"R-Squared Example\" width=\"650\" height=\"502\" \/><\/a><\/span><\/p>\n<p><span style=\"font-size: 16px;\">While the graph shows a hypothetical performance for a hypothetical stock index and for a hypothetical sovereign 10-year Treasury note, I think you will agree with me that it is typical of a finance industry chart.<\/span><\/p>\n<p><span style=\"font-size: 16px;\">Take a look at how the data are only roughly related to one another between January 2008 to April 2010, and then they appear to track each other very closely. I could continue using flowery language and a successful analyst pedigree to try and convince you to trade with my firm. Sound familiar?<\/span><\/p>\n<p><span style=\"font-size: 16px;\">Would it surprise you to learn that the r-squared for the above chart is a lowly 2.18%?! To better educate you as to what different r-squareds look like here is an r-squared taxonomy compiled using a random chart generator, based in real-world data, and after thousands of trials. [Keep at it, too, there is more analysis at the bottom of the post.]<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 0.00%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-0-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18073\" title=\"R-Squared = 0.00%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-0-percent.png\" alt=\"R-Squared = 0.00%\" width=\"650\" height=\"501\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">How can it be that this chart has an r-squared of 0.00% when between July 2009 and January 2011 it looks as if there is so much similarity? Remember that r-squared is a summary measure and that it is calculated as 1\u00a0\u2212 (sum of squared errors \u00f7 sum of squares total). Consequently, data can cancel one another out and affect the calculation positively or negatively.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 10.00%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-10-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18074\" title=\"R-Squared = 10.00%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-10-percent.png\" alt=\"R-Squared = 10.00%\" width=\"650\" height=\"425\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 20.01%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-20-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18075\" title=\"R-Squared = 20.01%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-20-percent.png\" alt=\"R-Squared = 20.01%\" width=\"650\" height=\"425\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 29.97%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-30-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18076\" title=\"R-Squared = 29.97%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-30-percent.png\" alt=\"R-Squared = 29.97%\" width=\"650\" height=\"445\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 40.01%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-40-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18077\" title=\"R-Squared = 40.01%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-40-percent.png\" alt=\"R-Squared = 40.01%\" width=\"650\" height=\"446\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 49.99%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-50-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18078\" title=\"R-Squared = 49.99%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-50-percent.png\" alt=\"R-Squared = 49.99%\" width=\"650\" height=\"425\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 60.00%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-60-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18080\" title=\"R-Squared = 60.00%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-60-percent.png\" alt=\"R-Squared = 60.00%\" width=\"650\" height=\"426\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 70.04%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-70-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18082\" title=\"R-Squared = 70.04%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-70-percent.png\" alt=\"R-Squared = 70.04%\" width=\"650\" height=\"501\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 80.03%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-80-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18083\" title=\"R-Squared = 80.03%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-80-percent.png\" alt=\"R-Squared = 80.03%\" width=\"650\" height=\"501\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 90.00%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-90-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18084\" title=\"R-Squared = 90.00%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-90-percent.png\" alt=\"R-Squared = 90.00%\" width=\"650\" height=\"501\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\"><strong>How Radically Different Looking Charts Generate Similar R-Squareds<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\">Most of the time when financial analysts think of r-squared they think of similarity, rather than relatedness or causality. The preceding charts show that the higher the r-squared the more closely the lines tend to track one another. But this is very dangerous thinking! In the thousands of trials done in order to create this post the highest r-squared chart randomly generated was a whopping 93.37%. But take a look at its chart below.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 93.37%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-93-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18087\" title=\"R-Squared = 93.37%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-93-percent.png\" alt=\"R-Squared = 93.37%\" width=\"650\" height=\"445\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">I bet you are surprised by the above result because, as I said, analysts tend to think of r-squared as similarity. However, the above chart demonstrates very high <i>negative correlation<\/i> of \u221295.29%. If you look at the chart above you will see a vintage of chart that recurred throughout the r-squared random trials: a scissors pattern. Count me among the educated by this experiment as I have never looked for scissors patterns when sifting through charts for causal relationships.<\/span><\/p>\n<p><span style=\"font-size: 16px;\">Take a look at various manifestations of scissors brethren.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 50.07%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-51-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18079\" title=\"R-Squared = 50.07%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-51-percent.png\" alt=\"R-Squared = 50.07%\" width=\"650\" height=\"425\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">Interestingly, look at the difference between the 50.07% and the 49.99% chart from before. While separated by only 0.08%, the two charts could hardly look more different.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 69.99%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-69-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18081\" title=\"R-Squared = 69.99%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-69-percent.png\" alt=\"R-Squared = 69.99%\" width=\"650\" height=\"425\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">Again, compare the 69.99% and the 70.04% r-squared charts, separated by just 0.05%. Last, compare the 90.81% r-squared graph below with the 90.00% chart above. What a dramatic difference.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 90.81%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-91-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18085\" title=\"R-Squared = 90.81%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-91-percent.png\" alt=\"R-Squared = 90.81%\" width=\"650\" height=\"425\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">Like everything in finance, reading charts is more complicated than just memorizing several heuristics, like \u201cbe on the look out for the scissors pattern.\u201d For example, look at these very different looking, but similar r-squareds that do not adhere to the scissors pattern.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 50.30%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-503-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18091\" title=\"R-Squared = 50.30%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-503-percent.png\" alt=\"R-Squared = 50.30%\" width=\"650\" height=\"502\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">To me, the above chart \u201clooks like\u201d it would have a lower r-squared than the preceding 49.99% r-squared chart; yet, it is higher! Or what about the 92.31% r-squared below which looks to have a lower r-squared than the 90.0% chart:<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 92.31%<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-92-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18086\" title=\"R-Squared = 92.31%\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-92-percent.png\" alt=\"R-Squared = 92.31%\" width=\"650\" height=\"445\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">For another interesting comparison look at the original 2.18% chart and compare it to the 10.0% r-squared chart. To further demonstrate how exactly the same r-squareds can look radically different compare these three very different ways of generating a theoretical 100.00% r-squared.<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 100.00%, Identically Similar Movement<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-100-percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18090\" title=\"R-Squared = 100.00%, Identically Similar Movement\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-100-percent.png\" alt=\"R-Squared = 100.00%, Identically Similar Movement\" width=\"650\" height=\"446\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\">Here both data series move identically with one another; so much so, in fact, that you cannot distinguish the movement of the hypothetical stock market from the movement of the 10-Year Treasury Note Yield. [Note: For the skeptics, the presence of the left-hand scale indicates that the stock market close time series is present, just \u201cunderneath\u201d the 10-year Treasury Note Yield series]<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 100.00%, Scissors Movement (i.e., Negative Correlation)<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-100-percent-negative-correlation.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18089\" title=\"R-Squared = 100.00%, Scissors Movement (i.e., Negative Correlation)\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-100-percent-negative-correlation.png\" alt=\"R-Squared = 100.00%, Scissors Movement (i.e., Negative Correlation)\" width=\"650\" height=\"446\" \/><\/a><\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><span style=\"font-size: 16px;\"><strong>R-Squared = 100.00%, Negative Correlation<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\"><a href=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-100-percent-neg-correlation.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18088\" title=\"R-Squared = 100.00%, Negative Correlation\" src=\"http:\/\/blogs.cfainstitute.org\/investor\/files\/2013\/05\/R-squared-chart-100-percent-neg-correlation.png\" alt=\"R-Squared = 100.00%, Negative Correlation\" width=\"650\" height=\"445\" \/><\/a><\/span><\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\"><strong>Why It Is Crucial to Use Multiple Tools, Including Charts, When Analyzing Data<\/strong><\/span><\/p>\n<p><span style=\"font-size: 16px;\">Hopefully I have demonstrated to you the futility of trusting your eyes when looking at chart data\u00a0\u2014 <i>seeing is not believing<\/i>! It behooves analysts to study the r-squared taxonomy to ensure developing a feeling for what actual relationships of particular degrees look like. Chartists should broaden their scope to include data that demonstrate a scissors pattern\/negative correlation and not just charts that track one another like dancers on a dance floor. Going forward it is obvious that understanding data well requires a combination of visuals and statistical measures.<\/span><\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p><span style=\"font-size: 16px;\"><em>Originally published on CFA Institute\u2019s \u00a0<a href=\"https:\/\/blogs.cfainstitute.org\/investor\/\">Enterprising Investor<\/a>.<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often financial analysts are presented with statistical charts that purport to demonstrate an important \u2014 and, of course, investable \u2014 relationship between data points. These charts are supposed to be worth a thousand words and thousands of shares traded. But invariably these charts do not have an r-squared for the data displayed, or any other [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[12,3],"tags":[165,183],"class_list":["post-5323","post","type-post","status-publish","format-standard","hentry","category-best-of-the-blog","category-the-blog","tag-quantitative-methods","tag-r-squared"],"_links":{"self":[{"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/posts\/5323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/comments?post=5323"}],"version-history":[{"count":0,"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/posts\/5323\/revisions"}],"wp:attachment":[{"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/media?parent=5323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/categories?post=5323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jasonapollovoss.com\/web\/wp-json\/wp\/v2\/tags?post=5323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}