EWT | Academic Question

Questions
Question (1)
QN0029493
The mean of five numbers is 18. If a new number 28 is added to the collection, what will be the new mean?
  • (A) 18
  • (B) 19
  • (C) 20
  • (D) 21

Correct Answer: C
Explanation:

Sum of first 5 numbers = 5 × 18 = 90. New sum = 90 + 28 = 118. New mean = 118 ÷ 6 ≈ 19.67, which is closest to 20.

Link:
Report Error
Question (2)
QN0029494
A data set has mean 24. If every value in the set is increased by 7, the new mean becomes:
  • (A) 24
  • (B) 31
  • (C) 17
  • (D) 168

Correct Answer: B
Explanation:

When each value increases by 7, the mean also increases by 7. So, new mean = 24 + 7 = 31.

Link:
Report Error
Question (3)
QN0029495
The mean of 8 numbers is 15. One number 19 was recorded as 25 by mistake. The incorrect mean obtained was 15. The correct mean is:
  • (A) 14.25
  • (B) 15
  • (C) 14.5
  • (D) 15.75

Correct Answer: A
Explanation:

Incorrect total = 8 × 15 = 120. Since 25 was written instead of 19, reduce total by 6. Correct total = 114. Correct mean = 114 ÷ 8 = 14.25.

Link:
Report Error
Question (4)
QN0029496
The median of the data 6, 9, 11, 15, 18, 20, 23 is:
  • (A) 11
  • (B) 15
  • (C) 18
  • (D) 20

Correct Answer: B
Explanation:

There are 7 observations. The middle (4th) observation is 15.

Link:
Report Error
Question (5)
QN0029497
The mean of a data set remains unchanged when:
  • (A) A value less than the mean is added
  • (B) A value greater than the mean is added
  • (C) A value equal to the mean is added
  • (D) Any value is added

Correct Answer: C
Explanation:

Adding a value equal to the existing mean does not affect the mean.

Link:
Report Error
Question (6)
QN0029498
The mean of 12 observations is 25. If each observation is doubled, the new mean becomes:
  • (A) 25
  • (B) 50
  • (C) 37.5
  • (D) 100

Correct Answer: B
Explanation:

Multiplying every observation by 2 also doubles the mean. Therefore, new mean = 50.

Link:
Report Error
Question (7)
QN0029499
The frequencies of marks are given below: Marks: 10, 20, 30, 40 and corresponding frequencies are 2, 3, 4, 1. The total number of observations is:
  • (A) 10
  • (B) 40
  • (C) 100
  • (D) 4

Correct Answer: A
Explanation:

Total observations = 2 + 3 + 4 + 1 = 10.

Link:
Report Error
Question (8)
QN0029500
For the data where marks are 10, 20, 30, 40 and frequencies are 2, 3, 4, 1 respectively, the mean marks are:
  • (A) 22
  • (B) 24
  • (C) 26
  • (D) 28

Correct Answer: B
Explanation:

Mean = (10×2 + 20×3 + 30×4 + 40×1) ÷ 10 = 240 ÷ 10 = 24.

Link:
Report Error
Question (9)
QN0029501
A spreadsheet formula to calculate the average of cells B2 to B8 is:
  • (A) =SUM(B2:B8)
  • (B) =AVERAGE(B2:B8)
  • (C) =MEAN(B2:B8)
  • (D) =AVG(B2:B8)

Correct Answer: B
Explanation:

The AVERAGE function computes the arithmetic mean of values in the specified range.

Link:
Report Error
Question (10)
QN0029502
The median of the data 4, 7, 9, 13, 18, 21, 25, 28 is:
  • (A) 11
  • (B) 13
  • (C) 15.5
  • (D) 18

Correct Answer: C
Explanation:

There are 8 observations. Median = (13 + 18) ÷ 2 = 15.5.

Link:
Report Error
Excel With Tutors

Learn At Your Own Pace... Because, Everyone's Pace of Learning is Different...

ExcelWithTutors

A unit of Innovexcel Edu Solution LLP.

SWIFT, RELIABLE & CONVENIENT..


Social Media

Corporate Office :
Bharat Impact Building, C-26, Sector - 59, Noida, Uttar Pradesh - 201301, India

Excel With Tutors : A Perfect Tutoring Platform & Repository of Learning Materials. Matches the Best Tutor as Per Your Requirement.


© 2025 | ©Innovexcel Edu Solution LLP. All Rights Reserved.

Technology Partner: Indev Consultancy Pvt Ltd

Find a Tutor Join as Tutor