Analyzing the Data Set Using Descriptive Statistics

Analyzing the Data Set Using Descriptive Statistics Now that you have your unique survey data in Excel, you can perform descriptive statistics with the tools about which we learned at the beginning of the course. You may choose how you wish to analyze the data, but your work should include the following at a minimum: Questions 1, 2, 3, and 4 (Binomial Questions) Each question should have the following elements: • Sample Proportion of each response. • Sample Size. • Bar Chart (Column Chart) or Pie Chart. Questions 5 and 6 (Continuous Questions) Each question should have the following elements: • Sample Mean. • Sample Median. • Sample Mode. • Sample Standard Deviation. • Sample Range. • Sample Minimum and Maximum. • Histogram. Next, explore your data a bit further. What are two interesting findings from your survey responses? Investigate responses for selected variables based on responses to binomial questions. For example, if the answer to question 1 was Male or Female and to question 8 was Annual Income, you might examine average annual income for Males only and Females only and compare these results. Present your interesting findings as both a table and an appropriate graph or chart. Results note: 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. Technology note: You will 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 e-mail attachment as a backup. Instructions 1. Analyze your data according to the assignment description. 2. Format your findings in an Excel spreadsheet with appropriate and easy-to-read labels. 3. Submit your spreadsheet to your instructor in the Analyzing the Data Set Using Descriptive Statistics assignment area.