O.02: Section 1 Part 1
Section 1: Compound models—adding two model formulas to model combined effects
Compound-model application 1: Modeling mixed populations In an earlier topic we discussed normal-distribution models, whose graph is a “bell-shaped” curve with a single peak. This model is appropriate in many situations where some characteristic of a group of generally-similar objects is distributed around an average value. But when two groups with different averages are mixed, the resulting distribution may have two partially-overlapping peaks, as illustrated below by a dataset on the height of a combined population of male and female students. A single normal distribution will not do a good job of modeling this data.Example 1:
Height data from a co-educational population
The data that produced the above graph is shown in a table to the right. A plausible model for data of this kind is the sum of two normal distributions. This will entail six parameters: total, average, and width for each normal. The formula to be placed into C3 will thus be “=$G$3*NORMDIST(A3,$G$4,$G$5,FALSE)+
$G$6*NORMDIST(A3,$G$7,$G$8,FALSE)”; as always, it should be spread down column C beside all the data rows.As usual, we will set the initial values for the parameters to reasonable approximations before using Solver. In this case, we can do that by setting each “total” parameter to 5,000 (half the overall total), setting the “average” parameters to the approximately the x positions of the two peaks (64 and 70 are close enough), and setting both “width” parameters to a value, such as 2 or 3, that gives a model that is reasonably similar to the data. Then use Solver to minimize the sum of squared deviations, answering “G3:G8” in the “By changing cells” entry field so that all six parameters will be used. As shown below, a good fit is found.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This same sum-of-two-normal-distributions approach can be used in a variety of situations. Sometimes the component distributions have about the same average but greatly different widths, so that the resultant distribution has “fat tails”. Other times the distributions have substantially different totals but nearby averages, so that the result looks like the larger distribution with a bump added on one side. It is often the case that an investigator is interested in only one of the component distributions, with the other values being ignored after the fitting process. An example of each of these kinds of two-normal situations are given below, with the components shown (thin lines) as well as the sum (dots) that reflects the data that would be observed.
Licenses & Attributions
CC licensed content, Shared previously
- Mathematics for Modeling. Authored by: Mary Parker and Hunter Ellinger. License: CC BY: Attribution.

