cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
ropeburn007
Level I

All pairs, Tukey HSD graph builder

Hey @everyone,

 

Does anyone have a script to take data from the Fit Y by X analysis tool and add the connected letters report to the table itself?

I am doing this manually in powerpoint, but I have a lot of data to analyse, so any tip or trick would help.

Thanks

 

I am looking for a result that looks like this, or close.

ropeburn007_0-1718661445118.png

This was generated by adding the letters one by one onto the graphs, but it is not sustainable long term with the amount of data we are dishing out!

Thanks for your help!

2 REPLIES 2
shampton82
Level VII

Re: All pairs, Tukey HSD graph builder

Could you do something like this:

Fit Y by X and then broadcast the Tukey analysis:

shampton82_0-1718663986916.png

Then use "Make combined data table" to save out the levels and the letters:

shampton82_1-1718664072492.png

Concatenate them into one column then use Join or Virtual join to get them back to the main table and use that new column as your label in graph builder?

 

Could probably use a WorkFlow builder to automate the flow.

jthi
Super User

Re: All pairs, Tukey HSD graph builder