Concept explainers
a.
Arrange the data and obtain Xmin and Xmax.
a.
Answer to Problem 99CE
The value of Xmin is 0.9.
The value of Xmax 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 is given below:
- 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 using the given below:
- 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:
Step-by-step procedure to display the data using the MINITAB software using the given below:
- Choose data> display data.
- Select the columns to display as Minimum, Maximum.
- Click ok.
Output using the MINITAB software is given below:
Thus, the value of Xmin is 0.9 and the value of Xmax is 11.9.
b.
Construct a histogram.
b.
Answer to Problem 99CE
Histogram:
Output obtained from MINITAB software is:
Explanation of Solution
Calculation:
Software procedure:
- Step by step procedure to draw the Histogram using MINITAB software is given below:
- 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.
Find the mean and
c.
Answer to Problem 99CE
The mean score is 3.55.
The median score is 3.
Explanation of Solution
Mean and median:
Software procedure:
Step-by-step procedure to find the mean, the median using the MINITAB software is given below:
- 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:
- 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.
Find the standard deviation for data set A.
d.
Answer to Problem 99CE
The standard deviation for data set A is 2.749.
Explanation of Solution
Standard deviation:
Software procedure:
Step-by-step procedure to find the mean and standard deviation using the MINITAB software is given below:
- 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:
- Thus, the standard deviation have been obtained.
e.
Standardize the data and identify the outliers and unusual observations.
e.
Answer to Problem 99CE
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 one outlier in the dataset.
Explanation of Solution
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 30nd cell.
- Output using EXCEL software is given below:
Thus, the standardized values have been obtained using EXCEL.
The outliers in the data set A can be identified using
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:
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.
Find the quartiles and a box plot for data set A.
f.
Answer to Problem 99CE
The Q1 (25th percentile) is 1.775, Q2 (50th percentile) is 3 and Q3 (75th percentile) is 4.525.
The boxplot for the data set A is:
Explanation of Solution
Quartiles:
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:
- 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, Q1 than it is to the third quartile, Q3, 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?
Chapter 4 Solutions
Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardA group of people at the park were asked their ages, and the results can be downloaded from the data file Ages. In StatKey, which menu option would you select under "Descriptive Statistics and Graphs" to graph the data? One Quantitative One Categorical One Quantitative and One Categorical A group of people at the park were asked their ages, and the results can be downloaded from the data file Ages. Summarize this data by creating a histogram with StatKey, and submit your graph as a PDF. When creating your graph, please make sure the number of buckets is set to 10.arrow_forwardNow monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts. Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Based on the X-bar and R Charts that you developed for the 1st 10 days of data, is the process in control? Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.arrow_forward
- TV Viewing Times. Data from a sample of Americans yielded the following estimates of average TV viewing time per month for all Americans 2 years old and older. The times are in hours and minutes; Q1 stands for first quarter. [SOURCE: The Cross-Platform Report, Quarter 1, 2011. Published by The Nielsen Company, _c 2011.]arrow_forwardOn December 17, 2007 baseball writer John Hickey wrote an article for the Seattle P-I about increases to ticket prices for Seattle Mariners games during the 2008 season. The article included a data set that listed the average ticket price for each MLB team, the league in which the team plays (AL or NL), the number of wins during the 2007 season and the cost per win (in dollars). The data for the 16 National League teams are shown below. league price wins cost/win team Arizona Diamondbacks NL 19.68 90 35.40 Atlanta Braves NL 17.07 84 32.89 Chicago Cubs NL 34.30 85 65.33 cincinnati Reds NL 17.90 72 40.32 Colorado Rockies NL 14.72 90 26.67 Florida Marlins NL 16.70 71 38.13 Houston Astros NL 26.66 73 59.11 Los Angeles Dodgers 20.09 82 34.64 NL Milwaukee Brewers NL 18.11 83 35.37 N.Y. Mets NL 25.28 88 46.56 Philadelphia Phillies 26.73 89 48.69 NL Pittsburgh Pirates NL 17.08 68 40.67 San Diego Padres NL 20.83 89 38.15 San Francisco Giants NL 24.53 71 56.00 St. Louis Cardinals NL 29.78 78…arrow_forwardDescribe the four levels of data measurement, and provide examples of when each method might be appropriate.arrow_forward
- Determine whether the variables is qualitative or quantitative number of infants born in a montharrow_forwardEach week the Wall Street Journal and Harris Interactive track the opinions and experiences of college recruiters for large corporations and summarize the results in the Business School Survey. Data have been gathered for the top 10 business schools from a list of 76 and is summarized below. Please complete the questions below and upload this document and your EXCEL document to the portal in CANVAS. School Ranking Enrollment (# of full-time students) Annual Tuition ($) Mean GMAT % with Job Offer Average Salary ($) Dartmouth 1 503 38,400 704 89 119,800 Michigan 2 1873 33,076 690 91 105,986 Carnegie Mellon 3 661 38,800 691 93 95,531 Northwestern 4 2650 38,844 700 94 117,060 Yale 5 468 36,800 696 86 104,018 Pennsylvania 6 1840 40,458 716 92 117,471 California Berkeley 7 1281 21,512 701 92 112,699 Columbia 8 1796 38,290 709 95 126,319 North…arrow_forwardPlease help!! From these following topics in CANADA, choose one of the 3, and formulate a research question, in which you could analyze the data. Sawn wood: Sawn wood, production, deliveries and stocks by species Weather: Weather data for Hamilton January 2020 Basketball - The Raptors: Statistics with the playersarrow_forward
- On December 17, 2007 baseball writer John Hickey wrote an article for the Seattle P-I about increases to ticket prices for Seattle Mariners games during the 2008 season. The article included a data set that listed the average ticket price for each MLB team, the league in which the team plays (AL or NL), the number of wins during the 2007 season and the cost per win (in dollars). The data for the 16 National League teams are shown below. team league price wins cost/win Arizona Diamondbacks NL 19.68 90 35.40 Atlanta Braves NL 17.07 84 32.89 Chicago Cubs NL 34.30 85 65.33 Cincinnati Reds NL 17.90 72 40.32 Colorado Rockies NL 14.72 90 26.67 Florida Marlins NL 16.70 71 38.13 Houston Astros NL 26.66 73 59.11 Los Angeles Dodgers NL 20.09 82 34.64 Milwaukee Brewers NL 18.11 83 35.37 N.Y. Mets NL 25.28 88 46.56 Philadelphia Phillies NL 26.73 89 48.69 Pittsburgh Pirates NL 17.08 68 40.67 San Diego Padres NL 20.83 89 38.15 San Francisco Giants NL 24.53 71…arrow_forwardAn business reviews data on the daily amount of calls it receives. Are the data discrete or continous?arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning