Homework Assignment 1:  Looking at Job Satisfaction


Create a new, blank Excel spreadsheet
        Each student must start with a new blank Excel worksheet
        File sharing of any kind, even raw data, is not allowed.
Go to the website http://sofia.whalen3.org/06HW/Employee_Data.html
Click "Edit,", then click "Select all"
Copy the page to the clipboard and paste it into your spreadsheet.
Save a copy.

The variable JOBSAT  is an individual's score on an assessment of their satisfaction with his or her job.  Use the =QUARTILE( function to find the Inter-Quartile Range.  Tukey's rule can be interpreted as specifying a "low normal" value and a "high normal" value, such that an individual observation outside this range is an outlier that may need an assignable cause analysis.  Fund these "Tukey fences" (the
"low normal"  and  "high normal" values) and compare them to the minimum and maximum values od JOBSAT to check for outliers.  You MUST use the Excel functions; no credit for typing the numbers into the cells.

Insert a new column between the current column B and C:  put the cursor in column C, click Insert, and click Column.  Label the column "Rounded JOBSAT"
Use the =ROUND function with num_digits equal to negative 1 to round JOBSAT to the nearest ten point level.

Make a real Excel pivot table: click anywhere on the data base:
Procedure
for pre-2007 Excel:
Click Data, click Pivot Table, Next, Next, Existing worksheet
In the box that opens up, specify a cell to the right of the data base, with a blank column in between
Click Layout and drag Rounded Jobsat into both Row and Data
In Data, click on "Sum of Rounded Jobsat" and change it to "Count"
Click Finish

Make a graph of the pivot table by clicking on the chart icon or clicking Insert and Chart.
Click on the graph background and choose "Clear" to get rid of Excel's silly colored background.

Clock here to see what your spreadsheet should look like
 Click here to see the formulas view


Attach your spreadsheet to an email to oochitel [at] sofia [dot] whalen3 [dot] org.
The subject line of your email must be the three characters HW1 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 receive credit!
Do not combine multiple assignments into the same email.


In the ***BODY*** of  the email (NOT a Word or Excel attachment!)
include a one page essay about what a manager can learn from the analysis done in Homework 1.


For extra credit, repeat the analysis for  some of the other variables the way you did for job satisfaction.