How to Calculate Correlation Coefficient

&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;95 -->&NewLine;<div class&equals;"quads-location quads-ad1" id&equals;"quads-ad1" style&equals;"float&colon;left&semi;margin&colon;0px 0px 0px 0&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;<&sol;p>&NewLine;<p><h3>Coefficient of Determination and Non Determination<&sol;h3>&NewLine;<p align&equals;"justify">&NewLine;Coefficient of determination shows the percentage of variance in a variable &lpar;say y&rpar; which is associated with the variance in other variable &lpar;say x&rpar;&period; It is calculated by taking the square of correlation coefficient &lpar;r&rpar; and is expressed in terms of percentage&period; Suppose r &equals; 0&period;40 then r square will be 0&period;16&period; Now the value of r square indicates that 16&percnt; of variation in variable y is explained by variable x&period; <&sol;p>&NewLine;<p align&equals;"justify">&NewLine;The coefficient of non determination &lpar;1- R square&rpar; indicates the amount of variance in one variable or the other which is independent of changes in second variable&period; For example in above case the coefficient of non determination would be 1- 0&period;16 &equals; 0&period;84&period; Thus it means that 84&percnt; of variance in variable y is not explained by variable x&period; <&sol;p>&NewLine;<p align&equals;"justify">&&num;160&semi;<&sol;p>&NewLine;<h3>Probable Error<&sol;h3>&NewLine;<p align&equals;"justify">&NewLine;Probable error is calculated to guard against false conclusions based on the calculation of coefficient of correlation&period; Since in majority of statistical investigations it is impossible to evaluate all the items therefore conclusions are based on a sample&period; The size of this sample has great influence on the results of analysis&period; For example in case of small sample size&comma; it is very likely to end up with wrong conclusions&period; It is therefore necessary to calculate probable error to avoid any error related to the sample size during the calculation of correlation&period; <&sol;p>&NewLine;<p align&equals;"justify">&NewLine;The formula for calculating probable error is given as&colon;<&sol;p>&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;95 -->&NewLine;<div class&equals;"quads-location quads-ad2" id&equals;"quads-ad2" style&equals;"float&colon;none&semi;margin&colon;0px 0 0px 0&semi;text-align&colon;center&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;&NewLine;<p align&equals;"justify">&&num;160&semi;<&sol;p>&NewLine;<p align&equals;"justify"><a href&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image96&period;png"><img title&equals;"image" style&equals;"border-top-width&colon; 0px&semi; display&colon; inline&semi; border-left-width&colon; 0px&semi; border-bottom-width&colon; 0px&semi; border-right-width&colon; 0px" height&equals;"49" alt&equals;"image" src&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image&lowbar;thumb96&period;png" width&equals;"180" border&equals;"0" &sol;><&sol;a> <&sol;p>&NewLine;<p align&equals;"justify">&&num;160&semi;<&sol;p>&NewLine;<p> <strong>Interpretation<&sol;strong><&sol;p>&NewLine;<p> <strong><&sol;strong> &&num;160&semi;<&sol;p>&NewLine;<ul>&NewLine;<li>&NewLine;<div align&equals;"justify">There is no correlation between two variables if the coefficient of correlation r is less than the P&period;E&period; <&sol;div>&NewLine;<&sol;li>&NewLine;<li>&NewLine;<div align&equals;"justify">Correlation exists between two variables if the coefficient of correlation r is more than P&period;E&period; However if r is less than 0&period;20&comma; then the correlation is not appreciable&period; <&sol;div>&NewLine;<&sol;li>&NewLine;<li>&NewLine;<div align&equals;"justify">The correlation is highly significant if r is more than 6 times the size of P&period;E<&sol;div>&NewLine;<&sol;li>&NewLine;<li>&NewLine;<div align&equals;"justify">Limits of correlation are <em>r ± P&period;E<&sol;em><&sol;div>&NewLine;<&sol;li>&NewLine;<&sol;ul>&NewLine;<p align&equals;"justify"><em><&sol;em><&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p align&equals;"justify"><strong>Problem&colon;<&sol;strong> A researcher wants to know the relation between advertisement expenditure and total sales&period; For this purpose he took a sample data of 7 companies for one year&period; The data is given below in the table&period; Find the correlation coefficient and interpret your result&period; <&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p> <a href&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image97&period;png"><img title&equals;"image" style&equals;"border-top-width&colon; 0px&semi; display&colon; inline&semi; border-left-width&colon; 0px&semi; border-bottom-width&colon; 0px&semi; border-right-width&colon; 0px" height&equals;"301" alt&equals;"image" src&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image&lowbar;thumb97&period;png" width&equals;"300" border&equals;"0" &sol;><&sol;a> <&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p> <strong>Solution&colon;<&sol;strong> <&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p> <a href&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image98&period;png"><img title&equals;"image" style&equals;"border-top-width&colon; 0px&semi; display&colon; inline&semi; border-left-width&colon; 0px&semi; border-bottom-width&colon; 0px&semi; border-right-width&colon; 0px" height&equals;"279" alt&equals;"image" src&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image&lowbar;thumb98&period;png" width&equals;"450" border&equals;"0" &sol;><&sol;a> <&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p> <a href&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image99&period;png"><img title&equals;"image" style&equals;"border-top-width&colon; 0px&semi; display&colon; inline&semi; border-left-width&colon; 0px&semi; border-bottom-width&colon; 0px&semi; border-right-width&colon; 0px" height&equals;"352" alt&equals;"image" src&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image&lowbar;thumb99&period;png" width&equals;"250" border&equals;"0" &sol;><&sol;a> <&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p> <a href&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image100&period;png"><img title&equals;"image" style&equals;"border-top-width&colon; 0px&semi; display&colon; inline&semi; border-left-width&colon; 0px&semi; border-bottom-width&colon; 0px&semi; border-right-width&colon; 0px" height&equals;"302" alt&equals;"image" src&equals;"http&colon;&sol;&sol;mba-lectures&period;com&sol;wp-content&sol;uploads&sol;2010&sol;06&sol;image&lowbar;thumb100&period;png" width&equals;"250" border&equals;"0" &sol;><&sol;a> <&sol;p>&NewLine;<p> &&num;160&semi;<&sol;p>&NewLine;<p> <strong>Interpretation <&sol;strong><&sol;p>&NewLine;<p> <strong><&sol;strong><&sol;p>&NewLine;<p> <strong><&sol;strong><&sol;p>&NewLine;<p align&equals;"justify">Since r &equals; 0&period;910 &gt&semi; P&period;E and r is also greater than 6P&period;E&period; Therefore there is high positive correlation between advertising expenditure and annual sales&period; The limits of correlation are from 0&period;87 to 0&period;95&period; The value of r square &equals; 0&period;8281 which shows that 83&percnt; of variance in x is associated with variation in y or vice versa&period; &NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;95 -->&NewLine;<div class&equals;"quads-location quads-ad3" id&equals;"quads-ad3" style&equals;"float&colon;none&semi;margin&colon;0px&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;&NewLine;

Page: 1 2

kasi

View Comments

  • I go through ur correlation & regression chapters but i did not find derivation of any formula. i would like to know the derivation of all formulas. would u pleasure to tell the above

  • In the case of 'r' taking a negative value, how can I interpret the Probable error value i.e say I get 'r'= -0.89 & using the formula indicated I get a value of 0.0625 for the P.E (which is positive), how do I interpret the significance of the 'r' value. Just because r<P.E in this case does it cease to be significant-in which case all negative values of 'r' will not be significant, isn't it?

Recent Posts

Walmat and JCPenney E-Commerce Sales Strategy

Walmart Inc. is the world’s largest retailer, and it is one of the most admired…

3 years ago

Google – CSR and Sustainable Management

This article will analyze in detail the role of managers in the adaptation of corporate…

3 years ago

Strategic Analysis of British Airways

British Airways is a renowned airline company, which has gained success as well as faced…

3 years ago

Knowledge Management System for MJR Advertising

The article is related to the development of a Knowledge Management System (KMS) for MJR…

3 years ago

IKEA – Sales and Strategic Marketing

The report focused on analysis of IKEA, a prominent retail organization, with global operations. The…

3 years ago

Analysis of HRM Strategies at PlusNet and Virgin Media

The report offers an analysis of the human resource management strategies implemented at PlusNet and…

3 years ago