Regression
> Linear
> Multiple
> Y = f( X1, X2, X3 )
> Excel
> Data Structure
A = X1, B = X2, C = X3, D = Y, Row 1 = Headers
> Data Operation
Excel > Data > Data Analysis > Regression
> Input Y Range = D1:D100
> Input X Range = A1:C100
> Lebels = Yes
> Confidence Level = 95 % = Default
> New Worksheet Ply = "Regr-Lin-Mult-Output"
> Residuals
> Residuals = Yes
Residual Plots = Yes
Standardized Residuals = Yes
Line Fit Plots = Yes
> Normal Probability
> Normal Probabilty Plots = Yes
Predict Dwell [days]
Y_Dwell = + b_0
+ b_1 * X_1_Movement
+ b_2 * X_2_Full
+ b_3 * X_3_Type
Y_Dwell = + (+16.34) * 1
+ (- 1.69) * X_1_Movement
+ (- 1.58) * X_2_Full
* (- 0.08) * X_3_Type

