Рет қаралды 355
In practice, we perform a Regression Analysis for sales forecasting or marketing analysis etc., but it's rare to have only one Explanatory Variable, so we usually use Multiple Regression Analysis. This episode will explain the Multiple Regression Analysis using my SEO activities on my blog site econoshift.com as an example. Fortunately, its operation in Excel is the same as the Simple Regression Analysis. However, when preparing source data, Multiple Regression Analysis has a couple of things you should be aware of. This video will also explain a Dummy Variable for Qualitative data and removing Collinearity.
(Process Improvement Methodology for Service Operations, PMP, Project Management, Lean Six Sigma, Japan, Six Sigma, Excel, VBA: Episode 107)
<<Read this video's transcript in my blog.>>
econoshift.com...
<< Related Videos >>
Simple Regression Analysis by Scatter Plot in Excel【Regression Analysis Series 1】
• Simple Regression Anal...
Simple Regression Analysis Interpretation (Excel Data Analysis Tools) 【Regression Analysis Series 2】
• Simple Regression Anal...
<< About this Channel >>
"Learn world-class Kaizen and improve your work and yourself."
This channel is for people who love their jobs, and want to improve their work and themselves.
<< SUBSCRIBE: (Click the link below.) >>
www.youtube.co...
<< Video Upload Schedule >>
A new video is uploaded bi-weekly at 7:30 am EST, Sundays. Please subscribe and share the journey together.
<< Let's Connect! >>
Mike Negami's Blog Site: econoshift.com...
Free Excel Template Downloads: econoshift.com...
Facebook Page: / econoshift