- For Teachers
Can any one help me to find the mean, variance and standard deviation of a collection of text samples - HLS
Your question doesn't make clear what variables (columns of numbers) for which you want these statistics. Once you have these columns entered, you can get all of these statistics using the statistical functions found in Excel.
Which 'columns' do you think would be useful?
You are starting backwards. To do any analysis of a text document, you have to begin by determining the question(s) for which you are seeking answers.
This is true in any kind of research. Defining the question(s) is the first step. Next, you determine, acquire, and format the data which will provide the basis for answering your question(s).
If you give me a sample of the text you are analyzing (just do an attachment in your reply), and the analysis you are trying to perform, Iíll suggest some possible statistical approaches which may be useful.