官术网_书友最值得收藏!

首頁 >

Minitab Cookbook

Producing a graphical summary of data

The Graphical Summary… tool is a quick way of producing an overview of a column of data. The following example shows us the output comprising a histogram, the Anderson-Darling test for normality, mean, standard deviation, and more.

Here, we will use the data from the Oxford weather station and produce a summary of the amount of rainfall in mm for each month, for all the results from 1853 onwards.

Getting ready

We will use the data from the Oxford weather station in this example. This data is from the Met Office website and can be found at http://www.metoffice.gov.uk/climate/uk/stationdata/. Select the Oxford station.

The data is made available in the Oxford Weather.txt file; this preserves the format from the website. This data is also available in the Minitab Oxford weather (cleaned).mtw file, and using this worksheet correctly imports itself into Minitab for us.

How to do it…

The following steps will import the weather station's data and then produce a summary of rainfall seen in each month from 1853 to 2013:

  1. Follow the previously mentioned link to the Met Office weather station website.
  2. Choose the Oxford (Oxford 1853-) station.
  3. In your web browser, save the file as a text file.
  4. In Minitab, go to File and select Open Worksheet….
  5. Change Files of type to Text (*.txt).
  6. Select the file that we have just saved or select the provided Oxford Weather.txt file.
  7. Click on the Preview… button to see how the data will be imported. Notice that the data starts on line 8 and the variable names on row 6. All the data appears in one column.
  8. Click on OK and select the Options… button.
  9. In the Variable Names section, select Use row: and enter 6.
  10. For the First Row of Data section, select Use row: and enter 8.
  11. Set the Field Definition option to Free format.
  12. Click on OK in the Open Worksheet dialog box and then click on Open.
  13. Go to the Stat menu, then Basic Statistics and then click on Graphical Summary….
  14. In the dialog box, enter the column for rainfall amount as the Variables: field, and the column for month into the By Variables field.
  15. Click on OK.

How it works…

The columns in Variables populate the summary statistics and the optional selection of By variables (optional) allows us to split a set of data into separate summaries. Using the month as By variables (optional) creates a summary for each month. The following screenshot shows us the results for July:

How it works…

There's more…

If we want to view the results from only one month, say July, instead of generating a summary for all months, we can use the Split Worksheet… or Subset Worksheet… tools. These can be used to generate new datasets using the results contained within a single month.

See also

  • The Splitting a worksheet by categorical column recipe in Chapter 1, Worksheet, Data Management, and the Calculator
  • The Creating a subset of data in a new worksheet recipe in Chapter 1, Worksheet, Data Management, and the Calculator
主站蜘蛛池模板： 普陀区| 尤溪县| 宣汉县| 罗定市| 华安县| 镇赉县| 阿合奇县| 荣昌县| 仪陇县| 吉安市| 隆子县| 泸溪县| 龙胜| 衢州市| 中方县| 阿勒泰市| 石泉县| 湘潭县| 永昌县| 余庆县| 旬阳县| 文山县| 天柱县| 上犹县| 河津市| 沙雅县| 进贤县| 专栏| 攀枝花市| 兴义市| 随州市| 宽甸| 长沙县| 临清市| 曲松县| 城固县| 道真| 托克托县| 无锡市| 成都市| 潍坊市|