Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo
Non-linear regression is used to fit data to a broad range of functions. In non-linear regression, a non-linear model is used to explain the relationship between the dependent variable and one or more independent variables. This paper demonstrates the use of the Gauss-Newton method in Microsoft Exce...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
2023-10-01
|
| Series: | Spreadsheets in Education |
| Online Access: | https://doi.org/10.1000/189 |
| _version_ | 1797646906492452864 |
|---|---|
| author | Prasanth Sambaraju |
| author_facet | Prasanth Sambaraju |
| author_sort | Prasanth Sambaraju |
| collection | DOAJ |
| description | Non-linear regression is used to fit data to a broad range of functions. In non-linear regression, a non-linear model is used to explain the relationship between the dependent variable and one or more independent variables. This paper demonstrates the use of the Gauss-Newton method in Microsoft Excel to perform non-linear regressions. |
| first_indexed | 2024-03-11T15:08:35Z |
| format | Article |
| id | doaj.art-343337dde1dd4dbabb17906ff1ec8b63 |
| institution | Directory Open Access Journal |
| issn | 1448-6156 |
| language | English |
| last_indexed | 2024-03-11T15:08:35Z |
| publishDate | 2023-10-01 |
| publisher | McMaster University |
| record_format | Article |
| series | Spreadsheets in Education |
| spelling | doaj.art-343337dde1dd4dbabb17906ff1ec8b632023-10-30T00:56:25ZengMcMaster UniversitySpreadsheets in Education1448-61562023-10-01Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNoPrasanth SambarajuNon-linear regression is used to fit data to a broad range of functions. In non-linear regression, a non-linear model is used to explain the relationship between the dependent variable and one or more independent variables. This paper demonstrates the use of the Gauss-Newton method in Microsoft Excel to perform non-linear regressions.https://doi.org/10.1000/189 |
| spellingShingle | Prasanth Sambaraju Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo Spreadsheets in Education |
| title | Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo |
| title_full | Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo |
| title_fullStr | Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo |
| title_full_unstemmed | Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo |
| title_short | Gauss-Newton Method for Non-linear Data Using Microsoft ExcelNo |
| title_sort | gauss newton method for non linear data using microsoft excelno |
| url | https://doi.org/10.1000/189 |
| work_keys_str_mv | AT prasanthsambaraju gaussnewtonmethodfornonlineardatausingmicrosoftexcelno |