Reference no: EM132446924

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.

• Create an individual Excel document for each of the required items.

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.

• Create an individual Excel document for each of the required items. Be sure to show your work.
• APA format is not required, but solid academic writing is expected.
• Mean, median, and mode are complete and include extensive details.
• Variance for each set of data for each of the variables is expertly constructed.
• Standard deviation for each variable is expertly constructed.
• Probability that each event occurs in each of the two variables is expertly constructed.

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.

• Create an individual Excel document for each of the required items.
• APA format is not required, but solid academic writing is expected.
• Best estimate of the population mean is complete and includes extensive details.
• Confidence intervals for the 90%, 95%, and 98% population mean are expertly constructed.
• Interpretation of the confidence interval is expertly constructed.

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.

• APA format is not required, but solid academic writing is expected.
• Data analysis and hypothesis test are clearly explained and include extensive details.
• Summary of survey results is clearly explained and includes extensive details.
• Excel analysis is expertly displayed.
• The writer is clearly in command of standard, written, academic English.