Hi,
I have 10 series of data and I want to find median of each series using excel, but my data contains some #N/A.
I try using this formula: =MEDIAN(IF(ISNUMBER(E22:E32),E22:E32))
but the result is all zero.
can you help me? Thanks
Hi,
I have 10 series of data and I want to find median of each series using excel, but my data contains some #N/A.
I try using this formula: =MEDIAN(IF(ISNUMBER(E22:E32),E22:E32))
but the result is all zero.
can you help me? Thanks
I have another problem. I want to run some simple regression using excel, but my data contains some NAs in it.
I try to find the constant (c), the slope (b), the residuals, for the following examples:
Y2005 = c + bX2005;
Y2006 = c + bX2006;
Y2007 = c + bX2007;
Y2008 = c + bX2008;
ect
Here is the data screenshot:
-- removed inline image ---
Can you help me again please.
Thank you so much in advance.