O'Reilly logo

Market Data Analysis Using JMP by Walter R. Paczkowski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Spreadsheets As Data Managers and Analysis Tools

Overreliance on Spreadsheets

Spreadsheets are very heavily relied upon for analyses and database management. There are several major issues associated with their use. They're easy to use in general, but this is not a reason to use them as database managers. They're not database managers.
Figure 1.6 Example of Spreadsheet Data shows an example of a section of a large spreadsheet typical of what you might receive from an online survey vendor. There are 18,492 rows or records, which represent that number of people, and 81 columns or variables on each person. There’s no indication of what Q1, Q2, and so on are, no indication of their values, and no definitions for the Code variable. Sometimes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required