Analytics
What is the process of examining data to find patterns and insights?
What is data analytics?
What measure of central tendency is calculated by adding all values and dividing by the number of values?
What is the mean?
Which Excel function adds numbers together?
What is SUM?
Which chart is commonly used to compare sales across different product categories?
What is a bar chart?
What does KPI stand for?
What is Key Performance Indicator?
What type of analytics explains what happened in the past?
What is descriptive analytics?
What is the middle value in an ordered dataset called?
What is the median?
Which Excel function calculates the average of a group of numbers?
What is AVERAGE?
Which chart is best for showing revenue trends over time?
What is a line chart?
What does ROI stand for?
What is Return on Investment?
What type of analytics predicts future outcomes using historical data?
What is predictive analytics?
What statistical measure describes how strongly two variables move together?
What is correlation?
Which Excel feature summarizes and organizes large datasets by categories?
What is a PivotTable?
Which chart helps identify the relationship between two numerical variables?
What is a scatter plot?
What is the term for the total revenue a company earns minus its expenses?
What is profit?
What type of analytics recommends the best course of action?
What is prescriptive analytics?
f two variables have a correlation of −0.95, what does this indicate?
What is a strong negative relationship?
In Excel, what does the formula =COUNT(A1:A10) calculate?
What is the number of cells containing numeric values in that range?
Why can starting a bar chart's vertical axis above zero be misleading?
What is that it can exaggerate differences between values?
What is the process of comparing a company's performance against industry standards or competitors called?
What is benchmarking?
A company uses historical sales data, seasonal trends, and promotions to estimate next quarter's revenue. What analytical technique is it using?
What is forecasting?
Why does correlation between advertising spending and sales not necessarily prove that advertising causes sales to increase?
What is correlation does not imply causation?
What type of cell reference keeps both the row and column fixed when copying an Excel formula?
What is an absolute reference, such as $A$1?
What is the term for a visual representation of data designed to communicate insights clearly and efficiently?
What is data visualization?
What do you call data that has been collected but has not yet been organized or analyzed?
What is raw data?