Use the spreadsheet below to answer the following question(s). Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period.The rate of shoes sold per day (X)and the price of the shoes (Y). \[\begin{array} { | l | l | } \hline \begin{array} { c } \text { Shoes sold } \\ \text { in \% } ( \mathbf { X } ) \end{array} & \text { Price (Y) } \\ \hline 15 & \$ 48 \\ \hline 27 & \$ 55 \\ \hline 10 & \$ 40 \\ \hline 13 & \$ 88 \\ \hline 25 & \$ 53 \\ \hline 9 & \$ 47 \\ \hline 18 & \$ 40 \\ \hline & \\ \hline \end{array}\] -Use Excel to calculate the z-score of X observation 27.

A) -0.24 B) 0 C) 0.18 D) 1.46 A) -0.24 B) 0 C) 0.18 D) 1.46

Use the spreadsheet below to answer the following question(s). Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period.The rate of shoes sold per day (X)and the price of the shoes (Y). \[\begin{array} { | l | l | } \hline \begin{array} { c } \text { Shoes sold } \\ \text { in \% } ( \mathbf { X } ) \end{array} & \text { Price (Y) } \\ \hline 15 & \$ 48 \\ \hline 27 & \$ 55 \\ \hline 10 & \$ 40 \\ \hline 13 & \$ 88 \\ \hline 25 & \$ 53 \\ \hline 9 & \$ 47 \\ \hline 18 & \$ 40 \\ \hline & \\ \hline \end{array}\] -Use Excel to calculate the correlation between variables X and Y.

A) 16.47 B) 0.02 C) 16.71 D) 7.04 A) 16.47 B) 0.02 C) 16.71 D) 7.04

Use the table below to answer the following question(s). Below is a table showing the costs per order of items bought by a computer hardware store. $\begin{array}{l|l|l} \hline \text { Supplier } & \text { Item Description } & \text { Cost per Order } \\ \hline \text { Aloham Technologies } & \text { Monitors } & \$ 250 \\ \hline \text { Aloham Technologies } & \text { Hard Disks } & \$ 220 \\ \hline \text { Aloham Technologies } & \text { Power Supply } & \$ 88 \\ \hline \text { Aloham Technologies } & \text { Graphics Card } & \$ 300 \\ \hline \text { Aloham Technologies } & \text { Processor } & \$ 325 \\ \hline \text { Aloham Technologies } & \text { Speakers } & \$ 88 \\ \hline \text { MindRoot Hardwares } & \text { Flashdrive } & \$ 9 \\ \hline \text { MindRoot Hardwares } & \text { Graphics Card } & \$ 299 \\ \hline \text { MindRoot Hardwares } & \text { CD-ROM } & \$ 88 \\ \hline \text { MindRoot Hardwares } & \text { Bluetooth Device } & \$ 80 \\ \hline \end{array}$ -Calculate the median for the cost per order data.

A) $325 B) $154 C) $174.17 D) $88 A) $325 B) $154 C) $174.17 D) $88

Use the spreadsheet below to answer the following question(s). Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period.The rate of shoes sold per day (X)and the price of the shoes (Y). \[\begin{array} { | l | l | } \hline \begin{array} { c } \text { Shoes sold } \\ \text { in \% } ( \mathbf { X } ) \end{array} & \text { Price (Y) } \\ \hline 15 & \$ 48 \\ \hline 27 & \$ 55 \\ \hline 10 & \$ 40 \\ \hline 13 & \$ 88 \\ \hline 25 & \$ 53 \\ \hline 9 & \$ 47 \\ \hline 18 & \$ 40 \\ \hline & \\ \hline \end{array}\] -Use Excel to calculate the variance of X.

A) 271.33 B) 16.47 C) 49.57 D) 7.04 A) 271.33 B) 16.47 C) 49.57 D) 7.04

The following table lists the amounts paid in mortgages as a percentage of the household income in the town Aponia.Calculate the variance and standard deviation of the data, if mean is given as 22.4%.The percentage (x)values are estimated as midpoints of each percentage range. $\begin{array}{l|l|l} \begin{array}{l} \text { Mortgage as a } \\ \text { percentage of } \\ \text { household income in } \\ \text { Aponia } \end{array} & & \\ \hline \text { Group in \% } & \begin{array}{l} \text { Percentag } \\ \text { e (x) } \end{array} & \begin{array}{l} \text { Number of households } \\ \text { (f) } \end{array} \\ \hline 0-10 & 5 & 4567 \\ \hline 10-20 & 15 & 6562 \\ \hline 20-30 & 25 & 3356 \\ \hline 30-40 & 35 & 2975 \\ \hline 40-50 & 45 & 1644 \\ \hline 50-60 & 55 & 1376 \\ \hline \end{array}$

For grouped data such as this, variance,

Exam 4: Descriptive Statistical Measures

Use the spreadsheet below to answer the following question(s). Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period.The rate of shoes sold per day (X)and the price of the shoes (Y). Shoes sold in \% () Price (Y) 15 \ 48 27 \ 55 10 \ 40 13 \ 88 25 \ 53 9 \ 47 18 \ 40 -Use Excel to calculate the z-score of X observation 27.

(Multiple Choice)

4.8/5

(39)

Question 61

Using Chebyshev's theorem for standard deviation, calculate the percentage of data that lie within five standard deviations of the mean.

(Multiple Choice)

4.8/5

(40)

Question 62

Calculate the coefficient of variation from the following data: Z-score = 1.32; standard deviation = 0.173; mean = 4.7; total variation = 0.6

(Multiple Choice)

5.0/5

(39)

Question 63

How is the return to risk described in financial statistics?

(Multiple Choice)

4.9/5

(31)

Question 64

If the distribution of observations are such that mode < median < mean, the histogram would be said to be negatively skewed.

(True/False)

4.9/5

(36)

Question 65

Use the spreadsheet below to answer the following question(s). Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period.The rate of shoes sold per day (X)and the price of the shoes (Y). Shoes sold in \% () Price (Y) 15 \ 48 27 \ 55 10 \ 40 13 \ 88 25 \ 53 9 \ 47 18 \ 40 -Use Excel to calculate the correlation between variables X and Y.

(Multiple Choice)

4.8/5

(32)

Question 66

A z-score of 1.0 means that ________.

(Multiple Choice)

4.9/5

(31)

Question 67

Which of the following is true of midspread?

(Multiple Choice)

4.7/5

(39)

Question 68

Use the table below to answer the following question(s). Below is a table showing the costs per order of items bought by a computer hardware store. Supplier Item Description Cost per Order Aloham Technologies Monitors \ 250 Aloham Technologies Hard Disks \ 220 Aloham Technologies Power Supply \ 88 Aloham Technologies Graphics Card \ 300 Aloham Technologies Processor \ 325 Aloham Technologies Speakers \ 88 MindRoot Hardwares Flashdrive \ 9 MindRoot Hardwares Graphics Card \ 299 MindRoot Hardwares CD-ROM \ 88 MindRoot Hardwares Bluetooth Device \ 80 -Calculate the median for the cost per order data.

(Multiple Choice)

4.7/5

(40)

Question 69

Which of the following describes standard deviation?

(Multiple Choice)

4.8/5

(36)

Question 70

Use the spreadsheet below to answer the following question(s). Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period.The rate of shoes sold per day (X)and the price of the shoes (Y). Shoes sold in \% () Price (Y) 15 \ 48 27 \ 55 10 \ 40 13 \ 88 25 \ 53 9 \ 47 18 \ 40 -Use Excel to calculate the variance of X.

(Multiple Choice)

4.9/5

(38)

Question 71

The measure of location that specifies the middle value when the data are arranged from least to greatest is the ________.

(Multiple Choice)

4.9/5

(38)

Question 72

Which of the following is a similarity between a midrange and a mean?

(Multiple Choice)

4.8/5

(35)

Question 73

The following table lists the amounts paid in mortgages as a percentage of the household income in the town Aponia.Calculate the variance and standard deviation of the data, if mean is given as 22.4%.The percentage (x)values are estimated as midpoints of each percentage range. Mortgage as a percentage of household income in Aponia Group in \% Percentag e (x) Number of households (f) 0-10 5 4567 10-20 15 6562 20-30 25 3356 30-40 35 2975 40-50 45 1644 50-60 55 1376

(Essay)

5.0/5

(32)

Question 74

Which of the following cases require the mean of a sample to be calculated using the formula = $\bar{x}=\frac{\sum_{i=1}^{N} f_{i} x_{i}}{N}$ ?

(Multiple Choice)

4.8/5

(37)

Question 75

The ________ is the average of the greatest and least values in the data set.

(Multiple Choice)

4.9/5

(33)

Question 76

The value of a coefficient of skewness falling between 0.5 and -0.5 indicates relative symmetry.

(True/False)

4.9/5

(36)

Question 77

Which of the following describes dispersion in statistics?

(Multiple Choice)

4.9/5

(36)

Question 78

Which of the following is an example of a subset?

(Multiple Choice)

4.9/5

(33)

Question 79

Using Chebyshev's theorem for standard deviation, calculate the percentage of data that lie within five standard deviations of the mean.

Calculate the coefficient of variation from the following data: Z-score = 1.32; standard deviation = 0.173; mean = 4.7; total variation = 0.6

How is the return to risk described in financial statistics?

If the distribution of observations are such that mode < median < mean, the histogram would be said to be negatively skewed.

A z-score of 1.0 means that ________.

Which of the following is true of midspread?

Which of the following describes standard deviation?

The measure of location that specifies the middle value when the data are arranged from least to greatest is the ________.

Which of the following is a similarity between a midrange and a mean?

Which of the following cases require the mean of a sample to be calculated using the formula = $\bar{x}=\frac{\sum_{i=1}^{N} f_{i} x_{i}}{N}$ ?

The ________ is the average of the greatest and least values in the data set.

The value of a coefficient of skewness falling between 0.5 and -0.5 indicates relative symmetry.

Which of the following describes dispersion in statistics?

Which of the following is an example of a subset?

Introduction to Business Analytics

Analytics on Spreadsheets

Visualizing and Exploring Data

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Predictive Modeling and Analysis

Regression Analysis

Forecasting Techniques

Simulation and Risk Analysis

Introduction to Data Mining

Linear Optimization

Applications of Linear Optimization

Integer Optimization

Nonlinear and Non-Smooth Optimization

Optimization Models with Uncertainty

Decision Analysis

Filters

Exam 4: Descriptive Statistical Measures

Using Chebyshev's theorem for standard deviation, calculate the percentage of data that lie within five standard deviations of the mean.

Calculate the coefficient of variation from the following data: Z-score = 1.32; standard deviation = 0.173; mean = 4.7; total variation = 0.6

How is the return to risk described in financial statistics?

If the distribution of observations are such that mode < median < mean, the histogram would be said to be negatively skewed.

A z-score of 1.0 means that ________.

Which of the following is true of midspread?

Which of the following describes standard deviation?

The measure of location that specifies the middle value when the data are arranged from least to greatest is the ________.

Which of the following is a similarity between a midrange and a mean?

Which of the following cases require the mean of a sample to be calculated using the formula = xˉ=∑i=1NfixiN\bar{x}=\frac{\sum_{i=1}^{N} f_{i} x_{i}}{N}xˉ=N∑i=1N​fi​xi​​ ?

The ________ is the average of the greatest and least values in the data set.

The value of a coefficient of skewness falling between 0.5 and -0.5 indicates relative symmetry.

Which of the following describes dispersion in statistics?

Which of the following is an example of a subset?

Introduction to Business Analytics

Analytics on Spreadsheets

Visualizing and Exploring Data

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Predictive Modeling and Analysis

Regression Analysis

Forecasting Techniques

Simulation and Risk Analysis

Introduction to Data Mining

Linear Optimization

Applications of Linear Optimization

Integer Optimization

Nonlinear and Non-Smooth Optimization

Optimization Models with Uncertainty

Decision Analysis

Filters

Which of the following cases require the mean of a sample to be calculated using the formula = $\bar{x}=\frac{\sum_{i=1}^{N} f_{i} x_{i}}{N}$ ?