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

Use your research and Excel to:

1. Derive and confirm the regression equation for this Nike sale data.
2. Use this function to extrapolate Dillard's monthly Nike shoe sales remaining in 2012 (The world comes to an end in 2012) and 2013.
3. Using interpolation, fill in any missing data points from the historical sales record.
4. Explain why might this curve make sense.
5. Explicitly identify your answers in your Word report and on your spreadsheet.
6. Predict the total number of Nike shoes that will be sold by Dillards in 2013.

Present your findings in a professional, MS Word processed format (to include supporting calculations and spreadsheets).

Send this final Word document report to mheinen_1@msn.com. Include (attach) the Excel spreadsheet with the MS Word document.

Ensure both files are "print" ready.

Name your MS Excel spreadsheet file: Stats-Shoes-Lastname

example:Stats-Shoes-Heinen.xlsx

(the computer will add the suffix .xlsx)

Due Date: before end of 1st Quarter.