Forum Discussion
Regression analysis and 3-D surface plotting
I have some data, two independent variables (input factors x,y axes) and one dependent variable (a response output variable z axis) and I would like to fit a model and plot a 3-D surface representing...
Excel can handle the regression analysis alright, but its surface chart expects equally-spaced x and y data (1, 2, 3, 4, 5, ...).
This means each subsequent input variable must have the same difference with its predecessor.
This means each subsequent input variable must have the same difference with its predecessor.
Thanks very much that's very helpful Jan. I just need to figure out how to do the analysis in Excel. Once I have I think that I should be able to use the model to produce a set of x,y values that are evenly spaced for input into a chart. Peter