Unlimited Attempts Now that you have your unique survey data in Excel, you can p

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

Unlimited Attempts
Now that you have your unique survey data in Excel, you can p

Unlimited Attempts
Now that you have your unique survey data in Excel, you can perform descriptive statistics with the tools we learned at the beginning of the course.
Windows PC users: For installing an Analysis ToolPak add-in, please use your HELP feature in your version of Microsoft Excel.
Mac users: StatPlus: mac LELinks to an external site. is the free equivalent for Apple users, but you must download it from AnalystSoft. Note: Excel 2016 now has an available Toolpak add-in.
Make sure you have watched the Week 7 Project Video. Your instructor walks you through the process.
https://media.capella.edu/coursemedia/mat2001eleme…Assignment Instructions
Complete this assignment on one Excel sheet. Access and review the Analyzing the Data Set Using Descriptive Statistics [XLSX].
Include the following components in your analysis of the data:
Part 1
Analyze the data for questions 1, 2, 3, and 4 (binary questions). Your analysis must have the following elements:
Sample Size.
Sample Proportion of each response.
Bar Chart or Pie Chart.
Part 2
Analyze the data for Questions 5 and 6. Your analysis must have the following elements:
Sample mean.
Sample median.
Sample mode.
Sample range.
Sample standard deviation.
Sample minimum and maximum.
Histogram.
Part 3
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 were Male or Female, and the answer to question 6 were 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.
Notes
Technology: You may need to sort or rearrange your original data file to accomplish some of these tasks. Be sure you keep a copy of your original data file as a backup.
Results: Because the survey data generation is done without context, you will have to put aside any preconceived notions about how your data should look. Your task is to analyze, interpret, and communicate the unique results.
Binary Question: For the responses to Questions 1–4, you will need to assign the survey responses to 0s and 1s generated for questions 1–4 in columns A through D. The generator automatically generates 0s and 1s for the responses to your binary questions (1–4). The tool does not know your questions or possible responses for these questions. Assign 0 to one of your possible responses and assign 1 to the other possible response. For example, if you asked: “Are you male of female?” you could assign Male = 0 and Female = 1, or vice versa. It is up to you which response to assign 0 and which to assign 1.
Submission and Verification Instructions
When you have completed this assignment, submit your Excel spreadsheet containing Parts 1–3, to your instructor in the Analyzing the Data Set Using Descriptive Statistics Assignment area. Format your findings with appropriate, legible labels.
Verify you have included all of the elements for Parts 1–3 before submitting. 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.
Refer to the Analyzing the Data Set Using Descriptive Statistics rubric before submitting to ensure your assignment meets the grading criteria.
Competencies Measured
By successfully completing this assignment , you will demonstrate your proficiency in the following course competencies and rubric criteria:
Competency 1: Interpret a data set’s central tendency and variability using descriptive statistical procedures.Calculate means correctly for Questions 5 and 6.
Calculate medians correctly for Questions 5 and 6.
Calculate modes correctly for Questions 5 and 6.
Calculate standard deviations correctly for Questions 5 and 6.
Calculate ranges correctly for Questions 5 and 6.
Calculate minimum value and maximum value correctly for Questions 5 and 6.
Create an appropriate graph or chart for Questions 1–6.
Competency 4: Solve problems in your personal and professional life by applying statistical procedures.Calculate proportions correctly for Questions 1–4.
Find and explain interesting findings or comparisons as a table.
Find and explain findings or comparisons as a graph or chart.

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!