EXAMPLE OF APPLYING A MULTIFACTORIAL LINEAR FIT TO THE MASS DEFECT EQUATION USING A SPREADSHEET

Abstract

Multivariate adjustment exercise is presented using the worksheet linear estimation function of the spreadsheet. This time we used 3179 mass defect data, which were the points used to calculate the coefficients (slopes) of the equation, of the Weizsäcker formula. In general, the correlation is very close to 1. Values close to those reported are obtained, and the prediction of the maximum binding energy differs from the experimental data. This is an exercise, where we apply multivariate linear regression, in a Physics teaching environment.