Purpose:The purpose of this assignment is to organize a random sample of data values and create statistics, tables, and a graph based on the data.Then the sample data will be compared to the Empirical Rule.The information will then be analyzed in a written summary.

Part 1:Random Data, Statistics, and the Empirical Rule

Methods:Use Excel (or similar software) to create the tables and graph.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 data values and relevant information are posted in the course website.Use the data set (P, Q, R, S, or T) assigned to you by your instructor to complete this application.

For the purpose of this application, treat the data set as if it represented a certain random variable and was a valid random sample gathered by a researcher from a normally distributed population. The sample data was actually found with an online Gaussian random number generator that creates normally distributed data values.The random number generator simulates the results of a researcher finding those values through observation or experimentation.

2. Use technology (Excel, graphing calculator, etc.) to sort the sample data values from low to high.Use Excel or similar software to put the data into a table with about 5 or 6 columns.Label this "Table 1:Sorted Set of Sample Data."

3. Using 5 to 10 class intervals, organize the sample data as a frequency distribution in a table. The intervals of the frequency distribution should be rounded to the tenths so that they match the data.Label this "Table 2:Frequency Distribution."

4.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."

5.Use Table 2, the frequency distribution, to find the midpoints of each class interval.Create a new frequency distribution with the midpoints in the left column and the frequencies in the right column.Label this "Table 3:Frequency Distribution with Midpoints."