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

Listen to this session

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

Click here to download the MP3 file.

Links & Resources mentioned in this podcast

Trend Analysis – formulas & chart techniques:

• Trend analysis & forecasting – part 1
• Trend analysis & forecasting – part 2
• Trend analysis & forecasting – part 3

Calculating moving averages in Excel

Regression & complex trend analysis:

Reference book: Data smart by John Foreman

Transcript of this session:

Download this podcast transcript [PDF]

How do you analyze trends?

For my work, I use both cyclical & linear trend analysis techniques. The insights from these help me to optimize my blog posts, understand best times to publish new articles & analyze how well various marketing initiatives are working out.

What about you? How do you analyze trends? What techniques do you apply? Please share your tips in the comments area.