Essentials Of Statistics For Business & Economics
Essentials Of Statistics For Business & Economics
9th Edition
ISBN: 9780357045435
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 62SE

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.

Chapter 3, Problem 62SE, Americans Dining Out. Americans tend to dine out multiple times per week. The number of times a

  1. a. Compute the mean and median.
  2. b. Compute the first and third quartiles.
  3. c. Compute the range and interquartile range.
  4. d. Compute the variance and standard deviation.
  5. 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?
  6. f. Do the data contain outliers?

a.

Expert Solution
Check Mark
To determine

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:

Essentials Of Statistics For Business & Economics, Chapter 3, Problem 62SE , additional homework tip  1

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.

Expert Solution
Check Mark
To determine

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 Q1=QUARTILE.EXC(input range,1).

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:

Essentials Of Statistics For Business & Economics, Chapter 3, Problem 62SE , additional homework tip  2

From the EXCEL output, the first quartile of the sample data is 1.

Third quartile:

The EXCEL function to compute third quartile is Q3=QUARTILE.EXC(input range,3).

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:

Essentials Of Statistics For Business & Economics, Chapter 3, Problem 62SE , additional homework tip  3

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.

Expert Solution
Check Mark
To determine

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:

IQR=Q3Q1

Substitute Q1=1 and Q3=4.75 in the formula of inter quartile range.

IQR=4.751=3.75

Thus, the IQR is 3.75.

Hence, the range, and interquartile range of the dataset are 7, and 3.75, respectively.

d.

Expert Solution
Check Mark
To determine

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.

Expert Solution
Check Mark
To determine

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 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.

Expert Solution
Check Mark
To determine

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:

Lower limit=Q11.5IQR

Here, Q1 is the first quartile and Q3 is the third quartile.

Substitute IQR=3.75 and Q1=1

Lower limit=11.5(3.75)=15.625=4.625

Thus, the lower limit is –4.625.

The formula for upper limit is given below:

Upper limit=Q3+1.5IQR

Substitute IQR=3.75 and Q3=4.75

Upper limit=4.75+1.5(3.75)=4.75+5.625=10.375

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 lie within the limits.

Thus, the dataset does not contain any outliers.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 3 Solutions

Essentials Of Statistics For Business & Economics

Ch. 3.1 - Time Spent Watching Traditional TV. Nielsen tracks...Ch. 3.1 - Online Multiplayer Game Downloads. The creator of...Ch. 3.1 - Automobile Fuel Efficiencies. In automobile...Ch. 3.1 - Unemployment Rates by State. The U.S. Bureau of...Ch. 3.1 - Motor Oil Prices. Martinez Auto Supplies has...Ch. 3.1 - Calculating Grade Point Averages. The grade point...Ch. 3.1 - The following table shows the total return and the...Ch. 3.1 - Business School Ranking. Based on a survey of...Ch. 3.1 - Revenue Growth Rate. Annual revenue for Corning...Ch. 3.1 - Mutual Fund Comparison. Suppose that at the...Ch. 3.1 - If an asset declines in value from $5000 to $3500...Ch. 3.1 - The current value of a company is 25 million. If...Ch. 3.2 - Consider a sample with data values of 10, 20, 12,...Ch. 3.2 - Consider a sample with data values of 10, 20, 12,...Ch. 3.2 - Consider a sample with data values of 27, 25, 20,...Ch. 3.2 - Price of Unleaded Gasoline. Data collected by the...Ch. 3.2 - Round-Trip Flight Prices. The following table...Ch. 3.2 - Annual Sales Amounts. Varatta Enterprises sells...Ch. 3.2 - Air Quality Index. The Los Angeles Times regularly...Ch. 3.2 - Prob. 30ECh. 3.2 - Cellular Phone Spending. According to the 2016...Ch. 3.2 - Advertising Spend by Companies. Advertising Age...Ch. 3.2 - Amateur Golfer Scores. Scores turned in by an...Ch. 3.2 - Consistency of Running Times. The following times...Ch. 3.3 - Consider a sample with data values of 10, 20, 12,...Ch. 3.3 - Prob. 36ECh. 3.3 - Consider a sample with a mean of 30 and a standard...Ch. 3.3 - Suppose the data have a bell-shaped distribution...Ch. 3.3 - The results of a national survey showed that on...Ch. 3.3 - Price per Gallon of Gasoline. Suppose that the...Ch. 3.3 - GMAT Exam Scores. The Graduate Management...Ch. 3.3 - Many families in California are using backyard...Ch. 3.3 - Best Places to Live. Each year Money magazine...Ch. 3.3 - NCAA Basketball Game Scores. A sample of 10 NCAA...Ch. 3.3 - Prob. 45ECh. 3.4 - Consider a sample with data values of 27, 25, 20,...Ch. 3.4 - Show the boxplot for the data in exercise 46. 46....Ch. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples Half-Marathon Times. Naples, Florida, hosts...Ch. 3.4 - Pharmaceutical Company Sales. Annual sales, in...Ch. 3.4 - Cell Phone Companies Customer Satisfaction....Ch. 3.4 - Most Admired Companies. Fortune magazines list of...Ch. 3.4 - U.S. Border Crossings. The Bureau of...Ch. 3.5 - Five observations taken for two variables follow....Ch. 3.5 - Five observations taken for two variables follow....Ch. 3.5 - Stock Price Comparison. The file StockComparison...Ch. 3.5 - Driving Speed and Fuel Efficiency. A department of...Ch. 3.5 - Smoke Detector Use and Death Rates. Over the past...Ch. 3.5 - Stock Market Indexes Comparison. The Russell 1000...Ch. 3.5 - Best Private Colleges. A random sample of 30...Ch. 3 - Americans Dining Out. Americans tend to dine out...Ch. 3 - NCAA Football Coaches Salaries. A 2017 USA Today...Ch. 3 - Physician Office Waiting Times. The average...Ch. 3 - Worker Productivity and Insomnia. U.S. companies...Ch. 3 - Work Commuting Methods. Public transportation and...Ch. 3 - Household Incomes. The following data represent a...Ch. 3 - Prob. 69SECh. 3 - Best Hotels. Travel + Leisure magazine provides an...Ch. 3 - NFL Teams Worth. In 2014, the 32 teams in the...Ch. 3 - MLB Team Winning Percentages. Does a major league...Ch. 3 - Money Market Funds Days to Maturity. The days to...Ch. 3 - Automobile Speeds. Automobiles traveling on a road...Ch. 3 - Annual Returns for Panama Railroad Company Stock....Ch. 3 - Pelican Stores, a division of National Clothing,...Ch. 3 - Prob. 2CPCh. 3 - The pursuit of a higher education degree in...Ch. 3 - Although millions of elephants once roamed across...
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License