You just learned how to evaluate pay compression by computing compa-ratios and comparing them with employee tenure. Now, it’s time to apply your new skills to a new dataset, which appears in the sheet called “Practice” in the Excel workbook. Imagine that you’re working at a different company but are still focusing on the job of a Customer Service Representative. There are 108 customer service representatives, and the pay range/grade midpoint for the job is $41,250. Respond to the following: 1. Introduce the topic, why it is important, and the specific assignment. Include appropriate attribution. 2. Calculate the compa-ratio for each individual customer service representative. What is the highest and lowest compa-ratio that you observed? What does that mean (include appropriate attribution)? 3. Calculate the overall average compa-ratio across all customer service representatives. What is it? Is the company compensating people noticeably below or above the pay range/grade midpoint (on average)? Explain (include appropriate attribution). 4. Create a scatterplot with the tenure and compa-ratio variables. Is there evidence of pay compression or inversion? How do you know (include appropriate attribution)? 5. Include a few of your own screen shots of the work to ensure you independently completed the assignment. These can be included as an appendix at the end of the report (after your reference page) of built into the report. You can use “snipping tool” to copy / place your screenshots (for ease of reproduction and placement).