Essentials of Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Essentials of Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
7th Edition
ISBN: 9781337298292
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 62SE

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. Chapter 3, Problem 62SE, The average number of times Americans dine out in a week fell from 4.0 in 2008 to 3.8 in 2012
a.Compute the mean and median.
b.Compute the first and third quartiles.
c.Compute the range and interquartile range.
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?

Expert Solution
Check Mark
To determine

(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:

6153730313
4124105631

Formula used:

  Mean(x¯)=xinMedian =  ( n 2 ) th term+ ( n 2 +1 ) thterm2

Calculation:

  Mean = 59202.95

Now, let's calculate median,

In order to calculate we need to first arrange the data in ascending order

0011111233
3334455667

  Median =  ( 20 2 ) thterm+ ( 20 2 +1 ) thterm2 10 thterm+ 11 th term23+323

Conclusion:

The mean and median for the given data is 3.

Expert Solution
Check Mark
To determine

(b)

To find the first and third quartile of the given data.

Answer to Problem 62SE

  Q1=1Q3=4.75

Explanation of Solution

Given:

The data:

6153730313
4124105631

Formula used:

  Q1=[14( n+1)]th termQ3=[34( n+1)]th term

Calculation:

We need to first arrange the data in ascending order;

0011111233
3334455667

  Q1=[14( n+1)]th term[14( 20+1)]th term5.25thterm5th term+(6 th term5 th term)×141+(11)×141

  Q1=[34( n+1)]th term[34( 20+1)]th term15.75thterm15th term+( 16 th term 15 th term)×344+(54)×344.75

Conclusion:

The value of first quartile is 1 and third quartile is 4.75.

Expert Solution
Check Mark
To determine

(c)

To find the value of Range and Interquartile Range.

Answer to Problem 62SE

  Range = 7Interquartile Range = 3.75

Explanation of Solution

Given:

The data:

6153730313
4124105631

Formula used:

  Q1=[14( n+1)]th termQ3=[34( n+1)]th term

Calculation:

We need to first arrange the data in ascending order;

0011111233
3334455667

  Range = Highest Value - Lowest Value7 - 07

  Interquartile Range = Q3Q14.7513.75

Conclusion:

The value of range is 7 and interquartile range = 3.75.

Expert Solution
Check Mark
To determine

(d)

To find the value of variance and Standard deviation.

Answer to Problem 62SE

  StandardDeviation = 2.09Variance = 4.366

Explanation of Solution

Given:

The data:

6153730313
4124105631

Formula used:

  StandardDeviation= ( x i x ¯ ) 2 n1Variance =  ( x i x ¯ )2n1

Calculation:

x(xix¯)(xix¯)2
0-2.958.7025
0-2.958.7025
1-1.953.8025
1-1.953.8025
1-1.953.8025
1-1.953.8025
1-1.953.8025
2-0.950.9025
30.050.0025
30.050.0025
30.050.0025
30.050.0025
30.050.0025
41.051.1025
41.051.1025
52.054.2025
52.054.2025
63.059.3025
63.059.3025
74.0516.4025
Sum590.0082.95
Mean2.95

  Standard Deviation =  82.95 192.09

  Variance = (StandardDeviation)22.0924.366

Conclusion:

The value of Standard Deviation is 2.09 and Variance is 4.366.

Expert Solution
Check Mark
To determine

(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:

6153730313
4124105631

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.

Expert Solution
Check Mark
To determine

(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:

6153730313
4124105631

Formula used:

  Outlier<Q11.5(IQR)Outlier>Q3+1.5(IQR)

  Q11.5(IQR)11.5(3.75)4.625

  Q3+1.5(IQR)4.75+1.5(3.75)10.375

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?

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

Chapter 3 Solutions

Essentials of Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 3.1 - According to the National Education Association...Ch. 3.1 - The Big Bang Theory, a situation comedy featuring...Ch. 3.1 - In automobile mileage and gasoline-consumption...Ch. 3.1 - Prob. 14ECh. 3.1 - Martinez Auto Supplies has retail stores located...Ch. 3.1 - The grade point average for college students is...Ch. 3.1 - The following table shows the total return and the...Ch. 3.1 - Prob. 18ECh. 3.1 - Prob. 19ECh. 3.1 - Prob. 20ECh. 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 - Prob. 24ECh. 3.2 - Prob. 25ECh. 3.2 - Data collected by the Oil Price Information...Ch. 3.2 - The results of a search to find the least...Ch. 3.2 - The Australian Open is the first of the four Grand...Ch. 3.2 - Prob. 29ECh. 3.2 - The following data were used to construct the...Ch. 3.2 - Prob. 31ECh. 3.2 - Prob. 32ECh. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - The following times were recorded by the...Ch. 3.3 - Consider a sample with data values of 10, 20, 12,...Ch. 3.3 - Prob. 36ECh. 3.3 - Prob. 37ECh. 3.3 - Prob. 38ECh. 3.3 - The results of a national survey showed that on...Ch. 3.3 - Prob. 40ECh. 3.3 - Prob. 41ECh. 3.3 - Many families in California are using backyard...Ch. 3.3 - Prob. 43ECh. 3.3 - Prob. 44ECh. 3.3 - The Wall Street Journal reported that Walmart...Ch. 3.4 - Prob. 46ECh. 3.4 - Prob. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples, Florida hosts a half-marathon (13.1 -mile...Ch. 3.4 - Annual sales, in millions of dollars, for 21...Ch. 3.4 - Consumer Reports provided overall customer...Ch. 3.4 - Fortune magazine's list of the world's most...Ch. 3.4 - Prob. 54ECh. 3.5 - Five observations taken for two variables follow...Ch. 3.5 - Five observations taken for two variables follow...Ch. 3.5 - Prob. 57ECh. 3.5 - A department of transportation's study on driving...Ch. 3.5 - Over the past 40 years, the percentage of homes in...Ch. 3.5 - Prob. 60ECh. 3.5 - A random sample of 30 colleges from Kiplinger's...Ch. 3 - The average number of times Americans dine out in...Ch. 3 - Prob. 63SECh. 3 - The average waiting time for a patient at an El...Ch. 3 - U.S. companies lose $63.2 billion per year from...Ch. 3 - Prob. 66SECh. 3 - Public transportation and the automobile are two...Ch. 3 - In 2007 the New York Times reported that the...Ch. 3 - Prob. 69SECh. 3 - Travel + Leisure magazine presented its annual...Ch. 3 - The 32 teams in the National Football League (NFL)...Ch. 3 - Does a major league baseball team's record during...Ch. 3 - The days to maturity for a sample of five money...Ch. 3 - Automobiles traveling on a road with a posted...Ch. 3 - The Panama Railroad Company was established in...Ch. 3 - Case Problem 1 Pelican Stores Pelican S to res, a...Ch. 3 - Case Problem 1 Pelican Stores Pelican S to res, a...Ch. 3 - Problem 2Motion Picture Industry The motion...Ch. 3 - Case Problem 2 Motion Picture Industry The motion...Ch. 3 - Case Problem 2 Motion Picture Industry The motion...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 5 African Elephant Populations...Ch. 3 - Case Problem 5 African Elephant Populations...Ch. 3 - Case Problem 5 African Elephant Populations...
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
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