Drug shelf life data

A quality engineer for a pharmaceutical company wants to determine the shelf life for pills that contain a new drug. The concentration of the drug in the pills decreases over time. The engineer wants to determine when the pills get to 90% of the intended concentration. Because this is a new drug, the company has only 5 pilot batches to use to estimate the shelf life. The engineer tests one pill from each batch at nine different times.

You can use this data 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 – 5
Drug% The percentage of drug that is present in each sample (response)