The average number of times Americans dine out in a week fell from 4.0 in 2008...

80.2K

Verified Solution

Question

Statistics

The average number of times Americans dine out in a week fellfrom 4.0 in 2008 to 3.8 in 2012 (Zagat.com, April 1, 2012). Thenumber of times a sample of 20 families dined out last weekprovides the following data: 6 1 5 3 7 3 0 3 1 3 1 2 4 1 0 5 6 3 14

Complete the following in Excel:

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 theshape of this distribution. Is it the shape you would expect? Whyor why not?

f. Do the data contain outliers?

Answer & Explanation Solved by verified expert
3.5 Ratings (497 Votes)
The data is entered in the cells A1 to A20Excel formulae are given within the brackets for thefollowingaMean 295 AVERAGEA1A20Median 3 MEDIANA1A20bFirst quartile Q1 1 QUARTILEA1A20    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students