All articles with 'Linest' Tag

CP036: How to do trend analysis using Excel?

Published on Jun 11, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP036: How to do trend analysis using Excel?

In the 36th session of Chandoo.org podcast, Let’s follow the trend.

What is in this session?

In this podcast,

  • A quick trip to down under
  • What is trend analysis
  • 4 types of common trends
    • linear
    • curve
    • cyclical
    • strange
  • Doing trend analysis in Excel – the process
  • How to use trend analysis results
  • Conclusions
Continue »

Learn Statistics & Probability using MS Excel

Published on Feb 13, 2012 in excel apps, Excel Howtos, Learn Excel, simulation, VBA Macros
Learn Statistics & Probability using MS Excel

One of the most dreaded courses during my under-graduation is Probability, Statistics & Queuing Theory. We called it PSQT. I struggled to understand the significance and concept of this course as I could barely concentrate in the class. We had a professor, who is probably a genius, but the moment he started the class, I would magically fall in to one of my after-noon naps. When I woke up, we are either in the middle of an elaborate t-test or going thru intricacies of a Markovian queue.

This was all 11 years ago. Later in life, I have embraced the world of probability & statistics. I still fear queues. May be I will get there one day. 😉

A good understanding of statistics & probability theory is necessary if you want to model complex real-life problems using Excel or similar tools. Naturally, Excel has several functions, features & supported add-ins to help you in this area.

Today, I want to share some of this with you. This article is broken down in to 3 parts.

  1. Learning Statistics & Probability using Excel
  2. Downloadable Excel Workbooks to understand
  3. Full blown models & simulations in Excel
Continue »

Analyse Data like a Super Hero

Published on Jun 20, 2011 in Excel Howtos, Huis, Learn Excel, Posts by Hui
Analyse Data like a Super Hero

Can I automate 500 Columns of Data Analysis without VBA?

Absolutely!

Excel super function – Data Table to the rescue.

After reading this post, you will be able to process data like a Data Analysis Super Hero !

Continue »

Are You Trendy ? (Part 3)

Are You Trendy ? (Part 3)

In the final post of the Are You Trendy? series we will look at the use of Excel Charts and associated Trendlines for trend analysis and I will give you a free tool (Normally valued at $200, I wish) which will allow interactive assessment of a Charts Trendline Y value for any X value.

Continue »

Are You Trendy? (Part 2)

Are You Trendy? (Part 2)

Does your data hold hidden secrets?
In Part 2 of Are You Trendy? we will examine the Excel functions that assist us in Trend Analysis.

Continue »