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.
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.
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
- Yes! Thank You! This is big time!
- I still can not seem to get the data to change with the date. So for athlete A on Date 2/16/21 everything shoes up. But when I change the Day it will not change to the data on day 2/17/2021. I can attach what I currently have.
What is your question?
- this is a couple weeks late. But any chance I can still get some help with this work book.
The workbook that I attached a few replies back shows how to do that.