Formula One Kelenge?

What does N means in the data analysis

• Sample size or number of observations
• Number of variables
• Mean value
• Standard deviation

What is the formula for Average in excel?

• =AVERAGE(range)
• =SUM(range)/COUNT(range)
• =AVERAGEIF(range, criteria)
• =AVERAGE(column)

How we can write formula for calculating sum in Excel?

• =SUM(range)
• =SUM(A1;A10)
• =SUM(A1, A2, A3)
• =SUM(A1:A10)

What is the usage of VLOOKUP in Excel?

• VLOOKUP is used to search for a value in the first column of a range and return a value in the same row from another column.
• VLOOKUP is used to create pivot tables in Excel.
• VLOOKUP is used to change cell formatting in Excel.
• VLOOKUP is used to calculate formulas in Excel.

How PIVOT will be helpful for data analysis?

• PIVOT helps in restructuring data for better analysis and visualization.
• PIVOT can only be used for numerical data, not categorical data.
• PIVOT does not impact data analysis in any way.
• PIVOT is only useful for basic data manipulation tasks.

What is outlier in data analysis?

• A data point that is always accurate
• A data point that is average in value
• A data point that is missing from the dataset
• A data point that differs significantly from other observations in a dataset.

What is the result of the formula =A1 + B1 if A1 = 10 and B1 = 5?

• 20
• 11
• 14
• 15

What type of chart represents the to see the outlier visually?

• Line graph
• Pie chart
• Bar chart

• Scatter plot

What function calculates the total number of students in the provided dataset?

• SUM(D:D)

• MAX(D:D)

• AVERAGE(D:D)

• COUNT(D:D)

What function calculates the average of a range of cells?

• AVERAGE
• MAX
• SUM
• MEDIAN