Simple Interactive Statistical Analysis
Explanation.
Frequency tabulates data of a single variable giving the frequency of each observed value. The command is comparable with SPSS's frequencies. Basic statistics such as the mean and standard deviation are given. Besides numerical analysis the procedure also allows simple textual analysis.
Data can be pasted or typed into the input field in any format, such as a row or column of data or a paragraph of text. Separators between numbers or words are spaces, returns, semicolons, colons and tabs. The following options can be checked:
Include.
Numbers. Non-Numbers are not included in the analysis. Numbers are treated by value, thus 10 and 10.0 are the same, and 5 is smaller than 12. Additional separators are $ and #, thus financial data is considered by value. Additional number base statistics such as the mean and standard deviation are given.
Text. Numbers are not included in the analysis. Additional separators between letters and words are ",'.()[]{}?!
Both. Both numbers, letters and words are included in the analysis. Numbers are treated by name, thus 10 and 10.0 are in different categories and 5 is larger than 12. There are no additional separators, thus a word in the middle of a sentence is classified differently from a word at the end of a sentence.
Options.
Read weights considers that every other –second- value is the case weight of the previous –first- value. The case weights must be numerical, if not the case with its previous value is ignored. A weighted frequency table is produced and in numerical analysis various weighted and weighing corrected statistics are produced. For a discussion of data weighing and the correction applied please read this paper.
Sort Descending Sorts the values descending.
Lowercase All. Lowercase all non numerical alphanumeric characters. Use this option if you want to categorize text data case insensitive.
Show Rows limits the number of rows displayed. Particularly relevant if you request a large Nice Table. Can also be used to exclude particularly high or low (after "Sort Descending") (missing) values from the analysis.
Solve problems into 99999.9. Change the data sequence -cariage return-line feed-tab- and the sequence -tab-cariage return-line feed- into 99999.9 if labels or delete the case if weigths. Wil mostly solve the problem of system missing values in data copied and pasted from SPSS. Might cause other problems.
Limitation.
The formatting and tabulating of large datasets might take a while in which case there might be warnings, just select "continue" and in the end the computer will get there.
This procedure is experimental!! Just give it a try and please let us know about your (negative) experiences and give us your suggestions @:
TOP of page
Go to procedure
All software and text copyright by SISA
