step by step help with doing a summary report for an excel spreadsheetPurpose

The purpose of this project is to assess your ability to:

• Collect data and display.
• Use Excel.
• Create and interpret Venn diagrams.
• Summarize and report findings.

Overview

In this module, you will turn in the first part of Probability Project 1. This project consists of three parts.

• Project 1-1: Data Collection - Due in Module 2
• Project 1-2: Create Venn Diagrams - Due in Module 3
• Project 1-3: Final Report Submission - Due in Module 4

Venn diagrams can be a useful way to display the results of a survey with multiple questions. At a glance, one can get a general feel of the ways in which the experiences and/or knowledge of a group of people overlap. In this project, you will collect data in a survey and then use a Venn diagram to analyze the results.

Action Items

1. Create ananonymousshort survey as follows:
   • Createthreequestions that can each be answered with either "Yes" or "No" only.
   • Example questions:
     • Do you have/live with a dog? [cat, pet, etc]
     • Do you own your own home?
     • Have you changed jobs within the last 3 years?
     • Have you ever traveled to a country outside of the one in which you currently live?
     • Do you speak more than one language?
     • Do you belong to a gym/fitness club?
     • Have you exercised 3 times in the past 7 days?
     • Have you made an online purchase within the past 30 days?
     • Within the past five years, have you attended a professional sporting event?
     • Within the past five years, have you been on a cruise?
       • Associate each question with a set identifier A, B, C
       • Addonemore question to capture a demographic characteristic that divides your responses into two sets, for example: male or female, under 25 or 25 and over, under 40 or 40 and over, under 60 or 60 and over, student or non-student, etc.
2. Using the same survey for all respondents, collect data fromat least 40subjects.
   • Please do not collect any self-identifying information (such as names and email addresses), as it is not necessary for this assignment.
   • Responses may be collected electronically using a short email or social media post, through an online survey or data collection tool such as Microsoft forms, Responses may be collected electronically using a short email or social media post, through an online survey or data collection tool such as Microsoft Forms, Google Forms, or similar, via a paper form, or even verbally (interviews).
   • Here are two free online survey tools:
     • Microsoft FormsLinks to an external site.
     • Using Microsoft Forms to create a SurveyLinks to an external site.
     • Send a Form and collect responsesLinks to an external site.
     • Adjust the settings of a FormLinks to an external site.
     • Check a Form for resultsLinks to an external site.
     • Google FormsLinks to an external site.
     • How to use Google FormsLinks to an external site.
   • You may choose to offer an opt-out response for the demographic characteristic such as "prefer not to answer," but you must collect a minimum of10responses in each of the two categories and a minimum of40total responses.
3. • Subjects may include family, coworkers, relatives, friends (or your kids' friends), classmates, teammates, random people you encounter, etc.
4. Downloadthe Excel templateDownload the Excel templateand record your responses. See the example below.
5. Complete the summary table on the Excel template:
   • Identify all possible combinations of responses for your survey
   • The total number of responses for each combination
6. Add a brief note describing the source of your data (i.e., who were your subjects) and how you collected your responses.
7. Submit the completed first draft of your Excel file containing your identified questions, data responses, and summary table. Your work will automatically be checked by Turnitin.
8. Access your Turnitin report by reviewing your Submission Details for this assignment. Revise your work as needed based on the feedback.
9. By the due date indicated, re-submit the final version of your work.

Example Table