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
Loose-leaf For Applied Statistics In Business And Economics
- You’re scrolling through Instagram and you notice that a lot of people are posting selfies. This piques yourcuriosity and you want to estimate the percentage of photos on Instagram that are selfies.(a) (5 points) Is there a “ground truth” for the percentage of selfies on Instagram? Why or why not?(b) (5 points) Is it possible to estimate the ground truth percentage of selfies on Instagram?Irrespective of your answer to the previous question, you decide to pull up n = 250 randomly chosenphotos from your friends’ Instagram accounts and find that 32% of these photos are selfies.(c) (15 points) Determine which of the following is an observation, a variable, a sample statistic (valuecalculated based on the observed sample), or a population parameter.• A photo on Instagram.• Whether or not a photo is a selfie.• Percentage of all photos on Instagram that are selfies.• 32%.(d) (5 points) Based on the sample you collected, do you think 32% is a reliable ballpark estimate for theground truth…arrow_forwardCan you explain this statement below in layman's terms? Secondary Analysis with Generalized Linear Mixed Model with clustering for Hospital Center and ICUvs Ward EnrolmentIn a secondary adjusted analysis we used generalized linear mixed models with random effects forcenter (a stratification variable in the primary analyses). In this analysis, the relative risk for the primaryoutcome of 90-day mortality for 7 versus 14 days of antibiotics was 0.90 (95% Confidence Interval [CI]0.78, 1.05).arrow_forwardIn a crossover trial comparing a new drug to a standard, π denotes the probabilitythat the new one is judged better. It is desired to estimate π and test H0 : π = 0.5against H1 : π = 0.5. In 20 independent observations, the new drug is better eachtime.(a) Find and plot the likelihood function. Give the ML estimate of π (Hint: youmay use the plot function in R)arrow_forward
- Can you explain what this analysis means in layman's terms? - We calculated that a target sample size of 3626, which was based on anticipated baseline 90-day mortality of 22% and a noninferiority margin of no more than 4 percentage points, would give the trial 80% power, at a one-sided alpha level of 2.5%, accounting for a maximum of 5% loss to follow-up and for early stopping rules for three interim analyses.-arrow_forwardCan you help me understand this analysis? A 95.7% confidence interval is shown for the intention-to-treat analysis (accounting for alpha spending in interim analyses), and 95% confidence intervals are shown for the other two analyses. The widths of the confidence intervals have not been adjusted for multiplicity. The dashed line indicates the noninferiority margin of 4 percentage points.arrow_forwardTitle: Analyzing Customer Satisfaction for UnileverAs a member of Unilever's Customer Experience Management team, you are responsible forevaluating customer satisfaction levels and monitoring competitive moves. This case studyinvolves analyzing satisfaction data to test two key hypotheses about Unilever's performancerelative to its main competitor, Procter & Gamble (P&G).Unilever’s leadership team has emphasized the importance of customer satisfaction inmaintaining competitive advantage and market leadership. As part of this initiative, yourteam regularly monitors satisfaction scores and benchmarks them against competitors likeP&G.You are tasked with analyzing the provided dataset to answer the following questions:1. Does Unilever’s average customer satisfaction score meet the minimum threshold of2. 75%?Is there no significant difference between Unilever’s overall average satisfaction scoreand P&G’s average satisfaction score?arrow_forward
- Need help answering wuestionarrow_forwardThe following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors (aaii.com, February 2002). Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts. Click on the datafile logo to reference the data. DATA file Company DeWolfe Companies Exchange Ticker Symbol Market Cap ($ millions) Price/ Gross Profit Earnings Ratio Margin (%) AMEX DWL 36.4 8.4 36.7 North Coast Energy OTC NCEB 52.5 6.2 59.3 Hansen Natural Corp. OTC HANS 41.1 14.6 44.8 MarineMax, Inc. NYSE HZO 111.5 7.2 23.8 Nanometrics Incorporated OTC NANO 228.6 38.0 53.3 TeamStaff, Inc. OTC TSTF 92.1 33.5 4.1 Environmental Tectonics AMEX ETC 51.1 35.8 35.9 Measurement Specialties AMEX MSS 101.8 26.8 37.6 SEMCO Energy, Inc. NYSE SEN 193.4 18.7 23.6 Party City Corporation OTC PCTY 97.2 15.9 36.4 Embrex, Inc. OTC EMBX 136.5 18.9 59.5 Tech/Ops Sevcon, Inc. AMEX ΤΟ 23.2 20.7 35.7 ARCADIS NV OTC ARCAF 173.4…arrow_forwardThe following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors (aaii.com, February 2002). Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts. Click on the datafile logo to reference the data. DATA file Company DeWolfe Companies Exchange AMEX Ticker Symbol Market Cap Price/ Gross Profit Earnings Margin ($ millions) Ratio (%) DWL 36.4 8.4 36.7 North Coast Energy OTC NCEB 52.5 6.2 59.3 Hansen Natural Corp. OTC HANS 41.1 14.6 44.8 MarineMax, Inc. NYSE HZO 111.5 7.2 23.8 Nanometrics Incorporated OTC NANO 228.6 38.0 53.3 TeamStaff, Inc. OTC TSTF 92.1 33.5 4.1 Environmental Tectonics AMEX ETC 51.1 35.8 35.9 Measurement Specialties AMEX MSS 101.8 26.8 37.6 SEMCO Energy, Inc. NYSE SEN 193.4 18.7 23.6 Party City Corporation OTC PCTY 97.2 15.9 36.4 Embrex, Inc. OTC EMBX 136.5 18.9 59.5 Tech/Ops Sevcon, Inc. AMEX ΤΟ 23.2 20.7 35.7 ARCADIS NV OTC ARCAF 173.4…arrow_forward
- The following data show the year to date percent change (YTD % Change) for 30 stock-market indexes from around the word (The Wall Street Journal, August 26, 2013). a. What index has the largest positive YTD % Change? Round your answer to once decimal place. index with a YTD % Change of % b. Using a class width of 5 beginning with -20 and going to 40, develop a frequency distribution for the data. YTD % Change Frequency -20 - -15 -15 - -10 -10 - -5 -5 - 0 0 - 5 5 - 10 10 - 15 15 - 20 20 - 25 30 - 35 c. 1. 2. 3. 4.arrow_forwardThe following data show the year to date percent change (YTD % Change) for 30 stock-market indexes from around the word (The Wall Street Journal, August 26, 2013). Click on the datafile logo to reference the data. DATA file Country Australia Index S&P/ASX200 YTD % Change 10.2 Belgium Bel-20 12.6 Brazil São Paulo Bovespa -14.4 Canada S&P/TSX Comp 2.6 Chile Santiago IPSA -16.3 China Shanghai Composite -9.3 Eurozone EURO Stoxx 10.0 France CAC 40 11.8 Germany DAX 10.6 Hong Kong Hang Seng -3.5 India S&P BSE Sensex -4.7 Israel Tel Aviv 1.3 Italy FTSE MIB 6.6 Japan Nikkei 31.4 Mexico IPC All-Share -6.4 Netherlands AEX 9.3 Singapore Straits Times -2.5 South Korea Kospi -6.4 Spain IBEX 35 6.4 Sweden Switzerland SX All Share 13.8 Swiss Market 17.4 Taiwan Weighted 2.3 U.K. FTSE 100 10.1 U.S. S&P 500 16.6 U.S. DJIA 14.5 U.S. Dow Jones Utility 6.6 U.S. Nasdaq 100 17.4 U.S. Nasdaq Composite 21.1 World DJ Global ex U.S. 4.2 World DJ Global Index 9.9 a. What index has the largest positive YTD %…arrow_forwardDescribe a three step process you choose to determine how many elementary schools there are in the city of 5 million people.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