Assignment
PART 1
For the statistics project you are completing in this course, you will need to select a relevant topic that will allow you to gather both qualitative and quantitative data. You may gather data from a group of your choice using a data collection instrument (survey or data mining) that you design. Using the results of that collection instrument, you will create a data set, analyze the data, and create a professional report showing the results of the data that you collected.
For this assignment you will choose a topic and create a data collection instrument. When selecting a topic, remember you need to collect both quantitative and qualitative data. Data collection could be done in the form of a survey via a medium such as Survey Monkey or Facebook or through available workplace content such as sales orders. You will want to collect data from approximately 30 observations. This means you will want to survey at least 30 people or select data from 30 different sales orders.
Submit the topic of the study, a rationale (one or two paragraphs) outlining the purpose of the study, and the data collection instrument you created as a Word document. Include relevant survey links if the data is being collected digitally.
PART 2
Administer the data collection tool you created in the Topic 2 assignment. Using the data you collect, create an Excel table and complete the items below.
1. Create two frequency tables based on two separate questions from your survey.
2. Create a bar graph and a pie chart based on the data in the frequency tables.
3. Determine the class intervals and create frequency distribution for each of the frequency tables.
4. Create one frequency polygon of the data from the frequency distribution.
PART 3
Conduct an analysis of your project data. Prepare the items below based on the data from two of the variables in the data collection instrument.
1. Determine the mean, median, and mode for each of the variables.
2. What is the variance for each set of data for each of the variables?
3. What is the standard deviation for each of the variables?
4. What is the probability that each event occurs in each of the two variables.
PART 4
Create confidence intervals related to the interval and ratio-level data you collected.
1. What is the best estimate of the population mean
2. Develop a 95% confidence interval for the population mean. Develop a 90% confidence interval for the population mean. Develop a 98% confidence interval for the population mean.
3. Interpret the confidence interval.
PART 5
Conduct an analysis and hypothesis test of your choice on the data you collected. Write a 250-500 word research summary of the findings generated in the assignments for Topics 2 through 5. The research summary should address the following.
1. Explain what type of analysis and hypothesis test was conducted on the data collected.
2. Summarize the survey results based on the results of the data you analyzed.
3. Include the Excel analysis as part of the document.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.