G
gruntguru
I have two dimensional data in two columns. The column of "x" data i
complete (no blank cells). The column of "y" data is incomplete (som
blank cells). I want to produce a third column containing a complet
set of "y" values using a second order polynomial obtained b
regression analysis of the first two columns. Everything I have trie
("TREND" function etc treats the blank cells in the incomplete colum
of "y" data as Zeros. I need something that will ignore the blanks.
have been able to get the answers I need by "x y scatter" graphing th
first two columns (excel ignores the blanks), then fitting a 2nd orde
polynomial trendline and displaying the trendline formula on the graph
I then have to type the formula constants back into the spreadsheet t
produce my third column. This is a tedious process as I need t
frequently update the values in my second column and re-calculate th
third column
complete (no blank cells). The column of "y" data is incomplete (som
blank cells). I want to produce a third column containing a complet
set of "y" values using a second order polynomial obtained b
regression analysis of the first two columns. Everything I have trie
("TREND" function etc treats the blank cells in the incomplete colum
of "y" data as Zeros. I need something that will ignore the blanks.
have been able to get the answers I need by "x y scatter" graphing th
first two columns (excel ignores the blanks), then fitting a 2nd orde
polynomial trendline and displaying the trendline formula on the graph
I then have to type the formula constants back into the spreadsheet t
produce my third column. This is a tedious process as I need t
frequently update the values in my second column and re-calculate th
third column