Issue when importing repeated measure data
Posted: Fri Oct 10, 2025 12:54 pm
Hello,
I am new to MLwiN, and I have been struggling to import data from an Excel file (my data file is attached). 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
I am new to MLwiN, and I have been struggling to import data from an Excel file (my data file is attached). 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