Study/Practice for the final: Course 1-7 (all 96)

What is the purpose of A/B testing?

• To compare user permissions on a website

• To test two variations of a web page to see which one performs better in terms of user traffic and revenue

• To lock rows and columns in a spreadsheet

• To collect data from multiple sources into a single dataset

What does 'absolute reference' in a spreadsheet function ensure?

• The function will change when copied to another location

• The function will not change when copied to another location

• The function allows user permissions

• The function provides password protection

Which term describes the process of collecting many separate pieces into a whole?

• Algorithm

• Aesthetic

• Aggregation

• Annotation

What is described by the term 'Anscombe’s quartet'?

• A method for password protection

• A type of administrative metadata

• Four datasets with nearly identical summary statistics but different plotted values

• A visual property of an object in a plot

What is required by a function in R as indicated by 'Argument (R)'?

• A visual property

• A scheduled appointment

• Information needed to run the function

• A set of rules for data analysis

What is the purpose of an arithmetic operator in basic math operations?

• To perform operations like sorting and filtering

• To perform basic math operations such as addition, subtraction, multiplication, and division

• To create visual data representations

• To assign values to variables

What does the AVERAGE function in a spreadsheet return?

• The total sum of the values from a selected range

• The median value of the selected range

• The average of the values from a selected range

• The maximum value from a selected range

Which data type only has two possible values, usually true or false?

• Numeric data

• Boolean data

• String data

• Complex data

What is a bar graph used for in data visualization?

• To display data as bubbles

• To display the distribution of values along an x-axis

• To use size to contrast and compare two or more values

• To label data in a table

What is the purpose of a CASE statement in SQL?

• To create a new database

• To return records that meet conditions specified in an if/then statement

• To delete records from a table

• To update records in a database