Column of data

K

Knowledge001

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.
 
J

joeu2004

Knowledge001 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top