3.3 Practice SAYOedited 2
xlsx
keyboard_arrow_up
School
University of California, Los Angeles *
*We aren’t endorsed by this school
Course
146
Subject
Geography
Date
Feb 20, 2024
Type
xlsx
Pages
4
Uploaded by mwpjoserizal
The lengths (in kilometers) of rivers on the South Island of New Zealand that flow to the T
River Length (km)
Length (km)
Hollyford
76
Waimea
48
Mean
67.681818182
Cascade
64
Standard Error
7.0965470427
Motueka
108
Median
64
Arawhata
68
Mode
64
Takaka
72
Standard Deviation
33.285756089
Haast 64
Sample Variance
1107.9415584
Aorere
72
Kurtosis
4.7692736914
Karangarua 37
Skewness
1.8960810478
Heaphy
35
Range
145
Cook
32
Minimum
32
Karamea
80
Maximum
177
Waiho
32
Sum
1489
Mokihinui 56
Count
22
Whataroa
51
What is the variable?
Buller 177
River
Wanganui
56
IS the Data quantitative or qualitative?
Grey
121
quantitative
Waitaha
40
Is this a population or a sample?
Taramakau
80
Sample
Hokitika 64
What is the Mean?
Arahura
56
67.682
What is the median?
64
What is the shape of the distribution?
right skewed
Tasman Sea are listed in table
Find Data value of percentile
=PERCENTILE.EXC(data range,percentile as decimal)
Tells what number is at the kth percentile
Percentile
Number
Meaning 50th
64
50 % of rivers were less than 10th
32.9
10% of rivers were less than 3
25th 46
25% of rivers were less than 75th
77
77% of rivers were less than 90th 117.1
90% of rivers were less than 11
Find Percentiles
=PERCENTRANK.EXC(data range, data value)
Tells what the percentile is for a specific data value
Percentile
Number
Meaning 76%
76
76% of rivers were less than 26%
48
26% of rivers were less than 86%
100
86% of rivers were less than 1
4%
Cook River
4% of rivers were less than 3
5 Number Summary
Percentile
Data value
Meanin
Min
0%
32
0% of rivers were les
Q1
25%
46
25% of rivers were le
Median
50%
64
50% of rivers were le
Q3
75%
77
75% of rivers were le
Maximum
100%
177
100% of rivers were le
Formula
Number
Meaning
IQR =Q3-Q1
31
the range of th
Loweer Fence
=Q1-(IQR*1.5)
-0.5
any river with a length l
Upper Fence
=Q3 +(IQR*1.5)
123.5
any river with a length gre
To make a Box and Whiskers Plot
Highlight Data
Click insert, down arrow on the charts, all charts, box and whiskers
Put Box and Whiskers plot
64 KM
32.9 KM
46 KM
77KM
17.1 KM
76KM
48KM
100KM
32KM
ng
ss than 32KM
ess than 46KM
ess than 64KM
ess than 77KM
ess than 177KM
What does the dot represent?
unusual number
g he middle 50% is 31
less than -0.5 KM is unusual
eater than 123.5km is unusual
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help