-
Construct a Frequency
- *Input Data
- *Order from lowest,highest
- ( AZ⇩, Ascending)
- *Make table
- classes |frequency
- ------------------|----------
- min-1st class # |#of times the #s appears on
- | data sheet within class
- *make 4,5 classes
- *=countif(HighlighDataSet,1range location)
-
Identified This Frequency?
Classes |Frequency
---------|-----------
0-20 |69
20-40 |78
40-60 |83
60-80 |69
80-100 |78
100-120|1
-------------------
378
GROUPED FREQUENCY TABLE
-
In order to create a
Cumulative Frequency (CF)
Relative Frequency (RF)
You need to make ______first.
A Frequency Table
- X | Frequency
- ------|------------
- 1 |55
- 2 |51
- 3 |48
- 4 |70
Data___Frequency___CF,RF
-
Make a Cumulative Frequency Table
- *Make a group frequency table
- *Add the frequencies
- class|Freq. Class |CF
- ----- |------ ---------- |------
- 0-20 |69 less than 20 |69 (69+78=)
- 20-40|78 less than 40 |147(147+78=)
- 40-60|83 less than60 |230(continue..)
-
Make a Relative Frequency Table
- *Make Frequency Table
- *Sum of all Frequency
- *÷ each freq. by total freq.
- classes|Freq. Classes|RF
- --------|----- -------- |---------
- 0-20 |69 0-20 |0.183 (=69÷378)
- 20-40 |78 20-40 |0.206 (=78÷378)
- ⇊-- ⇊ |⇊ ⇊--⇊ | ⇊
- -------------- -----------------------
- 378
- **to check if RF is correct
- all % number must =1
-
Frequency Polygon Graph
- ** Need Midpoints*add classes ÷ 2
- classes |Frequency X | F
- -----------|--------- ------|-------
- 0-30 |28 15 |28
- 30-60 |81 45 |81
- 0+30 30+60
- -------=15 ---------=45
- 2 2
-
Stem and Leaf Plots
- *Input Data
- *Arrange from lowest to highest
- (AZ⇩, ascending )
- *Arrange data according to Stem
- *Use Stem as rows
- *Use right outmost digit as leaf
-
- Ex: 56, 57,67,68,69,75
- 5 |6 7
- 6 |7 8 9
- 7 |5
-
Mean
- sum of all data
- μ = ------------------
- # of data
- -highlight, enter
- -average(Initial cell: Final cell)
-
Standard Deviation
- σ
 - -highlight data
- -=STDEV(initial cell:Final cell)
- -Enter
-
Range usual values
- *min usual value
- =mean - 2*(STDEV)
- *max usual value
- =mean + 2*(STDEV)
-
Quartile Summary
- ?1st= Quartile 1: Separates the bottom25% of data from the top 75%.
- It is the median of the bottom half of the data set.
• ?2 (median): Separates the bottom 50% of the data set from the top 50%.
• ?3 (3rd Quartile): Separates the bottom 75% of data from the top 25%.
-
5# Summary
*Min: lowest # in data set
- *Q1: Median of 1st half of data set
- Highlight 1st half of date set
- =Quartile(___,1)
- *Median: half of all data set
- (if two #s are in the middle: add÷ by 2)
- Highlight data
- =average(Initial cell, Last cell)
- *Q3: median of second half of date set
- fallow sets for Q1
- for left side of date set only
- *Max: Highest # in date set
-
Find Outliers
- * Find right outlier
- Q1-2(IQR)
- * Find left outlier
- Q3+2(IQR)
-
Z Score
- Data value - mean
- Z= -----------------------
- Standard Deviation
Data value: corresponding# to the zcore
-
Empirical Rule
* Use Z score equation
- * Z score identifies the position your
- % falls with in the empirical rule
- 68%:1 standard deviation away from the mean
- 95%:2 standard deviation away from the mean
- 99.7%:3 standard deviation away from the mean
-
Range usual / unusual values
formula: μ 2σ
mean 2 standard deviation
-
Percentiles
Find percentile for 30?
- Ex: Find percentile for 30?
- given date set......
1: sort data (AZ⇩, ascending)
- 2: see how many #are before the given #
- (ex: 30 )
- 3:
- #of values below x + 0.5
- P =-------------------------------- * 100
- total #of values in data set
-
Percentile
To find what # falls in position X
- To find
- given date set......
1: sort date set (AZ⇩, ascending)
- 2:
- #bellow value + 0.5
- = ------------------------- * 100
- n (total date set #)
-
- N= total # of date set
-
-
How does a Histogram graph look like?
-
Make an frequency OGIVE graph?
- *make cumulative frequency table
- *find upper class limits
- add frequencies to one and other
- *graph
|
|
