THIS IS A TABLEAU PROJECT:
For this project, you will be using instructions from Lab 5-1 Alt on page 298.
Imagine that you are performing an analysis for the CFO of ABC Retail Company, and you need to communicate the results of your analysis back to the CFO. The CFO has asked you to provide a statistical analysis of return on sales among competitors in the retail industry. Imagine that you performed the analysis in Excel only.
At ABC Retail Company, the CFO defines outliers as any observations beyond the following boundaries:
- The members of the highest and lowest bin on the histogram.
Project Instructions:
- Data preparation:
- Using the dataset in this assignment, perform Lab 5-1 Alternate on page 298 of your textbook. You do not need to perform the Assessment Steps 1-3. Instead you will be submitting an Excel Workbook with at least four tabs.
- Source data will be on one tab.
- Statistical analysis table will be on another tab.
- Source data with any outliers removed will be on another tab (it’s always a good idea to leave your original dataset intact).
- Re-performed statistical analysis, after removing the outlier, will be on another tab.
- Don’t forget to include your charts!
- Verbal analysis:
- Create a Word document and draft a hypothetical email to the CFO. Your email should include a recap of the work that you performed (use the AMPS model to help you), including the following:
- A: Explain what question was being answered and the purpose of the analysis.
- M: Describe any issues you had in obtaining, cleaning, transforming or using the data.
- P: Give an overview of your analysis procedures and any issues that may require additional validation.
- S: Explain why the results may provide value to making decisions, describing items of interest.
- For this assignment, explain statistical information for return on sales for the retail industry, including the number of companies analyzed, and the average return on sales for the population.
- Identify the outlier(s) by name in the email.
- Remove the outlier(s) from the population. After the outlier has been removed, explain statistical information for return on sales for the retail industry, including the number of companies analyzed, and the average return on sales for the population.
- Submit two files: The Excel Workbook and the Word document.
Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure 100% Original On Time Delivery