- Minitab Cookbook
- Isaac Newton
- 454字
- 2021-07-16 12:29:20
Calculator – basic functions
The e-calculator tool is analogous to formulas in Excel. In Minitab, we will run calculations on the columns one at a time. Using the weather data from the Oxford station, we will create a new column for the hours of sunlight in a month divided bythe amount of rainfall (in millimeters) for that month.
Getting ready
We will be using data from Oxford weather station; it can be obtained from http://www.metoffice.gov.uk/climate/uk/stationdata/. Select Oxford weather station data and copy the data into Minitab. Only copy the data and not the column headers. Then, rename the columns as Year, Month, T Max, T Min, Airfrost(days), Rain(mm), and Sun(Hrs).
Note
Inspect the data that we copy to ensure that the columns have the right data type. The column header C1-T will indicate text, C1-D will indicate data, and C1 without the hyphen is a numeric column.
Also, note that a few of the values in the data will be recorded as missing; this is where text values are supplied next to the number. A cleaned worksheet is provided in the Oxford weather (cleaned).mtw file.
How to do it…
The following instructions will create a new column for the hours of sunlight to amount of rainfall in a month ratio:
- Go to the Calc menu and click on Calculator.
- In the dialog box, enter a name for the new column into the Store result in Variable section. We will name it as
'Sun(Hrs)/Rain(mm)'. - Select the section labeled Expression, and then double-click on
Sun (Hours)to move it across, enter/, and then move theRain(mm)column over. - Tick the box labeled Assign as formula and click on OK.
How it works…
The results of this function are generated in the selected column. The checkbox Assign as a formula will create a formula in the worksheet that will keep updating it. By default, this is not selected to avoid problems with circular or self-referencing formulas. When a formula is stored in a column, a green cross is placed at the top of the column to indicate the presence of a formula. The green cross indicates that this is up-to-date, while a red cross would indicate a problem in updating the formula.
There's more…
The calculator in Minitab has a plethora of functions available. We can choose from the function list on the right in the calculator screen. These include several statistical, mathematical, and text functions. They can be filtered with the drop-down list at the top. The help function for the calculator includes a list of functions and how to use them.
See also
- The Calculator – using an if statement recipe
- The Cleaning up a text column with the calculator recipe
- INSTANT Citrix XenDesktop 5 Starter
- 一本書學內部審計：新手內部審計從入門到精通
- 注冊會計師全國統一考試專用教材：審計
- Learning Microsoft Azure
- 大數據搜索與挖掘及可視化管理方案 ：Elastic Stack 5：Elasticsearch、Logstash、Kibana、X-Pack、Beats （第3版）
- 陜西國家統計調查專題研究集萃（2006—2015）
- 《企業內部控制基本規范》合規實務指南
- 成功通過PMP（第3版）
- Minitab Cookbook
- 高級計量經濟分析及Stata應用
- 中國審計市場:制度變遷與競爭行為
- QlikView for Developers Cookbook
- INSTANT IBM Lotus Notes 8.5.3 How-to
- 多項目管理方法及其應用研究（國家社科基金后期資助項目）
- 審計實務