Statistic Project – 4 Different parts due over 5 weeks

This project consists of 4 parts. Each part is due a different day. The first part is due in 2 days, but then you have time to finish the rest.

1. CREATING A DATA SET (DUE 6/13/17 AT 5PM PST)

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.

2.DESCRIPTIVE STATISTICS (DUE 6/20/17 AT 5PM PST)

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.

3.CONFIDENCE INTERVALS (DUE 6/27/17 AT 5PM PST)

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.

4. INFERENTIAL STATISTICS HYPOTHESIS TESTING AND RESEARCH SUMMARY (DUE 7/18/17 AT 5PM PST)

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.