Data normalization and analysis

Question

[Adyasha]

Hello everyone,

I am testing 5 epigenetic drugs on SARS-Cov2. I have generated RTPCR results for all 5 drugs. Below is how my example dataset looks like

Here are RT-PCR result(Ct values) of RNA extracted from the samples and its replicates. PC= Positive Control.

I want to keep MS2 as internal control and keeping that value as 100, want to normalize the dataset to compare the drug responses. Please help me on how it could be done.

Thanking you in advance.

[1769mkc]

perhaps you should put the value and format it instead of posting image which is not helpful at all even if someone comes up with solution since its difficult to recreate the data by looking and typing it again.