Multiple Linear Regression using Excel | Predict Sales using Marketing Spends
Channel: Kunaal Naik | Data Science Masterminds
Date: 2022-08-11

A marketing manager wants to know what is the right marketing spends mix to get optimum Sales using the 80k budget he has. We are going to build a Linear Machine Learning Model to build a relationship between Sales and Marketing Spends and help the marketing manager decide his mix. This modelling technique is also known as the Marketing Mix Model. 

All of the steps are visual. This video, is good for those who want to build their intuition of how Linear Regression is used. 

We use the Data Analysis Toolpak within Excel to build the model. 

Post building the model, we will calculate the performance metrics such Sum of Squared Error, Mean of Squared Error, Root Mean Squared Error and Mean Absolute Percentage Error. 

----------
JOIN DATA SCIENCE MASTERMINDS HUB:

👉TELEGRAM: https://go.kunaalnaik.in/telegram
👉FACEBOOK: https://go.kunaalnaik.in/facebook_hub
----------

CONNECT WITH ME ON:

👉TWITTER:  https://go.kunaalnaik.in/twitter
👉LINKEDIN:  https://go.kunaalnaik.in/linkedin
👉YOUTUBE: https://go.kunaalnaik.in/YouTube
👉MEDIUM:  https://go.kunaalnaik.in/medium
👉WEBSITE: https://go.kunaalnaik.in/website
----------
 BUY ME A COFFEE:  https://www.buymeacoffee.com/KunaalNaik
----------

WANNA LEARN MORE? HAVE A LOOK👇

Plot confusion matrix in machine learning using python:
   https://youtu.be/jTCkpB7vjRA

Calculate machine learning classification accuracy:
   https://youtu.be/4CaM_-ovHro
----------

Thank you for reading with utmost patience:)
If you like my work, please subscribe and hit the like button. It's completely free for you but means a lot to me.