The packaged workbook can be found here. A major advantage to using this approach is that you can use any Excel file, regardless of the grain or dimensions of the data. Tableau will do any and all slicing and aggregations for you.
There are two things you must have though. First, the data must be stored in an Excel file. Second, the grain and slicer you would like to use must each exist as a single field in the workbook. If your slicer/grain is complex, you are free to create any calculated fields and/or groups, then use these in the calculations.
- Open the workbook
- Right-Click the Data Source -> Select "Edit Connection"
- Connect to your Excel Workbook
|Connecting to the Excel Workbook|
- Select the dimension/field/group you would like to slice your data with
- Select 1 slice to conduct a 1-sample test, comparing the slice against the [Theoretical Mean] Parameter
- Select 2 slices to conduct a 2-sample test, comparing the slices against each other