I'm looking to calculate the standard deviation when all I have is the average alongside how many records there are.
In my dataset I have been provided, I can see an average value which is reflected in the top 5 of the dataset provided.
How can I get the values in between, roughly speaking?
For example, I have an average of £735 in the top 5.
Thanks.
You can’t.
If I understand correctly, you are given the values of $n$ and $\frac1n\sum_{k=1}^nx_k$. It is not possible to recover the individual values of the $x_k$ from this, which are needed to compute the standard deviation.