How do I run linear regression with Python?

We'll be using the oldie but goldie Boston Housing dataset, which you can find attached here - BostonHousing to try and predict the median value of a home, indicated by the MEDV variable. The other variables defined in the dataset are: # CRIM per capita crime rate by town # ZN proportion of residential land zoned for lots … Continue reading How do I run linear regression with Python?

How do I interpret linear regression?

Contrary to what you might think - running a linear regression (be it in Python, R, SPSS or Excel) is not rocket science! What's trickier is the outcome interpretation, so let's first have a bit of review of what linear regression is all about! Regression analysis is a method of supervised learning used to predict … Continue reading How do I interpret linear regression?

Can I run a linear regression in Excel?

Anyone survived a statistics course at uni without running a linear regression in SPSS? Come forward, please Joke aside, linear regression is such a basic and fundamental forecasting tool that it is being taught across a range of bachelor and master programmes. Yet, all too often, very little is explained how you could use it … Continue reading Can I run a linear regression in Excel?

Top 3 Excel functions you can use to forecast sales

Well, I didn't need to predict sales but segment sizes for the upcoming 3 periods of the Markstrat simulation game we were playing as part of the Strategic Marketing class I was taking.  Still, it works pretty much the same way - you use the numerical historic data you have in order to make a prediction … Continue reading Top 3 Excel functions you can use to forecast sales