Order from us for quality, customized work in due time of your choice.
This assignment will assess your ability to apply the concepts of chapters 1-3 t
This assignment will assess your ability to apply the concepts of chapters 1-3 to conduct an analysis of data on 4 variables collected from the 50 United States (Case Study 2 – Data File – Fall 2021.xlsx Download Case Study 2 – Data File – Fall 2021.xlsx). You will calculate various descriptive statistics, create summary tables and create various charts to summarize the data for a company. Finally, you will create a written report for company leadership summarizing your findings. You will need to enable the Data Analysis ToolPak Add-in on your Data Ribbon in Excel to perform the necessary analyses. Refer to the video on how to enable the Data Analysis Add-in. Note: If you use a Mac, the Data Analysis ToolPak is only available in Excel 2016 or higher.
Please refer to the videos on how to create box plots, create histograms, create scatterplots, run descriptive statistics and run a correlation matrix in Excel.
Copy of instructions and a helpful template to utilize:
Case Study 2 – Fall 2021.pdfDownload Case Study 2 – Fall 2021.pdf
Case Study 2 – Template.docxDownload Case Study 2 – Template.docx
The case study is due on Sunday by 11:59pm of Week 2. Please refer to the rubric for grading criteria.
Resources:
Order from us for quality, customized work in due time of your choice.