G
Guest
I'm trying to calculate the number of standard deviations from the mean for
each data point. I have to do this many (pehaps hundreds) of times within a
given spreadsheet. My delema is that when I drag down my formula, it
references another number other than the STDEV, seeing there is only that
there is only one STDEV for a great number of values. How can I make Excel
reference the same STDEV while still changing the data point of comparison?
I having a working solution but it isn't very elegant at all.
each data point. I have to do this many (pehaps hundreds) of times within a
given spreadsheet. My delema is that when I drag down my formula, it
references another number other than the STDEV, seeing there is only that
there is only one STDEV for a great number of values. How can I make Excel
reference the same STDEV while still changing the data point of comparison?
I having a working solution but it isn't very elegant at all.