OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 210)

100

101

Solution with a matrix formula

To calculate the frequency you have to create 24 classes, one for each hour. In the

next column you enter the number of emails with the function FREQUENCY.

Figure 190: FREQUENCY function

in a matrix formula

The first argument is the cell area with the times of all approximately 38,000 emails.

The second argument is the cell area E2:E25 that describes the frequency classes. To

enter the formula, first select the cell area F2:F25, then enter the formula. Then

finish the formula by using the key combination Shift+Ctrl+Enter. This indicates to

the program that you want to use a matrix formula. To indicate the matrix formula,

the program uses curly brackets.

This technique is most often known only to (and used by) advanced users.

Solution with the DataPilot

With the DataPilot you can achieve the same result much easier and faster. The

solution is also possible for less advanced users. Starting with the raw data

(Figure 189), you need only a few mouse clicks.

210 OpenOffice.org 3.3 Calc Guide

1 2 ... 205 206 207 208 209 210 211 212 213 214 215 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 210

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3