Concept explainers
Spirit Airlines kept track of the number of empty seats on flight 308 (DEN-DTW) for 10 consecutive trips on each weekday except Friday. (a) Sort the data for each day. (b) Find the
a.
Arrange the data.
Answer to Problem 16SE
The sorted data is:
Explanation of Solution
Calculation:
The dataset represents the number of empty seats on flight 308 for 10 consecutive trips.
The data set of empty seats 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 in ascending using the EXCEL is given below:
- Open an EXCEL file.
- Enter the data in the column in H cells H1 to H10, column in I cells I1 to I10, J cells J1 to J10 and column in K cells K1 to K10.
- Choose Data > Sort.
- In Column drop down box, select Column H.
- In Sort on drop down box, select Values.
- In Order drop down box, select “Smallest to Largest”.
- Click OK.
- In Column drop down box, select Column I.
- In Sort on drop down box, select Values.
- In Order drop down box, select “Smallest to Largest”.
- Click OK.
- In Column drop down box, select Column J.
- In Sort on drop down box, select Values.
- In Order drop down box, select “Smallest to Largest”.
- Click OK.
- In Column drop down box, select Column K.
- In Sort on drop down box, select Values.
- In Order drop down box, select “Smallest to Largest”.
- Click OK.
Thus, the sorted data has been stored in the column in H cells H1 to H10, column in I cells I1 to I10, J cells J1 to J10 and column in K cells K1 to K10.
b.
Find the Mean, Median, Mode, Midrange, Geometric mean, and 10% Trimmed mean.
Answer to Problem 16SE
The Mean, Median, Mode, Midrange, Geometric mean, and 10% Trimmed mean is:
Descriptive measures | Monday | Tuesday | Wednesday | Thursday |
Mean | 4 | 4.70 | 3.80 | 1.90 |
Median | 5 | 5 | 5 | 1 |
Mode | 1 | 1 | 6 | 1 |
Geometric mean | 2.89 | 3.76 | Not applicable | 1.26 |
Midrange | 5 | 5 | 5 | 5.50 |
Trimmed mean | 3.75 | 4.63 | 3.50 | 1 |
Explanation of Solution
Calculation:
For Monday:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I10.
- In cell A1, enter the formula “=AVERAGE(I1:I10)”.
- Output using EXCEL software is given below:
Thus, the mean number of empty seats on Monday is 4.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I10.
- In cell A1, enter the formula “=MEDIAN(I1:110)”.
- Output using EXCEL software is given below:
Thus, the median for the number of empty seats on Monday is 5.
Mode:
Software procedure:
Step-by-step software procedure to obtain Mode using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I10.
- In cell A1, enter the formula “=MODE.SNGL(I1:I10)”.
- Output using EXCEL software is given below:
Thus, the mode for the number of empty seats on Monday is 1.
Geometric mean:
Software procedure:
Step-by-step software procedure to obtain Geometric mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I10.
- In cell A1, enter the formula “=GEOMEAN(I1:I10)”.
- Output using EXCEL software is given below:
Thus, the geometric mean for the number of empty seats on Monday is 2.89.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I10.
- In cell A1, enter the formula “=(MIN(I1:I10)+MAX(I1:I10))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange for the number of empty seats on Monday is 5.
10% Trimmed mean:
Software procedure:
Step-by-step software procedure to obtain 10% Trimmed mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I10.
- In cell A1, enter the formula “=TRIMMEAN(I1:I10,0.2)”.
- Output using EXCEL software is given below:
- Thus, the 10% Trimmed mean for the number of empty seats on Monday is 3.75.
For Tuesday:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J10.
- In cell A1, enter the formula “=AVERAGE(J1:J10)”.
- Output using EXCEL software is given below:
Thus, the mean number of empty seats on Tuesday is 4.70.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J10.
- In cell A1, enter the formula “=MEDIAN(J1:J10)”.
- Output using EXCEL software is given below:
Thus, the median for the number of empty seats on Tuesday is 5.
Mode:
Software procedure:
Step-by-step software procedure to obtain Mode using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J10.
- In cell A1, enter the formula “=MODE.SNGL(J1:J10)”.
- Output using EXCEL software is given below:
Thus, the mode for the number of empty seat on Tuesday is 1.
Geometric mean:
Software procedure:
Step-by-step software procedure to obtain Geometric mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J10.
- In cell A1, enter the formula “=GEOMEAN(J1:J10)”.
- Output using EXCEL software is given below:
Thus, the geometric mean for the number of empty seats on Tuesday is 3.76.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J10.
- In cell A1, enter the formula “=(MIN(J1:J10)+MAX(J1:J10))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange for the number of empty seats on Tuesday is 5.
10% Trimmed mean:
Software procedure:
Step-by-step software procedure to obtain 10% Trimmed mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J10.
- In cell A1, enter the formula “=TRIMMEAN(J1:J10,0.2)”.
- Output using EXCEL software is given below:
- Thus, the 10% Trimmed mean for the number of empty seats on Tuesday is 4.63.
For Wednesday:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K10.
- In cell A1, enter the formula “=AVERAGE(K1:K10)”.
- Output using EXCEL software is given below:
Thus, the mean number of empty seats on Wednesday is 3.80.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K10.
- In cell A1, enter the formula “=MEDIAN(K1:K10)”.
- Output using EXCEL software is given below:
Thus, the median for the number of empty seats on Wednesday is 5.
Mode:
Software procedure:
Step-by-step software procedure to obtain Mode using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K10.
- In cell A1, enter the formula “=MODE.SNGL(K1:K10)”.
- Output using EXCEL software is given below:
Thus, the mode for the number of empty seat on Wednesday is 6.
Geometric mean:
- Here, the data set on Wednesday contains zero, so, geometric mean is not applicable.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K10.
- In cell A1, enter the formula “=(MIN(K1:K10)+MAX(K1:K10))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange for the number of empty seats on Wednesday is 5.
10% Trimmed mean:
Software procedure:
Step-by-step software procedure to obtain 10% Trimmed mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K10.
- In cell A1, enter the formula “=TRIMMEAN(K1:K10,0.2)”.
- Output using EXCEL software is given below:
- Thus, the 10% Trimmed mean for the number of empty seats on Wednesday is 3.50.
For Thursday:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L10.
- In cell A1, enter the formula “=AVERAGE(L1:L10)”.
- Output using EXCEL software is given below:
Thus, the mean number of empty seats on Thursday is 1.90.
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L10.
- In cell A1, enter the formula “=MEDIAN(L1:L10)”.
- Output using EXCEL software is given below:
Thus, the median for the number of empty seats on Thursday is 5.
Mode:
Software procedure:
Step-by-step software procedure to obtain Mode using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L10.
- In cell A1, enter the formula “=MODE.SNGL(L1:L10)”.
- Output using EXCEL software is given below:
Thus, the mode for the number of empty seat on Thursday is 1.
Geometric mean:
Software procedure:
Step-by-step software procedure to obtain Geometric mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L10.
- In cell A1, enter the formula “=GEOMEAN(L1:L10)”.
- Output using EXCEL software is given below:
Thus, the geometric mean for the number of empty seats on Thursday is 1.26.
Midrange:
Software procedure:
Step-by-step software procedure to obtain Midrange using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L10.
- In cell A1, enter the formula “=(MIN(L1:L10)+MAX(L1:L10))/2”.
- Output using EXCEL software is given below:
- Thus, the midrange for the number of empty seats on Thursday is 5.50.
10% Trimmed mean:
Software procedure:
Step-by-step software procedure to obtain 10% Trimmed mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L10.
- In cell A1, enter the formula “=TRIMMEAN(L1:L10,0.2)”.
- Output using EXCEL software is given below:
- Thus, the 10% Trimmed mean for the number of empty seats on Thursday is 1.
b.
Explain whether or not the measures of center agreed.
Answer to Problem 16SE
No, the measures of center are not agreed.
Explanation of Solution
The measures of center will not acceptable for the number of empty seats on flight 308. In this situation, the mode and geometric mean are totally different from the other measures. That is, the mean, median and the midrange for all days in a week has the similar values.
c.
Note the strength or weakness of the statistic of center.
Explanation of Solution
Strength of the statistic of the center:
Mean: it is more preferable for any statistical analysis which uses all information about the sample data.
Median: median will be more unaffected by the extreme values.
Mode: Of all the observations, mode is the undependable measure of center.
Weakness of the statistic of the center:
Mean: it is affected by the extreme values.
Median: it is affected by the gaps in the data value.
Mode: it is not helpful for continuous data.
When the strength or weakness is observed for each day, it is known that mode is the undependable for all the days. It is observed from the previous part (b), the mean and median are equal for all the days, so it acts as the strength of the statistic of center.
Want to see more full solutions like this?
Chapter 4 Solutions
Applied Statistics in Business and Economics
- 59. At a certain gas station, 40% of the customers use regular gas (A1), 35% use plus gas (A2), and 25% use premium (A3). Of those customers using regular gas, only 30% fill their tanks (event B). Of those customers using plus, 60% fill their tanks, whereas of those using premium, 50% fill their tanks.a. What is the probability that the next customer will request plus gas and fill the tank (A2 B)?b. What is the probability that the next customer fills the tank?c. If the next customer fills the tank, what is the probability that regular gas is requested? Plus? Premium?arrow_forward38. Possible values of X, the number of components in a system submitted for repair that must be replaced, are 1, 2, 3, and 4 with corresponding probabilities .15, .35, .35, and .15, respectively. a. Calculate E(X) and then E(5 - X).b. Would the repair facility be better off charging a flat fee of $75 or else the amount $[150/(5 - X)]? [Note: It is not generally true that E(c/Y) = c/E(Y).]arrow_forward74. The proportions of blood phenotypes in the U.S. popula- tion are as follows:A B AB O .40 .11 .04 .45 Assuming that the phenotypes of two randomly selected individuals are independent of one another, what is the probability that both phenotypes are O? What is the probability that the phenotypes of two randomly selected individuals match?arrow_forward
- 53. A certain shop repairs both audio and video compo- nents. Let A denote the event that the next component brought in for repair is an audio component, and let B be the event that the next component is a compact disc player (so the event B is contained in A). Suppose that P(A) = .6 and P(B) = .05. What is P(BA)?arrow_forward26. A certain system can experience three different types of defects. Let A;(i = 1,2,3) denote the event that the sys- tem has a defect of type i. Suppose thatP(A1) = .12 P(A) = .07 P(A) = .05P(A, U A2) = .13P(A, U A3) = .14P(A2 U A3) = .10P(A, A2 A3) = .011Rshelfa. What is the probability that the system does not havea type 1 defect?b. What is the probability that the system has both type 1 and type 2 defects?c. What is the probability that the system has both type 1 and type 2 defects but not a type 3 defect? d. What is the probability that the system has at most two of these defects?arrow_forwardThe following are suggested designs for group sequential studies. Using PROCSEQDESIGN, provide the following for the design O’Brien Fleming and Pocock.• The critical boundary values for each analysis of the data• The expected sample sizes at each interim analysisAssume the standardized Z score method for calculating boundaries.Investigators are evaluating the success rate of a novel drug for treating a certain type ofbacterial wound infection. Since no existing treatment exists, they have planned a one-armstudy. They wish to test whether the success rate of the drug is better than 50%, whichthey have defined as the null success rate. Preliminary testing has estimated the successrate of the drug at 55%. The investigators are eager to get the drug into production andwould like to plan for 9 interim analyses (10 analyzes in total) of the data. Assume thesignificance level is 5% and power is 90%.Besides, draw a combined boundary plot (OBF, POC, and HP)arrow_forward
- Please provide the solution for the attached image in detailed.arrow_forward20 km, because GISS Worksheet 10 Jesse runs a small business selling and delivering mealie meal to the spaza shops. He charges a fixed rate of R80, 00 for delivery and then R15, 50 for each packet of mealle meal he delivers. The table below helps him to calculate what to charge his customers. 10 20 30 40 50 Packets of mealie meal (m) Total costs in Rands 80 235 390 545 700 855 (c) 10.1. Define the following terms: 10.1.1. Independent Variables 10.1.2. Dependent Variables 10.2. 10.3. 10.4. 10.5. Determine the independent and dependent variables. Are the variables in this scenario discrete or continuous values? Explain What shape do you expect the graph to be? Why? Draw a graph on the graph provided to represent the information in the table above. TOTAL COST OF PACKETS OF MEALIE MEAL 900 800 700 600 COST (R) 500 400 300 200 100 0 10 20 30 40 60 NUMBER OF PACKETS OF MEALIE MEALarrow_forwardLet X be a random variable with support SX = {−3, 0.5, 3, −2.5, 3.5}. Part ofits probability mass function (PMF) is given bypX(−3) = 0.15, pX(−2.5) = 0.3, pX(3) = 0.2, pX(3.5) = 0.15.(a) Find pX(0.5).(b) Find the cumulative distribution function (CDF), FX(x), of X.1(c) Sketch the graph of FX(x).arrow_forward
- A well-known company predominantly makes flat pack furniture for students. Variability with the automated machinery means the wood components are cut with a standard deviation in length of 0.45 mm. After they are cut the components are measured. If their length is more than 1.2 mm from the required length, the components are rejected. a) Calculate the percentage of components that get rejected. b) In a manufacturing run of 1000 units, how many are expected to be rejected? c) The company wishes to install more accurate equipment in order to reduce the rejection rate by one-half, using the same ±1.2mm rejection criterion. Calculate the maximum acceptable standard deviation of the new process.arrow_forward5. Let X and Y be independent random variables and let the superscripts denote symmetrization (recall Sect. 3.6). Show that (X + Y) X+ys.arrow_forward8. Suppose that the moments of the random variable X are constant, that is, suppose that EX" =c for all n ≥ 1, for some constant c. Find the distribution of X.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 HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning