BCOR 2020 Quiz Questions

Compute the mode for the following data. 12, 16, 19, 10, 12, 11, 21, 12, 21, 10 A. 12 B. 21 C. 11 D. 10

A. 12

Use the percentile function in Excel to find the 85th percentile of the following numbers: 2300 3500 4200 6700 7900 8600 8900 9400 A. 9225 B. 9000 C. 8900 D. 9220

A. 9225

When the distribution of data exhibits a symmetrical bell-shaped distribution, the __________ can be used to determine the percentage of values that are within a specified number of standard deviations of the mean. A. Empirical rule B. Interquartile rule C. Quartile rule D. Percentage rule

A. Empirical rule

Which of the following statements is true of a database? A. It helps companies analyze information to open new market opportunities. B. It is accessed primarily for use by an organization's database administrator and data administrator. C. It is a collection of unstructured data. D. It provides an essential foundation for an organization's knowledge management and artificial intelligence systems.

A. It helps companies analyze information to open new market opportunities.

In the spectrum of business analytics, which is the most complex? A. Prescriptive B. Operational C. Descriptive D. Predictive

A. Prescriptive

_____ encompasses all the activities required to get the right product into the right consumer's hands in the right quantity at the right time and at the right cost, from acquisition of raw materials through customer delivery. ​ A. Supply chain management B. Inventory management C. Value chain management D. Customer management

A. Supply chain management

A quantity of interest that can take on different values is known as a(n) ______________ A. Variable 2. Parameter 3. Sample 4. Observation

A. Variable

Which of the following is a set of interrelated components that collect, manipulate, store, and disseminate data and information and provide a feedback mechanism to meet an objective? A. information system B. big data C. software D. hardware

A. information system

Data-ink is the ink used in a table or chart that _________. A. is necessary to convey the meaning of the data to the audience B. helps in presenting data when the audience need not know exact values C. does not help in conveying the data to the audience D. increases the non-data-ink ratio

A. is necessary to convey the meaning of the data to the audience

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 ________ A. key performance indicators B. performance indicators C. company performance indicators D. business performance indicators

A. key performance indicators

The _______ provides a measure of central location for a dataset. A. mean B. range C. geometric mean D. mode

A. mean

The running coach wants to cut some people from the running team, and decides anyone slower than the 75th percentile of runners should be cut. Using the sample that stretched, how many people will be cut from the team if he enforces this rule? Mile time with stretching 7 8 11 9 9 5 6 12 13 A. 3 B. 2 C. 4 D. 1

B. 2

A running coach wants to see if stretching affects a runner's ability to complete the mile faster. He recorded runners' times on days they stretched and compared them to times they didn't stretch. The table below shows the results from his study. What is the interquartile range for the sample that stretched? Round to the nearest whole number. Mile time with stretching Mile time without stretching 7 9 8 11 11 14 9 8 9 6 5 12 6 9 12 5 13 8 A. 4 B. 5 C. 7 D. 6

B. 5

A manager of a fast food restaurant wants the drive-thru employee to ask every fifth customer if he or she is satisfied with the service. Who makes up the population? A. The proportion of customers who say they are satisfied with their service B. All customers who use the drive-thru window of this fast food restaurant C. All survey respondents D. All customers of this restaurant

B. All customers who use the drive-thru window of this fast food restaurant

What data values are considered outliers? A. Any data value that is less than -3 or greater than +3 B. Any data value with a z-score of less than -3 or greater than +3 C. Any data value with a z-score of -5 D> None of the answers is correct

B. Any data value with a z-score of less than -3 or greater than +3

Scores on Ms. Bond's test have a mean of 70 and a standard deviation of 11. David has a score of 52 on Ms. Bond's test. Scores on Ms. Nash's test have a mean of 64 and a standard deviation of 6. Steven has a score of 52 on Ms. Nash's test. Which student has the higher standardized score? z score = (xi - mean) / s A. David's standardized score is -1.64 and Steven's standardized score is -2.00. Therefore, Steven has the higher standardized score. B. David's standardized score is -1.64 and Steven's standardized score is -2.00. Therefore, David has the higher standardized score. C. David's standardized score is 1.64 and Steven's standardized score is 2.00. Therefore, Steven has the higher standardized score. D. Cannot be determined with the information provided.

B. David's standardized score is -1.64 and Steven's standardized score is -2.00. Therefore, David has the higher standardized score.

Which of the following is NOT an approach to making decisions? A. Intuition B. Guess and check C. Tradition D. Rules of thumb

B. Guess and check

In which form of missing data does missing data naturally occur? A. Missing not at random B. Legitimately missing data C. Missing completely at random D. Illegitimately missing data

B. Legitimately missing data

The idea of _____ is a form of innovation that constantly seeks ways to improve business processes and add value to products and services. A. process redesign B. continuous improvement C. disruptive change D. reengineering

B. continuous improvement

In some cases missing data naturally occur; these are called ... A. missing at random B. legitimately missing data C. illegitimately missing data D. missing not at random

B. legitimately missing data

A __________ determines how far a particular value is from the mean relative to the data set's standard deviation. A. percentile B. z-score C. variance D. coefficient of variation

B. z-score

Never use a ________ chart when a __________ chart will suffice. A. bar; pie B. 2-D; 3-D C. 3-D; 2-D D. color; black and white

C. 3-D; 2-D

You are to advise XYZ so that their BI efforts are fruitful. Which among the following is the most crucial advice of all? A. You need good data governance practices ​B. You need creative data scientists C. There must be strong commitment from the management ​D. You need good data management practices

C. There must be strong commitment from the management

Which of the following is NOT considered business intelligence practice?​ A. Visualization ​B. Data extraction C. Transaction processing ​D. Analysis

C. Transaction processing

The value of information is directly linked to how it helps decision makers achieve their organization's _____. A. cost/profit target B. customer satisfaction levels C. goals D. cost reduction initiatives

C. goals

A covariance __________________ indicates a positive relationship between the two variables in the analysis. A. zero B. less than zero C. more than zero D. between -1 and 1

C. more than zero

A ___________________ acts as a representative of the population. A. Variable B. Random Variable C. sample D. Variance

C. sample

Tables should be used instead of charts when A. the reader needs relative comparisons of data B. there are more than two columns of data C. the values being displayed have different units or very different magnitudes D. the reader need not differentiate the columns and rows

C. the values being displayed have different units or very different magnitudes

A quantity of interest that can take on different values is known as a(n) _____________. A. observation B. parameter C. variable D. sample

C. variable

A sample of 13 adult males' heights are listed below. ​ 70, 72, 71, 70, 69, 73, 69, 68, 70, 71, 67, 71, 74 ​ Find the range of the data. ​ A. 6.5 B. 5 C. 4 D. 7

D. 7

The letter grades (A,B,C,D,F) of business analysis students are recorded by a professor. This variable's classification ___________ A. Is quantitative data B. Is time series data C. Cannot be determined D. Is categorical data

D. Is categorical data

Which of the following statements is NOT true concerning PivotTables in Excel? A. PivotTables summarize data for two variables B. PivotTables are interactive C. PivotTables are also known as crosstabulation tables D. PivotTables can be built using data arrayed in rows

D. PivotTables can be built using data arrayed in rows

The decisions concerning an organization's goals and future plans are called A. Financial decisions B. Operational decisions C. Tactical decisions D. Strategic decisions

D. Strategic decisions

The difference in variable measured over observations (time, customers, items, etc.) is known as ______________ A. Variable change B. Observed differences C. Descriptive analytics D. Variation

D. Variation

A set of values corresponding to a set of variables is defined as a(n) A. event. B. quantity. C. factor. D. observation.

D. observation.

A __________ is a graphical presentation of the relationship between two quantitative variables. A. histogram B. pie chart C. bar chart D. scatter chart

D. scatter chart

One of the goals of business intelligence is to _________. A. use the most sophisticated techniques B. educate the users about business statistics C. ensure the transaction data is properly stored D. ​present the results in an easy to understand manner

D. ​present the results in an easy to understand manner

True or False: A population is a subset of a sample

False

True or False: A set of random or unrelated tasks performed to achieve a definite outcome is called a process.

False

True or False: A sustaining innovation is one that initially provides a lower level of performance than the marketplace has grown to accept.

False

True or False: Bar charts use horizontal bars to display the magnitude of the categorical variable

False

True or False: Business analytics can be used only for forecasting future business results.

False

True or False: Data collected form several entities over a period of time (minutes, hours, days, etc.) are called cross-sectional data

False

True or False: Data dashboards are a type of predictive analytics

False

True or False: In linear regression, you are to find a line that best fits the data. Sometimes the line may be curved.​

False

True or False: Information consists of raw facts, such as an employee number, number of hours worked in a week, inventory part numbers, or sales orders.

False

True or False: Online analytical processing is another name for enterprise application.

False

True or False: Two sets of fields can have a common primary key.

False

True or False: The concept of a value chain is not significant to organizations unless they manufacture products.

Fasle

True or False: A database must reflect the business processes of an organization.

True

True or False: A field is typically a name, number, or combination of characters that describes an aspect of a business object.

True

True or False: Data mining is used to explore large amounts of data, looking for hidden patterns that can be used to predict future trends and behaviors.

True

True or False: Making visual comparisons is much easier in the bar chart than in the pie chart. It is recommended against using pie charts in most situations and suggested using bar charts for comparing categorical data instead

True

True or False: The difference between the third and first quartiles is often referred to as the IQR.

True

True or False: The z-score is often called the standardized value.

True

True or False: Two of the major challenges business users face when using big data are finding the information they need to make decisions and knowing that the data they have is valid.

True

True or False: data-driven decision making tends to decrease a firm's risk.

True

The goal of business intelligence is to _____. ​ A. reduce the cost of data processing ​B. provide access to novel tools to the users ​C. improve employee morale ​D. support and improve decision making

​D. support and improve decision making