Quantitative Analysis

Tab Quantitative Analysis

Tab 1: Data—completed a datasheet Tab 2: Excel Summary Stats Tab 3: Graphs—Charts Tab 4: Histogram Tab 5: Sorted Data Quantitative Analysis I need help with the five questions and a short essay. 1. From the created histogram, it appears that a large share of employees have a salary between $61,000–$140,000 or $141,000–$190,000. This may indicate a reasonable promotion rate for new employees. Is this distribution unimodal or bimodal? Please explain. 2. The line chart, as detailed in your “Graph Charts” Excel spreadsheet, shows sales generally increasing over the years, although sales in the first two years were notably lower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2019 and 2020. Hint: An easy way to do this is to highlight the sales from the data page and apply the Forecast tool to this data. Your output will be a chart and a new sheet with projected sales for average, upper, and lower range growth. 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, the more narrow the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe your standard deviations. What does this tell you about the variables? 4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, dynamic workforce. From your “Graph Charts” spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how you would determine if the company was meeting expectations on these characteristics. 5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know an estimate of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings. FINAL ESSAY: Write a short three- to a four-paragraph summary of your analysis. 1 Write a one-paragraph narrative summary of your findings, describing patterns of interest. Provide an explanation of the potential relevance of such patterns. Provide a description of how you would investigate further to determine if your results are “good or bad” for the company. Simply expand the text box on the first tab to accommodate the essay and other answers.)