Minitab®  Support

Example of Format Column

Learn more about

A bank administrator collects data from loan applicants. The administrator wants to add currency symbols to the columns that contain monetary data.

  1. Open the sample data, LoanApplicant.MTW.
  2. Click in the Income column, right-click and choose Format Column.
  3. From Choose type, select Currency.
  4. Click OK.
  5. Select the Savings and Debt columns, right-click and choose Format Column.
  6. From Choose type, select Currency.
  7. Click OK.

Results

Income, Savings, and Debt are formatted as currency.

C1 C2 C3 C4 C5 C6 C7 C8
Income Education Age Residence Employ Savings Debt Credit Cards
$50,000 16 28 2 2 $5,000 $1,200 2
$72,000 18 35 10 8 $12,000 $5,400 4
$61,000 18 36 6 5 $15,000 $1,000 2
$88,000 20 35 4 4 $980 $1,100 4
... ... ... ... ... ... ... ...
Copyright © 2024 Minitab, LLC. All rights Reserved.