WorksheetsBusiness Analytics chapter 2
Total questions: 67
Worksheet time: 36mins
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.
7
6.5
5
4
The _____ shows the number of data items with values less than or equal to the upper class limit of each class.
cumulative frequency distribution
frequency distribution
percent frequency distribution
relative frequency distribution
Compute the 50th percentile for the following data.
10, 15, 17, 21, 25, 12, 16, 11, 13, 22
18.6
13.3
15.5
17.7
Compute the relative frequencies for the data given in the table below:
0.31, 0.14, 0.37, 0.18
0.37, 0.14, 0.31, 0.18
0.16, 0.28, 0.33, 0.13
0.18, 0.31, 0.37, 0.14
Compute the mean of the following data:
56, 42, 37, 29, 45, 51, 30, 25, 34, 57
42.8
52.1
40.6
39.4
Below is a histogram for the number of days that it took Wyche Accounting to perform audits in the last quarter of last year. What is the frequency of the 25-28 bin?
0.05
1
0.5
4
Select the histogram that is moderately skewed right.
A
B
C
D
In a survey of patients in a local hospital, 62.42% of the respondents indicated that the health care providers needed to spend more time with each patient. Who makes up the sample?
All patients in a local hospital
All survey respondents
Hospital patients
Cannot be determined from the information given
_____ acts as a representative of the population.
The variable
The variance
A sample
A random variable
Compute the geometric mean for the following data on growth factors of an investment for 10 years.
1.10, 0.50, 0.70, 1.21, 1.25, 1.12, 1.16, 1.11, 1.13, 1.22
1.0148
1.0221
1.0363
1.1475
The act of collecting data that are representative of the population data is called _____.
random sampling
sample data
population sampling
sources of data
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 sample?
All customers who use the drive-thru window of this fast food restaurant
All survey respondents
All customers of this restaurant
The proportion of customers who say they are satisfied with their service
The variance is based on the
deviation about the median.
number of variables.
deviation about the mean.
correlation in the data.
The College Board originally scaled SAT scores so that the scores for each section were approximately normally distributed with a mean of 500 and a standard deviation of 100. Assuming scores follow a bell-shaped distribution, use the empirical rule to find the percentage of students who scored less than 400.
16%
68%
84%
32%
_____ are collected from several entities at the same point in time.
Time series data
Categorical and quantitative data
Cross-sectional data
Random data
Compute the interquartile range (IQR) for the following data.
10, 15, 17, 21, 25, 12, 16, 11, 13, 22
6.25
7.75
5.14
9.50
If the covariance between two variables is near 0, it implies that ______
a positive relationship exists between the variables
the variables are not linearly related
the variables are negatively related
the variables are strongly related
Which of the following graphs provides information on outliers and IQR of a data set?
Histogram
Line chart
Scatter chart
Box plot
The amount of time taken by each of 10 students in a class to complete an exam is an example of what type of data?
Cannot be determined
Categorical data
Time series data
Quantitative data
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?
All customers who use the drive-thru window of this fast food restaurant
All survey respondents
All customers of this restaurant
The proportion of customers who say they are satisfied with their service
Which of the following gives the proportion of items in each bin?
Frequency
Class size
Relative frequency
Bin proportion
Which of the following relationships would have a negative correlation coefficient?
Supply and demand
Amount of a bill at a restaurant and the amount of the tip
Cost of a car and the amount of tax to be paid
The square footage of a home and the price of the home
Which of the following are necessary to be determined to define the classes for a frequency distribution with quantitative data?
Number of nonoverlapping bins, width of each bin, and bin limits
Width of each bin and bin lower limits
Number of overlapping bins, width of each bin, and bin upper limits
Width of each bin and number of bins
Below is a histogram for the number of days that it took Wyche Accounting to perform audits in the last quarter of last year. What is the relative frequency of the 21-24 bin?
0.05
0.14
0.25
2.5
Scores on Ms. Nash's test have a mean of 64 and a standard deviation of 9. Steve has a score of 52. Convert Steve's score to a z-score. (Round to two decimal places if necessary.)
1.33
58.2
–2
–1.33
Any data value with a z-score less than –3 or greater than +3 is considered to be a(n) _____.
outlier
statistic
whisker
z-score value
Compute the mode for the following data.
12, 16, 19, 10, 12, 11, 21, 12, 21, 10
21
11
12
10
The simplest measure of variability is the _____.
variance
standard deviation
coefficient of variation
range
A summary of data that shows the number of observations in each of several nonoverlapping bins is called a(n) _____.
frequency distribution
sample summary
bin distribution
observed distribution
Compute the third quartile for the following data.
10, 15, 17, 21, 25, 12, 16, 11, 13, 22
21.25
15.5
21.5
11.75
The distribution of hourly sales for a local family owned store is normally distributed with a mean of $225 per hour and a standard deviation of $75 per hour. Which of the following intervals contains the middle 95% of hourly sales?
$75 to $375
$150 to $300
$175 to $275
$125 to $325
Data collected from several entities over a period of time (minutes, hours, days, etc.) are called _____.
categorical and quantitative data
time series data
source data
cross-sectional data
Compute the coefficient of variation for the following sample data.
32, 41, 36, 24, 29, 30, 40, 22, 25, 37
18.64%
21.36%
20.28%
21.67%
The _____ is a point estimate of the population mean for the variable of interest.
sample mean
median
sample
geometric mean
The College Board originally scaled SAT scores so that the scores for each section were approximately normally distributed with a mean of 500 and a standard deviation of 100. Assuming scores follow a bell-shaped distribution, use the empirical rule to find the percentage of students who scored greater than 700.
97.5%
95%
2.5%
5%
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?
David's standardized score is –1.64 and Steven's standardized score is –2.00. Therefore, David has the higher standardized score.
David's standardized score is –1.64 and Steven's standardized score is –2.00. Therefore, Steven has the higher standardized score.
David's standardized score is 1.64 and Steven's standardized score is 2.00. Therefore, Steven has the higher standardized score.
Cannot be determined with the information provided.
When working with large spreadsheets with many rows of data, it can be helpful to _____the data to better find, view, or manage subsets of data.
split
sort and filter
chart
manipulate
Use technology to compute the standard deviation for the following sample data.
32, 41, 36, 24, 29, 30, 40, 22, 25, 37
5.96
6.41
5.42
6.75
James’s manager asked him to sort the last names in the following list in descending order. What does this mean?
The last names must be sorted from A to Z.
The last names must be sorted from Z to A.
The last names must be sorted from the earliest to the latest that has been added to the list.
James should use the Sort function to organize the data into order of sales.
The difference in a variable measured over observations (time, customers, items, etc.) is known as _____.
observed differences
variation
variable change
descriptive analytics
What is the total relative frequency?
20XX Contest Sales
________________________________________________
Salesman Frequency Relative Frequency
________________________________________________
Frances Clonts 15 0.05
Sarah Leigh 184 0.62
Devon Pride 37
John Townes 62 0.21
________________________________________________
Total 298
1
99.12
0.88
Not enough information
Identify the shape of the distribution in the figure below.
Skewed left
Symmetric
Approximately bell shaped
Skewed right
Data sets commonly include observations with missing values for one or more variables. In some cases missing data naturally occur; these are called _____.
legitimately missing data
data cleansing
illegitimate missing data
missing random data
Below is a histogram for the number of days that it took Wyche Accounting to perform audits in the last quarter of last year. What is the bin size for the histogram?
3
4
16
5
In a survey of patients in a local hospital, 62.42% of the respondents indicated that the health care providers needed to spend more time with each patient. Who makes up the population?
All patients in a local hospital
All survey respondents
Hospital patients
Cannot be determined from the information given
A _____ is a graphical summary of data previously summarized in a frequency distribution.
box plot
histogram
line chart
scatter chart
Which Excel command will return all modes when more than one mode exists?
MODE.MULT
MODE.SNGL
MODE
MODES
Scores on Ms. Bond's test have a mean of 70 and a standard deviation of 11. Michelle has a score of 48. Convert Michelle's score to a z-score. (Round to two decimal places if necessary.)
2
41.64
–2
1.33
A quantity of interest that can take on different values is known as a(n) _____.
parameter
variable
sample
observation
In a(n) _____, one or more variables are identified and controlled or manipulated so that data can be obtained about how they influence the variable of interest identified first.
experimental study
observational study
categorical study
variable study
Compute the median of the following data.
32, 41, 36, 24, 29, 30, 40, 22, 25, 37
28
31
40
34
The correlation coefficient will always take values _____. *
greater than 0
between –1 and 0
between –1 and +1
less than –1
Consider the data below. What percentage of students scored grade C?
33%
31%
37%
28%
A set of values corresponding to a set of variables is defined as a(n) _____.
quantity
factor
event
observation
What is the mode of the data set given below?
35, 47, 65, 47, 22
47.5
47
65
22
The data collected from the customers in restaurants about the quality of food is an example of a(n) _____.
variable study
cross-sectional study
experimental study
observational study
_____ is the process of removing variables from the analysis without losing crucial information
Data Cleansing
Dimension reduction
Legitimate missing data
Missing random data
For data having a bell-shaped distribution, approximately _____ percent of the data values will be within one standard deviation of the mean.
95
66
68
97
The goal regarding using an appropriate number of bins is to show the _____.
number of observations
number of variables
variation in the data
correlation in the data
Compute the relative frequency for students who earned a C shown in the table of grades below.
0.43
0.53
0.83
Not enough information
The College Board reported that the mean Math Level 2 SAT subject test score was 686 with a standard deviation of 96. Assuming scores follow a bell-shaped distribution, use the empirical rule to find the percentage of students who scored less than 494.
97.5%
95%
2.5%
5%
Below is the data for the number of days that it took Wyche Accounting to perform audits in the last quarter of last year.
56, 42, 37, 29, 45, 51, 30, 25, 34, 57
What is the median number of days that it took Wyche Accounting to perform audits in the last quarter of last year?
41
40.6
39.5
42
The letter grades (A, B, C, D, F) of business analysis students are recorded by a professor. This variable’s classification _____.
is quantitative data
cannot be determined
is categorical data
is time series data
When working with data sets in Excel, _____ can be used to automatically highlight cells that meet specified requirements.
averaging
conditional formatting
summing
sorting
A _____ determines how far a particular value is from the mean relative to the data set’s standard deviation.
coefficient of variation
z-score
variance
percentile
Compute the relative frequency for students who earned an A shown in the table of grades below.
0.12
0.10
0.83
Not enough information
You have been asked to reorganize the Excel table below into order of sales using the Sales column. Which option will allow you to do this quickly?
Use the Cut and Paste function to reorganize the data into order of sales.
Use the Filter function to organize the data into order of sales.
Use the Order function to organize the data into order of sales.
Use the Sort function to organize the data into order of sales.
