Complete the spreadsheet template following Steps 1–10, building a comprehensive workbook of data and analyses that will inform your conclusions
Complete the spreadsheet template following Steps 1–10, building a comprehensive workbook of data and analyses that will inform your conclusions in Step 10. Your final spreadsheet should include the following: Tab 1: DATA – completed data sheet (Steps
1–6 above) Tab 2: Excel Summary Stats (Step 7) Tab 3: Graphs – Charts (Step 8) Tab 4: Histogram (Step 8) Tab 5: Sorted Data (Step 9) Format this workbook so that all the spreadsheets can be printed. Now that you have completed your analysis, think about the
patterns you’ve seen in the workforce. Write a short 3-4 paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end-user will be able to interpret the data the way it should
be understood. Supporting narrative is helpful (I call this, never simply providing a “raw data” dump – strive to provide information!). The paper sections include - one paragraph narrative summary of your findings; describing patterns of interest - explanation
of their potential relevance of such patterns - describe how you will further investigate to determine if your results are “good or bad” for the company Prepare your response in this workbook. Place it at the front on completion.
a.
As a simple starting point, in cell D9, use
Define a Name under the Formulas menu to create the name "Annual_Hrs."
When setting up the name, enter the constant =2080 in the box named "Refers to." This is the number most often used in annual salary calculations based on full time, 40 hours per week, 52 weeks per year.b.
In E11, create a formula that calculates the hourly rate for each
employee, by referencing the employee’s salary in Column C, divided
by the name you created for the annual hours of 2080. Complete the
calculations for the remainder of Column E.c.
In Column F, calculate the number of years worked for each employee
by creating a formula that incorporates cell F9 and demonstrates your
understanding of relative and absolute cells in Excel.d.
In Column I,use an IF statement to flag with a "Yes" any employees who
have been employed 10 years or more.e.
Using the function VLookup, use the Region Key located at
F417:G420 to fill in the cells in Column N to identify the region in which the employee is located based on the state listed in Column M.
(If this function is new to you, hang in there—this one is worth it!)
Download A+ Rated Solution CLICK HERE
Password shiv for unlock .doc, .xls, .zip file
1–6 above) Tab 2: Excel Summary Stats (Step 7) Tab 3: Graphs – Charts (Step 8) Tab 4: Histogram (Step 8) Tab 5: Sorted Data (Step 9) Format this workbook so that all the spreadsheets can be printed. Now that you have completed your analysis, think about the
patterns you’ve seen in the workforce. Write a short 3-4 paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end-user will be able to interpret the data the way it should
be understood. Supporting narrative is helpful (I call this, never simply providing a “raw data” dump – strive to provide information!). The paper sections include - one paragraph narrative summary of your findings; describing patterns of interest - explanation
of their potential relevance of such patterns - describe how you will further investigate to determine if your results are “good or bad” for the company Prepare your response in this workbook. Place it at the front on completion.
a.
As a simple starting point, in cell D9, use
Define a Name under the Formulas menu to create the name "Annual_Hrs."
When setting up the name, enter the constant =2080 in the box named "Refers to." This is the number most often used in annual salary calculations based on full time, 40 hours per week, 52 weeks per year.b.
In E11, create a formula that calculates the hourly rate for each
employee, by referencing the employee’s salary in Column C, divided
by the name you created for the annual hours of 2080. Complete the
calculations for the remainder of Column E.c.
In Column F, calculate the number of years worked for each employee
by creating a formula that incorporates cell F9 and demonstrates your
understanding of relative and absolute cells in Excel.d.
In Column I,use an IF statement to flag with a "Yes" any employees who
have been employed 10 years or more.e.
Using the function VLookup, use the Region Key located at
F417:G420 to fill in the cells in Column N to identify the region in which the employee is located based on the state listed in Column M.
(If this function is new to you, hang in there—this one is worth it!)
Download A+ Rated Solution CLICK HERE
Password shiv for unlock .doc, .xls, .zip file
Comments
Post a Comment