Appendix D. Spreadsheet Tips

These Spreadsheet Tips complement the Spreadsheet Solutions that appear throughout this book. Use these tips as a starting point to learn more about how to use Microsoft Excel or Calc 3 to obtain your own customized results. The tips are divided into three groups:

Chart Tips that assist you in creating and refining your own charts.

Function Tips that explain the worksheet statistical functions used in Spreadsheet Solutions

Analysis ToolPak Tips that review how to use selected Analysis ToolPak statistical procedures (Microsoft Excel only)

CT: Chart Tips

CT1 Arranging Data in Categorical Charts

You can sort your data to display categories in largest to smallest order. ...

Get Math for the Non-Math Lovers (Collection) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.