How to Calculate Correlation in Microsoft Excel | Step by Step Guide
How to Calculate Correlation in Microsoft Excel | Step by Step Guide
How to Calculate Correlation in Microsoft Excel | Step by Step Guide
Correlation is a statistical measure (expressed as a number) that describes the size and direction of a relationship between two or more variables. A correlation between variables, however, does not automatically mean that the change in one variable is the cause of the change in the values of the other variable.
Note: 1= Correlation does not imply causation.
Positive Linear Correlation. There is a positive linear correlation when the variable on the x -axis increases as the variable on the y -axis increases. …
Negative Linear Correlation. …
Non-linear Correlation (known as curvilinear correlation) …
No Correlation.
#howto #microsoftexcel #correlationcoefficient
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~”
Links,
Facebook.
https://web.facebook.com/researchgat…
Blogspot.
https://educationalhubayeshamushtaq.b……
Twitter.
https://twitter.com/Ayesha08671094.
Related videos.
https://www.youtube.com/watch?v=ICoWv…
https://www.youtube.com/watch?v=TPJWh…
• วิดีโอ
Content
0.14 -> hi I'm Aisha you are watching educational
hub in this video I will show you how to calculate
8.29 -> a correlation in Microsoft Excel let's begin
11.79 -> [Music]
18.619 -> [Music]
25.449 -> okay now there is a work around here and what
we need to do okay if we go to regression
32.36 -> and select that so we can obtain a p-value
this way foreign [Music]
55.52 -> [Music] now what we will do you can see there
are two boxes here input y range and input
70.96 -> X range so for input y range we will go ahead
and select the exam grade value and I'm also
78.95 -> going to select the LA ball or the valuable
name in the first row here
83.3 -> [Music]
90.43 -> [Music] okay next click in input X range box
here and then select our studies and all the
103.72 -> value there and then be sure if you do select
the variable name as I have here be sure select
111.11 -> labels okay let's go ahead and click OK and
then here we get our output I'm going to expand
119.259 -> this little bit just to the values foreign
125.32 -> we need there is a lot of information here
but I really only need a few values and let's
130.81 -> go ahead and highlight those here so first
of all let's make this font a little bit bigger
137.67 -> so it is easier to read
149.94 -> alright then we will expand what we need here
now first of all if you see we have just two
156.97 -> variable like we do in the correlation example
where we have our studies an exam grade then
163.45 -> with two variables the multiple R is just
identical to the Pearson R so you can see
169.22 -> how this is also once again 0.86 foreign so
we could really just run regression to get
178.38 -> our correlation if you look under multiple
R here now for the p-value what we want to
185.11 -> do is we can go to the Anova table and under
significance here this is RP value and it
191.81 -> is very small there [Music]
200.33 -> okay now just in case you are interested there
is also the exact same p-value when we have
206.86 -> just two variables also is under our studies
where it says p-value [Music] so you can see
218.73 -> how two are the exact same here significance
F and p-value they are identical now what
225.79 -> we are going to do here we will use Alpha
.05 and the decision rule is as follows if
232.579 -> our p-value as as given by the significance
F or p-value right here
237.62 -> [Music]
244.28 -> [Music]
250.94 -> if it is less than .05 then the correlation
is statistically significant and since .0001
259.95 -> is definitely less than .05 that indicates
the correlation is in fact significant [Music]
277.08 -> since this correlation coefficient of 0.86
is statistically significant that means that
283.43 -> there are significant positive relationship
between our studies and the grade on the exam
288.94 -> and we can go ahead and write the results
as follows
294.9 -> there is a positive relationship between number
of hours spent studies and the grade on the
299.81 -> exam and then I have R and that's for Pearson's
R 11 and that's equal to the degrees of freedom
307.3 -> where DF is equal to -2 and N is e equal to
13.
311.96 -> so 13 minus 2 is 11.
316.669 -> [Music] so R11 equals 0.86 and that was the
value of Pearson's R if you remember and I
328.03 -> put p as less than .001 now alternatively
you could put p as less than .05 if you wanted
336.97 -> to [Music] foreign [Music] gives us more information
it has more information than the p-value is
348.29 -> less than .05 but since we used an alpha of
.05 in this test it would be acceptable to
355.729 -> put p as less than .05 if we wanted to but
this does provide more information and the
362.63 -> reason why I said p is less than .001 is because
if you look back our window in Excel our output
370.61 -> foreign [Music]
378.479 -> and it is goes to four decimal places before
the one appears but it is not less than .0001
386.25 -> in any event in most cases when you see a
p-value reported like this is usually does
392.57 -> not get smaller than less than .001 that about
the limit where we reported in our written
399.099 -> results
400.099 -> foreign
Source: https://www.youtube.com/watch?v=zs5QWaIRSfk