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 number and sub-part letter. along with the English
meaning of each number.
You will not get
credit for work that is not clearly labeled!
Address the email to 7020 [at] 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.
Do not combine different assignments in 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.
4. Is the following statement justified by the data? Why or Why
not?
"If you go to college you will be less
satisfied in your work than if you don't"