Data Analysis Quiz

Which function would you use in Google Sheets to add up a range of numbers?

• PRODUCT

• SUM

• AVERAGE

• MIN

In Google Sheets, which operator is used to divide two values?

• +

• *

• /

• %

What is the purpose of a pivot table in Google Sheets?

• To create charts automatically

• To perform complex calculations using formulas

• To summarize, analyze, and explore data interactively

• To adjust cell formatting automatically

Which of the following is NOT a measure of central tendency?

• Mean

• Median

• Range

• Mode

Which test would you use to compare the means of two independent groups?

• Paired sample t-test

• One sample t-test

• Independent sample t-test

• One-way ANOVA

Which measure of dispersion indicates the spread of values around the mean in a data set?

• Mean

• Median

• Standard Deviation

• Mode

What does ANOVA help to determine in statistical analysis?

• The relationship between two continuous variables

• The difference in means across multiple groups

• The average value of a dataset

• The central value in a dataset

If you want to test the mean of a single sample against a known value, which test should you use?

• Independent sample t-test

• One-way ANOVA

• One-sample t-test

• Two-way ANOVA

When using Google Sheets, which of the following functions would you use to find the smallest number in a range?

• MIN

• SUM

• MAX

• AVERAGE

In Google Sheets, which of the following symbols is used for multiplication?

• /

• *

• +

• ^