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

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

[@AliceJaneSwan1224]

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

[@channeling101]

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

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

[@Jack-v4i4u]

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.

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

[@govindvarma2443]

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

[@travisjiang5112]

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

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

[@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.

[@Bri-t6r]

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

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

[@nneditzz4159]

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

[@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.

[@AJMusicUganda]

YOU MADE IT LOOK EASY LIKE EASE. THUMBS UP

[@storybubble5726]

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

[@aidanlynch10]

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

[@hersheylatte6633]

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

[@madushaniranasinghe298]

You are the best for anlysis

[@TheMissmakeuphall]

you have just saved my dissertation! thank 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

[@DanFirthoh]

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

[@bashiryayasarki2193]

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

[@md.mostafijurrahman7561]

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

[@MrAnene1]

The explanation is very clear and understandable.

[@AgroDidata]

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

[@bigrussianboywithgun]

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

[@atbobby6817]

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

[@myles1005]

awesome! you make it easier than my professor

[@monaabdelmeguid4073]

These videos really helped me, thank you

[@fepiedad4494]

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

[@Frostbite720]

You are a savior man thanks so much

[@QuantitativeSpecialists]

You bet, Ryan! Glad to hear it helped!

[@thurayaahmed4272]

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

[@larisaconstantinou]

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

[@QuantitativeSpecialists]

Thanks for the feedback, Larisa!

[@paulmercer6899]

Very Helpful Video!

[@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

[@mortaaleksiejunaite2465]

that was so helpful. I love u

[@oldIndiangarage]

You are best 👍

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

[@ravikishorergajavalli]

Very good explanation and easily understood!!!

[@elois_jp]

Your video is so helpful thank you!!!

[@vmm6256]

thank you sooo much took me ages to find this

[@mermaidsarevegan2240]

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

[@nikitasharma1614]

Nicely explained. Thanks

[@N64PSXDCnow]

Thanks for this man, major help

[@namhoan1]

Thank you so much 🙏🏻

[@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

[@todoOnadaEnlavida]

Great video!Thanks a lot!

[@leelandrogers4581]

This was very helpful. Thank you!

[@TheAhmedtChannel]

Wonderful video, thanks

[@pacmn777]

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

[@anotherdamntroll]

you explain it well. thank you sir

[@sve2727]

Wow! I get it! Well done!

[@rinsedpie]

brilliant teacher

[@titosoysoy582]

Thanks man! it helps a lot!

[@2ndChance54]

Good video. Thank you

[@bolivaramon2215]

ME HA SERVIDO MUCHO... GRACIAS

[@QuantitativeSpecialists]

BOLO AMON Gracias, Bolo. Me alegra que poder ayudar!

[@THEANESTHESIST]

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

[@TheaFabian-s4m]

You are awesome.

[@dinaneel6255]

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

[@jessicachavarria6126]

Perfectly explain! thanks so much! :)

[@ladymora8073]

excelente video, me sirvió montones, gracias!

[@giselegiram]

A nice video. Very useful

[@bumbie888]

Thanks! helped me a lot!

[@QuantitativeSpecialists]

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

[@e1i4s]

Life saver, ty a lot.

[@DanielMartinez126]

Saved my life

[@sanb.521]

Very good! Thank you!

[@QuantitativeSpecialists]

+Sandra Böddeker My pleasure, Sandra. Thanks for letting me know!

[@maisarahmohdzahari7165]

tq so much! this tutorial really helped me!

[@QuantitativeSpecialists]

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

[@Sharma2-u1k]

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?,,,,,

[@pamrooks]

Very helpful -- thanks!

[@youhaventgotaprayer]

Very helpful

[@sonuthapa8651]

Thank you so much sir ...

[@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.

[@elena-dh2im]

thank you sir!

[@sonjab9182]

I have a question. When doing Pearson's correlation I get a negative value, but with the regression it is positive. Does this influence the assumption? Thanks for this both (part 1 and 2) videos...it's very clear and informative.

[@regineregunda8444]

same here sir, have you got the answer for this question?

[@elmars9794]

Great job. thank you.

[@wakeg40]

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

[@abdulrahmannafiu5441]

what do you do during a multiple regression and the computer says that x variable can't have the same number of column and row

[@Luna-lg7wb]

any answer ?

[@rakshakanwar3988]

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

[@sapientboy7557]

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

[@Nadjavkp95]

Thank you kind sir

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

[@Cat_main_apex]

Thanks for the help, you sound like Kevin Spacey btw

[@jaykenarn6223]

is there a video on how to interpret all those values?

[@lungdupak5978]

You found one?

[@jaykenarn6223]

@@lungdupak5978 nope. Cause I didn't search further

[@JuuriNightray]

Thank you so much!

[@ma.janedaling727]

How do you get 0.05 in Alpha?

[@nemanjailic8950]

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

[@sb12083]

Cool ! Thanks!

[@dalehawley9927]

I love the way you explain this so I can understand!! But my Excel (2010) won't recognize the column labels and returns an error. If I try it without including the labels, the results show only 12 observations rather than 13. I'm using the same data you have here. What am I doing wrong?

[@t1m3todance]

+Dale Hawley I had this problem too in regards to something else. If you use labels, select the labels box, if you don't then don't. Try playing around with that. For me, my problem was I had labels selected when I wouldn't include the label. Hope that maybe helps!

[@QuantitativeSpecialists]

+t1m3todance I concur. Thanks t1m3todance!

[@urielmenalled9998]

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

[@GlowingSkull27]

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

[@pmcf273]

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

[@phuonganhh2493]

Hi! Thank you for the video. However, i am a bit confused by the degree of freedom. I have learnt that df= n-1, but in your video, you stated that df= n-2. Could you please explain to me why it is n-2 instead of n-1? Thank you so much

[@QuantitativeSpecialists]

+Cecilia Dinh Hi Cecilia, My pleasure! Briefly, df = n -1 when there is one variable. Because there are two variables in correlation, df = n - 2.

[@kaii7959]

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

[@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?

[@عماداحمدياس]

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

[@pablofya]

thanks so much