stats help 5

1. Answer all questions included in the attached word file, using two excel spreadsheet data: ExamScores.xlsx and Chemitech.xlsx (DUE: Day 7 by 11:59 p.m. )

2. Follow the instructions mentioned in each problem

3. Your answer consists of two parts: (1)excel output and (2) interpretation

– Excel output should include the data and relevant results on hypothesis tests and ANOVA analysis

– You should provide the interpretations, using at least 100 words 

4. Assignment possible points: 30

Try to go through the following procedure, to make data analysis activate if you do not see it on your excel

Open Excel window.

1. Click file

2. Select option

3. Click add-ins

4. Select Analysis ToolPak

5. Click go

6. Make sure you select “Analysis ToolPak”

7. Select ok.