Spreadsheet modeling assignment | Statistics homework help

This assignment Must be completed using Excel (please show formulas too – cant just have the values showing)
There are three independent assignments. Save the file and submit it here. (photos for each of the problems is attached here) 

Place Order

Location Selection on Page 420 #39;
Portafolio Allocation on page 419 #36 and
Markdown Price Model on page 415 #18