Homework Assignment 6: Salary and Education

This assignment is based on the spreadsheet Jobsat.xls
Answer the questions in the BODY of an email, not a Word or Excel attachment.
Clearly label each question and sub-part. along with the English meaning of each number.
            You will not get credit for work that is not clearly labeled!
Address the email to oochitel [at] sofia [dot] whalen3 [dot] org
The subject line of your email must be the three characters HW6 followed by one space and your name.
PLEASE do not use a different subject line; it interferes with the emails going where they need to go to be graded!
Do not combine multiple assignments into the same email.

1. Use the data on the tab "Salary," especially cells F16-G18, to estimate:
a. the average job satisfaction of employees whose salary is 50.0,   and
b. the average job satisfaction of employees whose salary is 70.0

2. Use the data on the tab "Education," especially cells  F16-G18, to estimate:
a. the average job satisfaction of employees whose education is 12 years,   and
b. the average job satisfaction of employees whose education is 18 years.

3. Use the data on the tab "Multiple," especially cells F16-G19, to estimate:
a. the average job satisfaction of employees whose salary is 60.0 and education of 12,   and
b. the average job satisfaction of employees whose salary is 60.0 and education of 18.