Chapter.02 CGS2518

With microsoft office excel 2010 23 level 2 objecves

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: fference 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 different 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 Different 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 specified criteria •  Determine a total value for items that meet specified 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 Specified Criteria •  COUNTIF func3on –  Counts the number of items in a range that meet specified 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

Ask a homework question - tutors are online