Quiz 3 (1)

docx

School

University of Texas, Rio Grande Valley *

*We aren’t endorsed by this school

Course

1421

Subject

Statistics

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by JusticeRabbit4288

Quiz 3 – Elementary Statistical Methods Names: __________________________________________________ 1. Earnings of Nonliving Celebrities Forbes magazine prints an annual Top-Earning Nonliving Celebrities list (based on royalties and estate earnings). Find the mean, median, mode, and midrange for the data. Comment on the skewness. Figures represent millions of dollars. Kurt Cobain 50 Elvis Presley 42 Charles M. Schulz 35 John Lennon 24 Albert Einstein 20 Andy Warhol 19 Theodore Geisel (Dr. Seuss) 10 Ray Charles 10 Marilyn Monroe 8 Johnny Cash 8 J.R.R. Tolkien 7 George Harrison 7 Bob Marley 7 ***SEE EXCEL INSTRUCTIONS AT THE END OF THIS DOCUMENT TO FIND MEASURES OF CENTRAL TENDENCY FOR PROBLEMS 1&2.*** 2. Foreign Workers The number of foreign workers’ certificates for the New England states and the northwestern states is shown. Find the mean, median, and mode for both areas and compare the results. New England states Northwestern states 6768 1870 3196 622 1112 620 819 23 1019 172 1795 112 3. Hourly Compensation for Production Workers The hourly compensation costs (in U.S. dollars) for production workers in selected

countries are represented below. Find the mean and modal class for the data. Class Frequency 2.48–7.48 7 7.49–12.49 3 12.50–17.50 1 17.51–22.51 7 22.52–27.52 5 27.53–32.53 5 Compare the mean of these grouped data to the U.S. mean of $21.97. Midpoints: 2.48+7.48/2= 4.98, 7.49+12.49/2= 9.99, 12.50+17.50/2= 15, 17.51+22.51/2= 20.01, 22.52+27.52/2= 25.02, 27.53+32.53/2= 30.03 Mean: 7 x 4.98= 34.86 3 x 9.99= 29.97 1 x 15= 15 7 x 20.01= 140.07 5 x 25.02= 125.1 5 x 30.03= 150.15 4. Percentage of Foreign-Born People The percentage of foreign-born population for each of the 50 states is represented here. Find the mean and modal class for the data. Do you think the mean is the best average for this set of data? Explain. Percentage Frequency 0.8–4.4 26 4.5–8.1 11 8.2–11.8 4 11.9–15.5 5 15.6–19.2 2 19.3–22k.9 1 23.0–26.6 1

5. Fat Grams Using the weighted mean, find the average number of grams of fat per ounce of meat or fish that a person would consume over a 5-day period if he ate these: Meat or fish Fat (g/oz) 3 oz fried shrimp 3.33 3 oz veal cutlet (broiled) 3.00 2 oz roast beef (lean) 2.50 2.5 oz fried chicken drumstick 4.40 4 oz tuna (canned in oil) 1.75 6. Costs of Helicopters The costs of three models of helicopters are shown here. Find the weighted mean of the costs of the models. Model Number sold (w) Cost (x) Sunscraper 9 $427,000 Skycoaster 6 365,000 High-flyer 12 725,000 ∑ w=27 ∑(w.x)=14,733,000 WtimesX 9.47,000= 3,843,000 6.365,000= 2,190,000 12.725,000= 8,700,000 X= ∑(w.x)/ ∑w= 14,733,000/27= 545,666.6 The weighted mean of the helicopter costs is $545,667. EXCEL Step by Step Finding Measures of Central Tendency Example XL3–1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Find the mean, mode, and median of the data from problems 1 and 2 above. On an Excel worksheet enter the numbers in cells A2-A X (X here denotes the resulting cell after entering all data) . Enter a label for the variable in cell A1. On the same worksheet as the data: 2. Compute the mean of the data: key in =AVERAGE(A2:A X ) in a blank cell. 3. Compute the mode of the data: key in =MODE(A2:A X ) in a blank cell. 4. Compute the median of the data: key in =MEDIAN(A2:A X ) in a blank cell. These and other statistical functions can also be accessed without typing them into the worksheet directly. 1. Select the Formulas tab from the toolbar and select the Insert Function Icon . 2. Select the Statistical category for statistical functions. 3. Scroll to find the appropriate function and click [ OK ]. (Note: Excel reports only the first mode in a bimodal or multimodal distribution.)