Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column of data
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |