Creating Formulas Hands-on Activities

[#1]

These hands-on activities allow you to practice creating formulas using the formula editor inJMP. The data files for the activity are in the zip file attached to this post. Extract the data in Formulas Hands-on Activity.zip for use in the following activities. Click this link for the solutions. A PDF file of these activities and solutions (in English) is attached to this post.

1. A book publisher wishes to know if there are more defective books printed on Monday or Friday. Open the Publishing data table and add two formula columns to create the following graph.

2. As part of a manufacturing process, cells are grown in bioreactor tanks whose environment is regulated by automated sensors. The cell density is recorded every 12 hours. Three replicated measurements are taken. The growth since the beginning of the run is expected to follow an exponential growth and decay curve. Open the Growth Control data table and add two formula columns to build the following graph.