Today, we'll discuss how to interpret the results of a Simple Regression Analysis using
the Excel Analysis Tools.
[Intro Video]
Hi, this is Mike Negami, Lean Sigma Black Belt.
We learned about the basics of Regression Analysis and how to get a Single Regression
Equation from the Scatter Plot in the previous video.
If you would like to review the basics of Regression Analysis once again, please take
a look at the video from the link above.
Here are the results from the previous Scatter Plot.
We obtained a Simple Regression Equation of Y = 0.4738 X + 35.519 and a Coefficient of
Determination of 0.9727.
In practice, you can complete your job with only the Scatter Plot, many times, but performing
a Single Regression Analysis will give you more significant information.
Let's see the results of a Simple Regression Analysis in Excel with the same data first.
There are so many numbers, but you really only need to know the parts in yellow for
business, at least.
The numbers in the 'Coefficients' column are the exact same numbers as the Coefficient
and Intercept in the Regression Equation.
Therefore, you'll use these numbers to make a Regression Equation.
Next is the P-Value of the X value.
It is difficult to see, so change it to a %.
It is 0.000015%.
This P-Value is a numerical value which we cannot get from the Scatter Plot.
Simply speaking, you can see how well your Explanatory Variable explains the Objective
Variable.
In a Multiple Regression Analysis, this P-Value is very important, and you can find which
Explanatory Variable among the others has the most influence on the Objective Variable.
For a little more detail, the P-Value is the probability of a null hypothesis.
What is that?
The null hypothesis in a Regression Analysis is "To assume that the Explanatory Variable
of this X is no relation to the Objective Variable of Y".
Generally, if this percentage is less than 5%, this null hypothesis can be rejected.
In other words, "Being no relation" is rejected, which means that there is a lot
of relationship between X and Y.
In our case, the probability is 0.000015%, which is much less than 5%, so we'll reject
it which means their relationship is significant.
If this P-Value is more than 5%, you need to check the data for errors and add more
sample data to redo the analysis or conclude that the two data groups have no relation.
In our case it's less than 5% so I can continue to the next step.
Let's look at the top table.
See 'R Square'?
This number is exactly the same as the Coefficient of Determination in the Scatter Plot.
This is between 0 to 1 and indicates how well the Regression Equation calculates the Objective
Variable.
Closer to 1 is better.
'Multiple R' is the 'Correlation Coefficient'.
You know that squaring it, will be the same as the 'R Square'.
However, I would like you to use the 'Adjusted R Square' below as a Coefficient of Determination.
It's a little lower than the 'R Square' above.
What's the difference between the two?
In practice, you may need to add more Explanatory Variables and perform the Multiple Regression
Analysis.
The 'R Square' above has the characteristic that the more you have Explanatory Variables,
the higher the number becomes, which is mis-leading.
The 'Adjusted R Square' below corrects that issue.
There is not much influence by it in a Single Regression Analysis, but it would be better
to use the 'Adjusted R Square' regularly.
Lastly, I'll briefly show how to get Single Regression Analysis results from the Excel
Data Analysis Tool.
Click 'Data', 'Data Analysis Tools' and select 'Regression'.
In 'Input Y Range', you'll select the data of your Objective Variable, in my case
'Video Duration'.
In the 'Input X Range', you'll select the data of your Explanatory Variable, in
my case, it's 'Number of Blog Words' and 'OK'.
If you don't see 'Data Analysis Tools' in the 'Data' Ribbon, click 'File',
'Options' and 'Add-ins'.
After making sure that there is 'Excel Add-ins' here, click 'Go…'.
Check 'Analysis ToolPak' and click 'OK', then it'll show up.
You can conduct Scatter Plot and Simple Regression Analysis with Excel very easily, so please
put some data in and practice them, then you'll find unexpected discoveries in your business.
Thank you very much for viewing.
Please click the 'Subscribe' button.
Also click and watch my other related videos.
Thanks.
For more infomation >> COPENHAGEN JAZZ FESTIVAL 2018: LA ALDEA DEL NORTE, by Jonas Johansens Blanco Y Negro - Duration: 4:37. 
For more infomation >> İnsan Hakları 4 Sınıf Demokrasi 2 Dönem 1 Yazılı Soruları ve Cevapları - Duration: 21:43. 
For more infomation >> Darwin - BLACKPINK、北米・ヨーロッパ・オーストラリアでのツアー開催を発表！ ますますグローバルな活動へ - Duration: 2:22. 
For more infomation >> Eh Ah - funny | bản nhạc tik tok được yêu thích nhất 2019 - Duration: 1:29. 
For more infomation >> quy 1 nhịp. búa đập van truyền thống giá rẻ. quy 1 nhịp. búa đập truyền thong[#buadapvantruyenthong] - Duration: 3:08. 
For more infomation >> 2nd Free Toy Giveaway Winner Announcement
For more infomation >> Ford Transit 260S 2.0TDdi Celebration Ford Transit 2.0 300 S kort/laag Airco Marge - Duration: 1:12. 
For more infomation >> Macron peut-il accélérer les réformes ? - Duration: 4:19. 
For more infomation >> GARRY'S MOD: DARKRP ► ЧИТЕРСКИЕ БУДНИ ► ЧИТЕРИМ НА STARKRP - Duration: 12:38. 
For more infomation >> 谢霆锋杠上大S了？和张钧甯录节目傲娇称：女生不帮我剥蟹我不吃| 娛樂新聞 CBiz News - Duration: 3:50. 
For more infomation >> 解放军S400二次试射！250公里击中目标，中国军官这样评价 - Duration: 4:43. 
For more infomation >> L'éducation prioritaire, point faible des politiques publiques? - Duration: 8:35. 
For more infomation >> 【#9】活動半年記念配信よ～～～！＼(*´ｗ｀*)／ - Duration: 30:22. 
For more infomation >> ENTRAINEMENT DANS LA PASSE D'UNE PIROGUE FASSE A DE GROSSES CONDITIONS - Duration: 1:54. 
For more infomation >> 【レビュー】GAN356X | GANCUBE - Duration: 7:13. 
For more infomation >> Comment soigner une blessure pour éviter les cicatrices ? - Duration: 6:42. 
For more infomation >> Le resvératrol : un excellent bouclier pour le cerveau ? - Duration: 8:04. 
For more infomation >> Renaud, il risque l'arrêt cardiaque, son taux de potassium dans le rouge - Duration: 1:37. 
For more infomation >> What The F/1.4 - Behind The Camera - @Wolfboytroy - Duration: 3:36. 
For more infomation >> Sunday morning road check - Duration: 2:18. 
For more infomation >> Để Cho Anh Khóc - Nightcore Remix Lê Bảo Bình - Duration: 4:39. 
No comments:
Post a Comment