Scatterplot for Visualize Relationships With Turn-earn Index

Use Scatterplot to visualize the turn and earn index versus one continuous variable.

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

Example

The turn and earn index (T/E Index) balances inventory turnover and profits. To calculate the turn and earn index, multiply inventory turnover and gross profit percentage. For example, if the inventory turns over 10 times in a year and has a 40% profit margin, the turn/earn index is 400.

In this worksheet, T/E Index is the Y variable, and Sales Promotions is the X variable.

C1	C2
`T/E Index`	`Sales Promotions`
223	4
256	1
388	6
319	6

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Turn-earn index.
Select Visualize relationships with turn-earn index, then click OK.
Select Scatterplot, then click OK.
In Y variables, enter the column that contains the turn and earn index.
In X variables, enter a corresponding column that might explain or predict changes in the turn and earn index.
Click OK.

Tip

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