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:
In the text we cover the p-value for Correlation and much more.

YouTube Channel:

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!
YouTube Channel:


Xem thêm bài viết:

34 thoughts on “How to Calculate a Correlation (and P-Value) in Microsoft Excel

  1. 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

  2. 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

  3. Very helpful video. Thank you!
    Here you used Df =n-2 . Is this the rule always when we are considering correlation and regression?
    Also, when do we consider it as n-1?

  4. 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.

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

  6. This video is about regression and hypothesis not about correlation as the title named as correlation it has wasted my time as I was looking for correlation calculation

Leave a Reply

Your email address will not be published. Required fields are marked *