How to Calculate a Correlation (and P-Value) in Microsoft Excel

Показать описание

How to calculate the Correlation using the Data Analysis Toolpak in Microsoft Excel is Covered in this Video (Part 2 of 2).

In the text we cover the p-value for Correlation and much more.

Channel Description: For step by step help with statistics, with a focus on SPSS (with Excel videos now too). Both descriptive and inferential statistics covered. For descriptive statistics, topics covered include: mean, median, and mode in spss, standard deviation and variance in spss, bar charts in spss, histograms in spss, bivariate scatterplots in spss, stem and leaf plots in spss, frequency distribution tables in spss, creating labels in spss, sorting variables in spss, inserting variables in spss, inserting rows in spss, and modifying default options in spss. For inferential statistics, topics covered include: t tests in spss, anova in spss, correlation in spss, regression in spss, chi square in spss, and MANOVA in spss. New videos regularly posted. Videos series coming soon include: multiple regression in spss, factor analysis in spss, nonparametric tests in spss, multiple comparisons in spss, linear contrasts in spss, and many more. Subscribe today!

Рекомендации по теме

Комментарии

After searching for almost one hour, I can say you are the only one of all youtubers to perfectly explain the correlation. Thank you!

fioralessio

Dude. I LOVE YOU. You saved me from our thesis which our defense is tomorrow. THANKYOU

AliceJaneSwan

I’ve taken elementary statistics, and statistical method’s for psychology and this short video gave me more understanding of statistical significance than both of those courses.

Jack-viu

So helpful! Excel 2016; 2013 onwards actually, doesn’t display data analysis. You have to add it in. Go on file, options then add ins, then click data analysis. Then it appears and you can follow these clear helpful steps!

THESCRANBADGER

i'm so glad I didnt need to learn spss to do statistics work. there should be a love button. kudos an thanks!!

channeling

You have been the most helpful, my own professor couldn't explain this as good as you. i'm so grateful Got 100 on the homework and quiz!!!!

Sokoral

Can't explain how much this video has helped! for someone who doesn't usually use excel and statistics is not my strong point, this has potentially saved me from making huge mistakes in my psychology assessment!!

princessshaki

So easy to follow and a calming tone ❤ Thank you!

Bri-tr

Thank you for both the part 1 and part 2. I am completing my doctorate and was having an issue working out the formulas by hand. I totally forgot about the simplicity of the correlation formula and the ability to use the regression formula for the correlation validity. I appreciate it.

theculpeppers

man I think your video is so much better than how i received my research method training!! and yours is also very practical!

travisjiang

Because of your video I was able to complete my assignment.Just got saved 😌

govindvarma

Excellent. I was struggling on the analysis part and this is the best one I came across. Three videos (install data analysis, correlation and P value)together is a complete package. Thanks a lot. It helped in my project.

amitbasu

Thank you so much! After hours of searching I find this useful video.

nneditzz

I was going to learn how to calculate p value in Epi Info when I came across this video. I had no idea I could do this using Excel. Thank you very much!!

animationpoint