Part 1Analyze the data for questions 1, 2, 3, and 4 (binary questions). Your analysis must have thefollowing elements: Sample Size. Sample Proportion of each response. Bar Chart or Pie Chart.Part 2Analyze 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 yoursurvey responses? You might investigate responses for selected variables basedon responses to your binomial questions. For example, if the answer to question 1were Male or Female, and the answer to question 6 were Annual Income, youmight examine average annual income for males only and females only andcompare these results. Present your findings in an appropriate table, graph, or chart. Then, write in thesame Excel spreadsheet a 12 paragraph summary of your findings.Notes Technology: You may need to sort or rearrange your original data file to accomplish some ofthese 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 putaside 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 14, you will need to assign the surveyresponses to 0s and 1s generated for questions 14 in columns A through D. The generatorautomatically generates 0s and 1s for the responses to your binary questions (14). The tooldoes not know your questions or possible responses for these questions. Assign 0 to one ofyour possible responses and assign 1 to the other possible response. For example, if youasked: “Are you male of female?” you could assign Male = 0 and Female = 1, or vice versa. Itis up to you which response to assign 0 and which to assign 1.Submission and Verification Instructions1. When you have completed this assignment, submit your Excel spreadsheet containingParts 13, to your instructor in the Analyzing the Data Set Using Descriptive StatisticsAssignment area. Format your findings with appropriate, legible labels.2. Verify you have included all of the elements for Parts 13 before submitting. You shouldhave:o Four bar graphs (or four pie charts), one each for questions 14.o Competencies Measuredo By successfully completing this assignment , you will demonstrate your proficiencyin the following course competencies and rubric criteria:o Competency 1: Interpret a data set’s central tendency and variability usingdescriptive statistical procedures.o Calculate means correctly for Questions 5 and 6.o Calculate medians correctly for Questions 5 and 6.o Calculate modes correctly for Questions 5 and 6.o Calculate standard deviations correctly for Questions 5 and 6.o Calculate ranges correctly for Questions 5 and 6.o Calculate minimum value and maximum value correctly for Questions 5 and 6.o Create an appropriate graph or chart for Questions 16.o Competency 4: Solve problems in your personal and professional life by applyingstatistical procedures.o Calculate proportions correctly for Questions 14.o Find and explain interesting findings or comparisons as a table.o Find and explain findings or comparisons as a graph or chart.o View Rubricoo Two tables, graphs, or charts to represent interesting findings from your surveyresponses. Include a 12 paragraph summary of your findings.3. Refer to the Analyzing the Data Set Using Descriptive Statistics rubric before submitting toensure your assignment meets the grading criteria.
