Dale - Computer Science Illuminated 403

Dale - Computer Science Illuminated 403 - 376 Chapter 12...

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

376 Chapter 12 Information Systems Figure 12.2 A spreadsheet containing data and computations 1 2 3 4 5 6 7 8 9 10 11 12 ABCDEFGH Frank Amy Tutor Hal Total Avg 13 10 12 35 11.67 16 16 14 46 15.33 13 18 10 41 13.67 18 21 8 47 15.67 12 18 15 45 15.00 72 83 59 214 71.33 14.40 16.60 11.80 1 2 3 Week 4 5 Total Avg 42.80 14.27 example that demonstrates fundamental spreadsheet principles. Suppose we have collected data on the number of students that came to get help from a set of tutors over a period of several weeks. Let’s say we’ve kept track of how many students went to each of three tutors (Hal, Amy, and Frank) each week for a period of five weeks. Now we want to perform some basic analysis on that data. We might end up with the spreadsheet shown in Figure 12.2. This spreadsheet contains, among other things, the raw data to be analyzed. Cell C4, for instance, contains the number of students that Hal tutored in week 1. The column of data running from C4 to C8 contains the number of students tutored by Hal in each of the five weeks during
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online