For a given data table with five input variable and on output variable, how I can find an equation which fits best my data points? linear or nonlinear equation are admissible.
Is there other software to do that?
Excel is not a statistical package, and if you wish to publish it is best to engage with an up to date and well recognised Statistical package such as R.
You will need to have an understanding of statistics to be able to use the correct analysis.
It is not just about the data points but the Research Question you have and also the design of your study.
Excel package is perfectly fine for performing statistical analysis such as multiple linear regression, along with many others statistical methods. No coding is needed at all (vs. using R or Python)
In Excel you go to Data tab, then click Data analysis, then scroll down and highlight Regression.
In regression panel, you input a range of cells with Y data, with X data (multiple regressors), check the box with output range or new worksheet, and check all the plots that you need.
The output will include all regression statistics, and regression coefficients, ANOVA output, and all residuals.
Other software packages provide a more advanced options, such as R, Python, or software packages with graphical user interface (GUI) which require no coding at all. The packages such as Minitab 17 or 18, SPSS, JMP, SAS, and many others are available either free or with a nominal license fee.
I would still prefet that a serious researchet would use statistical software. I would not re commend Excel for statistics,. Fine for data collection, then take the data into a statistical package. T
Thank you for your Cooperation
Using ''logest'' and ''linest'' functions, you can do multi variable resression in Excel.
Good Luck
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics
- Regression