MA 203DL Excel Project 1 Chapter 3 Skills- Focus on Measures of Central Tendency and Variation

Parking Meter Theft Listed below are amounts (in millions of dollars) collected from parking meters by Brinks and others in NYC during similar time periods. A larger data set was used to convict five Brinks employees of grand larceny. The data were provided by the attorney for NYC and are listed on the DASL (Data and Story Library) website.

1. By comparing the measures of central tendency, what conclusion do you reach about the data showing evidence that the Brinks employees were stealing money? Why?
2. Do the two samples appear to have different amounts of variation? Bonus: what does the variation tell you about the thieves?

Collection Contractor WAS Brinks 1.3, 1.5, 1.3, 1.5, 1.4, 1.7, 1.8, 1.7, 1.7, 1.6 Collection Contractor was NOT Brinks 2.2, 1.9, 1.5, 1.6, 1.5, 1.7, 1.9, 1.6, 1.6, 1.8

Peas In A Pod

Biologists conducted experiments to determine whether a deficiency of carbon dioxide in the soil affects the phenotypes of peas. Listed below are the phenotype codes, where 1 = smooth and yellow, 2 = smooth and green,, 3 = wrinkled and yellow and 4 = wrinkled and green. 2,1,1,1,1,1,1,4, 1, 2, 2, 1, 2, 3, 3, 2, 3, 1, 3, 1, 3, 1, 3, 2, 2 3) Can the measures of center be obtained for these values? If so, what are they? Do the results make sense? 4) Can the measures of variation be obtained for these values? If so, what are they? Do the results make sense?

TV Prices

Listed below are selling prices in US Dollars of TVs that are 60" or larger and rated as a "best buy" by Consumer Reports magazine (2016). 5) Are the resulting summary statistics representative of the population of all TVs sixty inches or larger? Why or why not? 6) What statistic or statistics are most relevant for someone who wants to buy such a TV? Why?

1800, 1500, 1200, 1500, 1400, 1600, 1500, 950, 1600, 1150, 1500, 1750

Foot Lengths

Listed below are the foot lengths, in inches, of randomly selected Army Women measured in the 1988 Anthropometric Survey (ANSUR).

7) Find the summary statistics (measures of center and variation). 8) Are the statistics representative of the current population of all Army women? 10.4, 9.3, 9.1, 9.3, 10.0, 9.4, 8.6, 9.8, 9.9., 9.1, 9.1 Most Expensive Colleges

Listed below are the annual costs (in US dollars) of tuition and fees at the 10 most expensive colleges (for a year between 2014-2017, as listed in US News and World Reports) The colleges listed in order are Columbia, Vassar, Trinity, George Washington, Carnegie Mellon, Wesleyan, Tulane, Bucknell, Oberlin, and Union.

9) Find the summary statistics. 10) What, if anything, does this "top 10" list tell us about the costs for the population of all US college tuitions? What might it tell us about the variation among colleges?

49,138 47,890 47,510 47,343 46,962 46,944 46,930 46,902 46,870 46,785

Diamond Ring

Listed below (in US dollars) are the amounts it costs for marriage proposal packages at the different Major League Baseball stadiums. (Five teams don't allow proposals.) 11) What do the measures of center tell you?The measures of variation? 12) Are there any outliers? If so, do those outliers have a small or large effect on the measures of center? On variation? 39 50 50 50 55 55 75 85 100 115 175 175 200 209 250 250 350 400 450 500 500 500 500 1500 2500

Questions taken from "Elementary Statistics Using Excel, 6E," by Mario Triola