Hello,
I am trying to run a regression but I have blank cells in my x range and my y range has none. I do not want to put a 0 in because my data will be skewed. Is there a way to put a placeholder to skip over those specific cells, meaning do not include them in the regression test. I am using the regression test in the data analysis tool pak.
Example,
Y X
1 5
2 3
2
8 1
6
1 5
Thanks!
The only way I know to do this is to completely remove the "blank" records from the dataset used in the regression. There are a few different strategies for this, and I am not sure which ones you will like. A couple of ideas:
1) Use Advanced Filter to create a copy of the dataset that filters out the records where X is blank. Use the filtered list in the regression tool.
2) Sort the dataset so that all of the blank X are at the bottom (or top) of the data set. With all of the filled cells in one block, it should be easy to specify only that block in the regression tool
Or whatever strategy you come up with to remove the blank entries from the regression input.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks