- 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
- Microsoft Dynamics NAV Financial Management
- 大數據搜索與挖掘及可視化管理方案 ：Elastic Stack 5：Elasticsearch、Logstash、Kibana、X-Pack、Beats （第3版）
- 《企業內部控制基本規范》合規實務指南
- 新編統計學
- Programming Microsoft Dynamics NAV（Fifth Edition）
- 中國審計市場:制度變遷與競爭行為
- QlikView for Developers Cookbook
- 看穿一切數字的統計學
- INSTANT IBM Lotus Notes 8.5.3 How-to
- Getting Started with Citrix? Provisioning Services 7.0
- 2014年注冊會計師（CPA）全國統考專用輔導教材系列：審計（名師解讀版）
- 政府采購評審專家工作指南
- 績效考核與薪酬激勵精細化設計必備全書
- 規范內部審計的28個技巧
- 內部審計數字化轉型：方法論與實踐