Chapter.02 CGS2518

# With microsoft office excel 2010 23 level 2 objecves

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ﬀerence Between Two Sets of Data Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 22 Level 1 Summary •  Applica3on of problem ­solving skills to a variety of data sets, analyzing their sta3s3cal values (mean, mode, median, and standard devia3on) •  Using these sta3s3cs, comparison of diﬀerent data sets to assess absolute as well as percentage changes •  Using ROUND func3on to modify precision of values in data sets Succeeding in Business with Microsoft Office Excel 2010 23 Level 2 Objec/ves: Organizing and Evalua/ng Diﬀerent Data Groupings •  Evaluate the rank of each value in a data set •  Determine the highest and lowest values in a data set •  Determine the number of items that meet speciﬁed criteria •  Determine a total value for items that meet speciﬁed criteria Succeeding in Business with Microsoft Office Excel 2010 24 Determining a Rank for Each Value in a Data Set •  RANK.EQ func3on –  Allows a list to be sorted, then counts number of entries either above or below the value in ques3on •  RANK.EQ (number,ref,order) –  If “order” argument is 0 or lef blank, values are ranked in descending order –  If “order” argument is a posi3ve number, values are ranked in ascending order Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 25 Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 26 Determining the Highest and Lowest Values in a Data Set •  LARGE func3on –  Determines the nth largest value in a range –  LARGE (array,k) •  SMALL func3on –  Determines the nth smallest value in a range –  SMALL (array,k) Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 27 Determining Values Succeeding in Business with Microsoft Office Excel 2010 Level 2 home 28 Determining the Number of Items that Meet Speciﬁed Criteria •  COUNTIF func3on –  Counts the number of items in a range that meet speciﬁed criteria –  =COUNTIF (range,criteria) –  Range argument must be a con3guous set of cells –  Criteria argument is a “test” that data must meet in order to be counted in the grouping Succeeding in Business with Micros...
View Full Document

## This note was uploaded on 05/24/2012 for the course CGS 2518 taught by Professor Gower-winter during the Spring '12 term at FSU.

Ask a homework question - tutors are online