Analytics Exam 2
What is the total area under the normal distribution curve?
1
A survey of 100 random high school students finds that 85 students watched the Super Bowl, 25 students watched the Stanley Cup Finals, and 20 students watched both games. How many students did not watch either game?
10
This Excel bar chart displays the demographics of a Business Analysis class. Approximately how many students are in the class?
130.
A health conscious student faithfully wears a device that tracks his steps. Suppose that the distribution of the number of steps he takes in a day is normally distributed with a mean of 10,000 and a standard deviation of 1,500 steps. What percent of the days does he exceed 13,000 steps?
2.28%
Never use a __________ chart when a __________ chart will suffice.
3-D; 2-D
The number of minutes that Samantha waits to catch the bus is uniformly distributed between 0 and 15 minutes. What is the probability that Samantha has to wait less than 4.5 minutes to catch the bus?
30%
The random variable X is known to be uniformly distributed between 2 and 12. Compute E(X), the expected value of the distribution.
7
DJ needs to display data over time. Which of the following charts should he use?
Line chart
A ___________ uses repeated random sampling to represent uncertainty in a model representing a real system and that computes the values of model outputs.
Monte Carlo simulation
In a normal distribution, which is greater, the mean or the median?
Neither the mean or the median (they are equal)
Two events are independent if
P(A | B) = P(A) or P(B | A) = P(B).
To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs
PivotCharts with PivotTables.
The __________ probability distribution can be used to estimate the number of vehicles that go through an intersection during the lunch hour.
Poisson
__________ merges maps and statistics to present data collected over different geographies.
The geographic information system
Which of the following is not a characteristic of the normal probability distribution?
The standard deviation must be 1.
__________ is the process of determining that a simulation model provides an accurate representation of a real system.
Validation
In order to visualize three variables in a two-dimensional graph, we use a
bubble chart.
An experiment consists of determining the speed of automobiles on a highway by the use of radar equipment. The random variable in this experiment is a
continuous random variable.
The data dashboard for a marketing manager may have KPIs related to
current sales measures and sales by region.
A __________ describes the range and relative likelihood of all possible values for a random variable.
probability distribution for a random variable
The outcome of a simulation experiment is a(n)
probability distribution for one or more output measures.
In many cases, white space in a chart can improve
readability.
A simulation model extends spreadsheet modeling by
replacing the use of single values for parameters with a range of possible values.
The process of evaluating a decision in the face of uncertainty by quantifying the likelihood and magnitude of an undesirable outcome is known as
risk analysis.
A _____________ is a graphical presentation of the relationship between two quantitative variables.
scatter chart
A line chart that has no axes but is used to provide information on overall trends for time series data is called a
sparkline.
To avoid problems in interpreting the differences in color in a heat map, ____________ can be added.
sparklines
Sample space is
the collection of all possible outcomes.
All the events in the sample space that are not part of the specified event are called
the complement of the event.
The center of a normal curve is
the mean of the distribution.
Tables should be used instead of charts when
the values being displayed have different units or very different magnitudes.
A _____________ is a line that provides an approximation of the relationship between the variables.
trendline
The event containing the outcomes belonging to A or B or both is the __________ of A and B.
union
The charts that are helpful in making comparisons between categorical variables are
bar charts and column charts.
__________ are visual methods of displaying data.
Charts
Which of the following is a disadvantage of using simulation?
Each simulation run provides only a sample of how the real system will operate.
Which statement is true about mutually exclusive events?
If events A and B cannot occur at the same time, they are called mutually exclusive.
A data visualization tool that updates in real time and gives multiple outputs is called
a data dashboard.
A variable that can only take on specific numeric values is called a
discrete random variable.
A two-dimensional graph representing the data using different shades of color to indicate magnitude is called a
heat map.
Consider the clustered bar chart of the dashboard developed to monitor the performance of a call center- This chart allows the IT manager to
identify the frequency of a particular type of problem by location.
Deleting the grid lines in a table and the horizontal lines in a chart
increases the data-ink ratio.
Data-ink is the ink used in a table or chart that
is necessary to convey the meaning of the data to the audience.
A disadvantage of stacked-column charts and stacked-bar charts is that
it can be difficult to perceive small differences in areas.
In a business, the values indicating the business's current operating characteristics, such as its financial position, the inventory on hand, and customer service metrics, are typically known as
key performance indicators.
The best way to differentiate chart elements is using
labels.
A time series plot is also known as a
line chart.
The following image is a:
line chart.
Probability is the
numerical measure of the likelihood that an event will occur.
Making visual comparisons between categorical variables may be difficult in a
pie chart.
