![excel linear regression extension to nonlinear excel linear regression extension to nonlinear](https://engcourses-uofa.ca/wp-content/uploads/example-23.png)
In addition, the coefficient on the length of stay remains statistically significant. In that figure it is possible to see that not only is the coefficient for sex statistically different from 0, but so, too, is the interaction coefficient. The coefficients that result from this analysis are shown in Figure 13.8.
![excel linear regression extension to nonlinear excel linear regression extension to nonlinear](https://people.revoledu.com/kardi/tutorial/Regression/nonlinear/image/NonLinearRegression_clip_image004.jpg)
To determine if it does, it would be necessary to analyze all three variables-the length of stay, sex, and the length of stay*sex interaction-simultaneously. It may be that the interaction between the length of stay and sex could have a statistically significant relationship to charges. In this case, it would be a reasonable practice to simply drop sex from the analysis and predict charges with the length of stay only, except for one thing. Sex is no longer a statistically significant predictor of charges. Of the regression coefficients shown in Figure 13.7, only the coefficients for length of stay and the intercept are different from 0.
![excel linear regression extension to nonlinear excel linear regression extension to nonlinear](https://engineerexcel.com/wp-content/uploads/2016/06/060716_0247_NonlinearCu3.png)
6.4 MEAN AND STANDARD DEVIATION OF A DISCRETE NUMERICAL VARIABLE.6.3 THE SAMPLING DISTRIBUTION OF THE MEAN.6.1 MEASURES OF CENTRAL TENDENCY AND DISPERSION.CHAPTER 6 - MEASURES OF CENTRAL TENDENCY AND DISPERSION:DATA DISTRIBUTIONS.5.2 MARGINAL PROBABILITIES, JOINT PROBABILITIES, AND CONDITIONAL PROBABILITIES.5.1 SOME INITIAL CONCEPTS AND DEFINITIONS.CHAPTER 5 - BASIC CONCEPTS OF PROBABILITY.APPENDIX: USING EXCEL 2007 TO GENERATE PIVOT TABLES WITH ONE VARIABLE.4.3 A LOGICAL EXTENSION OF THE PIVOT TABLE: TWO VARIABLES.4.2 USING THE PIVOT TABLE TO GENERATE FREQUENCIES OF CATEGORICAL VARIABLES.CHAPTER 4 - DATA DISPLAY: DESCRIPTIVE PRESENTATION, EXCEL GRAPHING CAPABILITY.CHAPTER 3 - DATA ACQUISITION: SAMPLING AND DATA PREPARATION.2.9 THE DOLLAR SIGN ($) CONVENTION FOR CELL REFERENCES.2.8 FUNCTIONS THAT GIVE RESULTS IN MORE THAN ONE CELL.2.2 WORKING AND MOVING AROUND IN A SPREADSHEET.CHAPTER 2 - EXCEL AS A STATISTICAL TOOL.1.2 STATISTICAL APPLICATIONS IN HEALTH POLICY AND HEALTH ADMINISTRATION.1.1 HOW THIS BOOK DIFFERS FROM OTHER STATISTICS TEXTS.Veney Statistics for Health Care Professionals: Working With Excel, 2nd Edition CHAPTER 13 - EXTENSIONS OF MULTIPLE REGRESSION by David A.