Hi @aus22,
Please add your JMP file instead of Excel file, as all scripts are lost when using Excel files (unless converting files from JMP to Excel with the Table Attributes Add-In).
Table 2 seems to be a transpose of Table 1, or did I miss something ? In any case yes, table 2 is a comparative file between products in column, separated in 3 choice sets with 4 products in each choice set.
Yes you can simulate data when creating your design, go into the red triangle next to "Choice Design" and click on "Simulate Responses" :
It will create formula columns for probability calculations and choice simulated, depending on the marginal utility values entered :
You can then launch the script "Choice" (or go to Analyze, Consumer Research, Choice) and analyze the simulated Choice response. You will have access to various Profilers (utility, probability profiler) and comparison analysis, as well as Willingness to Pay metric if you have specified your variable Price as Continuous numerical factor type.
You can practice with the dataset "Laptop Results.jmp", available in the Sample Index (Help, Sample Index) and follow the analysis method on this use case here : Example of Making Design Decisions
Hope this answer will help you,
Victor GUILLER
L'Oréal Data & Analytics
"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)