topic Re: Using externally calculated st.dev. in X by Y in Discussions

Using externally calculated st.dev. in X by Y

Kanstantsin — Thu, 08 Jun 2023 16:35:57 GMT

Hi everyone,

i occasionally get datasets, where there is no raw data available, just the mean, st.dev. and number of replicates. Is there a way to use this available data to run a t-test, for instance? A quick platform launch is included to show what I want to do.

I was thinking, that maybe constructing a simulated distribution (let's assume it's normal) with the given parameters and counts could be the way to go, but I I'm not sure how to do that. Does anyone have an idea? A scripted solution would be good, i could adapt that.

Have a great day!

Kanstantsin

Re: Using externally calculated st.dev. in X by Y

Georg — Wed, 15 Feb 2023 16:08:57 GMT

You can use --> Sample Index --> Teaching Scripts for a t-test with summary statistics:

But may be not appropriate for many rows.

Re: Using externally calculated st.dev. in X by Y

Mark_Bailey — Wed, 15 Feb 2023 17:34:05 GMT

You might also be able to use this solution.

You would have to run very many bootstrap samples to approach inference by resampling.

Re: Using externally calculated st.dev. in X by Y

Georg — Thu, 16 Feb 2023 08:22:52 GMT

I would probably use this graph to understand the data, mean on y and stddev as interval:

Resampling can be done of course, but will not lead to a good assessment with small differences.

Re: Using externally calculated st.dev. in X by Y

Kanstantsin — Thu, 16 Feb 2023 15:27:05 GMT

Hi Mark,

thanks a lot! yes, this worked rather nicely, and so did the concatenation for categories that Ron mentions in his reply.

Re: Using externally calculated st.dev. in X by Y

Kanstantsin — Thu, 16 Feb 2023 15:30:07 GMT

Hi Georg, thanks for this! Didn't know this option existed! Doesn't scale too greatly unfortunately.

The solution that Mark gave is what I was looking for! And, yeah, that's not a dataset with high effects...