Part 1: Generate and Organize a Set ...



Descriptive Statistics Purpose: The purpose of this assignment is to collect and organize a random sample of data values into a frequency table and then create statistics ( measures of center and variation) based on the frequency table, and a histogram based on the data in the frequency table. 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. 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 document. 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. 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.” Create a frequency table based on the 40 values from step 1. Use 5 to 10 classes for the frequency table. Refer to the textbook, section 2.2, page 46 on instructions how to construct a frequency table. After you have created your classes, organize the data as a frequency distribution in the table which means to take each value from table 1 and place it in the appropriate class. The intervals of the frequency distribution should be rounded to match the data. Label this “Table 2: Frequency Distribution.” Use table 2, find the midpoint for each class first. Then use technology to find the mean, median, standard deviation, and variance of the frequency table data listed in table 2 of this application. Put these values into a new 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 3: Important Statistics.” Use Excel (or similar software) to construct a frequency histogram based on your frequency table from step 2 to illustrate the data. Give the axes the proper titles. Label this “Graph 1: Histogram.” Part 2: Written Introduction and Summary 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 of frequency tables that are applied. The introduction should be at least 50 words and be written with proper grammar and spelling. Write a summary of the application, considering the following topics. The summary should be at least 150 words and be written with proper grammar and spelling. Refer to the tables from step 2 and 3, and the graph 1 (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 frequency table, and graph. Discuss characteristics such as unusual values and skewness, providing support and examples. Discuss how the frequency distribution table 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. Format Requirements The introduction and summary should be written in paragraphs that are typed and double-spaced, with 1-inch margins and a readable font type and font size. The preferred font size could be 12 Times New Roman. The introduction by itself should be at least 50 words. The summary should be at least 150 words. The introduction and summary should be college-level writing with proper grammar and spelling. Do not use first or second person (I, you, etc.). Throughout the introduction, tables, graphs, and summary, proper statistical symbols and terms should be used. The title page, introduction, tables, graphs, and summary should be a single document (.doc, .docx, or .pdf) which is submitted to the proper Dropbox in Falcon Online by the due date. Grading: Application 2 is worth up to 24 points, based on the following criteria. The statistical content (Part 1) is worth up to 8 points, based on completion of all the listed requirements. The introduction and written summary (Part 2) are worth up to 8 points, based on completion of all the listed requirements. The format of the complete document submitted to the Dropbox is worth up to 8 points, based on completion of all the listed requirements. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download