# Analyzing Data With Descriptive Statistics

Generate, analyze, and communicate data using your previously defined survey questions. Required Resources

The following resources are required to complete the assessment.Capella Multimedia

Click the link provided below to view the following multimedia piece:Survey Data Generator | Transcript.

SHOW LESSInternet Resources

Access the following resources by clicking the links provided. Please note that URLs change frequently. Permissions for the following links have been either granted or deemed appropriate for educational use at the time of course publication.Microsoft Corporation. (2014). Office support. Retrieved from http://office.microsoft.com/en-us/supportSuggested Resources

The following optional resources are provided to support you in completing the assessment or to provide a helpful context. For additional resources, refer to the Research Resources and Supplemental Resources in the left navigation menu of your courseroom.Capella Resources

Click the links provided to view the following resources:Analyzing Data With Descriptive Statistics Example (Excel).Analyzing Data With Descriptive Statistics Example (PDF View).Capella Multimedia

Click the links provided below to view the following multimedia pieces:Statistics in Excel 2007: Basic Statistical Functions | Transcript.This presentation addresses mean, median, and mode.Statistics in Excel 2007: Standard Deviation | Transcript.Library Resources

The following e-books from the Capella University Library are linked directly in this course:Everitt, B. S. (2001). Statistics for psychologists: An intermediate course. Mahwah, NJ: Lawrence Erlbaum. Chapter 2, â€œGraphical Methods of Displaying Data,â€ pages 21â€“62.Naghshpour, S. (2012). Statistics for economics. New York, NY: Business Expert Press.Chapter 1, â€œDescriptive Statistics,â€ pages 1â€“28. This chapter covers both descriptive statistics and graphs.Chapter 2, â€œNumerical Descriptive Statistics for Quantitative Variables,â€ pages 29â€“60. This chapter covers central tendency and variation.Scott, I., & Mazhindu, D. (Eds.). (2005). Statistics for health care professionals. Thousand Oaks, CA: Sage Publications.â€Displaying Data,â€ pages 60â€“72.Spiegel, M. R., & Stephens, L. J. (1999). Schaumâ€™s outline of theory and problems of statistics. New York, NY: McGraw-Hill.Chapter 1, â€œVariables and Graphs,â€ page 38. Focus on the Histograms and Frequency Polygons section.Chapter 3, â€œThe Mean, Median, Mode and Other Measures of Central Tendency,â€ pages 58â€“88.Chapter 4, â€œThe Standard Deviation and Other Measures of Dispersion,â€ pages 89â€“113.Urdan, T. C. (2005). Statistics in plain English (2nd ed.). Mahwah, NJ: Lawrence Erlbaum.Chapter 2, â€œMeasures of Central Tendency,â€ pages 7â€“11.Chapter 3, â€œMeasures of Variability,â€ pages 13â€“23.Weinberg, G. H. (2012). Statistics: An intuitive approach. Belmont, CA: Wadsworth Publishing.Chapter 2, â€œThe Mode, the Median, and the Mean,â€ pages 12â€“25.Chapter 3, â€œVariability and Two Measures of Variability,â€ pages 26â€“39.Chapter 5, â€œGrouping Data and Drawing Graphs,â€ pages 53â€“68.Course Library Guide

A Capella University library guide has been created specifically for your use in this course. You are encouraged to refer to the resources in the MAT-FP2001 â€“ Statistical Reasoning Library Guide to help direct your research.Internet Resources

The resource listed below is relevant to the topics and assessments in this course and is not required. Unless noted otherwise, this resource is available for purchase from the Capella University Bookstore. When searching the bookstore, be sure to look for the Course ID with the specific â€“FP (FlexPath) course designation.Bennett, J. O., Briggs, W. L., & Triola, M. F. (2014). Statistical reasoning for everyday life (4th ed.). Boston, MA: Pearson.Assessment Instructions Note: Complete Assessment 2 before completing this assessment.

Complete your analysis (Parts 1â€“3) on one Excel sheet. Include the following components in your analysis of the data. You may wish to refer to the Analyzing Data with Descriptive Statistics  Example  (Excel and PDF versions linked in the Resources under the Capella Resources heading) for further explanation. Note that in order to cover all the survey questions, your submission should include more tables, graphs, and charts than you see in the example.Part 1: Questions 1, 2, 3, and 4 (Binary Questions)

Each question 1â€“4 should have the following elements:Sample size.Sample proportion of each response.Bar chart or pie chart.Part 2: Questions 5 and 6 (Quantitative Questions)

Questions 5 and 6 should have the following elements:Sample mean.Sample median.Sample mode.Sample range.Sample standard deviation.Sample minimum and maximum.Histogram.Part 3: Exploration of Data

Next, explore your data a bit further. What are two interesting findings from your survey responses? You might investigate responses for selected variables based on responses to your binomial questions. For example, if the answer to question 1 was Male or Female and to question 6 was Annual Income, you might examine average annual income for males only and females only and compare these results. Present your findings in an appropriate table, graph, or chart. Then write, in the same Excel spreadsheet, a 1â€“2 paragraph summary of your findings.Assessment Submission Instructions

Submit your Excel spreadsheet containing Parts 1â€“3. Before submitting your assessment, verify you have included all of the elements listed above for Parts 1â€“3. It is important to note that you should have:Four bar graphs (or four pie charts), one each for questions 1â€“4.Two histograms, one each for questions 5 and 6.Two tables, graphs, or charts to represent interesting findings from your survey responses. Include a 1â€“2 paragraph summary of your findings.Analyzing Data With Descriptive Statistics Scoring GuideACTIVITYExplain interesting findings or comparisons as a table, graph, or chart. Calculate ranges correctly. Calculate standard deviations correctly. Calculate modes correctly. Calculate medians correctly. Calculate means correctly. Calculate proportions correctly.

## Why US?

##### 100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

##### Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

##### Original Writing

We complete all papers from scratch. You can get a plagiarism report.

##### Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.