Forum Discussion

Dtripple40's avatar
Dtripple40
Copper Contributor
Feb 17, 2021
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...
Formulas and Functions
Dtripple40's avatar
Dtripple40
Copper Contributor
Feb 17, 2021

Also,

Will this work for the rest of the metrics like Broad, vert, and things like that?HansVogelaar 

  • Dtripple40's avatar
    Dtripple40
    Copper Contributor
    Feb 18, 2021

    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 

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Feb 18, 2021

      Dtripple40 

      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.

      • Dtripple40's avatar
        Dtripple40
        Copper Contributor
        Feb 18, 2021

        oh man that is tough. thank you. that helped a lot. I should be able then to just paste function in for weight and date next to the subject as well correct? That should give me the subjects metrics on the correct date as well?HansVogelaar 

Resources