business accounting
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 US states (Home Values
).
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.
Details of the assignment are contained in the document MBA 6350 Case Study 1
.
I have also prepared a MS Word Template
that you can use that can help with drafting a quality case study report in MS Word in APA format (it can also be found in the Helpful Resources module).
The case study is due on Sunday by 11:59 pm of Week 2. Please refer to the rubric for grading criteria.
Resources:
Videos:
- How to Install the Data Analysis ToolPak in Excel (PC) (Links to an external site.)

- How to Install the Data Analysis ToolPak in Excel (Mac) (Links to an external site.)

- How to Create Box Plots in Excel (Links to an external site.)

- How to Create a Histogram in Excel (Links to an external site.)

- How to Create a Scatter Plot in Excel (Links to an external site.)

- How to Run Descriptive Statistics in Excel (Links to an external site.)

- How to Run a Correlation Matrix in Excel (Links to an external site.)

6 years ago
20
Purchase the answer to view it

- MBA.xlsx
- MBAPaper2.docx
- 3 pages history major writing paper about U.S. history during the 20th century
- HSA300(health servuices organization
- high school world history online
- Store manager project .. 10$ for original work
- ACCT 525 Week 2 Assignment
- Please share a key philosophical insight from the chapter 5 textbook reading, and how you agree or disagree with it.
- LAW SCHOOL PERSONAL STATEMENT SAMPLE ATTACHED
- Process Analysis paper
- File attached
- PSY 450 Application of Cross-Cultural Psychology Presentation - Coca Cola Core Values*****Already A++ Rated Tutorial Use as Guide Paper*****