Discussion Regression analysis and 3-D surface plotting in Excel
https://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2798689#M116011
<P>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.<BR />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?</P><P>If Excel can handle this, how do I go about doing it?</P><P>Thanks for any comments or suggestions.</P><P>Peter</P>Thu, 30 Sep 2021 10:41:37 GMTPeter-PC32021-09-30T10:41:37ZRegression analysis and 3-D surface plotting
https://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2798689#M116011
<P>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.<BR />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?</P><P>If Excel can handle this, how do I go about doing it?</P><P>Thanks for any comments or suggestions.</P><P>Peter</P>Thu, 30 Sep 2021 10:41:37 GMThttps://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2798689#M116011Peter-PC32021-09-30T10:41:37ZRe: Regression analysis and 3-D surface plotting
https://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2798994#M116018
Excel can handle the regression analysis alright, but its surface chart expects equally-spaced x and y data (1, 2, 3, 4, 5, ...).<BR />This means each subsequent input variable must have the same difference with its predecessor.Thu, 30 Sep 2021 12:29:33 GMThttps://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2798994#M116018Jan Karel Pieterse2021-09-30T12:29:33ZRe: Regression analysis and 3-D surface plotting
https://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2803040#M116215
<P><LI-USER uid="22322"></LI-USER> </P><P> </P><P>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</P>Fri, 01 Oct 2021 15:01:33 GMThttps://techcommunity.microsoft.com/t5/excel/regression-analysis-and-3-d-surface-plotting/m-p/2803040#M116215Peter-PC32021-10-01T15:01:33Z