Statistical Packages and its Applications (STA641)

1. What are the two components of any Excel formula?

   1. Operator and operands
   2. Operator and + sign
   3. Operator and = sign
   4. Operator and brackets

2. The cell reference for cell range of G2 to M12 is ________.

   1. G2:M12
   2. G2.M12
   3. G2;M12
   4. G2-M12

3. If Standard Deviation is 3 what will be the value of Variance?

   1. 3
   2. 6
   3. 9
   4. 12

4. What is the median of the following set of scores?
   18. 6, 12, 10, 14?

   1. 10
   2. 12
   3. 14
   4. 18

5. When data is arranged, middle value in set of observations is classified as

   1. Median
   2. Mean
   3. Variance
   4. Standard deviation

6. Which of the following is NOT a measure of variability?

   1. Median
   2. Variance
   3. Standard deviation
   4. Range

7. Convert the value 0.125 into two-decimal places.

   1. 0.1
   2. 0.12
   3. 0.13
   4. 0.120

8. What is meant by precision of data?

   1. Any value with 2 decimal places
   2. Any value with 10 decimal places
   3. The number of decimal places displayed in the cell
   4. The number of decimal places stored in computer

9. In Excel, Rows are labeled as ________.

   1. A, B, C, etc
   2. 1, 2, 3, etc
   3. A1, A2, etc
   4. $A$1, $A$2, etc

10. Sum of values of data is divided by total number of values is used to calculate

    1. Arithmetic mean
    2. Weighted average mean
    3. Geometric mean
    4. Harmonic mean

Select a course code for Objective Questions:

ACC311 ACC501 BIF101 BIF401 BIF501 BIO101 BIO201 BIO202 BIO203 BIO204 BIO301 BIO302 BIO303 BIO401 BIO503 BNK603 BT101 BT201 BT301 BT302 BT401 BT402 BT403 BT404 BT405 BT406 BT501 BT504 BT505 BT604 CHE201 CHE301 CS001 CS101 CS201 CS202 CS204 CS301 CS302 CS304 CS311 CS401 CS402 CS403 CS408 CS501 CS502 CS504 CS506 CS508 CS601 CS602 CS604 CS605 CS607 CS609 CS610 CS614 CS707 CS710 ECO401 ECO402 ECO403 ECO404 EDU302 EDU401 EDU402 EDU501 EDU601 ENG101 ENG201 ENG301 ENG501 FIN611 FIN624 FIN625 ISL201 IT430 MCM101 MCM301 MGMT623 MGT101 MGT211 MGT301 MGT401 MGT402 MGT501 MGT502 MGT503 MGT510 MGT601 MGT603 MKT501 MKT610 MKT630 MTH101 MTH202 MTH302 MTH501 MTH601 MTH634 PAK301 PHY101 PHY301 PSY101 PSY403 PSY502 PSY512 SOC101 SOC301 SOC401 STA301 STA630 STA641 ZOO102 ZOO401 ZOO501 ZOO502 ZOO503 ZOO504 ZOO505 ZOO506 ZOO510 ZOO630

Select a course code for Subjective Questions:

ACC311 CS001 CS101 CS201 CS301 CS607 CS701 CS702 CS703 CS704 CS707 CS708 CS710 CS711 CS718 CS721 CS724 ECO401 ECO403 ENG101 ENG301 MGT703 MTH501 STA301