376Chapter 12Information SystemsFigure 12.2A spreadsheet containingdata and computations123456789101112ABCDEFGHFrankAmyTutorHalTotalAvg1310123511.671616144615.331318104113.67182184715.671218154515.0072835921471.3314.4016.6011.80123Week45TotalAvg42.8014.27example that demonstrates fundamental spreadsheet principles. Supposewe have collected data on the number of students that came to get helpfrom a set of tutors over a period of several weeks. Let’s say we’ve kepttrack of how many students went to each of three tutors (Hal, Amy, andFrank) each week for a period of five weeks. Now we want to performsome basic analysis on that data. We might end up with the spreadsheetshown in Figure 12.2.This spreadsheet contains, among other things, the raw data to beanalyzed. Cell C4, for instance, contains the number of students that Haltutored in week 1. The column of data running from C4 to C8 containsthe number of students tutored by Hal in each of the five weeks during
This is the end of the preview. Sign up
access the rest of the document.