Calculus homework help

Download the employment_stats_assignment_3.xlsx file and review all of the worksheets (there are 9 individual worksheets) and answer all of the questions in the file. Once you’ve answered all of the questions, submit the file as your third assignment.
  • Instructions:
    This final assignment workbook contains multiple worksheets, make sure you review them all before working on this assignment.
    The first sheet “rawData” has (as the name implies the raw Data file).
    The second sheet has a listing of different occupation codes and titles.
    The third sheet (area_state) has a listing of states by area.
    The remaining worksheets include additional problem sets.
    Show all your work. Simply having the answer (and not the underlying function(s) or pivots) will not be sufficient for any points.
    Points Possible
    20 Problems 1 – 2: Using a function learned in class, pull in the state_abbreviation and state_title from the area_state worksheet into the rawData file (into Columns C and D). So that the accurate state information is listed in the appropriate row as per the unique field.
    Hint: The area code is the unique field to join these tables together.
    20 Problems 3 – 4: Using a function learned in class, pull in the OCC_Title and OCC_GROUP from the occ_info worksheet into the rawData file (into Columns F and G), so that the accurate occupation information is listed in the appropriate row as per the unique field.
    Hint: The OCC_Code is the unique field to join these tables together.
    60 Problems 5 – 10
    See the remaining worksheet tabs for the remaining problems associated with this assignment.
    100
    Data Source: United States Deparment of Labor
    Bureau of Labor Statistics
    Occupational Employment Statistics
    Downloaded from: http://www.bls.gov/oes/tables.htm in August 2015
    Note: This workbook has been severly edited for this assignment. All but 5 states and 5 OCC Categories have been eliminated to help minimize the Excel file size.