Statistics

Statistics
collect and organize a random sample of data values and then create statistics, tables, and graphs based on the data. The information will then be analyzed in a written summary.

Part 1: Generate and Organize a Set of Random Data Values

Methods: Use Excel (or similar software) to create the tables and graphs. Then copy the items and paste them into a Word document. The tables should be formatted vertically, have borders, and be given the labels and titles stated in the assignment. The proper symbols should be used. Do not submit this assignment as an Excel file. The completed assignment should be a Word (or .pdf) document.

1. The sample data will be found by using an online random number generator. Use the link below or any other random generator of your choice.

http://www.randomnumbergenerator.com/

Set the random number generator to find numbers between 1 and 75. Repeat the simulation 40 times, recording the number for each repetition. Use technology (Excel, graphing calculator, etc.) to sort the data from low to high. Use Excel or similar software to put the data into a table with 4 columns and 10 rows. Label this “Table 1: Sorted Set of Random Data.”

2. Use technology to find the mean, median, standard deviation, and variance. Also determine the range and sample size. Put these values into a table with the proper symbol or term in the left column and the value of the statistic in the right column. The statistics should be rounded properly. Label this “Table 2: Important Statistics.”

3. Find the minimum and maximum usual values (mean – 2SD, mean + 2SD) and put them in a table. Put the proper symbols in the left column and the value of the statistic in the right column. Label this “Table 3: Minimum and Maximum Usual Values.”

4. Using 5 to 10 class intervals, organize the data as a frequency distribution in a table. The intervals of the frequency distribution should be rounded to match the data. Label this “Table 4: Frequency Distribution.”

5. Use Excel (or similar software) to construct a frequency histogram to illustrate the data. Give the axes the proper titles. Label this “Graph 1: Histogram.”

Part 2: Written Introduction and Summary

1. Write an introduction to this application. Discuss how the data values were found and why they are random. Refer to chapter 2 and 3 to describe the basic components of the application and the statistical concepts that are applied. The introduction should be at least 50 words and be written with proper grammar and spelling.

2. Write a summary of the application, considering the following topics. The summary should be at least 250 words and be written with proper grammar and spelling. Refer to the tables and graph (by label and number) throughout the summary. Use the proper statistical terms and symbols in the summary.

Discuss measures of center and variation as related to the data, tables, and graphs.
Discuss characteristics such as unusual values and skewness, providing support and examples.
Discuss how the frequency distribution was created, specifically referring to the intervals and class width.
Describe the features of the histogram, including the axes and the shape of the distribution.

FOR YOUR ASSIGNMENTS TO BE DONE AT A CHEAPER PRICE PLACE THIS ORDER OR A SIMILAR ORDER WITH US NOW