Business Finance Homework Help
Rasmussen College Salary Distribution Analysis Business Management Worksheet
INSTRUCTIONS
Scenario (information repeated for deliverable 01, 03, and 04)
A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:
A listing of the jobs by title
The salary (in dollars) for each job
Spreadsheet
- The client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.
- Background information on the Data
The data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.