How to add Summary Statistics for different X-axis nominal variables

Katz0801 — Tue, 27 Feb 2024 13:45:19 GMT

I have a large database which is formed of multiple experiments which can be separated by the scale of the experiment. I have created a scatter graph in graph builder with scale on the x-axis (a nominal variable with two values) and yield on the y-axis (continuous) with a overlay of experiment (as each experiment has repeats so there are multiple of each). Is there a way to add a summary statistics of mean with error bars of standard deviation for each scale (so one line for the small scale and one for the larger scale)? I tried before but loads of lines appeared because it presented the summary stats for each experiment and its repeats individually.

Additionally, I have a column switcher to change the y-axis to the other variables I have measured and would want the mean/SD statistic to still be present and update depending on my current column selected.

Is there a way to do this? Thank you in advance.

Re: How to add Summary Statistics for different X-axis nominal variables

txnelson — Tue, 27 Feb 2024 18:11:31 GMT

Is this what you want?

Re: How to add Summary Statistics for different X-axis nominal variables

Katz0801 — Wed, 28 Feb 2024 09:25:17 GMT

Hi Jim. Yes this is what I wanted. I followed your image to add the bars and select the correct variables. Thank you

topic Re: How to add Summary Statistics for different X-axis nominal variables in Discussions

How to add Summary Statistics for different X-axis nominal variables

Re: How to add Summary Statistics for different X-axis nominal variables

Re: How to add Summary Statistics for different X-axis nominal variables