
Hi,
I was wondering what is the most elegant, easiest and hopefully automated way to show multiple significant differences between groups in DataGraph.
I have 7 groups of data that I need to show their significant difference pairwise.
Thanks,
Kourosh
Hello Kourosh,
We uploaded a file to the examples that generates the mean and standard deviation from 7 groups of data.
The file uses expression columns to create a list for unique combination. Here are the expressions that generate the list in two columns A and B.
A = kceil((1 + sqrt(1+8*(n#+1)))/2)
B = A+A.countwhere
k = number of unique groups (in this case 7)
n = number of unique combinations
= k*( k− 1)/2Once these columns are populated (A and B), they are used to pull the associated means at that row index. (e.g., ColumnName(index) ), such that each pair of means is in one row of the table.
Here is a visual representation of each comparison.
This could be a starting point for performing other statistical testing but before we went much further and wanted to get your feedback.
Thank you for your quick response and this amazing example. This is indeed very useful and a very good starting point.
Looking at this example, what I want to do is to have a bar plot showing mean and std of each group (1 to 7). Then show if difference between them is statically significant or not, preferably by labeling them (similar to the attached figure).
I have already done the statistical analysis with Tukey’s HSD using Python (so I have F and pvalues and I know the differences between means of which pairs are statistically significant). I want to see what is the easiest way to achieve a figure similar to the one attached with DataGraph.
Thanks,
KouroshThe above figure is from this reference:
M. Aliabouzar et al., “Acoustic Droplet Vaporization in Acoustically Responsive Scaffolds: Effects of Frequency of Excitation, Volume Fraction and Threshold Determination Method.,” Ultrasound Med Biol, vol. 45, no. 12, pp. 32463260, 2019
You must be logged in to reply to this topic.