Search

# All articles with 'Linest' Tag

## How to predict cricket scores [Excel + Machine Learning]

Published on Jul 2, 2019 in Analytics, Charts and Graphs, Learn Excel

Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.

Continue »

## CP036: How to do trend analysis using Excel?

Published on Jun 11, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs

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

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.

1. Learning Statistics & Probability using Excel
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

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)

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)

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.