Create the same criteria type, "int", for the nGadgets cell. Click the "Solve" button. Excel computes the optimal values for your objective formula's variables (e.g., 19 widgets and 1 gadget).

The first step in running regression analysis in Excel is to double-check that the free plugin Data Analysis ToolPak is installed. This plugin makes calculating a range of statistics very easy.

Critical data, such as laboratory information and other GxP data, is often recorded in spreadsheet applications and are subject to regulatory inspection. Learn how to use Excel’s built in 21 CFR Part ...