Normalising grouped data in Excel

[@sharonsysy]

Thanks for the tutorial! Very helpful! Just wonder, is it possible to normalize data from two independent experiments by subtraction? e.g. to its own experiment-wise calibrator?

[@baytonater]

How would this be done if you want the base line to be 0 instead of 100?

[@ASOIAFanforlife]

My experiment has two groups of animals. One is treated with Saline and serves as the control. Another is experimental group treated with the drug dissolved in the saline. Both groups have a baseline day or day zero recording when neither saline or drug was administered. Then saline or drug was administered for the next four consecutive days to the respective groups. The long term effect of the drug has to be seen on the behavior and the data is recorded on three different time points- day 21, 31 an 41. How should I normalise the data in order to check the effect of the drug versus saline control group at each time point? Should data recorded on the baseline/day zero in the saline group serve as the standardising/normalising control for both the groups?

[@gulabositabo]

you are god sent, seriously!

[@DoryVideo]

My pleasure Happy Christmas!!

[@tisgiraf9666]

How would you do statistics on these data? Compare control group to drug treated groups? Thx much appreciated

[@noopurmitragotri8427]

You're a saviour 👍 thanks a lot!

[@DoryVideo]

My pleasure!

[@savitabasu1066]

Thank you, this really helped me

[@aaronpaulbaliga2132]

Very clear and helpful!😊😊

[@DoryVideo]

Thanks

[@imbrother1]

thank you. This helps so much.

[@DoryVideo]

Glad to be helpful!

[@awaisiqbal6950]

Saved me! Thank you!

[@DoryVideo]

My pleasure

[@stefankazakov62]

smooth and clear :)

[@ibrahimkhodabocus824]

Thank you so much

[@DoryVideo]

My pleasure

[@dr.asaadaladlaan1079]

THANK YOU SO MUCH.

[@surajapex1682]

thank you....

[@DoryVideo]

My pleasure