Hi all,
I have a really pressing question. I am currently undergoing my final year research thesis and have carried out a quasi experiment. Now I need to analyse the data but finding it very hard. I have no clue when it comes to excel or data analysis so any advice would be good.
I have four data columns in excel as follows:
Fixed Path X, Fixed Path Y, Participant Path X, and Participant Path Y
From the data I created two scatter plot graphs. One highlighting the fixed path (X,Y) and one highlighting the participant path (X,Y). In essence the points represent a location in a four metre by four metre grid and therefore each point on my scatter plot is a certain coordinate.
now my data sets for the fixed path XY, have a total of 80 data points and my data sets for my participant path XY, have a total of 68 data points.
What I want to do is see how accurate my participant path is when it is superimposed onto the fixed path. The fixed path is what the expected path they were supposed to take, and the participant path is my observed path. so basically i need to see how close they were to the actual fixed path..... but i have encountered these main problems when attempting to analyse the data:
1. I am dealing with two sets of varying coordinates
2. I have varying total number of data in my data sets
Can anyone help me? sorry if I've made a mistake anywhere above!
I have a really pressing question. I am currently undergoing my final year research thesis and have carried out a quasi experiment. Now I need to analyse the data but finding it very hard. I have no clue when it comes to excel or data analysis so any advice would be good.
I have four data columns in excel as follows:
Fixed Path X, Fixed Path Y, Participant Path X, and Participant Path Y
From the data I created two scatter plot graphs. One highlighting the fixed path (X,Y) and one highlighting the participant path (X,Y). In essence the points represent a location in a four metre by four metre grid and therefore each point on my scatter plot is a certain coordinate.
now my data sets for the fixed path XY, have a total of 80 data points and my data sets for my participant path XY, have a total of 68 data points.
What I want to do is see how accurate my participant path is when it is superimposed onto the fixed path. The fixed path is what the expected path they were supposed to take, and the participant path is my observed path. so basically i need to see how close they were to the actual fixed path..... but i have encountered these main problems when attempting to analyse the data:
1. I am dealing with two sets of varying coordinates
2. I have varying total number of data in my data sets
Can anyone help me? sorry if I've made a mistake anywhere above!