# Jake Soderberg - Frequency Distribution - Statistics With Excel - Dunwoody College of Technology

60 %
40 %
Information about Jake Soderberg - Frequency Distribution - Statistics With Excel -...
Technology

Published on January 9, 2010

Author: jakesoderberg

Source: slideshare.net

## Description

Jake Soderberg - Frequency Distribution - Statistics With Excel - Dunwoody College of Technology
http://jakesoderberg.com/

Jake Soderberg Dunwoody College of Technology QUAL 225 Statistics with Excel Wednesday, January 06, 2010 Homework 2.1 Questions 7-17 Odd Website: http://jakesoderberg.com/ 7. Trust in Internet Information, create a categorical frequency distribution A = trust in everything they read M = trust in most of what they read H = trust about one half of what they read S = trust in a small portion of what they read M M M A H M S S M M M M A M M M H M M M H A M M M H M M Categorical Frequency Distribution Class Tally Frequency Percent A III 4 10% M IIIII IIIII IIIII IIIII IIIII III 28 70% H IIIII I 6 15% S II 2 5% Total 40 100% 9. Weight of the NBA'a Top 50 Players, create a group frequency distribution and a cummulative frequency distribution with 240 210 220 260 250 195 230 165 295 205 230 250 210 220 250 265 230 210 240 245 225 215 235 245 250 215 210 195 260 210 190 260 230 190 210 Group Frequency Distribution Class limits Class boundaries Frequency 165 185 165-185 164.5 185.5 164.5-185.5 4 186 206 186-206 185.5 206.5 185.5-206.5 6 207 227 207-227 206.5 227.5 206.5-227.5 15 228 248 228-248 227.5 248.5 227.5-248.5 13 249 269 249-269 248.5 269.5 248.5-269.5 9 270 290 270-290 269.5 290.5 269.5-290.5 1 291 311 291-311 290.5 311.5 290.5-311.5 1 312 332 312-332 311.5 332.5 311.5-332.5 1 Total 50 Cumulative Frequency Distribution 164.5 Less than 164.5 0 185.5 Less than 185.5 4 206.5 Less than 206.5 10 227.5 Less than 227.5 25

248.5 Less than 248.5 38 269.5 Less than 269.5 47 290.5 Less than 290.5 48 311.5 Less than 311.5 49 332.5 Less than 332.5 50 Highest value: 325 Lowest value: 165 Large Peak: 210, 230 Small Peak: 240-260 11. GRE Scores at Top-Ranked Engineering Schools, create a grouped frequency distribution and a cumulative frequency dis 767 770 761 760 771 768 776 763 760 747 766 754 771 771 780 750 746 764 769 759 757 Group Frequency Distribution Class limits Class boundaries Frequency 746 752 746-752 745.5 752.5 745.5-752.5 4 753 759 753-759 752.5 759.5 752.5-759.5 6 760 766 760-766 759.5 766.5 759.5-766.5 8 767 773 767-773 766.5 773.5 766.5-773.5 9 774 780 774-780 773.5 780.5 773.5-780.5 3 Total 30 Cumulative Frequency Distribution 745.5 Less than 745.5 0 752.5 Less than 752.5 4 759.5 Less than 759.5 10 766.5 Less than 766.5 18 773.5 Less than 773.5 27 780.5 Less than 780.5 30 13. Ages of Declaration of Independence Signers, construct a grouped frequency distribution and a cumulative frequency di 41 54 47 40 39 35 50 44 52 39 50 40 30 34 44 63 60 27 42 34 50 35 43 48 46 31 27 55 35 46 45 34 53 50 50 Group Frequency Distribution Class limits Class boundaries Frequency 27 33 27-33 26.5 33.5 26.5-33.5 7 34 40 34-40 33.5 40.5 33.5-40.5 14 41 47 41-47 40.5 47.5 40.5-47.5 15 48 54 48-54 47.5 54.5 47.5-54.5 11 55 61 55-61 54.5 61.5 54.5-61.5 3 62 68 62-68 61.5 68.5 61.5-68.5 3 69 75 69-75 68.5 75.5 68.5-75.5 2 Total 55

Cumulative Frequency Distribution 26.5 Less than 26.5 0 33.5 Less than 33.5 7 40.5 Less than 40.5 21 47.5 Less than 47.5 36 54.5 Less than 54.5 47 61.5 Less than 61.5 50 68.5 Less than 68.5 53 75.5 Less than 75.5 55 15. Presidential Vetoes, create a grouped frequency distribution and a cummulative frequency distribution with 5 classes 44 39 37 21 31 170 44 42 6 250 43 44 82 50 Group Frequency Distribution Class limits Class boundaries Frequency 6 132 6-132 5.5 132.5 5.5-132.5 16 133 259 133-259 132.5 259.5 132.5-259.5 3 260 386 260-386 259.5 386.5 259.5-386.5 0 387 513 387-513 386.5 513.5 386.5-513.5 0 514 640 514-640 513.5 640.5 513.5-640.5 1 Total 20 Cumulative Frequency Distribution 5.5 Less than 5.5 0 132.5 Less than 132.5 16 259.5 Less than 259.5 19 386.5 Less than 386.5 19 513.5 Less than 513.5 19 640.5 Less than 640.5 20 What is challenging about this set of data? There is one outlier of 632 which skews the data. Most of the data points are in th 17. Heights of Alaskan Volcanoes, create a grouped frequency distribution and a cumulative frequency distribution for the d 4265 3545 4025 7050 11413 3490 5370 4885 5030 6830 4450 5775 3945 7545 8450 3995 10140 6050 10265 6965 150 8185 7295 2015 5055 5315 2945 6720 3465 1980 2560 4450 2759 9430 7985 7540 3540 11070 5710 885 8960 7015 Group Frequency Distribution Class limits Class boundaries Frequency 150 1276 150-1276 149.5 1276.5 149.5-1276.5 2 1277 2403 1277-2403 1276.5 2403.5 1276.5-2403.5 2 2404 3530 2404-3530 2403.5 3530.5 2403.5-3530.5 5 3531 4657 3531-4657 3530.5 4657.5 3530.5-4657.5 8 4658 5784 4658-5784 4657.5 5784.5 4657.5-5784.5 7 5785 6911 5785-6911 5784.5 6911.5 5784.5-6911.5 3

6912 8038 6912-8038 6911.5 8038.5 6911.5-8038.5 7 8039 9165 8039-9165 8038.5 9165.5 8038.5-9165.5 3 9166 10292 9166-10292 9165.5 10292.5 9165.5-10292.5 3 10293 11419 10293-11419 10292.5 11419.5 10292.5-11419.5 2 Total 42 Cumulative Frequency Distribution 149.5 Less than 149.5 0 1276.5 Less than 1276.5 2 2403.5 Less than 2403.5 4 3530.5 Less than 3530.5 9 4657.5 Less than 4657.5 17 5784.5 Less than 5784.5 24 6911.5 Less than 6911.5 27 8038.5 Less than 8038.5 34 9165.5 Less than 9165.5 37 10292.5 Less than 10292.5 40 11419.5 Less than 11419.5 42

M H M 4 A Count M A M 28 M Count M H M 6 H Count M M M 2 S Count quency distribution with eight classes 270 325 225 210 230 202 180 175 215 240 240 225 230 185 260 Class Width Class midpoint 21 175 21 196 21 217 21 238 21 259 21 280 21 301 322

umulative frequency distribution with 5 classes 771 756 770 778 766 762 753 758 746 Class Width Class midpoint 7 749 7 756 7 763 7 770 777 cumulative frequency distribution using 7 classes 37 49 42 70 32 69 39 45 33 42 42 52 38 36 45 63 46 33 60 62 Class Width Class midpoint 7 30 7 37 7 44 7 51 7 58 7 65 72

ibution with 5 classes 632 30 78 181 66 37 Class Width Class midpoint 127 69 127 196 127 323 127 450 577 the data points are in the first class. ncy distribution for the data using 10 classes Class Width Class midpoint 1127 713 1127 1840 1127 2967 1127 4094 1127 5221 1127 6348

1127 7475 1127 8602 1127 9729 10856

 User name: Comment:

## Related presentations

#### Neuquén y el Gobierno Abierto

October 30, 2014

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

#### Decision CAMP 2014 - Erik Marutian - Using rules-b...

October 16, 2014

In this presentation we will describe our experience developing with a highly dyna...

#### Schema.org: What It Means For You and Your Library

November 7, 2014

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

#### WearableTech: Una transformación social de los p...

November 3, 2014

Un recorrido por los cambios que nos generará el wearabletech en el futuro

#### O Impacto de Wearable Computers na vida das pessoa...

November 5, 2014

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

#### All you need to know about the Microsoft Band

November 6, 2014

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

## Related pages

### Statistics With Excel | LinkedIn

Statistics With Excel. Articles ... Business Statistics Teaching Assistant at USC Marshall ... Yale, Claremont McKenna College, Bowdoin College, Gunn ...

### Salalah college of technology - Education

Jake Soderberg - Frequency Distribution - Statistics With Excel - Dunwoody College of Technology

### Statistics In Excel | LinkedIn

View 27 Statistics In Excel posts, presentations, experts, and more. ... of condensed experience and technology often ...

### frequency distribution | statistics | Britannica.com

MLA style: "frequency distribution". Encyclopædia Britannica. Encyclopædia Britannica Online. Encyclopædia Britannica Inc., 2016. Web. 11 May. 2016 ...

### Excel 2013 Tutorial - Using Statistical Functions - Learn ...

Excel 2013 Tutorial - Using Statistical Functions ... Excel 2010 Statistics #15: Frequency Distributions, ... Excel Statistics 69: ...

### Data, Probability and Statistics - Math is Fun - Maths ...

Probability and Statistics Index. Graphs Index. ... Frequency Distribution; ... The Binomial Distribution.