Forum Discussion
Solved
Standard Deviation and Formula Look Up
Hello. I am having an Issue with my standard deviation not adjusting based off the date when looking up values. So the formula will not find the date in the table and update the averages based off th...
See the attached version.
Also,
Will this work for the rest of the metrics like Broad, vert, and things like that?HansVogelaar
See the attached version.
I still seem to be getting zero. Might just have to scrap this work book and go with a different route. Thank You for your help HansVogelaar
If you select the 17th of February, the Standard Deviation for most subjects will be zero since the data for those subjects are all the same. The standard deviation of a series of identical numbers is 0.
In the screenshot, you'll see that the weights vary, but all Broad values are the same, as are all Vert values, etc.