Statistics

Projected State Populations

This scatter plot graph was created with sample lab data using MS Excel. The goal was to estimate the populations of four states in the year 2050. The graph shows a polynomial trendline for each state as well as the trendline equation. Since we now know the equation, the population (y) can easily be calculated by plugging in the year (x). The graph is then very useful as a reference to check if our calculations are in the ballpark.