Posted to microsoft.public.excel.misc

R Vaughn

external usenet poster

Posts: 13

null vs zero in regression analysis

Is there a way to run a regression analysis with input data that contain some
null cells? I have a large matrix of data within there are many cells
containing zero value. As I continue to add data to the matrix, rather than
be forced to enter the number "0" in all zero value cells of a regression
input range, I prefer to just leave them blank. Any help would be
appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Correlation or Regression Analysis	les8	Excel Discussion (Misc queries)	3	October 17th 08 09:04 PM
regression analysis	usedtostata	Excel Discussion (Misc queries)	6	October 2nd 08 09:50 PM
how do i graph a regression analysis?	Brad	Excel Discussion (Misc queries)	1	September 29th 07 12:01 AM
Using Regression Analysis?	ccpalm2	New Users to Excel	1	February 21st 07 10:03 AM

All times are GMT +1. The time now is 11:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us