Discussion Board 5: Frequency Distributions and Histograms

Feb 3rd, 2012
Studypool Tutor
Price: $10 USD

Tutor description

You will be using the same data values as you used in discussion board 4. The purpose of this assignment is to familiarize you with Excel or similar software to create graphs and tables. Part 1: Create a frequency distribution table, histogram and descriptive data table 1. 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. Call this Table 1 and give the table an appropriate and descriptive title (example: Frequency Distribution of Temperatures with 6 Intervals). 2. Use Excel (or similar software) to construct a frequency histogram to illustrate the data. Label the axes of the graph properly, including units. Call this Graph 1: Corresponding Histogram. 3. Find the mean, median, modal class, standard deviation, and variance for this frequency distribution. Round statistics to one more decimal place than the data (for example, if the data values are integers,

Word Count: 425
Showing Page: 1/8
Discussion Board 4: Descriptive Data Analysis - StatisticsNameCourseInstitutional AffiliationDatePart oneTable 1: Frequency distribution tableClass interval Total8735-8744174748895-890489048905-891489108945-8954178998965-8974179428995-900489979005-9014180249015-902490249035-904490419055-906490579065-907490729105-9114182219115-912491219125-9134182529135-9144182789155-9164183219165-9174275099205-921492079235-924492379315-932493229345-935493529365-937493709385-939493949445-945494509475-948494819485-949494889515-952495199545-955495469565-957495739575-9584191569635-964496359715-972497229755-976497559785-979497879805-981498139825-983498289835-984498399885-989498899945-99542984910035-100441003910045-100541005010105-101141011010115-101241012210165-101745083610175-101841017510235-102441024310245-102542049610255-102641026010325-103341033010345-103541035010395-104041040010475-1048410477Grand Total668146Frequency HistogramDescriptive Statistics Table 2 :Summary Statistics for Table 1Mean12848.96154Standard Error1003.866484Median9833.5Modal class10165-10174Standard Deviation7238.984161Sample Variance52402891.68Kurtosis14.70757944Skewness3.405097907Part 2Table 3: Frequency distribution tableClass IntervalTotal8735-8754174748895-8914178148935-8954178998955-8974179428995-9014270219015-903490249035-9054

Review from student

Studypool Student
" Thanks, good work "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors