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 STAT.IN BUS.+ECONOMICS
- TIP the aren't, the data are not sym 11 Suppose that the average salary at a certain company is $100,000, and the median salary is $40,000. a. What do these figures tell you about the shape of the histogram of salaries at this company? b. Which measure of center is more appro- priate here? c. Suppose that the company goes through a salary negotiation. How can people on each side use these summary statistics to their advantage? 6360 be 52 PART 1 Getting Off to a Statistically Significant Sarrow_forward12 Suppose that you know that a data set is skewed left, and you know that the two measures of center are 19 and 38. Which figure is the mean and which is the median?arrow_forwardy of 45 home- televisions u find that 010020 le own one, ee, and 1 owns y histogram of 4 Suppose that you have a loaded die. You roll it several times and record the outcomes, which are shown in the following figure. Histogram for Loaded Die 444% 34.00 48% 6% 2% Frequency 20 20 15 155 10 5- ம 0 1 2 3 4 Outcome 5 6 a. Make a relative frequency histogram of these results. b. You can make a relative frequency histo- gram from a frequency histogram; can you go the other direction?arrow_forward
- Calculate the mean for Study Hours and Test Scores. Compute the covariance between the two variables using the formula: Calculate the standard deviation for Study Hours (X) and Test Scores (Y). Determine the correlation coefficient Interpret the results: What does the calculated r-value indicate about the relationship between study hours and test scores?arrow_forwardFor unemployed persons in the United States, the average number of months of unemployment at the end of December 2009 was approximately seven months (Bureau of Labor Statistics, January 2010). Suppose the following data are for a particular region in upstate New York. The values in the first column show the number of months unemployed and the values in the second column show the corresponding number of unemployed persons. Months Unemployed Number Unemployed 1 1029 2 1686 3 2269 4 2675 5 3487 6 4652 7 4145 8 3587 9 2325 10 1120 Let x be a random variable indicating the number of months a person is unemployed. a. Use the data to develop an empirical discrete probability distribution for x (to 4 decimals). (x) f(x) 1 2 3 4 5 6 7 8 9 10 b. Show that your probability distribution satisfies the conditions for a valid discrete probability distribution. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank c. What is the probability that a…arrow_forwardWest Virginia has one of the highest divorce rates in the nation, with an annual rate of approximately 5 divorces per 1000 people (Centers for Disease Control and Prevention website, January 12, 2012). The Marital Counseling Center, Inc. (MCC) thinks that the high divorce rate in the state may require them to hire additional staff. Working with a consultant, the management of MCC has developed the following probability distribution for x = the number of new clients for marriage counseling for the next year. Excel File: data05-19.xls x 10 f(x) .05 20 30 .10 .10 40 .20 50 60 .35 .20 a. Is this probability distribution valid? - Select your answer- Explain. f(x) Σf(x) Select your answer Select your answer b. What is the probability MCC will obtain more than 30 new clients (to 2 decimals)? c. What is the probability MCC will obtain fewer than 20 new clients (to 2 decimals)? d. Compute the expected value and variance of x. Expected value Variance clients per year squared clients per yeararrow_forward
- For unemployed persons in the United States, the average number of months of unemployment at the end of December 2009 was approximately seven months (Bureau of Labor Statistics, January 2010). Suppose the following data are for a particular region in upstate New York. The values in the first column show the number of months unemployed and the values in the second column show the corresponding number of unemployed persons. Months Unemployed Number Unemployed 1 1029 2 1686 3 2269 4 2675 5 3487 6 4652 7 4145 8 3587 9 2325 10 1120 Let x be a random variable indicating the number of months a person is unemployed. a. Use the data to develop an empirical discrete probability distribution for x (to 4 decimals). (x) f(x) 1 2 3 4 5 6 7 8 9 10 b. Show that your probability distribution satisfies the conditions for a valid discrete probability distribution. The input in the box below will not be graded, but may be reviewed and considered by your instructor. c. What is the probability that a person…arrow_forwardIn Gallup's Annual Consumption Habits Poll, telephone interviews were conducted for a random sample of 1014 adults aged 18 and over. One of the questions was "How many cups of coffee, if any, do you drink on an average day?" The following table shows the results obtained (Gallup website, August 6, 2012). Excel File: data05-23.xls Number of Cups per Day Number of Responses 0 365 264 193 3 4 or more 91 101 Define a random variable x = number of cups of coffee consumed on an average day. Let x = 4 represent four or more cups. Round your answers to four decimal places. a. Develop a probability distribution for x. x 0 1 2 3 4 f(x) b. Compute the expected value of x. cups of coffee c. Compute the variance of x. cups of coffee squared d. Suppose we are only interested in adults that drink at least one cup of coffee on an average day. For this group, let y = the number of cups of coffee consumed on an average day. Compute the expected value of y. Compare it to the expected value of x. The…arrow_forwardIn Gallup's Annual Consumption Habits Poll, telephone interviews were conducted for a random sample of 1014 adults aged 18 and over. One of the questions was "How many cups of coffee, if any, do you drink on an average day?" The following table shows the results obtained (Gallup website, August 6, 2012). Excel File: data05-23.xls Number of Cups per Day Number of Responses 0 365 264 193 2 3 4 or more 91 101 Define a random variable x = number of cups of coffee consumed on an average day. Let x = 4 represent four or more cups. Round your answers to four decimal places. a. Develop a probability distribution for x. x 0 1 2 3 f(x) b. Compute the expected value of x. cups of coffee c. Compute the variance of x. cups of coffee squared d. Suppose we are only interested in adults that drink at least one cup of coffee on an average day. For this group, let y = the number of cups of coffee consumed on an average day. Compute the expected value of y. Compare it to the expected value of x. The…arrow_forward
- A technician services mailing machines at companies in the Phoenix area. Depending on the type of malfunction, the service call can take 1, 2, 3, or 4 hours. The different types of malfunctions occur at about the same frequency. Develop a probability distribution for the duration of a service call. Duration of Call x f(x) 1 2 3 4 Which of the following probability distribution graphs accurately represents the data set? Consider the required conditions for a discrete probability function, shown below.Does this probability distribution satisfy equation (5.1)?Does this probability distribution satisfy equation (5.2)? What is the probability a service call will take three hours? A service call has just come in, but the type of malfunction is unknown. It is 3:00 P.M. and service technicians usually get off at 5:00 P.M. What is the probability the service technician will have to work overtime to fix the machine today?arrow_forwardA psychologist determined that the number of sessions required to obtain the trust of a new patient is either 1, 2, or 3. Let x be a random variable indicating the number of sessions required to gain the patient's trust. The following probability function has been proposed. x f(x) for x = 1, 2, or 3 a. Consider the required conditions for a discrete probability function, shown below. f(x) ≥0 Σf(x) = 1 (5.1) (5.2) Does this probability distribution satisfy equation (5.1)? Select Does this probability distribution satisfy equation (5.2)? Select b. What is the probability that it takes exactly 2 sessions to gain the patient's trust (to 3 decimals)? c. What is the probability that it takes at least 2 sessions to gain the patient's trust (to 3 decimals)?arrow_forwardA technician services mailing machines at companies in the Phoenix area. Depending on the type of malfunction, the service call can take 1, 2, 3, or 4 hours. The different types of malfunctions occur at about the same frequency. Develop a probability distribution for the duration of a service call. Which of the following probability distribution graphs accurately represents the data set? Consider the required conditions for a discrete probability function, shown below.Does this probability distribution satisfy equation (5.1)?Does this probability distribution satisfy equation (5.2)? What is the probability a service call will take three hours? A service call has just come in, but the type of malfunction is unknown. It is 3:00 P.M. and service technicians usually get off at 5:00 P.M. What is the probability the service technician will have to work overtime to fix the machine today?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