Question:
Given below are two statements.
Assertion (A):
The arithmetic mean of \(A1:
A10\) cells can be calculated using Microsoft Excel with the formula \(\texttt{=SUM(A1:
A10)/10\).
Reason (R):
The direct formula does not exist to calculate arithmetic mean in Microsoft Excel.}
Given below are two statements.
Assertion (A):
The arithmetic mean of \(A1:
A10\) cells can be calculated using Microsoft Excel with the formula \(\texttt{=SUM(A1:
A10)/10\).
Reason (R):
The direct formula does not exist to calculate arithmetic mean in Microsoft Excel.}
Assertion (A):
The arithmetic mean of \(A1:
A10\) cells can be calculated using Microsoft Excel with the formula \(\texttt{=SUM(A1:
A10)/10\).
Reason (R):
The direct formula does not exist to calculate arithmetic mean in Microsoft Excel.}
Show Hint
In Excel, mean can be calculated using \(\texttt{=SUM(range)/n}\) or directly by \(\texttt{=AVERAGE(range)}\).
Updated On: Jun 6, 2026
- Both (A) and (R) are correct and (R) is the correct explanation of (A)
- Both (A) and (R) are correct but (R) is not the correct explanation of (A)
- (A) is correct but (R) is not correct
- (A) is not correct but (R) is correct
Show Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
Concept:
Arithmetic mean is: \[ \text{Mean}=\frac{\text{Sum of observations}}{\text{Number of observations}} \]
Step 1: Check Assertion.
The formula: \[ \texttt{=SUM(A1:A10)/10} \] adds values from \(A1\) to \(A10\) and divides by \(10\). Therefore, it correctly calculates arithmetic mean.
Step 2: Check Reason.
Microsoft Excel has a direct function to calculate average: \[ \texttt{=AVERAGE(A1:A10)} \] Therefore, the statement that direct formula does not exist is false. Thus, Assertion is correct but Reason is not correct. \[ \therefore \text{Correct Answer is (C)} \]
Arithmetic mean is: \[ \text{Mean}=\frac{\text{Sum of observations}}{\text{Number of observations}} \]
Step 1: Check Assertion.
The formula: \[ \texttt{=SUM(A1:A10)/10} \] adds values from \(A1\) to \(A10\) and divides by \(10\). Therefore, it correctly calculates arithmetic mean.
Step 2: Check Reason.
Microsoft Excel has a direct function to calculate average: \[ \texttt{=AVERAGE(A1:A10)} \] Therefore, the statement that direct formula does not exist is false. Thus, Assertion is correct but Reason is not correct. \[ \therefore \text{Correct Answer is (C)} \]
Was this answer helpful?
0
0
Top CUET PG B.Ed. Mathematics Questions
- Which of the following represents the slope of the line passing through points (3, −2) and (3, 4)?
- Evaluate the determinant:
\[ \left| \begin{array}{ccc} b+c & a-b & a\\ c+a & b-c & b\\ a+b & c-a & c\\ \end{array} \right| \] - If \[ x=e^{\tan^{-1}\left(\frac{y-x^2}{x}\right)} \] then \(\dfrac{dy}{dx}=?\)
- If \(y=e^{m\sin^{-1}x}\) and \(y_n\) indicates \(n^{th}\) derivative of \(y\) with respect to \(x\), then which of the following relation is true?
- Which of the following is derivative of \(\sqrt{a^{\sqrt{x}}}\) with respect to \(x\)?
View More Questions
Top CUET PG Computer Science Questions
- Given below are two statements.
Assertion (A):
For a random variable \(X\), if \(x=0,1,2,\ldots\) and \[ P(X=x)=k\frac{\lambda^x}{x!}, \] then for it to be a probability mass function, \(k=e^{-\lambda}\).
Reason (R):
In a probability distribution, the sum of all probabilities must be \(1\). Match List-I with List-II. A data contains the following eight values:
\[ 4,3,0,5,2,9,4,5 \]List-I List-II (A) Range of data minus \(4\) (II) \(5\) (B) Mean Deviation (IV) \(1.75\) (C) Variance (III) \(6\) (D) Median (I) \(4\) - Which is odd one out of the following?
- For the binary input \(010\), which of the following represents min-term and max-term?
- Which of the following ICs (Integrated Circuits) is the fastest?
View More Questions
Top CUET PG Questions
- Given below are two statements:
Statement I: For Plato the meaning of the word 'Justice' is basically a conception in the mind only.
Statement II: For Plato the meaning of the word 'Justice' is fixed, mind-independently
In the light of the above statements, choose the correct answer from the options given below: - What is the electron count of OS6CO182-?
- XeF4 hydrolysis gives A + B, HF, and Oxygen. Find A and B
- What is more basic in pyrol and pyridine?
- Hydrolysis of Al2C3, Be2?
View More Questions