Fit Regression Model for Predict Freight Cost Per Unit

Use Fit Regression Model to use multiple predictors to predict freight cost per unit.

This example applies to the Supply Chain Module. For more information, go to www.minitab.com/supply-chain-module.

Example

Freight cost per unit is the total freight costs divided by the number of units shipped.

In this worksheet, Freight Cost/Unit ($) is the response. Load Times is a continuous predictor, and Pickup Time is a categorical predictor. The predictors may explain differences in freight cost per unit.

C1	C2	C3-T
`Freight Cost/Unit ($)`	`Load Times`	`Pickup Time`
1.38	2	Peak
1.22	4	Normal
2.36	8	Peak
1.75	3	Normal

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Costs, select Freight cost per unit.
Select Predict freight cost per unit, then click OK.
Select Fit Regression Model, then click OK.
In Responses, enter the column that contains the freight cost per unit data. The response is also called the Y variable.
In Continuous predictors, enter the columns of numeric data that may explain or predict changes in freight cost. The predictors are also called X variables.
In Categorical predictors, enter the categorical classifications or group assignments that may explain or predict changes in freight cost. The predictors are also called X variables.
Click OK.

Tip

For more information about this analysis, click Help in the main dialog box.