Business Stats HW
tv
econ_2300.xlsxInstructions
Instructions After performing the tasks on sheets #1 through #6, cut and paste (as pictures) your results/answers to a Word document. As needed, adjust the size of the pictures so that your Word document is 2 pages long. The printout of your Word document-- with the 2 pages on the front and back of a single sheet of paper--is due at the beginning of class on Monday, September 23. This take-home portion is worth 24 points (4 points per task). Friendly reminder: All bar charts, histograms, and line graphs call for axis labels and a Chart Title. In addition, any break in a histogram's x-axis scale should be indicated (e.g., by parallel hashmarks).
#1
| Below, from the Bureau of Economic Analysis, are the personal consumption expenditures on health care (in $ billions) | |
| in the U.S. for the years 1980 through 2012. | |
| Display the annual expenditures in the form of a line graph, | |
| using as the chart title U.S. Personal Consumption Expenditures on Health Care (in $ billions), 1980-2012 (source: Bureau of Economic Analysis). | |
| Year | Expenditures (in $ billions) |
| 1980 | 171.7 |
| 1981 | 201.9 |
| 1982 | 225.2 |
| 1983 | 253.1 |
| 1984 | 276.5 |
| 1985 | 302.2 |
| 1986 | 330.2 |
| 1987 | 366.0 |
| 1988 | 410.1 |
| 1989 | 451.2 |
| 1990 | 506.2 |
| 1991 | 555.8 |
| 1992 | 612.8 |
| 1993 | 648.8 |
| 1994 | 680.5 |
| 1995 | 719.9 |
| 1996 | 752.1 |
| 1997 | 790.9 |
| 1998 | 832.0 |
| 1999 | 863.6 |
| 2000 | 918.4 |
| 2001 | 996.6 |
| 2002 | 1082.9 |
| 2003 | 1154.6 |
| 2004 | 1240.1 |
| 2005 | 1322.3 |
| 2006 | 1394.2 |
| 2007 | 1481.8 |
| 2008 | 1556.5 |
| 2009 | 1556.5 |
| 2010 | 1627.4 |
| 2011 | 1690.7 |
| 2012 | 1767.8 |
| 2013 | 1847.6 |
#2
| A consultant developed an electronic billing system for a trucking company. | |
| The frequency distribution below summarizes the payment times (in days) for 65 invoices using the electronic billing system. | |
| Display the frequency distribution in the form of a histogram | |
| using as the chart title Payment Times (in days) for 65 Invoices Using Electronic Billing System. | |
| Payment time (in days) | # of invoices |
| 10-12 | 3 |
| 13-15 | 14 |
| 16-18 | 23 |
| 19-21 | 12 |
| 22-24 | 8 |
| 25-27 | 4 |
| 28-30 | 1 |
#3
| Below is the percentage distribution (by model) of the Jeeps sold at Bill's Jeep Dealership in 2012. | ||
| Jeep model | % of jeeps sold | |
| Commander | 27% | |
| Grand Cherokee | 29% | |
| Liberty | 32% | |
| Wrangler | 12% | |
| Portray the percentage distribution in the form of a bar chart, | ||
| using as the chart title Jeeps Sold at Bill's Jeep Dealership in 2012. | ||
#4
| Below (in column A) are the water usage levels (in gallons) on 9/13/2013 of the 120 condos in the Lark Complex. |
| Summarize the water usage levels in the form of a frequency distribution (in table form), using as the numeric classes the intervals |
| 15 to under 20, 20 to under 25, 25 to under 30, 30 to under 35, 35 to under 40, 40 to under 45, 45 to under 50, and 50 to under 55. |
| Water usage |
| 22.8 |
| 28.0 |
| 29.1 |
| 46.5 |
| 30.5 |
| 30.0 |
| 31.1 |
| 26.2 |
| 32.6 |
| 27.0 |
| 47.3 |
| 32.4 |
| 45.2 |
| 46.8 |
| 27.8 |
| 28.9 |
| 46.4 |
| 21.8 |
| 28.3 |
| 28.0 |
| 21.4 |
| 28.8 |
| 30.2 |
| 37.9 |
| 22.7 |
| 40.6 |
| 40.3 |
| 23.6 |
| 24.1 |
| 23.6 |
| 41.2 |
| 28.6 |
| 48.0 |
| 25.1 |
| 35.5 |
| 37.6 |
| 28.0 |
| 46.3 |
| 25.8 |
| 30.1 |
| 22.5 |
| 41.9 |
| 23.8 |
| 26.0 |
| 43.9 |
| 33.4 |
| 27.3 |
| 44.4 |
| 33.4 |
| 48.9 |
| 28.6 |
| 42.5 |
| 46.6 |
| 53.6 |
| 28.8 |
| 30.1 |
| 32.3 |
| 36.8 |
| 22.4 |
| 31.5 |
| 31.2 |
| 27.8 |
| 44.0 |
| 22.4 |
| 15.1 |
| 28.2 |
| 23.3 |
| 29.0 |
| 24.7 |
| 21.3 |
| 36.4 |
| 33.5 |
| 22.1 |
| 41.0 |
| 29.6 |
| 32.4 |
| 24.4 |
| 25.0 |
| 24.0 |
| 43.1 |
| 18.0 |
| 45.1 |
| 30.3 |
| 17.9 |
| 33.4 |
| 28.4 |
| 22.9 |
| 28.7 |
| 38.4 |
| 24.9 |
| 30.7 |
| 42.9 |
| 35.3 |
| 32.1 |
| 29.4 |
| 21.7 |
| 26.8 |
| 34.6 |
| 25.1 |
| 48.1 |
| 31.8 |
| 50.0 |
| 29.3 |
| 27.8 |
| 51.3 |
| 23.2 |
| 41.6 |
| 22.3 |
| 32.3 |
| 30.6 |
| 29.1 |
| 25.9 |
| 19.7 |
| 26.8 |
| 37.0 |
| 25.8 |
| 19.4 |
| 21.6 |
| 39.2 |
| 16.8 |
#5
| Determine--relying on an Excel function--the probabilities requested below. |
| If 10% of adolescents in the U.S. have Type II diabetes, what is the probability that, |
| out of a random sample of 500 adolescents in the U.S.: |
| (a) 75 or more have Type II diabetes? |
| (b) 45 or less have Type II diabetes? |
#6
| A car manufacturer is assessing the mileage of its new hybrid car model. Below are the mileages (in mpg) in city driving for a sample of 40 cars of this model. | |||||||||
| 37.6 | 36.1 | 37.0 | 37.5 | 37.9 | 38.1 | 36.4 | 35.9 | ||
| 36.8 | 35.0 | 37.7 | 35.7 | 39.3 | 37.5 | 35.0 | 37.2 | ||
| 38.4 | 34.3 | 38.7 | 38.2 | 37.9 | 36.9 | 39.8 | 38.5 | ||
| 35.4 | 37.2 | 35.2 | 37.6 | 37.4 | 34.8 | 39.5 | 39.9 | ||
| 40.2 | 39.1 | 36.8 | 37.0 | 38.8 | 38.3 | 36.2 | 37.7 | ||
| Determine--relying on Excel functions--each of the following measures for the sample of cars. | |||||||||
| (a) mean mileage | |||||||||
| (b) median mileage | |||||||||
| (c) variance in the mileages | |||||||||
| (d) standard deviation in the mileages | |||||||||
| (e) range in the mileages |
