2 Case Study – Data Visualization and Descriptive Statistics

Pay Attention to All case calculations are indicated using spreadsheet formulas; calculations are 100% correct; all required aspects/calculations of the case are completed and presented.

Presents detailed and thorough narrative analysis that addresses all relevant aspects of case; presents recommendations supported clearly by the case data and accounting principles

Case data is formatted professionally (concisely and clearly); case presentation is easy to follow; correct formatting for text and numerical data.

Standard accounting formats (as presented in course materials) is used to present accounting data; case narrative is well-organized; no mistakes in spelling or grammar. Supporting documentation is presented in correct APA format.

Home_Values

.1

.7

.2

0

71

69

64

74.2

96500

70

69

69.2

23094 68.2

71

69.9

134100

69.6

68.9

64.8

&”Helvetica Neue,Regular”&12&K000000&P

MBA 6350

Case Study 1 – Data Visualization and Descriptive Statistics

The data file
Home_Values.xlsx
contains median home values (
Home Value
), median household income (
HH Inc
), median per capita (
Per Cap Inc
) and percent of homes that are owner occupied (
Pct Owner Occ
) for each state and the District of Columbia. Prior to a more detailed analysis of the data, a company wants to get a good understanding of the 4 variables (e.g. central tendency, variability, shape of the distribution, pattern of relationship between the variables). A company representative contracts with you to help with this process. To help the company get a better understanding of the data, you are asked to perform the following analysis steps:

Using Data>Data Analysis>Descriptive Statistics in Excel, calculate the mean, median, range and standard deviation of each variable and summarize the results in table.

Using Excel, create a frequency histogram for each variable to determine the shape of the distributions. Be sure to give each chart a title and label the axes clearly.

Using Excel, create boxplots for each variable. Be sure to give each chart a title and label the axes clearly.

Using Excel, create scatterplots of each variable with each other variable (hint: you should have 6 scatterplots). Be sure to give each chart a title and label the axes clearly.

Using Data>Data Analysis>Correlation in Excel, calculate the correlation coefficient each variable with each other variable.

In Word, write a summary report of the findings that includes the tables and charts from steps 1-5 and includes the following:

An introductory paragraph summarizes the purpose of the analysis.

A section (1 or more paragraphs) describing what the tabular data from step 1 indicate about the central tendency, variability and distribution of each variable. For example, do the variables appear to be distributed in a symmetric or skewed pattern.

A section (1 or more paragraphs) describing how the frequency histograms from step 2 and the boxplots from step 3 support and clarify the findings of the tabular data. Include in this section any evidence suggesting outliers in the data.

A section (1 or more paragraphs) describing what the scatterplots from step 4 and correlations from step 5 indicate about the relationship between the various pairs of variables (e.g., are the variables related?, does the relationship appear to be linear or nonlinear?, is the direction of the relationship positive or negative?).

A concluding paragraph summarizing the key findings of the analysis and making recommendations for the variable among
HH Inc
,
Per Cap Inc
and
Pct Owner Occ
that is most strongly correlated with
Home Value
.

Note: Submit a single Excel workbook showing all work for steps 1-5 and a Word document of your summary report that addresses all parts step 6. Make sure to clearly label your tables and charts.

2

5

Case Study – Data Visualization and

Descriptive Statistics

Comment by McCloud, Shawn K. (College of Business-Graduate): Insert your name

Insert your name here

Wilmington University

Survey of Data Analytics

MBA.6350

Dr. Shawn K. McCloud

May XX, 2020 Comment by McCloud, Shawn K. (College of Business-Graduate): Update the date

Case Study – Data Visualization and Descriptive Statistics
Comment by McCloud, Shawn K. (College of Business-Graduate): This document contains headings (like this) and is constructed in APA format. I embedded the instructions and you can use this as a template for the assignment.

Introduction

This section should clearly summarize the purpose of the analysis you are undertaking (per instruction 6a). One or two paragraphs should suffice.
Comment by McCloud, Shawn K. (College of Business-Graduate): About APA writing – please follow these ‘guidelines’ when writing in this course.

When completing this assignment please remember the primary objective of scientific reporting is clear communication (American Psychological Association [APA], 2010, p. 65). In this context, clear communication means presenting ideas in an orderly manner and by expressing yourself smoothly and precisely (APA, 2010, p. 65). To this end, your writing should be concise and communicate your ideas clearly and effectively (APA, 2010, p. 65).

Writing in APA style is concerned with economy of expression which means “say only what needs to be said” (APA, 2010, p.67). Moreover, “short words and short sentences are easier to comprehend than are long ones” (APA, 2010, p. 67). Per Strunk (2014), “a sentence should contain no unnecessary words, a paragraph no unnecessary sentences, for the same reason that a drawing should have no unnecessary lines and a machine no unnecessary parts” (p. 27). Additionally, per Strunk (2014), “prefer the specific to the general, the definite to the vague, the concrete to the abstract” (p. 24).

Overall, your goal should be to examine the statistical data, charts, graphs, etc. and then tell a story about it, per these guidelines (and adhering to the assignment instructions), so that you demonstrate your understanding of the data and can convey critical findings to a reader that may have much less statistical knowledge than you. Think of yourself as a data analyst that needs to put together a meaningful Executive Summary report for your non-statistical boss at work to easily read and understand.

Descriptive Statistics

This section should describe what the tabular data (from step 1 of the assignment) indicates about the central tendency, variability, and distribution of each variable (per instruction 6b). For example, do the variables appear to be distributed in a symmetric or skewed pattern?

Please remember to utilize statistical terms in describing the data and include applicable tables and/or charts (from steps 1-5 of the instructions and from your Excel data). One or two paragraphs should suffice and ensure any graphs or tables have titles and, if applicable, the axes are labeled clearly.

Frequency Histograms and Boxplots

This section should describe how the frequency histograms and the boxplots (from steps 2 and 3 of the assignment) support and clarify the findings of the tabular data (per instruction 6c). Be sure to include any evidence suggesting outliers in the data.

Please remember to utilize statistical terms in describing the data and include applicable tables and/or charts (from steps 1-5 of the instructions and from your Excel data). One or two paragraphs should suffice and ensure any graphs or tables have titles and, if applicable, the axes are labeled clearly.

Scatterplots and Correlations

This section should describe what the scatterplots and correlations (from steps 4 and 5) indicate about the relationship between the various pairs of variables (per instruction 6d). For example, all of the following points for all relationships should be addresses: 1) are the variables related; 2) does the relationship appear to be linear or nonlinear; and, 3) is the direction of the relationship positive or negative?

Please remember to utilize statistical terms in describing the data and include applicable tables and/or charts (from steps 1-5 of the instructions and from your Excel data). One or two paragraphs should suffice and ensure any graphs or tables have titles and, if applicable, the axes are labeled clearly.

Conclusion

This final section contains a concluding paragraph (per instruction 6e) summarizing the key findings of the analysis and making recommendations for the variable among HH Inc, Per Cap Inc and Pct Owner Occ that is most strongly correlated with Home Value.

References

If you use any references (although not required for this assignment) you would list them here… in alphabetical order. If you do not use any references please remove this Reference page before you submit your assignment. Following is how a reference should appear in APA immediately following the “References” heading on the page:

American Psychological Association. (2010). Publication manual of the American Psychological Association (Sixth). American Psychological Association.

Jaggia, S. & Kelly, A. (2019). Business Statistics: Communicating with Numbers 3rd Edition (3rd ed.). New York, NY: McGraw-Hill Education.

Strunk, W. (2014). The elements of style.

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order