Forum Discussion
Formula for using integral values in a chart, blank spaces, and looking for overall concordance.
SEAK1 See if the attached file has everything as it should be. If not, let me know.
Hi Riny,
Sorry about that. You are absolutely correct, it is much better for me to say it in text.
-- If both ER and PR are greater than or equal to 1, then “Yes” Concordance.
-- If both ER and PR are less than 1 (including zero), then “Yes” Concordance.
-- If ER greater or equal to 1, and PR < 1 (including zero), then “No” Concordance.
-- If ER < 1 (including zero), and PR greater or equal to 1, then “No” Concordance.
-- If “Blank” space, then leave “blank” space in the Concordance column.
--Finally, calculate the overall Concordance at the bottom of the third column…..
Number of “Yes” divided by total number of “Yes” and No”, and express as a “percentage Overall Concordance”.
I hope this helps. Again, Riny, I really appreciate your kindness in helping me with this.
Best Regards,
Steve
SEAK1 See if the attached file has everything as it should be. If not, let me know.
- Hi Riny,
Your formula worked perfectly and gave me the results I needed! There is no way I would have been able to figure it out with your help! I really appreciate it! If I can help you in any way, please feel free to contact me. Thank you again!
Best Regards,
SteveSEAK1 Glad I could help!
Age
ER (%)
PR (%)
ER/PR Concordance
81
99
82
Yes
78
96
86
Yes
73
68
64
95
9
Yes
73
97
44
Yes
71
59
0
0
Yes
46
0
79
Yes
75
99
99
Yes
52
99
0
No
Hi Riny,
I hope all is well. I am so sorry to bother you, but may I please ask you follow-up questions in order to obtain some other data that we need.
--Assuming my chart goes from line 4 to line 10,000, how can I calculate the percentage of “Yes” in the ER/PR concordance for all these 10,000 lines?
Only the Yes’s and No’s should be in the calculation, and skipping the blank spaces (where no ER/PR testing was performed.)
Most will certainly be “blank or empty” spaces but I wanted to have the flexibility for future testing.
In the example above, it should be 87.5%. (7 Yes / 8 Yes + No)
--Finally, if a woman is < 65 years old, how can we calculate the percentage of “ER Negative cases” (where ER % is <1 by definition) from line 4 up to line 10,000 ?
(ER Positive cases would be when ER > 1 ). In the example above, it should be 25% ( 2 / 8 ).
I am having data from line 4 up to line 10,000 to accommodate future testing.
Thank you kindly Riny. I really appreciate it.
Sincerely yours,
Steve