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
" Solid work, thanks. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 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