Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
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!
Students have asked these similar questions
In addition to the in-school milk supplement program, the nurse would like to increase the use of daily vitamin supplements for the children by visiting homes and educating about the merits of vitamins. She believes that currently, about 50% of families with school-age children give the children a daily megavitamin. She would like to increase this to 70%. She plans a two-group study, where one group serves as a control and the other group receives her visits. How many families should she expect to visit to have 80% power of detecting this difference? Assume that drop-out rate is 5%.
A recent survey of 400 americans asked whether or not parents do too much for their young adult children. The results of the survey are shown in the data file. a) Construct the frequency and relative frequency distributions. How many respondents felt that parents do too much for their adult children? What proportion of respondents felt that parents do too little for their adult children? b) Construct a pie chart. Summarize the findings
The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows: Click on the datafile logo to reference the data. DATA file Albuquerque 23.3 Jacksonville 26.2 Phoenix 28.3 Atlanta 28.3 Kansas City 23.4 Pittsburgh 25.0 Austin 24.6 Las Vegas 28.4 Portland 26.4 Baltimore 32.1 Little Rock 20.1 Providence 23.6 Boston 31.7 Los Angeles 32.2 Richmond 23.4 Charlotte 25.8 Louisville 21.4 Sacramento 25.8 Chicago 38.1 Memphis 23.8 Salt Lake City 20.2 Cincinnati 24.9 Miami 30.7 San Antonio 26.1 Cleveland 26.8 Milwaukee 24.8 San Diego 24.8 Columbus 23.4 Minneapolis 23.6 San Francisco 32.6 Dallas 28.5 Nashville 25.3 San Jose 28.5 Denver 28.1 New Orleans 31.7 Seattle 27.3 Detroit 29.3 New York 43.8 St. Louis 26.8 El Paso 24.4 Oklahoma City 22.0 Tucson 24.0 Fresno 23.0 Orlando 27.1 Tulsa 20.1 Indianapolis 24.8 Philadelphia 34.2 Washington, D.C. 32.8 a. What is the mean commute time for…

Chapter 3 Solutions

Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)

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.
Similar questions
SEE MORE QUESTIONS
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