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? ? \(\begin{array}{llllcccc} \text { Customer ID } & \text { First } & \text { Last } & \text { Sales } & \text { Quantity } & \text { Discount } &{\text { Profit }} \\ \text { CG-12520 } & \text { Claire } & \text { Gute } & \$ 261.96 & 2 & 0 & \$ 41.91 \\ \text { DV-13045 } & \text { Darrin } & \text { VanHuff } & \$ 14.62 & 2 & 0 & \$ 16.87 \\ \text { SO-20335 } & \text { Sean } & \text { ODonnell } & \$ 957.58 & 5 & 0.45 & \$ (383.03)\\ \text { BH-11710 } & \text { Brosina } & \text { Hoffman } & \$ 48.86 & 7 & 0 & \$ 14.17 \\ \text { AA-10480 } & \text { Andrew } & \text { Allen } & \$ 25.55 & 3 & 0.2 & \$ 5.44 \\ \text { IM-15070 } & \text { Irene } & \text { Maddox } & \$ 407.98 & 3 & 0.2 & \$ 132.59\\ \text { HP-14815 } & \text { Harold } & \text { Pawlan } & \$ 68.81 & 5 & 0.8 & {(123.86)} \\ \text { PK-19075 } & \text { Pete } & \text { Kriz } & \$ 665.88 & 6 & 0 & \$ 13.32 \\ \text { AG-10270 } & \text { Alejandro } & \text { Grove } & \$ 55.50 & 2 & 0 & \$ 9.99 \\ \text { ZD-21925 } & \text { Zuschuss } & \text { Donatelli } & \$ 8.56 & 2 & 0 & \$ 2.48 \end{array}\) ? ?

A) Use the Cut and Paste function to reorganize the data into order of sales. B) Use the Filter function to organize the data into order of sales. C) Use the Order function to organize the data into order of sales. D) Use the Sort function to organize the data into order of sales. A) Use the Cut and Paste function to reorganize the data into order of sales. B) Use the Filter function to organize the data into order of sales. C) Use the Order function to organize the data into order of sales. D) Use the Sort function to organize the data into order of sales.

Consider the data below. What percentage of students scored grade C? $\begin{array} { c | c } \text { Grades } & \begin{array} { c } \text { Number of } \\ \text { students } \end{array} \\ \hline \text { A } & 16 \\ \text { B } & 28 \\ \text { C } & 33 \\ \text { D } & 13 \\ \hline \text { Total } & 90 \end{array}$

A) $33 \%$ B) $31 \%$ C) $37 \%$ D) $28 \%$ A) $33 \%$ B) $31 \%$ C) $37 \%$ D) $28 \%$

Compute the relative frequency for students who earned a C shown in the table of grades below. ? \[\begin{array} { l | c } \text { Grades } & \text { Number of Students } \\ \hline \mathrm { A } & 10 \\ \mathrm {~B} & 31 \\ \mathrm { C } & 36 \\ \mathrm { D } & 6 \\ \hline & \mathbf { 8 3 } \end{array}\] ?

A) 0.43 B) 0.53 C) 0.83 D) Not enough information A) 0.43 B) 0.53 C) 0.83 D) Not enough information

James's manager asked him to sort the last names in the following list in descending order. What does this mean? ? \(\begin{array}{llllcccc} \text { Customer ID } & \text { First } & \text { Last } & \text { Sales } & \text { Quantity } & \text { Discount } &{\text { Profit }} \\ \text { CG-12520 } & \text { Claire } & \text { Gute } & \$ 261.96 & 2 & 0 & \$ 41.91 \\ \text { DV-13045 } & \text { Darrin } & \text { VanHuff } & \$ 14.62 & 2 & 0 & \$ 16.87 \\ \text { SO-20335 } & \text { Sean } & \text { ODonnell } & \$ 957.58 & 5 & 0.45 & \$ (383.03)\\ \text { BH-11710 } & \text { Brosina } & \text { Hoffman } & \$ 48.86 & 7 & 0 & \$ 14.17 \\ \text { AA-10480 } & \text { Andrew } & \text { Allen } & \$ 25.55 & 3 & 0.2 & \$ 5.44 \\ \text { IM-15070 } & \text { Irene } & \text { Maddox } & \$ 407.98 & 3 & 0.2 & \$ 132.59\\ \text { HP-14815 } & \text { Harold } & \text { Pawlan } & \$ 68.81 & 5 & 0.8 & {(123.86)} \\ \text { PK-19075 } & \text { Pete } & \text { Kriz } & \$ 665.88 & 6 & 0 & \$ 13.32 \\ \text { AG-10270 } & \text { Alejandro } & \text { Grove } & \$ 55.50 & 2 & 0 & \$ 9.99 \\ \text { ZD-21925 } & \text { Zuschuss } & \text { Donatelli } & \$ 8.56 & 2 & 0 & \$ 2.48 \end{array}\) ? ?

A) The last names must be sorted from A to Z. B) The last names must be sorted from Z to A. C) The last names must be sorted from the earliest to the latest that has been added to the list. D) James should use the Sort function to organize the data into order of sales. A) The last names must be sorted from A to Z. B) The last names must be sorted from Z to A. C) The last names must be sorted from the earliest to the latest that has been added to the list. D) James should use the Sort function to organize the data into order of sales.

Exam 2: Descriptive Statistics

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.)

(Multiple Choice)

4.9/5

(37)

Question 41

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? ? Customer ID First Last Sales Quantity Discount Profit CG-12520 Claire Gute \ 261.96 2 0 \ 41.91 DV-13045 Darrin VanHuff \ 14.62 2 0 \ 16.87 SO-20335 Sean ODonnell \ 957.58 5 0.45 \ (383.03) BH-11710 Brosina Hoffman \ 48.86 7 0 \ 14.17 AA-10480 Andrew Allen \ 25.55 3 0.2 \ 5.44 IM-15070 Irene Maddox \ 407.98 3 0.2 \ 132.59 HP-14815 Harold Pawlan \ 68.81 5 0.8 (123.86) PK-19075 Pete Kriz \ 665.88 6 0 \ 13.32 AG-10270 Alejandro Grove \ 55.50 2 0 \ 9.99 ZD-21925 Zuschuss Donatelli \ 8.56 2 0 \ 2.48 ? ?

(Multiple Choice)

4.8/5

(31)

Question 42

Compute the IQR for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

(Multiple Choice)

4.9/5

(37)

Question 43

The simplest measure of variability is the

(Multiple Choice)

5.0/5

(36)

Question 44

__________ are collected from several entities at the same point in time.

(Multiple Choice)

4.7/5

(44)

Question 45

Consider the data below. What percentage of students scored grade C? Grades Number of students A 16 B 28 C 33 D 13 Total 90

(Multiple Choice)

4.7/5

(35)

Question 46

Identify the shape of the distribution in the figure below.

(Multiple Choice)

4.8/5

(51)

Question 47

Select the histogram that is moderately skewed right.

(Multiple Choice)

4.9/5

(29)

Question 48

Compute the coefficient of variation for the following sample data. 32, 41, 36, 24, 29, 30, 40, 22, 25, 37

(Multiple Choice)

4.7/5

(37)

Question 49

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.

(Multiple Choice)

4.9/5

(38)

Question 50

Compute the 50^th percentile for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

(Multiple Choice)

4.9/5

(41)

Question 51

The variance is based on the

(Multiple Choice)

4.9/5

(30)

Question 52

Compute the relative frequency for students who earned a C shown in the table of grades below. ? Grades Number of Students 10 31 36 6 ?

(Multiple Choice)

4.9/5

(32)

Question 53

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?

(Multiple Choice)

4.9/5

(33)

Question 54

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.

(Multiple Choice)

4.7/5

(34)

Question 55

Compute the mode for the following data. 12, 16, 19, 10, 12, 11, 21, 12, 21, 10

(Multiple Choice)

4.9/5

(43)

Question 56

The __________ is a point estimate of the population mean for the variable of interest.

(Multiple Choice)

4.8/5

(45)

Question 57

The act of collecting data that are representative of the population data is called

(Multiple Choice)

4.9/5

(41)

Question 58

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?

(Multiple Choice)

4.9/5

(30)

Question 59

James's manager asked him to sort the last names in the following list in descending order. What does this mean? ? Customer ID First Last Sales Quantity Discount Profit CG-12520 Claire Gute \ 261.96 2 0 \ 41.91 DV-13045 Darrin VanHuff \ 14.62 2 0 \ 16.87 SO-20335 Sean ODonnell \ 957.58 5 0.45 \ (383.03) BH-11710 Brosina Hoffman \ 48.86 7 0 \ 14.17 AA-10480 Andrew Allen \ 25.55 3 0.2 \ 5.44 IM-15070 Irene Maddox \ 407.98 3 0.2 \ 132.59 HP-14815 Harold Pawlan \ 68.81 5 0.8 (123.86) PK-19075 Pete Kriz \ 665.88 6 0 \ 13.32 AG-10270 Alejandro Grove \ 55.50 2 0 \ 9.99 ZD-21925 Zuschuss Donatelli \ 8.56 2 0 \ 2.48 ? ?

(Multiple Choice)

4.9/5

(40)

Question 60

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.)

Compute the IQR for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

The simplest measure of variability is the

__________ are collected from several entities at the same point in time.

Consider the data below. What percentage of students scored grade C? Grades Number of students A 16 B 28 C 33 D 13 Total 90

Identify the shape of the distribution in the figure below.

Select the histogram that is moderately skewed right.

Compute the coefficient of variation for the following sample data. 32, 41, 36, 24, 29, 30, 40, 22, 25, 37

Compute the 50^th percentile for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

The variance is based on the

Compute the relative frequency for students who earned a C shown in the table of grades below. ? Grades Number of Students 10 31 36 6 ?

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?

Compute the mode for the following data. 12, 16, 19, 10, 12, 11, 21, 12, 21, 10

The __________ is a point estimate of the population mean for the variable of interest.

The act of collecting data that are representative of the population data is called

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?

Introduction

Data Visualization

Descriptive Data Mining

Probability: an Introduction to Modeling Uncertainty

Statistical Inference

Linear Regression

Time Series Analysis and Forecasting

Predictive Data Mining

Spreadsheet Models

Monte Carlo Simulation

Linear Optimization Models

Integer Linear Optimization Models

Nonlinear Optimization Models

Decision Analysis

Filters

Exam 2: Descriptive Statistics

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.)

Compute the IQR for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

The simplest measure of variability is the

__________ are collected from several entities at the same point in time.

Consider the data below. What percentage of students scored grade C? Grades Number of students A 16 B 28 C 33 D 13 Total 90

Identify the shape of the distribution in the figure below.

Select the histogram that is moderately skewed right. ​ ​

Compute the coefficient of variation for the following sample data. 32, 41, 36, 24, 29, 30, 40, 22, 25, 37

Compute the 50th percentile for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

The variance is based on the

Compute the relative frequency for students who earned a C shown in the table of grades below. ? Grades Number of Students 10 31 36 6 ?

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? ​

Compute the mode for the following data. 12, 16, 19, 10, 12, 11, 21, 12, 21, 10

The __________ is a point estimate of the population mean for the variable of interest.

The act of collecting data that are representative of the population data is called

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?

Introduction

Data Visualization

Descriptive Data Mining

Probability: an Introduction to Modeling Uncertainty

Statistical Inference

Linear Regression

Time Series Analysis and Forecasting

Predictive Data Mining

Spreadsheet Models

Monte Carlo Simulation

Linear Optimization Models

Integer Linear Optimization Models

Nonlinear Optimization Models

Decision Analysis

Filters

Select the histogram that is moderately skewed right.

Compute the 50^th percentile for the following data. 10, 15, 17, 21, 25, 12, 16, 11, 13, 22

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?