# Charts and Tables

#### Charts and Tables

The post has two asighnments

#### 1: Histogram Charts and Tables

Order Description

Demonstrate practical application of the techniques used to generate and present descriptive statistics.

Competency 1: Evaluate the quality and fit of data for use in business analysis.
Create a summary table for examining data for use in business analysis.
Apply descriptive statistics techniques to accurately compute mean, median, mode, range, and standard deviation.
Competency 2: Analyze business decision opportunities using descriptive statistics.
Analyze data in a prepared histogram to use in decision making.
Analyze data in a scatter plot to use in decision making.
Competency 5: Apply data analysis to general business management planning and decision making.
Compile findings into a management report with details for recommended actions.
Competency 6: Communicate in a manner that is professional and consistent with expectations for members of the business professions.
Communicate in a manner that is professional and consistent with expectations for members of the business professions.
Competency Map

Toggle Drawer
Context
Research basic statistical concepts as well as how to perform descriptive statistics and how to interpret them. Managers make sense of data by using graphing techniques, and graph analyses are useful in making better business decisions. Demonstrate how managers transform data into useful information for making managerial decisions.

Toggle Drawer
Questions to Consider
To deepen your understanding, you are encouraged to consider the questions below and discuss them with a fellow learner, a work associate, an interested friend, or a member of the business community.
Show Less
Suppose that you are a real estate agent in Florida, working with a retired couple from out of state. They are considering purchasing a retirement home in Boca Raton, as they wish to be near family members in Delray Beach. In order to make informed decisions about buying a house, they first need to understand the Boca real estate market.
What home parameters (price mean, price mode, home size mean, home size mode, and so on) would be most useful (or descriptive) in giving your potential clients an understanding of the Boca market?

Toggle Drawer
Resources
Required Resources
This template will assist you in formatting and completing your assessment.
Florida Pool Home Data.
Show Less
Suggested Resources
The resources provided here are optional. You may use other resources of your choice to prepare for this assessment; However, you will need to ensure that they are appropriate, credible, and valid. They provide helpful information about the topics in this unit. The MBA-FP6018 – Data Analysis for Business Decisions Library Guide can help direct your research. The Supplemental Resources and Research Resources, both linked from the left navigation menu in your courseroom, provide additional resources to help support you.
The following texts provide instruction in Statistics.
Bowerman, B., O’Connell, R., &amp; Murphree, E. (2014). Business statistics in practice (7th ed.). New York, NY: McGraw Hill. Available from the bookstore
Chapter 1, &quot;An Introduction to Business Statistics,&quot; in Business Statistics in Practice, pages 3–16.
Chapter 2, &quot;Descriptive Statistics: Tabular and Graphical Methods,&quot; in Business Statistics in Practice, pages 34–74.
Chapter 3, &quot;Descriptive Statistics: Numerical Methods,&quot; in Business Statistics in Practice, on pages 100–140.
Data Analysis Software
For your assessments in this course, you will need to complete statistical calculations, graphically produce an output, and copy your graphical results into a Word document for submission. You may use the statistical application of your choosing; however, the final results must meet the requirements of the assessments. Several options are listed below.
SAS Enterprise Guide:
Access to this software is free to Capella learners taking this course. SAS is one of the most commonly used statistical analysis tools in business. To have free access to this software, you must first register with SAS using the following steps:
After registering and receiving your login ID and password, click the Course Enrollment link provided to you by Capella faculty to access the SAS MBA-FP6018 courseroom.
You only need to access the SAS website to download the SAS Enterprise Guide software. If you have problems with the download procedure, first consult the Capella faculty to determine if you have a hardware compatibility problem. If you are having problems navigating the SAS website, contact SAS Customer Support.
View the Getting Started With SAS Enterprise Guide video for an overview of the basics of the software.
Microsoft Excel Analysis ToolPak Activation for PC Users:
The Microsoft Excel Analysis ToolPak is a specialized Excel add-in included in the standard Microsoft Office suite. If your Excel software meets the standard Capella University Computer Requirements, you will not need to purchase this software. However, you may need to activate the application before you can use it.
Use the Load the Analysis ToolPak instructions from Microsoft’s support site for step-by-step installation instructions. These instructions are designed for Microsoft Excel 2013. If you are using a different version, you can search the Microsoft Office website for version-specific activation instructions. Use the following search terms: Excel analysis ToolPak activation instructions (your version).
StatPlus: mac LE Download for Mac Users: StatPlus:mac is a statistical software tool from AnalystSoft, which is compatible with Excel 2008 and 2011. If you use a Mac and you do not already have this software installed, you can download a 30-day free trial version from AnalystSoft’s StatPlus:mac LE page.
Refer to the Statistical Software page on Campus for general information on SPSS software, including the most recent version made available to Capella learners.
The following text provides instruction for statistical analysis in Microsoft Excel.
Salkind, N. J. (2016). Excel statistics: A quick guide (3rd ed.). Thousand Oaks, CA: Sage. Available from the bookstore
The following text provides instruction for SAS one of the most commonly used statistical analysis tools in business.
Slaughter, S. J., &amp; Delwiche, L. D. (2010). The little SAS book for Enterprise Guide 4.2. Cary, NC: SAS Institute. Available from the bookstore
Statistics Tutorials
Capella University partners with Sophia Learning to provide tutorials and other learning resources online. Sophia tutorials that explore statistical topics related to the assessments will be recommended for your study throughout this course. You may already be familiar with some of the topics addressed in these tutorials. However, you will find that the tutorials build gradually into more complex subjects as the course progresses. You are encouraged to view all of the tutorials that are listed, to refresh yourself on the basics and build your knowledge from a solid foundation. For this assessment, you are encouraged to study the following Sophia tutorials:
This tutorial defines the mean, or average, of a data set.
This tutorial defines variance and the role it plays in a data set.
The tutorial contains several multimedia elements that you are encouraged to view.
Shaw, C. (Producer). (n.d.). Frequency distribution [Video] | Transcript. Retrieved from https://www.sophia.org/frequency-distribution-tutorial
This tutorial explains how to create an XY scatter plot graph in Microsoft Excel.
Brebeuf, C. (Producer). (n.d.). Excel XY scatter plot graph [Video] | Transcript. Retrieved from https://www.sophia.org/excel-xy-scatter-plot-graph-tutorial
The following website links cover many topics in statistics and concepts that you may find useful .

Assessment Instructions
Use the Florida Pool Home Data file, linked in the Resources under the Required Resources heading, to complete the calculations for the following scenario.
You are also encouraged to use one of the statistical applications, such as SAS Enterprise Guide or the Microsoft Excel Analysis ToolPak, suggested in this course. Refer to the instructions in the Resources to activate or download the software.
Practical Application Scenario
Suppose you are a real estate agent living and working in southern Florida. The senior real estate partner of your firm e-mails you the Florida Pool Home Data file and asks you to find ways to use data to describe the most important aspects of home sales. The Florida Pool Home Data file contains the data for 80 properties, including each home’s price, size, number of bathrooms, and niceness rating and whether the home has a pool.
Directions
Use the scenario above and the Florida Pool Home Data file to complete the following:
Create a table in which you calculate the mean, median, range, and standard deviation of home price and size. Then, calculate the mode for the number of bathrooms. Label this table as &quot;Mean, Median, Range, Standard Deviation, and Mode Results.&quot;
Produce a histogram that shows the number of houses by price range, in increments of \$50,000 (for example: \$0–\$50,000, \$50,001–\$100,000, and so on). Label this histogram as &quot;Home Price Range Histogram.&quot;
Produce a scatter plot showing the relationship between price and home size. Under your scatter plot, indicate whether the relationship is positive or negative as well as whether the results are what you expected. Label this scatter plot as &quot;Price and Size Scatter Plot.&quot;
Write a report for the senior real estate partner that details your findings and recommendations about the most important aspects of home sales.