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 ...
Get Market Data Analysis Using JMP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
