Issue when importing repeated measure data

[tomcolas]

Hello,

I am new to MLwiN, and I have been struggling to import data from an Excel file (my data file is attached).

DonneesML.xls

issue when importing repeated measure data - excel file

(139.5 KiB) Downloaded 7 times

Importing the data using the Edit/Paste Data option seems to work; however, when inspecting my data, only the "subject" and "stimuli" columns seem to have correct values. All the other columns appear completely wrong. In the "Names" window, the mean, max, and min are completely different from what I expect. For example, the "annoyance" column shows a mean of 144 when it should be around 4.

After some digging, it seems that the software interprets the values from these columns as categories and automatically assigns somewhat random values to these categories. For example, in the "annoyance" column, the first cell, which should have a value of 1.94, is given the value 1; the second cell is given the value 2, and so on (with some cells containing values very close to previous ones being assigned the same categorical value).
Even after using the Toggle Categorical option in the Names window, these variables retain the wrong values.
All I want is the original values from my Excel file to be retained.

I have tried other ways to import the data, but nothing seems to work, and I’m stuck unable to use my data.
If anyone has any advice, that would be great!
I hope this message is clear enough.

Looking forward to your answers.
Take care,
Tom

[ChrisCharlton]

Can you confirm which version of MLwiN you are using? I just tested this and it loaded correctly for me. Are you able to say which other ways you have used to try importing the data? The File>Import... menu should allow you to load a variety of text based formats.