Statistics t test, z test and F test
Tap the "Statistics" tab in calculator app, select option for t test, z test, F test and use the "Read/Create Spreadsheet..." option to read the spreadsheet containing raw or processed data. Select one of the options about how your data is organized in your spreadsheet and provide respective column numbers. See the snapshot below for details -
Select the test model for test and to perform z-test instead of t-test check the option "Do Z test..." by providing population SD.
You can also view a sample data file in csv format where columns are separated by comma and rows are provided in new lines (Comments are provided in sample after #). The app expects the first line as shown in the sample csv to be the file read start row.
Since data in spreadsheets may not always start at first row (ex-first few rows may be used for column names and comments), you need to set the correct file read start row in the "Read/Create Spreadsheet..." page.
See a sample snapshot below of results for a sample data.