+ Reply to Thread
Results 1 to 2 of 2

Thread: Newbie ...stats analysis of research survey using excel

  1. #1
    Points: 171, Level: 3
    Level completed: 43%, Points required for next Level: 29

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up Newbie ...stats analysis of research survey using excel




    I am doing my Masters having not done any stats for 34 years , so I would like your help

    I have undertaken by survey , I have codified by data into numerical data by assigning a number to male or female , and age groups

    I am through the basics such as counting the data doing the graphs , working out mean , median mode and standard deviation.

    i feel i need to take it to the next level , so I am going to attempt correlation and Chi squared

    Question 1

    My third question is one where participants have to rank 5 objectives with number one being the most importunate and number 5 being the least important

    I want to try to assess the correlation between age and the choice of ranking or years or membership and their choice of ranking


    A B C D
    Data (Gender) age years of membership ranking of first statement

    1 1 1 1
    2 1 1 1
    1 3 2 2
    2 3 2 3


    What i want to understand is whether the age of the participant(b) had an impact on ranking of the first statement ?



    Question 1:Is this approach correct ?



    Do the chi squared to understand if there is a relationship between age and ranking of the first statement ?

    If there is a null relationship then stop , if there is a relationship


    Then do correlation and regression to understand the nature of the relationship ?


    Question 2

    Chi squared

    CHITEST(R1,R2)

    slightly confused about how what to include here

    R1 = years of membership ( column C )

    R2 .... do i need to convert the ranking into something else ?


    Ok I have more questions but that is the starting point

    Thank you


    EPY

  2. #2
    TS Contributor
    Points: 17,779, Level: 84
    Level completed: 86%, Points required for next Level: 71
    Karabiner's Avatar
    Location
    FC Schalke 04, Germany
    Posts
    2,542
    Thanks
    56
    Thanked 640 Times in 602 Posts

    Re: Newbie ...stats analysis of research survey using excel


    What i want to understand is whether the age of the participant(b) had an impact on ranking of the first statement?
    Age groups is an ordinal variable. Ranking of first statement is an ordinal variable. You can analyse the relationship between two ordinal variables by using Spearman's rank correlation coefficient rho.
    https://startpage.com/do/search?q=sp...ation+in+excel

    With kind regards

    K.

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats