Sep 30 2021 03:41 AM
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 this data.
So my first question is can the data analysis pack in Excel handle this regression analysis, or do I need to use a statistical package like PSPP?
If Excel can handle this, how do I go about doing it?
Thanks for any comments or suggestions.
Peter
Sep 30 2021 05:29 AM
Oct 01 2021 08:01 AM
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