stats question

please find atached. The paragraph in yellow is supposed to be worked out by me.You are to provide big explaining comments on every analysis and graphs. A summary is also supposed to be made. I have to do last 8 tabs in the attached worksheet.