Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Data
I have a database set up in excel and I would like to extract data from
certain columns and take an average of that data. However, I need to average the data in decimal format that is seperated by whole numbers. I need to eliminate the whole numbers and just take the average of the inbetween data. Also, the data is always changing and there is no set "Cell Location." I need to be able to run this with an arbitrary amount of cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Data
Carl,
You need to explain your requirements with an example table of values, and what average you would expect based on your example. HTH, Bernie MS Excel MVP "FGE-carl" wrote in message ... I have a database set up in excel and I would like to extract data from certain columns and take an average of that data. However, I need to average the data in decimal format that is seperated by whole numbers. I need to eliminate the whole numbers and just take the average of the inbetween data. Also, the data is always changing and there is no set "Cell Location." I need to be able to run this with an arbitrary amount of cells. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Data
Part 1: Here is some data in column A and the fractional parts in column B
Note that although the non-integer part is shown as a decimal, it is still referred to as the 'fractional part' 1.3 0.3 5.6 0.6 7.8 0.8 9.5 0.5 4.6 0.6 3.5 0.5 7.7 0.7 1.4 0.4 9.4 0.4 7.3 0.3 If you use =AVERAGE(B1:B10) you get 0.51 To get the result without the 'helper column' use =AVERAGE(MOD(A1:A10,1)) This is an array formula and must be entered using CTRL+SHIFT+ENTER not just ENTER -- Bernard V Liengme http://people.stfx.ca/bliengme remove caps from email "FGE-carl" wrote in message ... I have a database set up in excel and I would like to extract data from certain columns and take an average of that data. However, I need to average the data in decimal format that is seperated by whole numbers. I need to eliminate the whole numbers and just take the average of the inbetween data. Also, the data is always changing and there is no set "Cell Location." I need to be able to run this with an arbitrary amount of cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging intervals of data | Excel Discussion (Misc queries) | |||
Averaging data with errors | Excel Worksheet Functions | |||
averaging data | Excel Discussion (Misc queries) | |||
Averaging data | Excel Worksheet Functions | |||
incremental averaging of data | Excel Discussion (Misc queries) |