Deck 15: Business Statistics

Question 1

The mean is the number that is in the middle when numbers are arranged in ascending or descending order.

Answer 1

False

Question 2

The salary of five employees is listed below. $34,500; $45,000; $50,000; $40,000; $70,000
What is the mean salary?

A) $35,500
B) $47,900
C) $199,000
D) $239,500

Answer 2

B

Question 3

What is the mode of the prices below? $45, $52, $40, $50, $42, $52, $55, $58, $40, $50, $32, $52

A) $40
B) $45
C) $50
D) $52

Answer 3

D

Question 4

What is the median of the list below? 220, 310, 175, 222, 220, 264, 155, 289

A) 155
B) 220
C) 221
D) 231

Question 5

Cameron used the following numbers of minutes on his cell phone each month. 600, 552, 411, 325, 621, 401, 468, 324, 215, 367, 459, 367
What is the range number of minutes Cameron used each month?

A) 406
B) 401
C) 386
D) 367

Question 6

The =STDEV function in Excel can be used to calculate the standard deviation of a set of data values.

Question 7

Range is the measure of the spread of data around the mean in a data set.

Question 8

The mode of a data set can be more than one number.

Question 9

The vertical axis that measures magnitude is the x -axis.

Question 10

Tony checked the price of a computer at six different stores. The prices are listed below. $1,200; $1,900; $1,500; $2,100; $1,600; $1,500
What is the mean cost of a computer?

A) $900.67
B) $1,500
C) $1,650
D) $1,633.33

Question 11

The standard deviation of the data set below is 62.5.
10, 15, 20, 30, 25

Question 12

What is the mean of the prices below? $45, $52, $60, $47, $53, $23, $55, $57

A) $37
B) $49
C) $53
D) $57

Question 13

Dale's paycheck was $1,200. He spent $300 on his car payment. If Dale made a pie graph to show how his paycheck was spent, the central angle of the sector showing his car payment would measure 90°.

Question 14

What is the median of the prices below? $452, $560, $455, $560, $440

A) $120
B) $455
C) $490
D) $560

Question 15

The range of the following data set is 23.
15, 3, 25, 31, 2, 9, 15, 14, 5, 15

Question 16

The median of the list below is 25.
17, 13, 25, 26, 13, 9, 28, 33, 32

Question 17

The function in Excel used to calculate the middle value in a data set is =MIDDLE.

Question 18

What is the standard deviation of the following set of data? 18, 14, 12, 16, 22, 26

A) 4.8
B) 18
C) 22.7
D) 136

Question 19

What is the mode of the list below? 102, 105, 111, 104, 123, 132, 204, 201, 106, 116, 115, 142, 131

A) no mode
B) 105
C) 106
D) 132

Question 20

Coach Ralph recorded the number of free throws made by the players on a team. 12, 10, 9, 15, 18, 11, 13, 8, 14, 7, 19, 6
The number of free throws were grouped into four equal classes (0-4, 5-9, 10-14, 15-19). How many players made between 10 and 14 free throws?

A) 1
B) 2
C) 5
D) 6

Question 21

The _______________ function is used in Excel to calculate the mean of a data set.

Question 22

The range is the difference between the _________ and _________ values in a group of values or set of data.

Question 23

The mode of the numbers 15, 10, 12, 13, 16, 15, 14, 12, 10, 16, 13, 18, 14, 12, 13, 10, 12, 15 is _____.

Question 24

The list shows 8 salaries.
$42,000; $51,000; $45,000; $49,000; $48,000; $50,000; $43,000; $48,000
What is the range of salaries?

Question 25

What is the mode of the list below?
17, 25, 32, 16, 28, 18, 29, 12, 21, 35, 62, 74, 48, 25, 32, 25, 65

Question 26

What is the median of the list below?
801, 753, 811, 836, 821, 789, 741, 811, 812, 799

Question 27

What is the range of the data set below?
634, 642, 146, 479, 836, 235, 163, 163, 687, 124, 284

Question 28

A _________ compares two variables of data along a _________ showing how the data changes.

Question 29

What is the standard deviation of the test scores below?
98, 87, 70, 92, 88, 78, 89

Question 30

What is the median of the list below?
592, 576, 523, 594, 601, 532, 555, 566, 529, 578, 594, 582, 545

Question 31

The list shows the number of points a team scored in ten games.
35, 60, 45, 42, 51, 50, 63, 32, 34, 48
What is the average number of points scored each game?

Question 32

Which of the following steps should be done first when creating any type of chart in Excel?

A) Click Chart Titles on the Layout subtab to key a title for the graph.
B) Select the cells that contain the data needed for the chart by highlighting them.
C) Click Data Labels on the Layout subtab to key names for the data values.
D) Click the Insert tab and in the Charts group select the type of chart to create.

Question 33

What is the mean of the list below?
981, 842, 686, 199, 964, 958, 159, 413, 357, 159, 411, 159

Question 34

The list shows the amount Kyle earned each week.
$200, $180, $100, $150, $110, $130
What is the mean of Kyle's earnings each week?

Question 35

What is the mode of the list below?
540, 650, 870, 250, 630, 520, 940, 880, 870, 620, 740, 850, 710

Question 36

Linda spent $375 at the grocery store. She spent $75 on dairy products. Linda made a pie graph to show her grocery bill. How many degrees would be designated for dairy products?

Question 37

The purpose of a __________ __________ __________ is to help organize large amounts of data into a form that is more understandable.

Question 38

What is the mean of the prices below?
$135, $250, $130, $250, $175, $180, $240, $220

Question 39

What is the mode of the list below?
78, 77, 75, 79, 74, 70, 78, 72, 74, 75, 70, 73, 79, 76, 71, 79, 71

Question 40

A pie graph can also be called a _________ _________ or a _________ __________.

Question 41

Construct a bar graph showing John's monthly earnings.
Month Earnings ($)
March 2,500
April 4,000
May 3,500
June 3,000
July 5,000

Question 42

Construct a pie graph showing Dana's monthly expenditures.

Expenditure Amount ($)
Mortgage 500
Condo Fees 225
Credit Card 250
Car Payment 300
Groceries 300
Gasoline 225
Entertainment 100
Savings 100
Total $2,000

Question 43

This function can be used in Excel to find the value(s) in a set of data that occur most often.

Question 44

What is the mode of the scores below?
99, 100, 78, 79, 83, 85, 89, 68, 77, 82, 88, 81, 84, 86

Question 45

What is the median of the list below?
75, 45, 62, 35, 85, 96, 12, 47, 66, 80

Question 46

The list shows the number of cars in different lots.
410, 320, 250, 260, 190, 270, 320
What is the median?

Question 48

Describe the correct method for keying the mean, median, and mode functions in Excel.

Question 49

Describe how to use Excel and its functions to calculate the range of a set of values.

Question 50

What is the mode of the list below?
978, 984, 983, 971, 976, 928, 972, 964, 987, 916, 976, 986, 961

Question 51

What is the mode of the prices below?
$200, $150, $225, $250, $500, $300, $350, $175, $325, $450, $200, $400, $500, $425, $650

Question 52

Construct a line graph showing a company's yearly revenue.
Year Profit ($)
2007 100,000
2008 150,000
2009 250,000
2010 100,000
2011 50,000

Question 53

The list shows the number of employees in different departments.
11, 25, 16, 13, 24, 12, 15, 27, 25, 22
What is the average number of employees in each department?