Evaluating design made by Qualtrics

This forum is for posts that specifically focus on Ngene.

Moderators: Andrew Collins, Michiel Bliemer, johnr

Evaluating design made by Qualtrics

Postby SoradaTapsuwan » Thu Jul 11, 2024 1:35 pm

Hi

I have a design that I exported from Qualtrics as an .xlsx. There are about 1000 rows and each row has 3 alternatives and 5 attributes for each alternative. Could I evaluate the efficiency of this design in Ngene using the "; eval" command and how would I have to modify this .xlsx file so that it could be read and evaluated in Ngene i.e. how do I turn an .xlsx file into a .ngd file?

Sorry if this has been asked before. I can't find it in the search.

Thanks!
SoradaTapsuwan
 
Posts: 2
Joined: Thu Jul 11, 2024 9:44 am

Re: Evaluating design made by Qualtrics

Postby Michiel Bliemer » Thu Jul 11, 2024 2:33 pm

Page 23 of the manual shows an example of the format in Excel.

You can use any header names, Ngene does not use them, but your spreadsheet does need headers in the first row.

First column: use 1 for each row
Second column: choicetask numbers
Other columns: your attributes

Please make sure that you put the attributes in the Ngene script in the same order as they appear in the spreadsheet, first for alternative 1, then alternative 2, then alternative 3. Make sure that the attribute levels in the spreadsheet match the levels in the Ngene script.

Once your spreadsheet is complete, save it, close it, and open it in your project in Ngene. Next, you add, ;eval = spreadsheetname.xlsx to your script.

Michiel
Michiel Bliemer
 
Posts: 1877
Joined: Tue Mar 31, 2009 4:13 pm

Re: Evaluating design made by Qualtrics

Postby SoradaTapsuwan » Thu Jul 11, 2024 4:11 pm

Hi - Thank you so much for your quick reply. It worked!
SoradaTapsuwan
 
Posts: 2
Joined: Thu Jul 11, 2024 9:44 am


Return to Choice experiments - Ngene

Who is online

Users browsing this forum: Google [Bot] and 7 guests

cron