Concept explainers
The average number of times Americans dine out in a week fell from 4.0 in 2008 to 3.8 in 2012 (Zagat.com, April 1, 2012). The number of times a sample of 20 families dined out last week provides the following data.
a.Compute the
b.Compute the first and third
c.Compute the
d.Compute the variance and standard deviation.
e.The skewness measure for these data is 0.34. Comment on the shape of this distribution. Is it the shape you would expect? Why or why not?
f.Do the data contain outliers?
(a)
To find the mean and median of the given data.
Answer to Problem 62SE
Mean = 3
Median = 3
Explanation of Solution
Given:
The data:
6 | 1 | 5 | 3 | 7 | 3 | 0 | 3 | 1 | 3 |
4 | 1 | 2 | 4 | 1 | 0 | 5 | 6 | 3 | 1 |
Formula used:
Calculation:
Now, let's calculate median,
In order to calculate we need to first arrange the data in ascending order
0 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 |
3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 |
Conclusion:
The mean and median for the given data is 3.
(b)
To find the first and third quartile of the given data.
Answer to Problem 62SE
Explanation of Solution
Given:
The data:
6 | 1 | 5 | 3 | 7 | 3 | 0 | 3 | 1 | 3 |
4 | 1 | 2 | 4 | 1 | 0 | 5 | 6 | 3 | 1 |
Formula used:
Calculation:
We need to first arrange the data in ascending order;
0 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 |
3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 |
Conclusion:
The value of first quartile is 1 and third quartile is 4.75.
(c)
To find the value of Range and Interquartile Range.
Answer to Problem 62SE
Explanation of Solution
Given:
The data:
6 | 1 | 5 | 3 | 7 | 3 | 0 | 3 | 1 | 3 |
4 | 1 | 2 | 4 | 1 | 0 | 5 | 6 | 3 | 1 |
Formula used:
Calculation:
We need to first arrange the data in ascending order;
0 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 |
3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 |
Conclusion:
The value of range is 7 and interquartile range = 3.75.
(d)
To find the value of variance and Standard deviation.
Answer to Problem 62SE
Explanation of Solution
Given:
The data:
6 | 1 | 5 | 3 | 7 | 3 | 0 | 3 | 1 | 3 |
4 | 1 | 2 | 4 | 1 | 0 | 5 | 6 | 3 | 1 |
Formula used:
Calculation:
0 | -2.95 | 8.7025 | |
0 | -2.95 | 8.7025 | |
1 | -1.95 | 3.8025 | |
1 | -1.95 | 3.8025 | |
1 | -1.95 | 3.8025 | |
1 | -1.95 | 3.8025 | |
1 | -1.95 | 3.8025 | |
2 | -0.95 | 0.9025 | |
3 | 0.05 | 0.0025 | |
3 | 0.05 | 0.0025 | |
3 | 0.05 | 0.0025 | |
3 | 0.05 | 0.0025 | |
3 | 0.05 | 0.0025 | |
4 | 1.05 | 1.1025 | |
4 | 1.05 | 1.1025 | |
5 | 2.05 | 4.2025 | |
5 | 2.05 | 4.2025 | |
6 | 3.05 | 9.3025 | |
6 | 3.05 | 9.3025 | |
7 | 4.05 | 16.4025 | |
Sum | 59 | 0.00 | 82.95 |
Mean | 2.95 |
Conclusion:
The value of Standard Deviation is 2.09 and Variance is 4.366.
(e)
To identify the shape of the distribution when skewness is equal to 0.34.
Answer to Problem 62SE
Left Skewed or Negatively Skewed
Explanation of Solution
Given:
The data:
6 | 1 | 5 | 3 | 7 | 3 | 0 | 3 | 1 | 3 |
4 | 1 | 2 | 4 | 1 | 0 | 5 | 6 | 3 | 1 |
It has been given that the value of skewness is 0.34 and as we have calculated the value of mean and median where the value of median is 3 and mean is 2.95, When the median is greater than mean then the shape of the distribution is negatively skewed or left skewed.
Conclusion:
The shape of the given data is negatively skewed or left skewed.
(f)
To identify whether there is any outlier in the given data or not.
Answer to Problem 62SE
No outliers exist
Explanation of Solution
Given:
The data:
6 | 1 | 5 | 3 | 7 | 3 | 0 | 3 | 1 | 3 |
4 | 1 | 2 | 4 | 1 | 0 | 5 | 6 | 3 | 1 |
Formula used:
Since in the given data there is no value which is less than -4.625 and greater than 10.375. Therefore, there is no outliers exists in the given data set.
Conclusion:
The data contains no outliers.
Want to see more full solutions like this?
Chapter 3 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
- Morningstar tracks the total return for a large number of mutual funds. The following table shows the total return and the number of funds for four categories of mutual funds. Click on the datafile logo to reference the data. DATA file Type of Fund Domestic Equity Number of Funds Total Return (%) 9191 4.65 International Equity 2621 18.15 Hybrid 1419 2900 11.36 6.75 Specialty Stock a. Using the number of funds as weights, compute the weighted average total return for these mutual funds. (to 2 decimals) % b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights? The input in the box below will not be graded, but may be reviewed and considered by your instructor. c. Suppose you invested $10,000 in this group of mutual funds and diversified the investment by placing $2000 in Domestic Equity funds, $4000 in International Equity funds, $3000 in Specialty Stock…arrow_forwardThe days to maturity for a sample of five money market funds are shown here. The dollar amounts invested in the funds are provided. Days to Maturity 20 Dollar Value ($ millions) 20 12 30 7 10 5 6 15 10 Use the weighted mean to determine the mean number of days to maturity for dollars invested in these five money market funds (to 1 decimal). daysarrow_forwardc. What are the first and third quartiles? First Quartiles (to 1 decimals) Third Quartiles (to 4 decimals) × ☑ Which companies spend the most money on advertising? Business Insider maintains a list of the top-spending companies. In 2014, Procter & Gamble spent more than any other company, a whopping $5 billion. In second place was Comcast, which spent $3.08 billion (Business Insider website, December 2014). The top 12 companies and the amount each spent on advertising in billions of dollars are as follows. Click on the datafile logo to reference the data. DATA file Company Procter & Gamble Comcast Advertising ($billions) $5.00 3.08 2.91 Company American Express General Motors Advertising ($billions) $2.19 2.15 ETET AT&T Ford Verizon L'Oreal 2.56 2.44 2.34 Toyota Fiat Chrysler Walt Disney Company J.P Morgan a. What is the mean amount spent on advertising? (to 2 decimals) 2.55 b. What is the median amount spent on advertising? (to 3 decimals) 2.09 1.97 1.96 1.88arrow_forward
- Martinez Auto Supplies has retail stores located in eight cities in California. The price they charge for a particular product in each city are vary because of differing competitive conditions. For instance, the price they charge for a case of a popular brand of motor oil in each city follows. Also shown are the number of cases that Martinez Auto sold last quarter in each city. City Price ($) Sales (cases) Bakersfield 34.99 501 Los Angeles 38.99 1425 Modesto 36.00 294 Oakland 33.59 882 Sacramento 40.99 715 San Diego 38.59 1088 San Francisco 39.59 1644 San Jose 37.99 819 Compute the average sales price per case for this product during the last quarter? Round your answer to two decimal places.arrow_forwardConsider the following data and corresponding weights. xi Weight(wi) 3.2 6 2.0 3 2.5 2 5.0 8 a. Compute the weighted mean (to 2 decimals). b. Compute the sample mean of the four data values without weighting. Note the difference in the results provided by the two computations (to 3 decimals).arrow_forwardExpert only,if you don't know it don't attempt it, no Artificial intelligence or screen shot it solvingarrow_forward
- For context, the image provided below is a quesion from a Sepetember, 2024 past paper in statistical modelingarrow_forwardFor context, the images attached below (the question and the related figure) is from a january 2024 past paperarrow_forwardFor context, the image attached below is a question from a June 2024 past paper in statisical modelingarrow_forward
- For context, the images attached below are a question from a June, 2024 past paper in statistical modelingarrow_forwardFor context, the images attached below (question and related graph) are from a February 2024 past paper in statistical modelingarrow_forwardFor context, the images attached below are from a February 2024 past paper in statistical modelingarrow_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 Harcourt