Column of data
Knowledge001 wrote:
I have a column of data from A1:A1024, how
can I use Excel to list the mean, standard
error,median,mode standard deviation,sample
variance, Kurtosis, skewness, range,minimum,
maximum,sum, count,largest(1) smallest(1) and
confidence level at the bottom of the column.
You have been asking a lot of remedial questions.
I suggest that you learn to use Help on the
toolbar. Select Show the Office Assistant, and
enter one of the phrases that you have above or
simply the word "statistics".
By the way, from your previous postings, I suspect
you want to do statistical analysis of stock
prices. Since these are normally a time series,
you would compute those statistics on the log
returns, not the original values. If you do not
understand that, I suggest that you do a google
search to learn about that.
|