In: Statistics and Probability
Name the pros and cons of spreadsheets in statistics.
The pros of spreadsheets in statistics are:-
A) It is easy to understand. It dioes not require hard core-programming.
B) One can get results instantly of mathematical calculations.
C) The basic statistics tools in "DATA ANALYSIS" are provided which are useful for begineers in statistics.
D) One which are not from statistics background can easily use statistics tool .
E) It also supports multiple spreadsheet and keep the large data organised efficiently.
F) It also supports integration of other apps with excel.
The cons of spreadsheets in statistics are:-
A) The formulae are hard to understand and hard to recognize the errors.
B) The high level of statistical formulae is not supported by spreadsheet.
C) One can easily change the formulae and there are chances of fraudness.
D) Many dignitaries McCullough (2008) and Yalta(2008) suggested that solver is not sufficient for the complete statis programme.
E) One can't code the programming in excel .