
Concept explainers
Americans Dining Out. Americans tend to dine out multiple times per week. The number of times a sample of 20 families dined out last week provides the following data.
- a. Compute the
mean andmedian . - b. Compute the first and third
quartiles. - c. Compute the
range andinterquartile range . - d. Compute the variance and standard deviation.
- e. The skewness measure for these data is .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.

Find the mean and median.
Answer to Problem 62SE
The mean and median are 2.95 and 3, respectively.
Explanation of Solution
Calculation:
The data represent the number of times a family dined out last week for a sample of 20 families.
Descriptive measures:
Software procedure:
Step by step procedure to obtain the descriptive statistics using EXCEL is as follows:
- In an EXCEL sheet enter the data values of the sample and label it as Sample.
- Go to Data > Data Analysis (in case it is not default, take the Analysis ToolPak from Excel Add Ins) > Descriptive statistics.
- Enter Input Range as $A$2:$A$21, select Columns in Grouped By, tick on Summary statistics.
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the mean and median number of crossing for these ports of entry are 2.95 and 3, respectively.
Thus, the mean and median are 2.95, and 3, respectively.
b.

Find the first and third quartiles.
Answer to Problem 62SE
The first and third quartiles of the dataset are 1 and 4.75, respectively.
Explanation of Solution
Calculation:
First quartile:
The EXCEL function to compute first quartile is
Software Procedure:
Step by step procedure to obtain the first quartile using EXCEL is as follows:
- Open an EXCEL file.
- Enter the data in the column A in cells A2 to A21.
- In a cell, enter the formula QUARTILE.EXC (A2:A21,1).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the first quartile of the sample data is 1.
Third quartile:
The EXCEL function to compute third quartile is
Software Procedure:
Step by step procedure to obtain the third quartile using EXCEL is as follows:
- Open an EXCEL file.
- Enter the data in the column A in cells A2 to A21.
- In a cell, enter the formula QUARTILE.EXC (A2:A21,3).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the third quartile of the sample data is 4.75.
Thus, the first and third quartiles are 1 and 4.75, respectively.
c.

Find the range and interquartile range.
Answer to Problem 62SE
The range and interquartile range are 7 and 3.75, respectively.
Explanation of Solution
Calculation:
From the EXCEL output obtained in Part (a), the range of the dataset is 7.
From the answers obtained in Part (b), the first and third quartiles of the dataset are 1 and 4.75, respectively.
The IQR can be obtained as follows:
Substitute
Thus, the IQR is 3.75.
Hence, the range, and interquartile range of the dataset are 7, and 3.75, respectively.
d.

Find the variance and standard deviation.
Answer to Problem 62SE
The variance and standard deviation of the dataset are 4.366 and 2.089, respectively.
Explanation of Solution
Calculation:
From the EXCEL output obtained in Part (a), the variance and standard deviation of the dataset are 4.366 and 2.089, respectively.
Thus, the variance and standard deviation of the dataset are 4.366 and 2.089, respectively.
e.

Comment on the shape of the distribution of the given dataset.
Explain whether or not the obtained shape is expected shape.
Explanation of Solution
Given that, the skewness measure for the data is 0.34.
Skewness:
- If the value of skewness is equal to zero, then the distribution is normal and symmetric.
- If the skewness value is less than zero, then the distribution is negatively skewed
- If the skewness value is greater than zero, then the distribution is positively skewed.
Here, the measure of skewness is 0.34.
Since, the measure of skewness is greater than zero, the shape of the distribution is said to be positively skewed.
f.

Check whether the data contain any outliers.
Answer to Problem 62SE
The data has no outliers.
Explanation of Solution
Calculation:
Outliers:
The outlier is the observational point that is distant from the remaining observational points. In other words, outlier is an observation that lies in an abnormal distance from the remaining values.
The outlier in the dataset is identified using the following calculation.
The formula for lower limit is given below:
Here,
Substitute
Thus, the lower limit is –4.625.
The formula for upper limit is given below:
Substitute
Thus, the upper limit is 10.375.
In the present scenario, the data points that are less than lower limit (–4.625) and the data points that are greater than upper limit (10.375) are considered as outliers.
Here, none of the data points are less than the lower limit (–4.625) and none of the data points are greater than upper limit (10.375).
Since, all the data values lies within the limits.
Thus, the dataset does not contain any outliers.
Want to see more full solutions like this?
Chapter 3 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
- Find the critical value for a left-tailed test using the F distribution with a 0.025, degrees of freedom in the numerator=12, and degrees of freedom in the denominator = 50. A portion of the table of critical values of the F-distribution is provided. Click the icon to view the partial table of critical values of the F-distribution. What is the critical value? (Round to two decimal places as needed.)arrow_forwardA retail store manager claims that the average daily sales of the store are $1,500. You aim to test whether the actual average daily sales differ significantly from this claimed value. You can provide your answer by inserting a text box and the answer must include: Null hypothesis, Alternative hypothesis, Show answer (output table/summary table), and Conclusion based on the P value. Showing the calculation is a must. If calculation is missing,so please provide a step by step on the answers Numerical answers in the yellow cellsarrow_forwardShow all workarrow_forward
- Show all workarrow_forwardplease find the answers for the yellows boxes using the information and the picture belowarrow_forwardA marketing agency wants to determine whether different advertising platforms generate significantly different levels of customer engagement. The agency measures the average number of daily clicks on ads for three platforms: Social Media, Search Engines, and Email Campaigns. The agency collects data on daily clicks for each platform over a 10-day period and wants to test whether there is a statistically significant difference in the mean number of daily clicks among these platforms. Conduct ANOVA test. You can provide your answer by inserting a text box and the answer must include: also please provide a step by on getting the answers in excel Null hypothesis, Alternative hypothesis, Show answer (output table/summary table), and Conclusion based on the P value.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 Harcourt

