what precaution have to be taken by Sameer when entering the data in spreadsheet ?
Answers
Answered by
7
Spreadsheets are good tools for entering and tabulating raw data. However, you do need to be careful:
when entering dates, and
when exporting data to .
CSV or .TXT formats.
They can also be useful to manipulate data - calculating totals or counts, regrouping data with pivot tables, and for preliminary data exploration - scatterplots, simple graphs, means and SDs. Usually, you will need to export your data to a purpose-built statistical package (such as R) for final analysis, because spreadsheet packages offer only a limited range of statistical options, and some of those are flawed.
In some of our workshops, we have used MS Excel for more sophisticated analysis, including likelihood calculations and model fitting. The results for these examples have been checked against other software and are sufficiently accurate. However, we do not recommend spreadsheets for serious statistical analysis of wildlife data.
The bottom line is that statistical analysis results from spreadsheet programs should not be trusted until they have been corroborated by a purpose-built statistical package
when entering dates, and
when exporting data to .
CSV or .TXT formats.
They can also be useful to manipulate data - calculating totals or counts, regrouping data with pivot tables, and for preliminary data exploration - scatterplots, simple graphs, means and SDs. Usually, you will need to export your data to a purpose-built statistical package (such as R) for final analysis, because spreadsheet packages offer only a limited range of statistical options, and some of those are flawed.
In some of our workshops, we have used MS Excel for more sophisticated analysis, including likelihood calculations and model fitting. The results for these examples have been checked against other software and are sufficiently accurate. However, we do not recommend spreadsheets for serious statistical analysis of wildlife data.
The bottom line is that statistical analysis results from spreadsheet programs should not be trusted until they have been corroborated by a purpose-built statistical package
Similar questions