Data Ka Analysis

One district was rating “1,2,3”, now rating “A, B, C” in the same column. This is an example of ‘inconsistent data’. 

• True

• False

Which is not effective data cleaning techniques? 

• Remove irrelevant data 

• Ignore Duplicates

• Handling Missing Values

• Convert Data Types 

Outliers must be ignored during analysis.

• True
• False

If cell B4 (in excel sheet) has value 76, Then Formula “=AND(F5>75,F5<65)” would result as. 

• FALSE
• TRUE

Average of values (1,2,3) would be. 

• 1

• 2

• 3

• 6

What is Informed Decision?

• A decision made solely based on emotions
• A decision made based on relevant information, data, and analysis.
• A decision made based on random guesses
• A decision made without any thought

To calculate average of values (10, 32, 53, 14, 66), What formula should be used in Excel. 

• =SUM(10, 32, 53, 14, 66)
• =MAX(10, 32, 53, 14, 66)
• =MIN(10, 32, 53, 14, 66)
• =AVERAGE(10, 32, 53, 14, 66)

VLOOKUP function can be used to calculate median.

• True
• False

Count functions gives sum of values of the range.

• True

• False

‘$’ is used in ‘relative cell referencing’.

• True

• False