{"id":192,"date":"2006-09-02T21:11:18","date_gmt":"2006-09-03T04:11:18","guid":{"rendered":"https:\/\/staging.opexlearning.com\/resources\/192\/applied-regression-analysis"},"modified":"2014-09-25T08:43:08","modified_gmt":"2014-09-25T13:43:08","slug":"applied-regression-analysis","status":"publish","type":"post","link":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/","title":{"rendered":"Applied Regression Analysis on Absenteeism and Service Level"},"content":{"rendered":"<div class=\"a296a24fa2fc69ef5487857f02f111e8\" data-index=\"9\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- Single Post readerboard -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:728px;height:90px\"\r\n     data-ad-client=\"ca-pub-8207522353004717\"\r\n     data-ad-slot=\"1144967431\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>In a lot of business analysis, there&#8217;s quite a bit of art, not just science. In this article, I employ science, but there&#8217;s definitely some art involved too. And, just like the <a title=\"forecasting methods and techniques\" href=\"https:\/\/staging.opexlearning.com\/resources\/introduction-to-forecasting\/307\/\">first rule of forecasting is that it&#8217;s always wrong<\/a>, take this regression with a grain of salt. For the purposes of the project, it was sufficient, but certainly not worthy of much else.<\/p>\n<p>Sometime ago, I was able to do some work involving advanced statistics for a very complex process. This very large healthcare company was struggling with absenteeism issues &#8212; that is, the <a title=\"call center metrics and service balancing act\" href=\"https:\/\/staging.opexlearning.com\/resources\/call-center-balancing-act-cost-customer-satisfaction\/11812\/\">call center<\/a> representatives would sometimes just not show up for work, or have other human resources issues. I wasn&#8217;t privy to those details, and I didn&#8217;t really care. But, I was concerned about the impact that absenteeism had on service level, which is defined as<\/p>\n<div>\n<blockquote><p>{(sick days) + (leave) + (other) + (extended)<\/p>\n<p>\u00c3\u00b7<\/p>\n<p>(total hours for time period)}<\/p><\/blockquote>\n<\/div>\n<p>Whenever you have a situation where you want to learn more about the impact of one or more variables has on another, then this business problem can be best understood with the Regression.<\/p>\n<h2><strong>Regression Analysis<\/strong><\/h2>\n<p>Regression deals with relationships between variables and also with Prediction: the ability to accurately predict behavior not only makes you more confident about decisions, but also implies an understanding of the processes at work. Regression in all its shapes and forms remains the central workhorse of social science research &#8212; economics, sociology, psychology, and is used in many areas of business and technology. It is central to techniques like conjoint and discrete-choice analysis; in fact, many pieces of theGoogle&#8217;s MapReduce technology (then do a CTRL-F on &#8220;Regression&#8221;) utilizes the regression &#8212; the way it is computational linguistics is to reduce noise in the data, in conjunction with Bayesian Statistics.<\/p>\n<p>The problem above is a fairly simple one, but one that wasn&#8217;t fully understood in a quantitative way. But, with data to support people&#8217;s hunches that &#8212; yes, absenteeism does in fact impact service level &#8212; the company could have some solid evidence.<\/p>\n<h2><strong>Regression Heuristics<\/strong><\/h2>\n<ul>\n<li>Predictor and Response: The predictor (x) is the variable we suspect has an influence on the response (y) variable. For our purposes, (x=absenteeism), and (y=service level).<\/li>\n<li>Intercept: In a regression equation, the intercept is the value of the response (y) when the predictor (x) equals zero.<\/li>\n<li>R^2: This is a mathematical term that describes how much of the variation in the data is explainable by the regression model. This value is between 0.0 and 1.0. The closer the R^2 value is to 1.0, then the more successful the regression model is in explaining variability in the data. The the R^2 is 0.0, then that means knowing (x) does not help us predict what (y) will be; in other words, it&#8217;s no better than chance or guessing.<\/li>\n<li>Slope: The slope of the regression line depicts the association between the (x,y) pair. In other words, in a regression the slope is the expected change in y for each unit change in x.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14923\" src=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-absenteeism-service-level.jpg\" alt=\"regression analysis on absenteeism and service level with r squared\" width=\"907\" height=\"448\" srcset=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-absenteeism-service-level.jpg 907w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-absenteeism-service-level-600x296.jpg 600w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-absenteeism-service-level-300x148.jpg 300w\" sizes=\"(max-width: 907px) 100vw, 907px\" \/><\/p>\n<p>Above is the plot for the analysis of the absenteeism problem described. The data above allows us conclude the following:<\/p>\n<ul>\n<li>For a 1.18% decrease in absenteeism, we can probably expect a 1.05% increase in service level.<\/li>\n<li>There is a very strong relationship between service level and absenteeism as evidenced by the R^2 value of 0.93, which means that much of the data is explained by the regression model.<\/li>\n<\/ul>\n<p>The data and analysis above supports the hunch that many people already had and, it&#8217;s pretty obvious in a lot of ways. So, why the analysis? Well, the company was a union shop and this topic was a very big union topic. The company now had hard data to show the union during their labor negotiations that, yes, absenteeism impacts the company and the customer in a very specific way. This data was used to leverage the negotiation process in favor of the company. Without the data, negotiating this piece would probably be much more difficult and may not have gone in favor of the company.<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>Regression is the workhorse of many important business-type analysis. I&#8217;ve learned during my short career that it&#8217;s not used nearly as much as it ought to be. Later, I&#8217;ll show how Regression is used in computational linguistics &#8212; parsing large corpora (like the Brown Corpus) &#8212; and how discrimant analysis (a type of regression) helps to reduce noise and expose the data that is useful.<\/p>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In a lot of business analysis, there&#8217;s quite a bit of art, not just science. In this article, I employ science, but there&#8217;s definitely some art involved too. And, just like the first rule of forecasting is that it&#8217;s always wrong, take this regression with a grain of salt. For the purposes of the project, [&hellip;]<\/p>\n","protected":false},"author":12327,"featured_media":9713,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_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":"","footnotes":""},"categories":[9],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Applied Regression Analysis on Absenteeism and Service Level<\/title>\n<meta name=\"description\" content=\"Applied Regression Analysis on Absenteeism and Service Level - the results were not surprising but example shows good business application\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Applied Regression Analysis on Absenteeism and Service Level\" \/>\n<meta property=\"og:description\" content=\"Applied Regression Analysis on Absenteeism and Service Level - the results were not surprising but example shows good business application\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/\" \/>\n<meta property=\"og:site_name\" content=\"OpEx Learning\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/get.shmula\" \/>\n<meta property=\"article:published_time\" content=\"2006-09-03T04:11:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-09-25T13:43:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"354\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Uday Kawar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@shmula\" \/>\n<meta name=\"twitter:site\" content=\"@shmula\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Uday Kawar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/\",\"name\":\"Applied Regression Analysis on Absenteeism and Service Level\",\"isPartOf\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg\",\"datePublished\":\"2006-09-03T04:11:18+00:00\",\"dateModified\":\"2014-09-25T13:43:08+00:00\",\"author\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd\"},\"description\":\"Applied Regression Analysis on Absenteeism and Service Level - the results were not surprising but example shows good business application\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#primaryimage\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg\",\"contentUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg\",\"width\":354,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/staging.opexlearning.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Operations Management\",\"item\":\"https:\/\/staging.opexlearning.com\/resources\/operations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Applied Regression Analysis on Absenteeism and Service Level\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#website\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/\",\"name\":\"OpEx Learning\",\"description\":\"Lean Six Sigma. Simplified.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/staging.opexlearning.com\/resources\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd\",\"name\":\"Uday Kawar\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Applied Regression Analysis on Absenteeism and Service Level","description":"Applied Regression Analysis on Absenteeism and Service Level - the results were not surprising but example shows good business application","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Applied Regression Analysis on Absenteeism and Service Level","og_description":"Applied Regression Analysis on Absenteeism and Service Level - the results were not surprising but example shows good business application","og_url":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/","og_site_name":"OpEx Learning","article_publisher":"https:\/\/www.facebook.com\/get.shmula","article_published_time":"2006-09-03T04:11:18+00:00","article_modified_time":"2014-09-25T13:43:08+00:00","og_image":[{"width":354,"height":400,"url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg","type":"image\/jpeg"}],"author":"Uday Kawar","twitter_card":"summary_large_image","twitter_creator":"@shmula","twitter_site":"@shmula","twitter_misc":{"Written by":"Uday Kawar","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/","url":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/","name":"Applied Regression Analysis on Absenteeism and Service Level","isPartOf":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#primaryimage"},"image":{"@id":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg","datePublished":"2006-09-03T04:11:18+00:00","dateModified":"2014-09-25T13:43:08+00:00","author":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd"},"description":"Applied Regression Analysis on Absenteeism and Service Level - the results were not surprising but example shows good business application","breadcrumb":{"@id":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#primaryimage","url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg","contentUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/09\/regression-analysis-demand-planning.jpg","width":354,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.opexlearning.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Operations Management","item":"https:\/\/staging.opexlearning.com\/resources\/operations\/"},{"@type":"ListItem","position":3,"name":"Applied Regression Analysis on Absenteeism and Service Level"}]},{"@type":"WebSite","@id":"https:\/\/staging.opexlearning.com\/resources\/#website","url":"https:\/\/staging.opexlearning.com\/resources\/","name":"OpEx Learning","description":"Lean Six Sigma. Simplified.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.opexlearning.com\/resources\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd","name":"Uday Kawar"}]}},"_links":{"self":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/192"}],"collection":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/users\/12327"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/comments?post=192"}],"version-history":[{"count":0,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media\/9713"}],"wp:attachment":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media?parent=192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/categories?post=192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/tags?post=192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}