MHB Formula to use instead of model

  • Thread starter Thread starter BTH
  • Start date Start date
  • Tags Tags
    Formula Model
AI Thread Summary
To calculate the expected number of tests administered per month in a study with subjects enrolling and exiting over time, a formula can be developed based on the average number of subjects and their duration in the study. The key is to sum the tests for each month by considering the number of subjects enrolled and their retention period. Utilizing a spreadsheet can streamline this process, allowing for efficient tracking and calculation of tests without needing to model each scenario individually. While a precise formula may vary based on specific study parameters, the focus should be on counting enrolled users for accurate monthly totals. This approach enhances efficiency, especially in larger studies with fluctuating subject numbers.
BTH
Messages
2
Reaction score
0
Scenario: An average of 5 test subjects are brought into a study in subsequent months and are administered 1 monthly test for as long as they remain part of the study. The time they remain in the study is 3 months.

Could someone please explain a formula or technique to sum the number of expected tests per month and total if possible in lieu of having to model it out like below to capture the dynamic of subjects rolling on and off over time? My real example has many more subjects and time on study varies, so a formula would save a lot of time at scale.

View attachment 7679
 

Attachments

  • Test cascade.PNG
    Test cascade.PNG
    3 KB · Views: 117
Mathematics news on Phys.org
I don't think there's anything that's going to make this more convenient than counting the number of users enrolled during a particular month. Using a spreadsheet will speed things up somewhat.
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
Back
Top