Sub4Sub network gives free YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

Multiple Linear Regression using Excel | Predict Sales using Marketing Spends

Follow
Kunaal Naik | Data Science Masterminds

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:
   • Plot Confusion Matrix in Machine Lear...  

Calculate machine learning classification accuracy:
   • Calculate Machine Learning Classifica...  


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.

posted by fontoldy