Recording Metadata
- System
- Windows
- Version
- 10 (10.0.19045)
- Processor
- Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
- Resolution
1920 x 1080 px
Reasoning Steps
Step 1
Launch Microsoft Excel Begin by opening a new Excel workbook to enter and analyze data.
Step 2
Enter sample data for two groups Populate column A with the label "Group A" and enter 5 numeric values below it. Do the same for column B with "Group B" and another 5 numeric values.
Step 3
Label and calculate AVERAGE In cell A9, type "Average" as the label. In cell B9, enter the formula =AVERAGE(A2:A6) to compute the average for Group A.
Step 4
Label and calculate MEDIAN In cell A10, type "Median" and in B10, input =MEDIAN(A2:A6) to calculate the median.
Step 5
Label and calculate STANDARD DEVIATION In A11, type "Standard Deviation" and in B11, input =STDEV.S(A2:A6) to get the sample standard deviation.
Step 6
Label and calculate CONFIDENCE INTERVAL In A12, type "Confidence Int" and in B12, use the formula: =CONFIDENCE.T(0.05, STDEV.S(A2:A6), COUNT(A2:A6))
Step 7
Label T-TEST section In A15, type "T-TEST" to introduce the section. In A16, type "Comparison" and in B16, write "Formula" as an indicator of what’s in the next cell.
Step 8
Calculate P-VALUE using T.TEST In A17, type "P-VALUE" and in B17, enter: =T.TEST(A2:A6, B2:B6, 2, 2) This performs a two-tailed, two-sample equal variance t-test between Group A and Group B.
Step 9
After completing the task, stop the screen recording to capture the full process. The screen recording is automatically saved to: Documents > DuckTrack Recordings on your local machine.
Step 10
Open the Paradigm Shift AI portal in the browser, click the “Select video file” button. Navigate to the 'DuckTrack Recordings' folder, select the relevant screen recording file, and confirm the upload to associate it with the task.
Video
Loading tracking data...