Formula for normalizing data to control mean
Here's the very simple situation I have:Column A: Continuous data on treatment levels in an experiment. 0 = controlsColumn B: Continuous data that is the response metric to the treatment. Column C: Formula that calculates response metric from Column B normalized (i.e. divided by) the mean of the responses in the controls (rows where Column A=0).How do I write the formula in Column C to do this no...