I have a large group of numbers; they are volumes at certain percentages, e.g. (54.32%, 232), (18.5%, 129), (11.98%, 89)...
What I would like to do is have Excel determine what the average volume would be for specified percentages, for example, What is the average volume at 50.00%, 60.00%, etc.
I would also like to be able to determine the standard deviations as well.
Thanks in advance for your help.
What I would like to do is have Excel determine what the average volume would be for specified percentages, for example, What is the average volume at 50.00%, 60.00%, etc.
I would also like to be able to determine the standard deviations as well.
Thanks in advance for your help.