Explain why a spreadsheet is more suitable than a database for data analysis in the above scenario?
Dec.07, 2008 in
Uncategorized
pitt asked:
Dirt Bikes Ltd. (Laudon & Laudon, Essentials of MIS, 2004) would like to replace the desktop office productivity software used by its administrative staff. A spreadsheet was used for comparing prices of different software packages. The findings have been summarised in a spreadsheet and presented to management.
Dirt Bikes Ltd. (Laudon & Laudon, Essentials of MIS, 2004) would like to replace the desktop office productivity software used by its administrative staff. A spreadsheet was used for comparing prices of different software packages. The findings have been summarised in a spreadsheet and presented to management.
(a)Explain why a spreadsheet is more suitable than a database for data analysis in the above scenario.
JUNIOR
Tags: recover data, statistical data, noc, data analysis, data feed
December 8th, 2008 at 8:57 pm
A spreadsheet is more suitable because you can use pivot tables and charts to quickly compare the data whereas a database would require the creation of reports in order to look at the data in a meaningful way.
December 10th, 2008 at 2:54 am
A spreadsheet has functions and mathamatical capabilities. These are usefull for calculating percentages, and doing what if calculations.
A database stores data, and presents different views of the data. It is not really designed for doing calculations based upon the data.
With a bit of work, you can use the spreadsheet to analyze the data in your database.
good luck.