RDW in the blood report

Z

zeee

Newbie
Messages
3
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..
 
urbanracer

urbanracer

Expert
Retired Moderator
Messages
5,206
Type of diabetes
Type 1
Treatment type
Insulin
Dislikes
Not being able to eat as many chocolate digestives as I used to.
zeee said:
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..
Click to expand...


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.

upload_2021-1-20_15-20-4.png
 
Dark Horse

Dark Horse

Well-Known Member
Messages
1,840
This info might be useful:-

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%.​
 
Top Bottom