How to Calculate a Correlation (and P-Value) in Microsoft Excel
ฝัง
- เผยแพร่เมื่อ 24 ส.ค. 2024
- 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...
In the text we cover the p-value for Correlation and much more.
TH-cam 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!
TH-cam Channel: / statisticsinstructor
After searching for almost one hour, I can say you are the only one of all youtubers to perfectly explain the correlation. Thank you!
+Alessio Fioravanti
Thanks, Alessio - very glad to hear you found the video to be helpful!
Dude. I LOVE YOU. You saved me from our thesis which our defense is tomorrow. THANKYOU
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.
i'm so glad I didnt need to learn spss to do statistics work. there should be a love button. kudos an thanks!!
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!
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!!!!
Because of your video I was able to complete my assignment.Just got saved 😌
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!!
Shakiera Anderson - Roscoe
Very glad to hear it helped, Shakiera. Thanks for letting me know!
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.
man I think your video is so much better than how i received my research method training!! and yours is also very practical!
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.
Thank you so much! After hours of searching I find this useful video.
Bruh I can't find my Data Analysis Tab
Great explanation...however, how did you determine the Alpha of .05?
I understand this better than may stat class. 😊 Thank you
I'm wondering how comes of the alpha = 0.05? is it a fixed value?
You are the best for anlysis
what about when using 3 variables , is the multiple R still the same as the correlation r ?
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!!
Thanks too you
, this video helps me a lot. I am about to cry when my minitab broke down. more power to you!
extremely helpful!!!!! literally saved me while i was doing a lab report.
The explanation is very clear and understandable.
you have just saved my dissertation! thank you
Amazing !!!!! Thanks for your lucid explanation !!!!!!!!!! Really it made my day...
How do you get 0.05 in Alpha?
Man, what a video! I owe my manuscript to you.
how to do this calculation in excel 2016, because there is no data analysis function in 2016 version. plz elp.
Great, it seems is the only place you can find how to calculate the p-value for a correlation :) nice !! thanks
I am very grateful to you for the simple and useful explanation, thank you
awesome! you make it easier than my professor
Thanks for this great video, I now learned how to do correlation and regression...
You are best 👍
Thank you! I've been looking for this for more than an hour now. I'm so happy
Thanks for the help, it made my life so much simpler!
These videos really helped me, thank you
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
that was so helpful. I love u
You are a savior man thanks so much
You bet, Ryan! Glad to hear it helped!
Very good explanation and easily understood!!!
Thank you so much! Your video is very helpful for my lab report.
Thanks for the feedback, Larisa!
You are awesome.
Very Helpful Video!
Very helpful
Hi, could you please explain how to adjust the values in a data sample to have a standard p-value (p< 0.05)? Thanks
Super super thank you! I was able to survived my Stat requirements!
+Julie-Ann Tacgos
Thanks for letting me know, Julie-Ann!
Thank you so much 🙏🏻
Thank you.
great
Your video is so helpful thank you!!!
Nicely explained. Thanks
Thank you so much for this video!! Extremely helpful.
you explain it well. thank you sir
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.
thank you sooo much took me ages to find this
What if you have more than 2 variables? How can you generate a P-value? Regression only has two inputs :(
thank you sir!
Thank you kind sir
brilliant teacher
Saved my life
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.
same here sir, have you got the answer for this question?
Okay. Thank you for the video man. But there is far more easy to compute a pearson and its pvalue. Using your example, it is as simple as
First note that we have 13 pairs of observations
And 2 degress of freedom
*** The correlation ***
In D1 we have : =pearson(B2:B14,C2:C14)
which returns 0.860462439748914
*** The t-stat ***
In E1 we have : =D1*(13-2)^0.5/(1-D1^2)^0.5
which returns 5.60108604214799
*** The probability value ***
And finally in F1 we have : TDIST(ABS(E1),(13-2),2)
which returns 0.000160052673878084
Thanks. Everyone should clue into how much more awesome this answer is.
Thanks for the informative comment. If now I was to try and use this correlation to predict a future SAT score, would I just treat it like a regression (y = mx + b) line and be 99.999% confident? Thanks!
Wonderful video, thanks
Thanks for this man, major help
Great video!Thanks a lot!
This was very helpful. Thank you!
nice video and very helpful with it`s explnation, thank u
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.
Wow! I get it! Well done!
thanks for the help! came in at a perfect time!
Thanks for the help, you sound like Kevin Spacey btw
Good video. Thank you
thanks so much
Great video you saved me a ton of work! :)
Is a t-value the same thing as a t-statistic?
شكرا لك دكتورة ... لو سمحت دكتوره حاولت تفعيل البيانات ولكن لم تتفعل البيانات رغم اتباع الخطوات نفسها
Regression tools are not included in Excel 2011 for Mac! Too bad!
Perfectly explain! thanks so much! :)
ME HA SERVIDO MUCHO... GRACIAS
BOLO AMON
Gracias, Bolo. Me alegra que poder ayudar!
Thanks man! it helps a lot!
excelente video, me sirvió montones, gracias!
Very helpful -- thanks!
Thank you so much sir ...
Thanks! helped me a lot!
+Aixa I. Rodriguez
My pleasure, Aixa. Glad to hear it helped!
A nice video. Very useful
Life saver, ty a lot.
Very good! Thank you!
+Sandra Böddeker
My pleasure, Sandra. Thanks for letting me know!
Great job. thank you.
Lovely
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
+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.
tq so much! this tutorial really helped me!
My pleasure, Maisarah. I'm glad to hear it helped out!
where is this tool in the updated version of excel. I can't find it.
Excellent
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
is there a video on how to interpret all those values?
You found one?
@@lungdupak5978 nope. Cause I didn't search further
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
any answer ?
Great videos! Is there a way to find/search for sequential numbers in one column?
Thank you so much!
Cool ! Thanks!
dose not work if there are missing data
any solutions ?
Perfect, but may need video quality (specially in illustrating screen dialog box).
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?,,,,,