Null Variables and Dates

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

Forum Topic

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

Find relevant Excel templates and add-ins for Null Variables and Dates in the Excel Business Solutions Directory