Description
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 1–2 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 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.
Submission and Verification Instructions
When you have completed this assignment, submit your Excel spreadsheet containing Parts 1–3, 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 1–3 before submitting. You should have:
Four bar graphs (or four pie charts), one each for questions 1–4.
Two histograms, one each for questions 5 and 6.
Two tables, graphs, or charts to represent interesting findings from your survey responses. Include a 1–2 paragraph summary of your findings.
Refer to the Analyzing the Data Set Using Descriptive Statistics rubric before submitting to ensure your assignment meets the grading criteria.
Competencies Measured
By successfully completing this assignment , you will demonstrate your proficiency in the following course competencies and rubric criteria:
Competency 1: Interpret a data set’s central tendency and variability using descriptive statistical procedures.
Calculate means correctly for Questions 5 and 6.
Calculate medians correctly for Questions 5 and 6.
Calculate modes correctly for Questions 5 and 6.
Calculate standard deviations correctly for Questions 5 and 6.
Calculate ranges correctly for Questions 5 and 6.
Calculate minimum value and maximum value correctly for Questions 5 and 6.
Create an appropriate graph or chart for Questions 1–6.
Competency 4: Solve problems in your personal and professional life by applying statistical procedures.
Calculate proportions correctly for Questions 1–4.
Find and explain interesting findings or comparisons as a table.
Find and explain findings or comparisons as a graph or chart.
TRANSCRIPT OF THE CLASS VIDEO EXPLAINING WHAT IS TO BE DONE
THE DATA TO BE USED IS WITHIN THE EXCEL SHEET FOR QUESTIONS 1,2,3
Hello class. The main goal of this presentation is to introduce the Unit Seven Project Template. The goal of the unit seven deliverable is for you to present your findings of descriptive statistics analyses on your data collection.
Note that this particular template is an Excel, rather than Word document, because you’re going to be performing statistical analysis using Excel as a statistical tool.
Note here. When you first load the Excel document you will get this page first, which has an example loaded on it.
Note here that there are multiple tabs in this Excel document and you can traverse them at the bottom of the page. Here is tab one, tab two, tab three, and tab four.
Note that tabs one through three provide a number of examples, each example with corresponding hints and tips with respect to how to complete the submission successfully.
Note here. In the first part of the document is the corresponding data collected for the survey questions. Here are some tips and hints on how to organize and interpret the data with respect to this document and how to insert the data within the template.
Note again, there are tips sprinkled throughout the document.
Moving on to the second tab here. There are instructions on how to complete the statistical analysis within Excel, showing you how to organize the data, sort the data, and then perform various analyses on the data. Make sure that you read over each of these steps and complete your analysis appropriately.
Going over to tab number three. Again, a reminder of all the elements required for this corresponding submission, including tables and graphs. Be sure that you complete each of these requirements before submission.
Again, note here are some key tips and hints on how to compute the various analyses and computations that are required for this submission.
Also note, here are some exemplars solutions. What they might look like and how the submission should be organized.
Please scan through each of these examples so that you best understand what is expected for this corresponding submission.
On the last tab here is where you are asked to insert your data and then perform your analyses, filling in your data, your computations, analyses, and your tables and charts.