Use the Formula Editor to create columns that contain calculated values.
The sample data table On-Time Arrivals.jmp reflects the percent of on-time arrivals for several airlines. The data was collected for March, June, and August of 1999.
Suppose that you want to create a new column containing the average on-time percentage for each airline.
1. Add a new column.
2. Right-click the column heading of the new column and select Formula. The Formula Editor window appears.
Figure 3.12 Formula Editor
Create the formula for the average on-time percentage of each airline:
3. From the Columns list, select March 1999.
4. Click the button on the keypad.
5. Select June 1999, followed by another sign.
6. Select August 1999.
Figure 3.13 Sum of the Months
Notice that only August 1999 is selected (has the blue box around it).
7. Click the box surrounding the entire formula.
Figure 3.14 Entire Formula Selected
8. Click the button.
9. Type a 3 in the denominator box, and then click outside of the formula in any of the white space.
Figure 3.15 Completed Formula
10. Click OK
The new column contains the averages.
The Formula Editor has many built-in arithmetic and statistical functions. For example, another way to calculate the average on-time arrival percentage is to use the Mean function in the Statistical functions list. For more information about all of the Formula Editor functions, see Create Formulas in JMP in Using JMP.