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:

SHOW LESS

Internet 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.

Suggested 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:

Capella Multimedia

Click the links provided below to view the following multimedia pieces:

Library Resources

The following e-books from the Capella University Library are linked directly in this course:

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

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.

Bookstore 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.

Assessment Instructions

Note: Complete Assessment 2 before completing this assessment.

For this assessment, use a data generator tool to generate hypothetical data for the questions you developed in Assessment 2. Then, use Excel to conduct your analysis and interpret the data using descriptive statistics and visual representations of the data.

Data Generation and Preparation

Step 1: Generate Data Using the Survey Data Generator.

Step 2: Prepare for Data Analysis in Excel.

Data Analysis and Interpretation

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:

Part 2: Questions 5 and 6 (Quantitative Questions)

Questions 5 and 6 should have the following elements:

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:

Analyzing Data With Descriptive Statistics Scoring Guide

ACTIVITYExplain 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. 

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.