Which of the following software can be used to perform a t-test? (A) MS Excel…

2022

Which of the following software can be used to perform a t-test?

(A) MS Excel

(B) Unix

(C) SPSS

(D) Microsoft Equation

Choose the most appropriate answer from the options below.

Answer: C. (A) and (C) onlyConceptA t-test must be carried out by a tool that implements the statistical calculation or provides a t-test procedure. A spreadsheet qualifies when it has…

  1. A.

    (A) and (B) only

  2. B.

    (B), (C) and (D) only

  3. C.

    (A) and (C) only

  4. D.

    (A), (C) and (D) only

Show answer & explanation

Correct answer: C

Concept

A t-test must be carried out by a tool that implements the statistical calculation or provides a t-test procedure.

A spreadsheet qualifies when it has a built-in statistical function, while a statistical package qualifies through a dedicated test command.

Application

  1. MS Excel provides the T.TEST function for paired and two-sample t-tests.

  2. Unix is an operating-system platform; statistical programs may run on it, but Unix itself is not a t-test application.

  3. SPSS provides dedicated one-sample, independent-samples, and paired-samples t-test procedures.

  4. Microsoft Equation is an equation editor for typesetting mathematical expressions, not a statistical-analysis package.

Cross-check

Microsoft documents the T.TEST function, and IBM documents the SPSS T-TEST command and its supported test types.

Result

Therefore, the usable software named in the statements are MS Excel and SPSS.

Explore the full course: Nta Ugc Net Paper 1

Loading lesson…