Results 1 to 2 of 2

Math Help - Coefficient of Correlation?

  1. #1
    Junior Member
    Joined
    Oct 2007
    Posts
    48

    Question Coefficient of Correlation?

    Hi,

    help me to solve this..

    X=2,4,5,6,8,11
    Y=18,12,10,8,7,5

    (i)Calculate coefficient of correlation, using Excel function, for the above data.
    What type of relationship is found between the variables X and Y?

    (ii) Construct a Scatter diagram for the above Data.

    (iii) Now subtract 10 from values of ‘X’ and divide by ‘5’.Also subtracts ‘4’from values of ‘Y’ and divide by ‘2’.

    Now again calculate coefficient of correlation .And give reason why answer do or do not match.


    Thnx
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by cu4mail View Post
    Hi,

    help me to solve this..

    X=2,4,5,6,8,11
    Y=18,12,10,8,7,5

    (i)Calculate coefficient of correlation, using Excel function, for the above data.
    What type of relationship is found between the variables X and Y?

    (ii) Construct a Scatter diagram for the above Data.

    (iii) Now subtract 10 from values of ‘X’ and divide by ‘5’.Also subtracts ‘4’from values of ‘Y’ and divide by ‘2’.

    Now again calculate coefficient of correlation .And give reason why answer do or do not match.


    Thnx
    This question is for you to practice using Excel not the mathematics of statistics.

    Enter the data in two adjacent columns in a new sheet.

    Select any other cell, then go to the insert menue, and select function..

    Change the category to statistical, scroll down to CORREL and follow the instructions.

    RonL
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 0
    Last Post: February 25th 2011, 12:15 AM
  2. Replies: 1
    Last Post: December 11th 2010, 10:16 PM
  3. Correlation coefficient?
    Posted in the Statistics Forum
    Replies: 4
    Last Post: June 28th 2010, 09:13 PM
  4. correlation coefficient help
    Posted in the Advanced Statistics Forum
    Replies: 6
    Last Post: January 7th 2010, 04:57 PM
  5. Correlation coefficient
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: October 10th 2009, 09:23 AM

Search Tags


/mathhelpforum @mathhelpforum