Regression analysis and 3-D surface plotting

%3CLINGO-SUB%20id%3D%22lingo-sub-2798689%22%20slang%3D%22en-US%22%3ERegression%20analysis%20and%203-D%20surface%20plotting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2798689%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20some%20data%2C%20two%20independent%20variables%20(input%20factors%20x%2Cy%20axes)%20and%20one%20dependent%20variable%20(a%20response%20output%20variable%20z%20axis)%20and%20I%20would%20like%20to%20fit%20a%20model%20and%20plot%20a%203-D%20surface%20representing%20this%20data.%3CBR%20%2F%3ESo%20my%20first%20question%20is%20can%20the%20data%20analysis%20pack%20in%20Excel%20handle%20this%20regression%20analysis%2C%20or%20do%20I%20need%20to%20use%20a%20statistical%20package%20like%20PSPP%3F%3C%2FP%3E%3CP%3EIf%20Excel%20can%20handle%20this%2C%20how%20do%20I%20go%20about%20doing%20it%3F%3C%2FP%3E%3CP%3EThanks%20for%20any%20comments%20or%20suggestions.%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2798689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2798994%22%20slang%3D%22en-US%22%3ERe%3A%20Regression%20analysis%20and%203-D%20surface%20plotting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2798994%22%20slang%3D%22en-US%22%3EExcel%20can%20handle%20the%20regression%20analysis%20alright%2C%20but%20its%20surface%20chart%20expects%20equally-spaced%20x%20and%20y%20data%20(1%2C%202%2C%203%2C%204%2C%205%2C%20...).%3CBR%20%2F%3EThis%20means%20each%20subsequent%20input%20variable%20must%20have%20the%20same%20difference%20with%20its%20predecessor.%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies
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.

@Jan Karel Pieterse 

 

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