13-6-1

Statistical Calculations

13-6 Statistical Calculations

The upper part of the [Calc] menu includes the same menu items as the Statistics Application [Calc] menu.

Spreadsheet ApplicationStatistics Application

Menu items with the same name perform the same functions, but there are some differences between the Statistics Application and Spreadsheet Application in terms of operation procedures, calculation result display, etc. This section explains statistical operations and functions that are peculiar to the Spreadsheet Application.

Tip

For information about the Test, Interval, Distribution and DispStat commands, and the commands that appear on the One-Variable, Two-Variable and Regressions submenus, see “Chapter 7 Using the Statistics Application”.

kSingle-variable and Paired-variable Statistical Calculations

You can enter single-variable or paired-variable data into Spreadsheet cells and display a list of statistical values.

Single-variable

Frequencies for

Paired-variable

 

Frequencies for

 

DataSingle-variable Data

 

Data

Paired-variable Data

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

X1

 

 

X1

Freq 1

 

 

X1

Y1

 

 

X1

Y1

Freq 1

 

 

X2

 

 

X2

Freq 2

 

 

X2

Y2

 

 

X2

Y2

Freq 2

 

 

X3

 

 

X3

Freq 3

 

 

X3

Y3

 

 

X3

Y3

Freq 3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

20090601