![APPLIED STAT.IN BUS.+ECONOMICS](https://www.bartleby.com/isbn_cover_images/9781259957598/9781259957598_largeCoverImage.gif)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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 STAT.IN BUS.+ECONOMICS
- Clint, obviously not in college, sleeps an average of 8 hours per night with a standard deviation of 15 minutes. What's the chance of him sleeping between 7.5 and 8.5 hours on any given night? 0-(7-0) 200 91109s and doiw $20 (8-0) mol 8520 slang $199 galbrog seam side pide & D (newid se od poyesvig as PELEO PER AFTE editiw noudab temand van Czarrow_forwardTimes to complete a statistics exam have a normal distribution with a mean of 40 minutes and standard deviation of 6 minutes. Deshawn's time comes in at the 90th percentile. What percentage of the students are still working on their exams when Deshawn leaves?arrow_forwardSuppose that the weights of cereal boxes have a normal distribution with a mean of 20 ounces and standard deviation of half an ounce. A box that has a standard score of o weighs how much? syed by ilog ni 21arrow_forward
- Bob scores 80 on both his math exam (which has a mean of 70 and standard deviation of 10) and his English exam (which has a mean of 85 and standard deviation of 5). Find and interpret Bob's Z-scores on both exams to let him know which exam (if either) he did bet- ter on. Don't, however, let his parents know; let them think he's just as good at both subjects. algas 70) sering digarrow_forwardSue's math class exam has a mean of 70 with a standard deviation of 5. Her standard score is-2. What's her original exam score?arrow_forwardClint sleeps an average of 8 hours per night with a standard deviation of 15 minutes. What's the chance he will sleep less than 7.5 hours tonight? nut bow visarrow_forward
- Suppose that your score on an exam is directly at the mean. What's your standard score?arrow_forwardOne state's annual rainfall has a normal dis- tribution with a mean of 100 inches and standard deviation of 25 inches. Suppose that corn grows best when the annual rainfall is between 100 and 150 inches. What's the chance of achieving this amount of rainfall? wved now of sociarrow_forward13 Suppose that your exam score has a standard score of 0.90. Does this mean that 90 percent of the other exam scores are lower than yours?arrow_forward
- Bob's commuting times to work have a nor- mal distribution with a mean of 45 minutes and standard deviation of 10 minutes. How often does Bob get to work in 30 to 45 minutes?arrow_forwardBob's commuting times to work have a nor- mal distribution with a mean of 45 minutes and standard deviation of 10 minutes. a. What percentage of the time does Bob get to work in 30 minutes or less? b. Bob's workday starts at 9 a.m. If he leaves at 8 a.m., how often is he late?arrow_forwardSuppose that you want to put fat Fido on a weight-loss program. Before the program, his weight had a standard score of +2 com- pared to dogs of his breed/age, and after the program, his weight has a standard score of -2. His weight before the program was 150 pounds, and the standard deviation for the breed is 5 pounds. a. What's the mean weight for Fido's breed/ age? b. What's his weight after the weight-loss program?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
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)