Hi, can some one please help me work out the RDW in the blood report, from the report it says that my MCV: 87fl and my is RDW: 12% what I would like to do is stick the working out formula onto a Excel sheet. were i get stuck is the sd Standard Deviation thing..
Hi, can some one please help me work out the RDW in the blood report, from the report it says that my MCV: 87fl and my is RDW: 12% what I would like to do is stick the working out formula onto a Excel sheet. were i get stuck is the sd Standard Deviation thing..
It's not entirely clear to me what you're aiming to do here but :
You are aware that there's a built in Standard Deviation function in Excel ?
If you wanted to know the Standard Deviation of (say) the numbers in column A then type =STDEV.S(A1:A6) in the cell where you want the answer to appear.
The two RDW measurements currently in use are the red cell distribution width - coefficient of variation (RDW-CV) and the red cell distribution width - standard deviation (RDW-SD).
The RDW-CV is a calculation based on both the width of the distribution curve and the mean cell size. It is calculated by dividing the standard deviation of the mean cell size by the MCV of the red cells and multiplying by 100 to convert to a percentage. A normal range for the RDW-CV is approximately 11.0 - 15.0%. Because it is a calculation, the RDW-CV is dependent not only on the width of the distribution curve but also the MCV of the red cell population and may not always reflect the actual variation in red cell size. Be aware that:
A homogenous population of red cells with a narrow distribution curve and low MCV may have an elevated RDW-CV
A heterogeneous population of red cells with a broad distribution curve and a high MCV may have a normal RDW-CV.
The RDW-SD is an actual measurement of the width of the red cell distribution curve in femtoliters (fL). The width of the distribution curve is measured at the point that is 20% above the baseline. Since the RDW-SD is an actual measurement, it is not influenced by the MCV and more accurately reflects the red cell size variance. The normal RDW-SD range for adults is 40.0 - 55.0 fL. https://www.labce.com/spg579122_red...The RDW-CV is a,is approximately 11.0 - 15.0%.