MHB Formula to use instead of model

  • Thread starter Thread starter BTH
  • Start date Start date
  • Tags Tags
    Formula Model
Click For 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.
 

Similar threads

MHB How to Model Capacity for Training 5000 Trainees Annually?
  • · Replies 1 ·
Replies
1
Views
2K
Modeling Air Compression Cylinder
  • · Replies 45 ·
2
Replies
45
Views
5K
MHB Demand and Regression Analysis
  • · Replies 3 ·
Replies
3
Views
3K
I How is Adaptive Optics Revolutionizing Our Understanding of the Galactic Center?
  • · Replies 1 ·
Replies
1
Views
1K
A Modeling the damping of a physical rigid pendulum
  • · Replies 1 ·
Replies
1
Views
2K
I Simple lateral vehicle dynamics model
  • · Replies 18 ·
Replies
18
Views
3K
Atomic displacements, replacements, and radiation damage of structural materials
  • · Replies 1 ·
Replies
1
Views
909
A "The 7 Strangest Coincidences in the Laws of Nature" (S. Hossenfelder)
  • · Replies 62 ·
3
Replies
62
Views
10K
A Why is there no distance-measure in the standard model?
  • · Replies 6 ·
Replies
6
Views
2K
Looking for equation/formula for calculating boomerang trajectory based on few variables for game
  • · Replies 1 ·
Replies
1
Views
3K