Statistical Analysis What type of sampling methods would you use

This is the start of the assignment

I complete steps 1 and 2, need steps 3-6 completed

Step 1.

What type of sampling methods would you use?

With my survey, in order to get the best results I would use stratified sampling since I would be concerned with different subgroups among the population that is selected for the study.

In developing your survey, you will create six questions. What are some of the specific questions that your survey should contain?

What is your age?

What is your gender?

What is your nationality?

How many times a week do you consume dairy products? i.e. cheese, milk, whey protein..

How many times a week do you consume meat products? i.e. beef, chicken, pork, lamb, deer etc.

Where do you consume these products? i.e. home, restaurant etc.

What difficulties do you anticipate in designing a study around the topics offered?

There maybe an obstacle or two I may run across while designing study. One definitely would be the confusion a participants may face when deciding what contains dairy products or not.

Step 2.

How much meat and dairy are you consuming on a weekly basis?

Survey Questions:

• What is your age?
• What is your gender?
• What is your ethnicity?
• How often do you go out to eat in a week?
• How much dairy do you consume in a week?
• How much meat do you consume in a w

Step 3.

http://media.capella.edu/CourseMedia/MAT2001/SurveyDataGenerator/media.asp

For this assignment, you will use a data generator tool to generate hypothetical data for the questions you developed.

To generate data using the survey data generator, complete the following:

• Open the Survey Data Generator linked in the Resources for this assignment. The Survey Data Generator will generate responses to the set of six survey questions you previously defined. It knows nothing about the particular subject of your study; it only generates a set of responses to question types that are predefined.
• Type the minimum, the maximum, and the expected values for questions 5 and 6 into the Survey Data Generator. (These are values for the quantitative questions from Table 1 of your completed Data Collection Template.) Note that the generator has spaces only for the values for your two quantitative questions.
  • For the top set of boxes, enter the values for question 5.
  • For the bottom set of boxes, enter the values for question 6.
  • For each of these questions, you must enter a single number for the minimum, the maximum, and the expected value.
  • For each of these questions, do not enter commas or other symbols.
• Select Download Excel Spreadsheet. An Excel spreadsheet will be created that contains your survey responses.
• Keep in mind the following about the Excel data:
  • Excel will have six columns (A–F) and one column for each question (1–6).
  • Columns A–D represent the responses for questions 1–4 and should only contain 0s and 1s. Columns E and F represent the responses for questions 5–6 and should contain numbers between your minimum and maximum.
  • Each row will represent the responses from one survey participant. For example, the first row of answers represents the first survey participant’s answers to all six questions. The second row of answers represents the second survey participant’s answers to the questions—and so forth. The number of rows of answers is how many participants completed the survey.
  • You need to use the Survey Data Generator again if a column contains all the same numbers. There must be variation in these responses for you to statistically analyze the data. Check to see that columns 1 through 4 contain a mix of 0s and 1s and that columns 5 and 6 contain a range of different numbers between your minimum and maximum.
• What do the 0s and 1s mean in columns A through D? The generator automatically generates 0s and 1s for the responses to your binary questions (1–4), so do not enter anything into the generator for these questions. The tool knows that the only possible responses for these questions are 0 and 1. For example, if you asked: “Are you male of female?” you could assign Male = 0 and Female = 1, or vice versa. For the next project assignment (u07a2) you will analyze the survey responses and will need to assign 0 and 1 to the two possible responses for your binary questions; it is up to you which response to assign 0 and which to assign 1. For this assignment, u05a2, you do not need to submit your assignment of these values—just keep this in mind for the future.

Instructions

• Submit the Excel spreadsheet to your instructor in the Survey Results assignment area. No manipulation should be done to the results created by the survey generator. No statistical calculations are completed until the next project assignment.

Step 4.

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:

Assignment Instructions

Complete this on one Excel sheet. Include the following components in your analysis of the data.

• Technology note: 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 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.

Binary Question Note: 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.

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 was Male or Female, and the answer to question 6 was 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.

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 and easy to read labels.
• Before submitting it, verify you have included all of the elements for Parts 1–3. 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.
• Before submitting, refer to the Analyzing the Data Set Using Descriptive Statistics Scoring Guide to ensure that it meets the grading criteria.

Step 5.

At the start of the project, you documented your typical responses along with your question formulations. You did not know it at the time, but you were hypothesizing about the future survey results. Now that you have the actual survey data, you can go back and apply the tools of inferential statistics to test your hypotheses.

Assignment Overview and Preparation

For this assignment, you will:

• Calculate an appropriate 95% confidence interval for each question.
• Perform an appropriate one-sample hypothesis test for each question. Based on the context of your questions, you may choose to set up your hypothesis test as a one-sided test or two-sided test.

Remember, we want to estimate population proportions in questions 1–4 and population means in questions 5–6 (from Unit 7). We already calculated the sample statistics for each question in Unit 7. Feel free to use this prior work to help complete the above tasks. That is, we already have sample proportions for questions 1–4 as well as sample means and standard deviations for questions 5–6.

Use the Excel Analyzing Data With Inferential Statistics Template linked in the Resources for this assignment. The template has two pages. Be sure to review each one carefully. The first page is the blank template that you will complete, and the second page is a completed example. Almost every type of situation is shown, so try to model your results after the ones shown.

Instructions

Complete the following in order to apply the tools of inferential statistics to test your hypotheses:

• Open and complete the Excel Analyzing Data With Inferential Statistics Template linked in the Resources for this assignment.
• Calculate a 95% confidence interval for each of your survey questions (1–6). Your final product should have six confidence intervals.
• Perform a hypothesis test for each survey question (1–6). Your final product should have six hypothesis tests.

When you have completed this assignment, submit it to your instructor in the Analyzing Data Using Inferential Statistics assignment area.

See Excel attachment in folder

Step 6

Now that you have completed all of the statistical calculations involved with your analysis of the survey, it is time to put the project together. Your final project submission will be a single document, which contains information from all of the previous components along with your written analysis and comments on the survey results.

The format for your final project submission should include the following sections, in this order:

• Title Page.
• Executive Summary (six double-spaced pages minimum): This should be a summary of the findings and conclusions of the study you developed and conducted. Discuss each of your six survey questions.
• Reflection Statement (four double-spaced pages minimum): This needs to include what you learned both in the course and in this project. Review the competencies of this course, which are located in the syllabus, as well as the criteria of this project to make sure you are focusing on the correct concepts for your reflections.
• Appendix (This includes your supporting data):
  • Introduction.
  • Data Collection Plan.
  • Descriptive Results.
  • Inferential Statistics.
  • Table of Data From the Survey Data Generator.

The two sections that are new for this project component are the executive summary and the reflection statement. You may also need to edit your introduction to make it fit the style of a project document. The remaining items should be treated as an appendix. As you write your executive summary, you may wish to refer the reader to particular graphs or results in this supporting data section.

Executive Summary

Write a six-page, double-spaced summary of your course project for someone interested in your work. While you did a lot of calculations and quantitative analysis in the project, your executive summary should give the reader a quick summary of your survey intent, design, and results without an overload of numbers and formulas. Discuss each of your six survey questions.

• Focus on communicating the results and interpretations of your results. You will not be able to comment on every little finding, so you will have to make some judgments about what might be the most interesting or revealing results.
• Discuss inferential statistics and how your survey data can be used to estimate or test population parameters such as the population mean and population proportion.
• Your executive summary should be professionally written and follow good writing practices.

Reflection Statement

Write a four-page, double-spaced summary of your thoughts on how your view of statistics has changed since you started this course and this project. We have covered a wide range of topics in this course, and many learners quickly forget the formulas they worked so hard to memorize.

• While you may not remember the mathematical formulas, what concepts or ideas will you take from this course?
• How will those ideas influence or impact your personal or professional life?

After you have written and integrated all of the previously described sections and items, refer to the Statistical Analysis course project description and then submit your project in the assignment area.