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

1. ## 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. ## 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.

 Tweet

#### Posting Permissions

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