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).
Check out our brand-new Excel Statistics Text: www.amazon.com/dp/B076FNTZCV
In the text we cover the p-value for Correlation and much more.
KZbin Channel: / statisticsinstructor
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!
KZbin Channel: / statisticsinstructor

[@fioralessio]

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

[@QuantitativeSpecialists]

+Alessio Fioravanti Thanks, Alessio - very glad to hear you found the video to be helpful!

[@theculpeppers]

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.

[@AliceJaneSwan1224]

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

[@animationpoint4621]

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!!

[@Sokoral]

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!!!!

[@amitbasu8880]

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.

[@user-ew8mv8db2m]

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.

[@channeling101]

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

[@travisjiang5112]

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

[@hersheylatte6633]

Thanks too you , this video helps me a lot. I am about to cry when my minitab broke down. more power to you!

[@jarhrodriguez646]

Thank you! I've been looking for this for more than an hour now. I'm so happy

[@gerardo4108]

Great, it seems is the only place you can find how to calculate the p-value for a correlation :) nice !! thanks

[@THESCRANBADGER]

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!

[@bashiryayasarki2193]

what about when using 3 variables , is the multiple R still the same as the correlation r ?

[@catherineblue6860]

Adding to the other comments, your explanations were perfect, simple enough for me to understand, and thank you so much for taking the time to post this for us non-loving-statistical-analysis-assignments. You made my day!!!!! By the way, where do you teach? Blue

[@bigrussianboywithgun]

Thanks for the help, it made my life so much simpler!

[@aidanlynch10]

extremely helpful!!!!! literally saved me while i was doing a lab report.

[@mermaidsarevegan2240]

Thank you so much for this video!! Extremely helpful.

[@nneditzz4159]

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

[@thurayaahmed4272]

I am very grateful to you for the simple and useful explanation, thank you

[@reed2196]

Thanks a lot, this saves me from fiddling with SPSS where I have no clue what to do and how it works. I do have a question though: what about having 3 or 4 data columns that need the same treatment? Could you do a video about that too? Thanks, or at least how do I extract p and r from that.

[@govindvarma2443]

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

[@princessshaki]

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!!

[@QuantitativeSpecialists]

Shakiera Anderson - Roscoe Very glad to hear it helped, Shakiera. Thanks for letting me know!

[@AgroDidata]

Man, what a video! I owe my manuscript to you.

[@leelandrogers4581]

This was very helpful. Thank you!

[@ijuolachiobiora6695]

My data is grouped e.g 150-200, 201-300, 301-400 etc. the second set is a response to a likert scale question eg 2,4,1, I understand spearman correlation or mann-whitney u test is appropriate but how do I do this on excel. I really need help on this. thanks

[@pmcf273]

Could I use this approach in calculating the p-value for a 2-sample, unequal variance t-test?

[@MrAnene1]

The explanation is very clear and understandable.

[@storybubble5726]

I understand this better than may stat class. 😊 Thank you

[@pacmn777]

thanks for the help! came in at a perfect time!

[@fepiedad4494]

Thanks for this great video, I now learned how to do correlation and regression...

[@monaabdelmeguid4073]

These videos really helped me, thank you

[@md.mostafijurrahman7561]

Amazing !!!!! Thanks for your lucid explanation !!!!!!!!!! Really it made my day...

[@TheMissmakeuphall]

you have just saved my dissertation! thank you

[@nemanjailic8950]

Great videos! Is there a way to find/search for sequential numbers in one column?

[@eleosas]

Hi, I tried the regression model with three variables but I am not sure how to interpret the results. I get different significance F on the ANOVA table in comparison with the third table were I get two new p-values. If anybody could help on regression with more than 2 variables please do! Thank you for the video.

[@N64PSXDCnow]

Thanks for this man, major help

[@DanFirthoh]

Great explanation...however, how did you determine the Alpha of .05?

[@jessicachavarria6126]

Perfectly explain! thanks so much! :)

[@ravikishorergajavalli]

Very good explanation and easily understood!!!

[@todoOnadaEnlavida]

Great video!Thanks a lot!

[@julie-anntacgos9316]

Super super thank you! I was able to survived my Stat requirements!

[@QuantitativeSpecialists]

+Julie-Ann Tacgos Thanks for letting me know, Julie-Ann!

[@madushaniranasinghe298]

You are the best for anlysis

[@atbobby6817]

I'm wondering how comes of the alpha = 0.05? is it a fixed value?

[@tashidorjee5760]

After following the same steps P-value for one of my variables is found to be 3.68219E-59. How do I convert it to get the value in decimal.? And please, let me know what does this value indicate!

[@zapy422]

Hi! Please does anyone know a function to calculate the khi value ? Thank

[@studywithkelly2022]

Hi, could you please explain how to adjust the values in a data sample to have a standard p-value (p< 0.05)? Thanks

[@urielmenalled9998]

Can one use this method to generate the p-value of a cubic regression?

[@myles1005]

awesome! you make it easier than my professor

[@elois_jp]

Your video is so helpful thank you!!!

[@vmm6256]

thank you sooo much took me ages to find this

[@Luna-lg7wb]

hey, what if you don't have the same number of variables ? thank's a lot

[@katink1425]

any help?? I did the same method of both correlation and regression, there is the same figure for the result of Correlation Function show negative r= -.374, but regression show positive result r= .374 . so why it's difference?

[@giselegiram]

A nice video. Very useful

[@wakeg40]

Great video you saved me a ton of work! :) Is a t-value the same thing as a t-statistic?

[@titosoysoy582]

Thanks man! it helps a lot!

[@ladymora8073]

excelente video, me sirvió montones, gracias!

[@feathera40]

How do I calculate if my two columns don't have the exact same number of cells ? Because the groups whose results I'm trying to compare don't have the same number of participants

[@drmrsnidhisharmavishwakarm7980]

Sir,I want to ask a think that, when I used more than 3 parameters for all subcategories in my study, and subjects are more than 100, with five subcategories, like; 20,20,20,20,20........,then which type of test or statistics I should have to apply?,,,,,

[@ashleyholum9078]

What if on your graph the R value was - because it was going in the negative direction but in the statistics table it is +? How would you word that.

[@anotherdamntroll]

you explain it well. thank you sir

[@dinaneel6255]

nice video and very helpful with it`s explnation, thank u

[@pamrooks]

Very helpful -- thanks!

[@abdulrhmankh8601]

Regression tools are not included in Excel 2011 for Mac! Too bad!

[@THEANESTHESIST]

how to do this calculation in excel 2016, because there is no data analysis function in 2016 version. plz elp.

[@Frostbite720]

You are a savior man thanks so much

[@QuantitativeSpecialists]

You bet, Ryan! Glad to hear it helped!

[@nikitasharma1614]

Nicely explained. Thanks

[@paulmercer6899]

Very Helpful Video!

[@mortaaleksiejunaite2465]

that was so helpful. I love u

[@someguythatfollowstheguywi5953]

Bruh I can't find my Data Analysis Tab

[@tessemamereed1643]

Could anyone help me if the variables are more than two because regression only have two inputs ?????

[@laurab5883]

Is alpha a set value at 0.05 or can it be changed to 0.5?

[@sve2727]

Wow! I get it! Well done!

[@GlowingSkull27]

where is this tool in the updated version of excel. I can't find it.

[@elmars9794]

Great job. thank you.

[@larisaconstantinou4510]

Thank you so much! Your video is very helpful for my lab report.

[@QuantitativeSpecialists]

Thanks for the feedback, Larisa!

[@TheAhmedtChannel]

Wonderful video, thanks

[@davidt.6676]

Is this p value two tails? How do we know? Thanks!

[@rakshakanwar3988]

Which ms excel are you using? I can't find data analysis in mine

[@Cat_main_apex]

Thanks for the help, you sound like Kevin Spacey btw

[@anuradhanaskar4329]

How did you determine the Alpha of .05?

[@lovelygrace6015]

how can i calculate the P value without using the function approach?

[@namhoan1]

Thank you so much 🙏🏻

[@josiahdrake1308]

Said trying do this on chromebook laptop does show the coefficient

[@ma.janedaling727]

How do you get 0.05 in Alpha?

[@kaii7959]

What if you have more than 2 variables? How can you generate a P-value? Regression only has two inputs :(

[@e1i4s]

Life saver, ty a lot.

[@oldIndiangarage]

You are best 👍

[@rinsedpie]

brilliant teacher

[@DanielMartinez126]

Saved my life

[@elena-dh2im]

thank you sir!

[@raidalobaidi]

Very helpful. Though its not working for me i just get a #NUM! as P... I want to calculate P: from Year 2010 (Men 113) (Female 67) vs Year 2014 (Men 76) (Women 25) in fact i would only need to calculate P for Men = 113+76 vs Women = 67 + 25 Can you help me please! Thanks

[@JuuriNightray]

Thank you so much!

[@sb12083]

Cool ! Thanks!

[@user-em4mw7eb7t]

You are awesome.

[@2ndChance54]

Good video. Thank you

[@user-tc6ju1qo1q]

شكرا لك دكتورة ... لو سمحت دكتوره حاولت تفعيل البيانات ولكن لم تتفعل البيانات رغم اتباع الخطوات نفسها

[@bumbie888]

Thanks! helped me a lot!

[@QuantitativeSpecialists]

+Aixa I. Rodriguez My pleasure, Aixa. Glad to hear it helped!

[@maisarahmohdzahari7165]

tq so much! this tutorial really helped me!

[@QuantitativeSpecialists]

My pleasure, Maisarah. I'm glad to hear it helped out!

[@youhaventgotaprayer]

Very helpful