Correlation and Multiple Regression in Excel

[@henryclaycoxjr1181]

Professor Benson: Excellent video. I am doctoral candidate working on my dissertation and your explanation of Correlation and Multiple Regression was very helpful. In my research study, I am using the delphi research methodology (series of questionnaires sent to a small number of subject matter experts to obtain collaborative judgement or agreement regarding a specific subject or query). In the second round of questionnaires, I am asking the respondents to rank (in order of significance) the responses from round 1. At this point, I was stuck; as to how I would quantify consensus? I did some research... and decided I would use the "Kendall W Correlation Coefficient (W = 12S/m^2 (N)(N^2 - 1) analysis technique to demonstrate consensus. To make a long story short, your video basically enlightened me regarding the multivariant world. Don't get me wrong, I am a long way from getting to point "B" from point "A", however, I now feel like I can see the light. Thank you!

[@DrWendiLBenson]

Check out the 3 part series starting at th-cam.com/video/dmX0Ns4ZAFA/w-d-xo.html for an even better demo.

[@petersuson8852]

Thank you so much for sharing this. You have the knack in teaching stat that is so appealing.

[@marcio3147]

Thanks! I have studied this 15 years ago at an econometrics class and was not remembering how to do it again. Cheers

[@sarathps223]

your video is a turning point in my life and the deadline for my research is tomorrow. Thank you a lot

[@rockstarvarun1995]

Tons of Respect from India...Thanks mam!

[@SteeringMariners]

Thank you so much Wendi. My data analysis was completely based on what i learned from your video.

[@lilypiggy30]

I cant thanks enough. Very clear explanation, I am so glad Ive found you, saving my life with stats lol. thanks so much

[@anubitee]

Great video! Maybe the only one I was able to endure until the end and enjoy it!

[@alayerene1254]

Thank you so much Dr. Wendi; It is very clear and it has helped me a lot.

[@karpodukpa5482]

Great Lesson!! I enjoyed going through it. Much appreciated.

[@mohammadahsan6342]

Very, very and very nice... You don't have thought that what a great work you have done!!!!!!!!Thank You Very much......Kamrul Ahsan

[@Iam1nsane]

You are so clear, succinct and engaging. Amazing.

[@parvathigudala3846]

Thank you so much. Your explanation helped me a lot in my research paper

[@nikulya833]

Thank you for giving me some confidence in writing my assignment. I have no previous knowledge in analytics and I was struggling. But this video is incredibly helpful.

[@Negrodamusthedestroy]

I'm not sure what class this is for, but this is clutch for teaching yourself how to use multiple regressions

[@mameboubakardembatamba1877]

Ho Wendy oh Wendy, you are wonderful the day we meet I'll cook for you Okra soup and placali (cassava paste) with dry fish. Thanks a lot you don't know how you saved me

[@shirazgrib5121]

thank you very much this is verry helpful

[@rainzo84]

Wow, your video is very easy to follow, it is very helpful, thankyou

[@isayu134]

thanks. you explained clear and detailed. great

[@michaeldiep10]

thanks, very clear video that helps me so much!!

[@AlexanderJohnGChoi]

Hi Professor Benson, I don't know how many thanks I should give to your explanations. Very clear and direct. But one question I have is why do you need to run regression analysis twice?

[@DrWendiLBenson]

I had my students only keep the significant predictors in the model.

[@giridharbalasubramanian3755]

Good work... Explained Nice and slow that even non-math guys like me can follow!

[@DrWendiLBenson]

Check out the 3 part series starting at th-cam.com/video/dmX0Ns4ZAFA/w-d-xo.html for an even better demo.

[@nahcus]

Thank you so much for the video, helped a lot

[@eddcarvajal9064]

Good video, very explanatory. I'm trying to apply the same study to a survey conducted every day to patients attending to a medical clinic. Any suggestions???

[@manjusapkota9209]

Thank you so much. IT HELPS me a lots

[@soumiasou8046]

Professor Benson thank you so much

[@200006893]

It helped me a lot
Thanks!

[@saintsoham]

Nice video.. Detail explanation.. Lets have some more on other topics... :)

[@xenopholis47]

Thank You............ It helped a lot.

[@anamunoz730]

Awesome explanation thank you

[@MAbdullah47]

Thank You Wendi for this useful material , the methodology of learning is very simple and could be understood by any level of student thank you for your dedication and please I need you to post your email just in case if we have some questions to send it for you related to the same topic.

[@pkmisra769]

Very nice and informative video.

[@DrWendiLBenson]

I just made a 3 part series on correlation and regression (including a prediction macro) for my upcoming textbook. Check it out at th-cam.com/video/dmX0Ns4ZAFA/w-d-xo.html

[@Maharshi251993]

helps me a lot
Thanks

[@Surfturf88]

Hi Wendi, Can u provide a link to the data that u have used in the video for my practice purpose plz?

[@richierichard984]

very useful information

[@timedullantes571]

thanks a lot

[@ABSurpriseToys]

This is well presented

[@shaileshdupare7165]

Nicely explained

[@kong3724]

Well explain concept

[@SteeringMariners]

excellent..thank you:)

[@rodbrenbautista218]

how to get the pearson coefficient m ? is that the average of all the coefficient ? thank u in advance

[@mehnajtharranum4194]

thank you so much

[@abdiladif625]

how you get .25?

[@megan2484]

Is it possible to download the same file somewhere?

[@IamMoreno]

hii! where can i find this worksheet?

[@anukoolchoudhary2099]

Your voice reminded me of Selfie by Chainsmokers..

[@DrWendiLBenson]

Hahaha! That only makes me mildly self-conscious :D

[@jpaokx]

What does mean if the p-value in Excel gives me a value of 0? I don't mean 0.00000.... but exactly 0.

[@DrWendiLBenson]

It means there is less than a .01% chance that your results are due to error...you can reject the null and celebrate statistical significance!

[@anukoolchoudhary2099]

Thanks a lot