ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   If you have missing data in a regression, what goes in the cell? (https://www.excelbanter.com/excel-discussion-misc-queries/117667-if-you-have-missing-data-regression-what-goes-cell.html)

Lindzie

If you have missing data in a regression, what goes in the cell?
 
I am trying to run a regression and I have some missing data. What do I put
in the cell so that the regression will run without the data? It keeps
telling me it has non numeric data and can't run it.

Dave F

If you have missing data in a regression, what goes in the cell?
 
If you have missing data you need to interpolate. Start here for some links
about interpolation in XL:
http://www.google.com/search?hl=en&q...+interpolation
--
Brevity is the soul of wit.


"Lindzie" wrote:

I am trying to run a regression and I have some missing data. What do I put
in the cell so that the regression will run without the data? It keeps
telling me it has non numeric data and can't run it.



All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com