title: Exponential Smoothing Excel
body: <p>I've a table of data for which I need to exclude outliers and generate an estimated monthly base rate.</p>
  
  <p>The data is a format similar to the following:</p>
  
  <pre><code>Product, Month 1, Month 2, Month 3, Month 4
  Example, 222, 104, 1110, 223, 220
  </code></pre>
  
  <p>Within Excel, I've used the analysis packs Exponential Smoothing function to determine a base rate. This works fine, but I needed to extend this to over 550 rows of products.</p>
  
  <p>Python seems like a good solution here, but I'm very rusty and was hoping for a solution that I can use in a spreadsheet to share with the team.</p>