Arrange the data and obtain X min and X max .

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

b.

To determine

Construct a histogram.

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

c.

To determine

Find the mean and median.

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

d.

To determine

Find the standard deviation for data set A.

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

f.

To determine

Find the quartiles and a box plot for data set A.

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Using the accompanying Home Market Value data and associated regression line, Market ValueMarket Valueequals=$28,416+$37.066×Square Feet, compute the errors associated with each observation using the formula e Subscript ieiequals=Upper Y Subscript iYiminus−ModifyingAbove Upper Y with caret Subscript iYi and construct a frequency distribution and histogram. LOADING... Click the icon to view the Home Market Value data. Question content area bottom Part 1 Construct a frequency distribution of the errors, e Subscript iei. (Type whole numbers.) Error Frequency minus−15 comma 00015,000less than< e Subscript iei less than or equals≤minus−10 comma 00010,000 0 minus−10 comma 00010,000less than< e Subscript iei less than or equals≤minus−50005000 5 minus−50005000less than< e Subscript iei less than or equals≤0 21 0less than< e Subscript iei less than or equals≤50005000 9…

The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c Overhead Costs Billable Hours345000 3000385000 4000410000 5000462000 6000530000 7000545000 8000

Using the accompanying Home Market Value data and associated regression line, Market ValueMarket Valueequals=$28,416plus+$37.066×Square Feet, compute the errors associated with each observation using the formula e Subscript ieiequals=Upper Y Subscript iYiminus−ModifyingAbove Upper Y with caret Subscript iYi and construct a frequency distribution and histogram. Square Feet Market Value1813 911001916 1043001842 934001814 909001836 1020002030 1085001731 877001852 960001793 893001665 884001852 1009001619 967001690 876002370 1139002373 1131001666 875002122 1161001619 946001729 863001667 871001522 833001484 798001589 814001600 871001484 825001483 787001522 877001703 942001485 820001468 881001519 882001518 885001483 765001522 844001668 909001587 810001782 912001483 812001519 1007001522 872001684 966001581 86200

Answer 2

Question

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

b.

To determine

Construct a histogram.

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

c.

To determine

Find the mean and median.

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

d.

To determine

Find the standard deviation for data set A.

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

f.

To determine

Find the quartiles and a box plot for data set A.

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

b.

To determine

Construct a histogram.

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

c.

To determine

Find the mean and median.

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

d.

To determine

Find the standard deviation for data set A.

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

f.

To determine

Find the quartiles and a box plot for data set A.

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

b.

To determine

Construct a histogram.

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

c.

To determine

Find the mean and median.

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

d.

To determine

Find the standard deviation for data set A.

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

f.

To determine

Find the quartiles and a box plot for data set A.

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

b.

To determine

Construct a histogram.

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

c.

To determine

Find the mean and median.

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

d.

To determine

Find the standard deviation for data set A.

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

f.

To determine

Find the quartiles and a box plot for data set A.

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.

Answer 6

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

Answer 7

Chapter 4, Problem 95CE

a.

To determine

Arrange the data and obtain X_min and X_max.

Answer 8

a.

Expert Solution

Answer to Problem 95CE

The value of X_min is 0.9.

The value of X_max is 11.9.

Answer 9

a.

Expert Solution

Answer 10

a.

Expert Solution

Answer 11

Expert Solution

Answer 12

Explanation of Solution

Calculation:

The data state to choose a dataset to prepare a brief descriptive report.

Here, the data chosen is Data set A.

The Data set A represents the percentage of sales in selected industries.

The data set A of sales percent can be sorted either ascending or descending.

Here, the data is sorted in the ascending order.

Sorting:

Software procedure:

Step-by-step procedure to sort the data using the MINITAB software:

• Choose Data > Sort.
• In columns to sort by, enter Percent.
• Under Columns to sort, Choose specified columns.
• In columns, enter the percent and choose increasing option.
• In storage location for current columns, choose “specified columns of the current worksheet”.
• In columns, enter “sorted percent”.
• Click ok.

Thus, the sorted data has been stored in the column of sorted percent.

Minimum and Maximum:

Step-by-step procedure to find the minimum and maximum using the MINITAB software:

• Choose Calc>calculator.
• In store result in variable box, enter Minimum.
• Under Expression, enter “MIN(Percent)”.
• Click ok.
• Choose Calc>calculator.
• In store result in variable box, enter Maximum.
• Under Expression, enter “MAX(Percent)”.
• Click ok.

Data display:

• Choose data> display data.
• Select the columns to display as Minimum, Maximum.
• Click ok.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 1

Thus, the value of X_min is 0.9 and the value of X_max is 11.9 respectively.

Answer 13

b.

To determine

Construct a histogram.

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

Answer 14

b.

To determine

Construct a histogram.

Answer 15

b.

Expert Solution

Answer to Problem 95CE

Histogram:

Output obtained from MINITAB software is:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 2

Answer 16

b.

Expert Solution

Answer 17

b.

Expert Solution

Answer 18

Expert Solution

Answer 19

Explanation of Solution

Calculation:

Software procedure:

Step by step procedure to draw the Histogram using MINITAB software.
• Choose Graph > Histogram.
• Choose Simple, and then click OK.
• In Graph variables, enter the Percent.
• Click OK.

Thus, the histogram has been obtained.

By observing the graph, it is clear that the curve is right skewed. Hence, it is appropriate to conclude that the data is approximately right skewed. Thus, the data set A for percent of sales is approximately right skewed.

Answer 20

c.

To determine

Find the mean and median.

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

Answer 21

c.

To determine

Find the mean and median.

Answer 22

c.

Expert Solution

Answer to Problem 95CE

The mean score is 3.55.

The median score is 3.

Answer 23

c.

Expert Solution

Answer 24

c.

Expert Solution

Answer 25

Expert Solution

Answer 26

Explanation of Solution

Calculation:

Mean and median:

Software procedure:

Step-by-step procedure to find the mean, the median using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Mean, Median.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 3

Thus, the mean and the median for the data set A are 3.55 and 3 respectively.

Shape of the distribution:

• For symmetric data, the mean, the median and the mode are equal.
• For positively skewed data, the mean exceeds the median.
• For negatively skewed data, the mean is lower than the median.

From the value of mean, median, it is observed that the value of mean is greater than that of the median.

Thus, the data is said to be right skewed or positively skewed.

Answer 27

d.

To determine

Find the standard deviation for data set A.

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

Answer 28

d.

To determine

Find the standard deviation for data set A.

Answer 29

d.

Expert Solution

Answer to Problem 95CE

The standard deviation for data set A is 2.749.

Answer 30

d.

Expert Solution

Answer 31

d.

Expert Solution

Answer 32

Expert Solution

Answer 33

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the mean and standard deviation using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select Standard deviation.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 4

Thus, the standard deviation has been obtained.

Answer 34

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

Answer 35

f.

To determine

Standardize the data and identify the outliers and an unusual observations.

Answer 36

f.

Expert Solution

Answer to Problem 95CE

The standardized values of dataset A are given below:

-0.9640	-0.6366	0.3456	0.3820	-0.6730	0.0909
0.7093	-0.0182	-0.0182	-0.9276	-0.1637	-0.2001
1.4005	-0.9640	-0.8912	-0.0182	3.0375	-0.6002
-0.8185	1.0367	-0.2001	-0.4547	0.2728	-0.6366
-0.8912	-0.5638	-0.5638	0.4911	-0.3820	2.8192

There are two outliers and two unusual values in the dataset.

Answer 37

f.

Expert Solution

Answer 38

f.

Expert Solution

Answer 39

Expert Solution

Answer 40

Explanation of Solution

Calculation:

Standardized values:

Software procedure:

Step-by-step software procedure to obtain standardized values using EXCEL software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A32.
• In cell B1, enter the formula “=STANDARDIZE(A1, 3.55, 2.749)”.
• Select “ENTER” option.
• Select and copy the cell B1 and drag till the 30^nd cell.
Output using EXCEL software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 5

Thus, the standardized values have been obtained using EXCEL.

The outliers in the data set A can be identified using Empirical rule.

Empirical Rule:

The Empirical Rule for a Normal model states that:

• Within 1 standard deviation of mean, 68.26% of all observations will lie.
• Within 2 standard deviations of mean, 95.44% of all observations will lie.
• Within 3 standard deviations of mean, 99.73% of all observations will lie.

Empirical rule using MEGASTAT:

Software procedure:

Step-by-step software procedure to obtain Empirical rule using Mega Stat software is as follows:

• Open an EXCEL file.
• Enter the data in the column A in cells A1 to A30.
• From the Add-Ins, Select Mega Stat >Descriptive statistics.
• A dialogue box appears.
• In Input range box, select the input range from Sheet1!$A$1:$A$30.
• From the list box, select Empirical rule.
• Click “OK”.

Output obtained using MEGA STAT is as follows:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 6

The upper and lower bounds for the intervals indicated by the Empirical rule have been obtained.

Based on the z-scores, the observation has one outlier, that is, the observations with values 11.9 do not lie within the 3-standard deviations limits (–4.697 to 11.797). there is no unusual observation in the data set A.

Answer 41

f.

To determine

Find the quartiles and a box plot for data set A.

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.

Answer 42

f.

To determine

Find the quartiles and a box plot for data set A.

Answer 43

f.

Expert Solution

Answer to Problem 95CE

The Q₁ (25^th percentile) is 1.775, Q₂ (50^th percentile) is 3 and Q₃ (75^th percentile) is 4.525.

Answer 44

f.

Expert Solution

Answer 45

f.

Expert Solution

Answer 46

Expert Solution

Answer 47

Explanation of Solution

Calculation:

Standard deviation:

Software procedure:

Step-by-step procedure to find the Quartiles using the MINITAB software:

• Choose Stat > Basic Statistics > Display Descriptive Statistics.
• In Variables enter the columns Percent.
• Choose option statistics, and select First Quartile, Median and Third Quartile.
• Choose option Graphs, and select boxplot of data.
• Click OK.

Output using the MINITAB software is given below:

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 7

Loose-leaf For Applied Statistics In Business And Economics, Chapter 4, Problem 95CE , additional homework tip 8

Thus, the Quartiles and boxplot have been obtained.

Observation:

From the boxplot, it is observed that the data set has two outliers within it. The boxplot disclosed that the median is closer to the first quartile, Q₁ than it is to the third quartile, Q₃, suggesting that the data is right skewed. The whiskers on the two sides are close in length, although it appears that the left whisker is slightly longer.