Chapter 1. Worksheet, Data Management, and the Calculator

In this chapter, we'll be covering the following recipes:

  • Opening an Excel file in Minitab
  • Opening data from Access using ODBC
  • Stacking several columns together
  • Stacking blocks of columns at the same time
  • Transposing the columns of a worksheet
  • Splitting a worksheet by categorical column
  • Creating a subset of data in a new worksheet
  • Extracting values from a date/time column
  • Calculator – basic functions
  • Calculator – using an if statement
  • Coding a numeric column to text values
  • Cleaning up a text column with the calculator

Introduction

This first chapter illustrates the use of a worksheet, data menu, and calculator tools. We start by bringing data in from other applications and then working on it using other ...

Get Minitab Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.