Drug shelf life data with random batches

A quality engineer for a drug manufacturer wants to determine the shelf life for a medication. The concentration of the active ingredient in the medication decreases over time. The engineer wants to determine when the concentration reaches 90% of the intended concentration. The engineer randomly selects 8 batches of medication from a larger population of possible batches and tests one sample from each batch at nine different times.

You can use this data set to demonstrate Stability Study.

You can use the data that contains the fitted model to demonstrate Predict for Stability Study.

Worksheet column Description
RunOrder The order of the experimental runs
Month The number of months from creation in which the samples were tested: 0, 3, 6, 9, 12, 18, 24, 36, or 48
Batch The batch that each sample belongs to: 1 to 8
Drug% The percentage of drug that is present in each sample (response)