JustAnswer



Step 9: Conduct Quantitative AnalysisIn this step, your hard work bears fruit. What does it all mean? Think back to your boss's reasons for tasking you with this project. Bring your powers of analysis to bear to determine what the data may be telling you. Apply your? HYPERLINK "" \t "_blank" quantitative reasoning skills?by answering the questions provided in the resource and writing a short essay.After you answer the questions, your short essay include:a one-paragraph narrative summary of your findings, describing patterns of interestan explanation of the potential relevance of such patternsa description of how you would investigate further to determine if your results could be perceived as good or bad for the company.Prepare your response in this workbook. Create a tab for Quantitative Analysis, create a text box, and paste your answers to above questions and your essay in it. Move the tab to the first tab position.Good job! In the next step, you’ll submit your workbook and analysis.Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you’ve seen in the workforce.1. From the histogram, there are two pronounced peaks of salaries. This may indicate reasonable promotion rate for new employees. Is this distribution unimodal or bimodal?2. The Sales Summary shows sales figure over the years from 1999 to 2014. In 2015, sales slightly decreased. Investors want to know what the projected sales will be in 2017. One method for determining this value is to calculate the average annual growth rate per year, based on historical trends. For example, if sales were $200 last year and $500 this year, the average annual growth rate would be calculated as ($500 – $200/$200)/2. Calculate the average annual growth rate for 1999 – 2015 and projected sales for 2017.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, please 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. Their emphasis is on a diverse, dynamic workforce. From your ‘Graph Charts’ spreadsheet, please describe your pie chart findings for these characteristics of the workforce. Describe how you would determine how 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 identify a rough estimate of the number of positions per job title. From your Excel chart, please identify the mode of the job title distribution. Describe your findings.For your final assignment, write a short three- to four-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. Never simply provide a “raw data” dump. Instead, seek to provide information!Structure your essay like this:a. Write a one-paragraph narrative summary of your findings, describing patterns of interest; b. Provide an explanation of the potential relevance of such patterns; c. Provide a description of how you would investigate further to determine if your results are “good or bad” for the company.Prepare your response in this workbook. Create a tab for QR Analysis, create a text box and paste your answers to the above questions in it. Move the tab to the first tab position. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download