CU Statistics Qualitative Questions Data Analysis Project

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: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.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.NotesTechnology: 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.