Question

In: Statistics and Probability

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

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: 6 1 5 3 7 3 0 3 1 3 1 2 4 1 0 5 6 3 1 4

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

f. Do the data contain outliers?

Solutions

Expert Solution

The data is entered in the cells A1 to A20.

Excel formulae are given within the brackets for the following:

a.

Mean =2.95 (=AVERAGE(A1:A20))

Median =3 (=MEDIAN(A1:A20))

b.

First quartile, Q1 =1 (=QUARTILE(A1:A20, 1))

Third quartile, Q3 =4.25 (=QUARTILE(A1:A20, 3))

c.

Range =7 (=A25 - A26)

Interquartile Range, IQR=3.25 (=A24 - A23)

To find range:

Maximum value =7 (=MAX(A1:A20))

Minimum value =0 (=MIN(A1:A20))

d.

Variance =4.3658 (=VAR(A1:A20))

Standard deviation =2.0894 (=STDEV(A1:A20))

e.

Since the skewness of 0.34 is between -0.5 and 0.5, the shape of this distribution is approximately symmetrical (normal).

Yes. It is the shape I would expect because more number of families would be clustered around the center and it decreases as we move towards left and right from the center making the distribution to be normal or approximately normal.

f.

1.5(IQR) =1.5(3.25) =4.875

Q1 - 1.5(IQR) =1 - 4.875 = -3.875

Q3 + 1.5(IQR) =4.25 + 4.875 =9.125

Since, the data do not contain any values that are less than -3.875 or greater than 9.125, the data do not contain outliers.


Related Solutions

The average number of times Americans dine out in a week fell from 4.0 in 2008...
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 dines out last week provides the following data. 6             1              5              3              7              3              0              3              1              3 4              1              2              4              1              0              5              6              3              1 a)      The skewness measure for these data is 0.34. Comment on the shape of the distribution. Is it the...
The average number of times Americans dine out in a week fell from 4.0 in 2008...
The average number of times Americans dine out in a week fell from 4.0 in 2008 to 3.8 in 2012. The number of times a sample of 20 families dined out last year provides the following data. Table 4 60 10 50 30 70 3 50 30 10 30 40 10 20 40 10 40 50 60 30 500 Compute the mean and median. Compute the first and third quartiles. Compute the range and interquartile range. Compute the variance and...
The average number of times Americans dine out in a week fell from 4.0 in 2008...
The average number of times Americans dine out in a week fell from 4.0 in 2008 to 3.8 in 2012. The number of times a sample of 20 families dined out last year provides the following data. Table 4 60 10 50 30 70 3 50 30 10 30 40 10 20 40 10 40 50 60 30 500 Compute the mean and median. Compute the first and third quartiles. Compute the range and interquartile range. Compute the variance and...
The average number of times Americans dine out in a week fell from  in 2008 to  in 2012....
The average number of times Americans dine out in a week fell from  in 2008 to  in 2012. The number of times a sample of  families dined out last week provides the following data. 7 2 6 4 8 4 1 4 2 4 5 2 3 5 2 0 6 7 4 2 a. Compute the mean and median. Mean (to 2 decimals) Median (to 1 decimal) b. Compute the first and third quartiles. Round the answers to 2 decimal places, if...
Between 2008 and 2013 the United States fell from 5th to 10th place in the Heritage...
Between 2008 and 2013 the United States fell from 5th to 10th place in the Heritage Foundation’s World Ranking of Countries with the Most Economic Freedom. In 2017, Hong Kong, Singapore and New Zealand respectively hold the top 3 spots for being economically free and the U.S. ranks 17th. Briefly explain why the U.S. has continued to decline in its respective world ranking.
Professor Venkat is on a mission to find out the average number of students absent from...
Professor Venkat is on a mission to find out the average number of students absent from his lectures. For this, he analyzed 14 random attendance sheets from his previous semesters and found out that on average, the number of absentees was 38 with a standard deviation of 12. Let's assume that the data follows a Gaussian distribution. Construct a 99% confidence interval for the true mean of the dataset.
The average number of minutes Americans commute to work is 27.7 minutes. The average commute time...
The average number of minutes Americans commute to work is 27.7 minutes. The average commute time in minutes for 48 cities are as follows. Albuquerque 23.6 Jacksonville 26.5 Phoenix 28.6 Atlanta 28.6 Kansas City 23.7 Pittsburgh 25.3 Austin 24.9 Las Vegas 28.7 Portland 26.7 Baltimore 32.4 Little Rock 20.4 Providence 23.9 Boston 32.0 Los Angeles 32.5 Richmond 23.7 Charlotte 26.1 Louisville 21.7 Sacramento 26.1 Chicago 38.4 Memphis 24.1 Salt Lake City 20.5 Cincinnati 25.2 Miami 31.0 San Antonio 26.4 Cleveland...
You are rolling a fair dice 100 times. Let N be the number of times out...
You are rolling a fair dice 100 times. Let N be the number of times out of 100, when you roll an odd number. What is the most suitable distribution for N? Type one of the following (Poisson, binomial, normal,geometric)  . Determine the probability that the number of times N out of 100, when you roll an odd number is 60 or more P ( N ≥ 60 ) =  (use R and round to the third decimal place). Which distribution is...
Fred fell from the garage roof when cleaning out the gutters after a storm. At the...
Fred fell from the garage roof when cleaning out the gutters after a storm. At the hospital doctors concluded that he had an Left T12 hemi-section.   What pathway that would carry proprioceptive information and which side of the Fred's body would be effected. ? Would Fred have voluntary movement of his lower limbs? consider both left and right sides? Would Fred still have a knee jerk reflex? Would Fred be able to perceive the reflex? Describe the types of sensory...
The number of times a machine broke down each week was observed over a period of...
The number of times a machine broke down each week was observed over a period of 100 weeks and recorded as shown in the table below. Complete parts a and b below. Number of Breakdowns 0 1 2 3 4 5 or More Number of weeks 9 22 32 26 6 5 a. Using alphaequals?0.10, perform a? chi-square test to determine if the population distribution of breakdowns follows the Poisson probability distribution. What is the null? hypothesis, Upper H 0??...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT