Some Statistical Function

• large and small
  • These take an array and a number and return the corresponding largest or smallest item in the array
  • In cell a11 put Category
  • In a12 put sodium
  • In B12 put 1st
  • In B13 put 2nd
  • In B14 put 3rd
  • In C11 put Amount
  • Use large to find the corresponding largest values for the cagegor
  • In D12:14 find the names of the matching itmes.
• The Frequency function
  • Will let you build a frequency distribution.
  • It takes a range
  • And a list of upper bounds for bins.
  • But in this case, please select all the data beside the bins.
  • And press ctrl-shift-enter when entering the formula.
  • Less than or equal to the high
• The rank function
• Inner Quartile Range
  • Defined as Q3-Q1
  • Frequently Q1 - (Q3-Q1)*1.5 defines Low fence for outliers
  • Frequently Q3 + (Q3-Q1)*1.5 defines High fence for outliers
• Conditional formatting.
  • A quick look at chapter 17
  • coutif (range, cell) > 0
  • or(cell<q1,cell>q3)