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:

Nguồn: https://paddlewithsim.com/

Xem thêm bài viết: https://paddlewithsim.com/category/cong-nghe

What if Significace F & P values are not same.

great

How and why is r(11) @ 3:30?

awesome! you make it easier than my professor

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

Nicely explained. Thanks

Wonderful video, thanks

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

Lovely

These videos really helped me, thank you

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

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

is it Pearson or Spearman´s way?

Thanks for the help, you sound like Kevin Spacey btw

This will not work with negative correlations r<0, then Multiple R will be positive.

Perfectly explain! thanks so much! 🙂

what about when I got negative value by using =KORREL Excel function and value by doing Regression is positive?

great but how to plot that value in a graph to show the significance

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?

thank you sooo much took me ages to find this

Excellent video.Thank you.

awesome

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

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

What about the 95% CI? Can I read that from this? :s

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.

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

excelente video, me sirvió montones, gracias!

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

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

Excellent

Thanks too you

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

I am sorry but how is it that df=N-2 in your video? Shouldn't it be df=N-1?

Hi! What if my "Significance F" and " P-value" is equal to absolute zero ("0") with no decimals?