Computing Simple Descriptive Statistics in Microsoft® Excel

Chapter 3, Printout 1


  1. Launch Excel.

  2. Enter the data.

    Screenshot: screenshot

  3. Display the descriptive statistics for Supplier 1.

    Excel displays descriptive statistics for Supplier 1 in cells A11-B25.

    Note: you can resize Column A to fit its contents by dragging the right-hand border of Column A's header.

    Screenshot: screenshot

  4. Display the descriptive statistics for Supplier 2.

    Excel displays descriptive statistics for Supplier 2 in cells D11-E25.

    Screenshot: screenshot