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.
 

Thread 'Trigonometry problem of interest'

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...
View full post »

Thread 'Six Pencil Puzzle'

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.
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top