Abstract
The two sets of statistical functions of Quattro Pro are identical except for the method of designating the block for the calculation. The standard statistics functions set the block by cell location, as in @COUNT(B5…B30). The database statistics functions use the Block, Column, and Criteria as in Table 6.1. Since the database is memory based, the standard statistical functions can be used if the cell locations are known. To have the best of both worlds, either the database or the standard statistical functions can be used on a spreadsheet if the column headings are in a database format.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 1992 Springer-Verlag New York, Inc.
About this chapter
Cite this chapter
Parks, R.G. (1992). Statistics. In: Quattro Pro® for Scientific and Engineering Spreadsheets. Springer, New York, NY. https://doi.org/10.1007/978-1-4612-2810-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4612-2810-3_7
Publisher Name: Springer, New York, NY
Print ISBN: 978-0-387-97636-5
Online ISBN: 978-1-4612-2810-3
eBook Packages: Springer Book Archive