Appendix 1: Software Solutions

The image shows a screenshot of a Microsoft Excel application. In the background, a worksheet titled “Book1” is open, with column headers labeled “[latex]A[/latex]” and “[latex]B[/latex]“. The worksheet contains a column of numerical data under column “[latex]A[/latex],” specifically labeled “Data” in cell [latex]A1[/latex], with values [latex]25[/latex], [latex]35[/latex], [latex]45[/latex], [latex]50[/latex], [latex]55[/latex], [latex]65[/latex], [latex]75[/latex], [latex]85[/latex], [latex]95[/latex], and [latex]105[/latex] in cells [latex]A2[/latex] through [latex]A11[/latex]. Cell [latex]A12[/latex] is empty, and cell [latex]A13[/latex] is highlighted. Column [latex]B[/latex] is empty.

In the foreground, a “Descriptive Statistics” dialog box is open. The dialog box is divided into two main sections:

[latex]1[/latex]. Input:
– Input Range: `[latex]$A$1:$A$12[/latex]`
– Grouped By: Columns (selected)
– A checkbox labeled “Labels in first row” is checked.

[latex]2[/latex]. Output options:
– Output Range: `[latex]$D$1:$F$12[/latex]`
– Radio buttons for `Output Range` (selected), `New Worksheet Ply`, and `New Workbook`.
– A checkbox for “Summary statistics” is checked.
– Fields with labels for “Confidence Level for Mean:” set to [latex]95%[/latex], and fields for “[latex]K^{th}[/latex] Largest” and “[latex]K^{th}[/latex] Smallest” both set to [latex]1[/latex].

On the right side of the dialog box, there are three buttons: `OK`, `Cancel`, and `Help`. The Excel Ribbon is visible at the top with various tabs like File, Home, Insert, Page Layout, Formulas, Data, Review, and View. The “Data” tab is currently selected, displaying options such as Connections, Sort, Filter, Data Tools, and Outline.