Null Variables and Dates

Excel Help for Null Variables And Dates in Excel Multiple Regression Analysis and Forecasting Template

Null Variables And Dates

Rate this: (2/5 from 2 votes)

	I recently downloaded (and paid for) the Regression Model Spreadsheet produced by "Business Spreadsheets". How do I include "date" as an independant variable? (I get Error 13 Type Mismatch). How do I include "Null Variables" (Yes - data element is NEW versus Not New).  Again - if I use 0 and 1; I get Error 13 Type Mismatch.   Please advise.
	Posted by macdaddy on 15 Aug 2009

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Input data format for multiple regression Rate this: (4/5 from 2 votes) For the date values, try to format the cells as a number. You can then reformat them back in the results and forecast later. For the boolean values, try using 1 and 2 rather than 0 and 1 as using 0s will result in an error with division be zero in the program.
	Excel Business Forums Administrator
	Posted by Excel Helper on 15 Aug 2009

Displaying page 1 of 1