The company will be developing a payroll system using the SDLC. Currently, the project is in Phase 1 ("Definition"). Because it has yet to be determined if an Orange County location will be opened, it is unknown if any employees for this location will be incorporated into the payroll system. You are part of the project team and have been tasked with conducting an analysis related to hourly salesperson wage for the Orange County area, which is another key determining factor to whether to open the Orange County location. The company owner would prefer to not open a retail location in an area in which the mean hourly wage is greater than 5% of the national mean.

Using the data in the provided spreadsheet, compare the mean hourly wage for the "Los Angeles-Long Beach-Anaheim" area to the national mean (you will need to compute this yourself) and make a determination based on the aforementioned 5% threshold. Also, as an additional illustration, compare the "Los Angeles-Long Beach-Anaheim" area with all other areas in California (taken as a group) with respect to hourly wage.

Write a 300 - 500-word report using Microsoft Word to the company owner in which you share your analysis and recommendation based solely on the factor of hourly wage. You can present it in any way you wish, but you must include at least one visual accompaniment (e.g., chart, graph, table).

Spreadsheet:

https://drive.google.com/file/d/1i_JZsumMJ5kst0sIf2uM28rI2FRFhQAh/view?usp=sharing