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.
4 Responses to “CP036: How to do trend analysis using Excel?”
[…] http://chandoo.org/wp/2015/06/11/how-to-do-trend-analysis-using-excel/ […]
Guru Chandooji,
You are awesome as a teacher and a nice speaker.
Thanks for educating the community and appreciate your volunteership.
Please let me know when you release a new PodCast/video/article. I would like to to read/listen and write feedback.
Please change the icon/picture next to Chandoo.org, it looks awful.
Thanks a bunch
I enjoyed listening the Podcast
Thanks a bunch
Do you have any videos?