Statistics advance

Hello, 

I was wondering if you could help me solving and understanding my homework step by step in Statistics for managers course using Microsoft Excel 2011 with PHStat add-in. The homework covers chapter 13 and 14 of the book which is about Linear Regression Models. It is from the textbook, one on page 518 and the other one is on page 567. Please let me know as soon as possible!

Thanks.