3.3 Practice SAYOedited 2

xlsx

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

Report
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