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 LE 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.
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 12 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 14, you will need to assign the survey responses to 0s and 1s generated for questions 14 in columns A through D. The generator automatically generates 0s and 1s for the responses to your binary questions (14). 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 13, 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 13 before submitting. You should have:
Four bar graphs (or four pie charts), one each for questions 14.
Two histograms, one each for questions 5 and 6.
Two tables, graphs, or charts to represent interesting findings from your survey responses. Include a 12 paragraph summary of your findings.
Refer to the Analyzing the Data Set Using Descriptive Statistics Scoring Guide before submitting to ensure your assignment meets the grading criteria.
