Friday, April 28, 2017 11:13:35 AM
My Assumptions:
(a) Right Now - 110 Alive
(b) Target - 98 Alive
(c) March 20th 2017 - the 98 ALIVE I developed in March 2017 will be
the SAME 98 ALIVE in June or July or August or Sept or whatever
THEY DO NOT CHANGE
(d) What does change is the END OS EVENT DATE -
(e) The (c) above determined that MEDIAN OS was 44 months -
based on
(1) dispersing 98 alive across a 331 population
(2) calculating the MONTHS IN TRIAL for ALL 331 based on the
following -
MONTHS IN TRIAL = MONTHS BETWEEN (June 1, 2017 - ENTRY DATE MONTH/YEAR)
(3) locating the 49th ALIVE person amoung the 98 defined in (1)
See Chart below
(f) Now what this all means (c) thru (f) is the following
this equation will change depending on when we hit 233 events
MONTHS IN TRIAL = MONTHS BETWEEN (June 1, 2017 - ENTRY DATE MONTH/YEAR)
Median OS = 44 Months
OR
MONTHS IN TRIAL = MONTHS BETWEEN (JuLY 1, 2017 - ENTRY DATE MONTH/YEAR)
Median OS = 45 Months
OR
MONTHS IN TRIAL = MONTHS BETWEEN (August 1, 2017 - ENTRY DATE MONTH/YEAR)
Median OS = 46 Months
OR
MONTHS IN TRIAL = MONTHS BETWEEN (September 1, 2017 - ENTRY DATE MONTH/YEAR)
Median OS = 47 Months
Please see the following and do the following -
(1) Find Column T - that NUMBERS the 98 ALIVE from 1 to 98
(2) Walk down Column T - until you hit #49
That patient is the MEDIAN PATIENT
(3) Look in Column S -
that 44 number represents this Excel formula -
MONTHS IN TRIAL = MONTHS BETWEEN (June 1, 2017 - ENTRY DATE MONTH/YEAR)
THAT NUMBER 44 IS THE MEDIAN OS of the 49th patient
(4) As a consequence of all I have written -
there is NO NEED to recalculate a Median spreadsheet for each
possible monthly outcome -
For each month that we go past June - add 1 additional month
to the MEDIAN OS of 44 months that was applicable to the 49th
identified ALIVE person ... whose MEDIAN OS was calculated by
MONTHS IN TRIAL = MONTHS BETWEEN (June 1, 2017 - ENTRY DATE MONTH/YEAR)
I am sorry - but I am very certain in my logic about this -
** the 98 were identified and do not change
** the time in trial for 98 was based on the diff between their
entry date and June 1, 2017
** Whatever the results were at June 1, 2017 for each of the 98 alive
records - just add 1 month if we go to July 1, 2017 etc
** It goes without saying that it is IMPOSSIBLE for me to identify
THE TRUE 98 ALIVE - but having played with this enough - I know I am
in the ballpark in that 2 others have suggested different distributions
of 98 ALIVE so as to make a worse outcome - but they could not
screw with these good results (44 months) for a reason they could
not envision - WE HAVE TOO MANY ALIVE 98 ACROSS A VERY LIMITED
RECORDSET OF 331 - so of course the median is gonna be high
anyway - if my post is like MUD or SHIT - yell back and I will
try to answer better ....
Remember - we are in Excel - AND WE CAN ANALYZE ANYTHING
WE WANT - in a relatively short amount of time
regards
Summary
Recent NWBO News
- Biophma Announces Exclusive In License for Dendritic Cell Technology, Sending Shares Higher • AllPennyStocks.com • 06/17/2024 04:40:00 PM
- Form 8-K - Current report • Edgar (US Regulatory) • 06/04/2024 09:11:16 PM
- Form DEF 14A - Other definitive proxy statements • Edgar (US Regulatory) • 06/03/2024 09:22:55 PM
- Form PRE 14A - Other preliminary proxy statements • Edgar (US Regulatory) • 05/22/2024 08:13:36 PM
- Form 10-Q - Quarterly report [Sections 13 or 15(d)] • Edgar (US Regulatory) • 05/10/2024 09:04:57 PM
- Form NT 10-K - Notification of inability to timely file Form 10-K 405, 10-K, 10-KSB 405, 10-KSB, 10-KT, or 10-KT405 • Edgar (US Regulatory) • 03/01/2024 10:04:38 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 12/02/2023 01:31:35 AM
- Form 8-K - Current report • Edgar (US Regulatory) • 11/16/2023 10:11:54 PM
- Epazz, Inc. (OTC Pink: EPAZ) ZenaDrone Demonstration to Defense Departments of UAE and Saudi Arabia • InvestorsHub NewsWire • 11/15/2023 12:19:31 PM
- Form 10-Q - Quarterly report [Sections 13 or 15(d)] • Edgar (US Regulatory) • 11/09/2023 09:30:39 PM
- Epazz, Inc. (OTC Pink: EPAZ) US Navy Collaboration ZenaDrone 1000 • InvestorsHub NewsWire • 11/09/2023 01:00:34 PM
- Epazz, Inc. (OTC Pink: EPAZ) US Navy Collaboration ZenaDrone 1000 Extreme Weather Demo • InvestorsHub NewsWire • 11/07/2023 12:29:43 PM
- Form 10-Q - Quarterly report [Sections 13 or 15(d)] • Edgar (US Regulatory) • 08/09/2023 08:36:14 PM
Mass Megawatts Announces $220,500 Debt Cancellation Agreement to Improve Financing and Sales of a New Product to be Announced on July 11 • MMMW • Jun 28, 2024 7:30 AM
VAYK Exited Caribbean Investments for $320,000 Profit • VAYK • Jun 27, 2024 9:00 AM
North Bay Resources Announces Successful Flotation Cell Test at Bishop Gold Mill, Inyo County, California • NBRI • Jun 27, 2024 9:00 AM
Branded Legacy, Inc. and Hemp Emu Announce Strategic Partnership to Enhance CBD Product Manufacturing • BLEG • Jun 27, 2024 8:30 AM
POET Wins "Best Optical AI Solution" in 2024 AI Breakthrough Awards Program • POET • Jun 26, 2024 10:09 AM
HealthLynked Promotes Bill Crupi to Chief Operating Officer • HLYK • Jun 26, 2024 8:00 AM