Regression 1 - The Earth's population density and life expectancy over the years is shown in the spreadsheet.



More data on line...

Regression 2 - The velocity of gas in a rocket engine at Point B is correlated to the the temperature at point A. Develop a regression equation and fill in missing values to 1700 degrees C.

Regression 3 - Nike brand shoe sales for Dillard's Stores in Colorado are shown to the right.


Use your research and Excel to:


Derive and confirm the regression equation for this Nike Shoe sale data. Use this function to extrapolate Dillard's monthly Nike shoe sales remaining in 2017 and 2018. Using interpolation, fill in any missing data points from the historical sales record.