A sales file contains both transaction-level rows and daily totals. Before calculating total sales, what should you establish to avoid counting some sales twice?
3 Descriptive Analytics and Exploratory Analysis Online Quiz Questions
Use this free practice quiz with 20 questions to review 3 Descriptive Analytics and Exploratory Analysis, test your knowledge, and prepare for your next test or exam.
A scatter plot shows that stores with more promotional activity also had higher sales. This pattern by itself proves that promotions caused the higher sales.
- A
True
- B
False
A missing value may mean the information was ; it should not automatically be treated as zero.
An analyst changes the interval widths used in a histogram of order values. Which interpretation is sound?
- A
Changing the bin widths cannot affect the histogram’s appearance.
- B
A histogram is designed to show category shares rather than numeric values.
- C
The selected bin widths can influence the pattern that appears.
- D
A histogram directly establishes whether one variable caused another.
Daily revenue, in thousands of dollars, was 8, 9, 10, 10, 11, 12, 13, and 37. What is the median daily revenue, expressed in thousands of dollars?
Select all valid matches between a business question and a useful display.
- A
Use a histogram to inspect the distribution of numeric order values.
- B
Use a scatter plot to explore the relationship between two numeric measures.
- C
Use a bar chart to show the sequence of values over time.
- D
Use a box plot to determine the exact shape of every individual value.
Most orders at a store have similar values, but a few orders are exceptionally large. Which outcome is most likely for the mean and median order values?
- A
The median must be larger because most orders are small.
- B
The mean may be higher because the few large orders pull it upward.
- C
The mean and median must be equal when all orders are recorded.
- D
The median is always pulled toward the largest value.
A value flagged as an outlier by a box-plot convention should be deleted from the dataset automatically.
- A
True
- B
False
In April, 240 of 600 orders came through a mobile app. What percentage of April orders came through the app? Enter the numeric percentage value in percentage points, without a percent sign.
An unusual observation flagged by a box plot should prompt , not automatic deletion.
Select all practices that help make a descriptive analysis reviewable and reproducible.
- A
Confirm how business measures, such as active customers, are defined.
- B
Avoid recording changes so the analysis can be summarized more quickly.
- C
Document filters, corrections, exclusions, and assumptions.
- D
Assume that every dataset uses the same definition of each measure.
A dataset includes one exceptionally large but valid order. Which spread measure is most focused on the middle half of the observations and is therefore less affected by that extreme value?
- A
The range
- B
The standard deviation
- C
The interquartile range
- D
The mean
A dataset contains every transaction recorded during a calendar month. That alone guarantees that it covers all relevant customer groups, channels, and locations.
- A
True
- B
False
Across 12 stores in May, median daily revenue was $10,500, and two stores had unusually high days. A manager wants to use the overall mean to make staffing plans. Write a concise interpretation that gives the scope, identifies a limitation, and recommends a reasonable next step without overstating what the data shows.
You need to examine how daily revenue changed over the last quarter, including recurring patterns and abrupt changes. Which display is most useful?
- A
A histogram
- B
A line chart
- C
A scatter plot
- D
A bar chart
A store's daily revenue is usually similar, but one day had an exceptionally high, valid sale. Which measure of center is generally less affected by that unusual day when describing typical daily revenue?
A required sales field is blank for some transactions. Before calculating a total, what is the most appropriate step?
- A
Replace every missing value with zero so totals can be calculated consistently.
- B
Exclude every row with any missing field without checking its relevance.
- C
Determine whether the value was not recorded or truly represents none, then document the handling decision.
- D
Copy the value from the nearest row to preserve the dataset's size.
A sales dataset contains both transaction-level records and daily totals. What should an analyst do before calculating total sales to avoid double-counting?
- A
Confirm what each row represents and which rows contain transaction-level values versus daily totals before summing.
- B
Sum every revenue value because all rows belong to the same sales file.
- C
Average the values first so that differences in row types cancel out.
- D
Remove all daily-total rows without checking whether they are needed for the business question.
Two analysts create histograms from the same numeric data but use different bin widths. Why might the histograms appear different?
- A
It changes the dataset's actual values.
- B
It determines whether the observations are independent.
- C
It guarantees that the histogram will have a symmetric shape.
- D
It can change the histogram's appearance and the patterns that are easy to notice.
For the revenue values 8, 9, 10, 10, 11, 12, 13, and 37, the median-of-halves convention gives a first quartile of 9.5 and a third quartile of 12.5. What is the interquartile range? Give your answer in thousand-dollar units.