ZuoTi.Pro
Question

Listed below is the median household income for the 50 states and the District of Columbia....

Listed below is the median household income for the 50 states and the District of Columbia.

State, Amount

Alabama 42278 Alaska 67629 Arizona 49254 Arkansas 44922 California 60487 Colorado 60940 Connecticut 70161 Delaware 57522 DC 68277 Florida 46140 Georgia 49555 Hawaii 71223 Idaho 53438 Illinois 54916 Indiana 48060 Iowa 57810 Kansas 53444 Kentucky 42786 Louisiana 42406 Maine 51710 Maryland 76165 Massachusetts 63151 Michigan 52005 Minnesota 67244 Mississippi 35521 Missouri 56630 Montana 51102 Nebraska 56870 Nevada 49875 New Hampshire 73397 New Jersey 65243 New Mexico 46686 New York 54310 North Carolina 46784 North Dakota 60730 Ohio 49644 Oklahoma 47199 Oregon 58875 Pennsylvania 55173 Rhode Island 58633 South Carolina 44929 South Dakota 53053 Tennessee 43716 Texas 53875 Utah 63383 Vermont 60708 Virginia 66155 Washington 59068 West Virginia 39552 Wisconsin 58080 Wyoming 55690

Use Excel to help answer the following questions.

a. Determine the mean, median, and standard deviation.

b. Determine the first and third quartiles.

c. Develop a box plot. Are there any outliers? Do the amounts follow a symmetric distribution or are they skewed? Justify your answer.

d. Organize the distribution of funds into a frequency distribution.

e. Write a brief summary of the results in parts a to d.

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

From the given data

F6 fQUARTILE(B2:B50,1) 1 State Amount 2 Arizona 3 Arkansas44922 4 California 60487 5 Colorado 6 Connectic 70161 7 Delaware 8 DC 9 Florida 10 Georgia 11 Hawaii 12 Idaho 13 Illinois 14 Indiana 15 lowa 16 Kansas 17 Kentucky 42786 18 Louisiana 19 Maine 20 Maryland 21 Massachu 63151 22 Michigan 23 Minnesot67244 24 Mississip 35521 25 Missouri 49254 a) Mean= Median= SD- 55234.63 54916 8942.349 =AVERAGE(B2:B50 MEDIAN(B2:B50 STDEV.P(B2:B50 60940 b) 49254 -QUARTILE(B2:B50,1 57522 68277 46140 49555 71223 53438 54916 60708QUARTILE(B2:B50,3 57810 53444 42406 51710 76165 52005 56630 I Sheet1Sheet2Sheet3

c)

Modified Boxplot of Column1 Col 1) 48060 60730 30000 40000 50000 60000 70000 80000 Sample Value

d) Frequency distribution

The Frequency distribution is
Class Interval
LL UL f
35520 43649.9 4
43650 51779.9 14
51780 59909.9 17
59910 68039.9 9
68040 76169.9 5
Total = 49

e) It is nearly symmetric distribution

0 0
Add a comment
Know the answer?
Add Answer to:
Listed below is the median household income for the 50 states and the District of Columbia....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • My project has to do with the average tuition for in-state students per semester and the proportion of western states th...

    My project has to do with the average tuition for in-state students per semester and the proportion of western states that pay less than $5000 for tuition. Western states include Alaska, Arizona, California, Colorado, Hawaii, Idaho, Montana, Nevada, New Mexico, Oregon, Utah, Washington and Wyoming. I need help with the best method of graphing this and how to create the confidence intervals for 95% for BOTH the average tuition for in state students AND the proportion of western states that...

  • Rate 3% 12% 14% 8% 9% 596 State Rate State 1090 | Kansas 11% Kentucky 13%...

    Rate 3% 12% 14% 8% 9% 596 State Rate State 1090 | Kansas 11% Kentucky 13% Louisiana 1296 | Maine 8% Maryland 690 590 | Michigan 890 | Minnesota 996 | Mississippi 1196 | Missouri 1390 | Montana 1090 | Nebraska 996 | Nevada 996| New Hampshire 590 796 | New Jersey 1290 | South Dakota 996 | Tennessee Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa New Mexico New York North Carolina...

  • C++ how can I input this data correctly? State, Coal, Natural Gas, Fuel Oil, Jet Fuel,HGL...

    C++ how can I input this data correctly? State, Coal, Natural Gas, Fuel Oil, Jet Fuel,HGL Other, Motor Gasoline, Residual Fuel Oil, Nuclear Electric Power, Hydroelectric Power, Wood and Waste, Fuel Ethanol, Geothermal, Solar, Wind Alabama,410.20,715.70,169.40,18.00,44.90,309.10,11.90,417.30,64.50,167.40,23.70,0.10,0.40,0.00 Alaska,16.60,330.90,64.40,104.80,28.60,35.20,0.00,0.00,15.30,2.30,0.00,0.20,0.05,1.60 Arizona,323.90,371.50,149.10,24.90,33.90,324.30,0.00,338.60,66.20,6.60,24.70,0.30,52.80,5.00 Arkansas,246.40,315.70,113.60,8.50,36.40,170.10,0.05,140.40,33.00,77.90,13.00,0.80,0.40,0.00 California,32.10,2248.40,560.40,672.60,383.00,1714.40,145.80,197.80,267.20,137.00,131.30,107.90,267.10,124.70 Colorado,321.50,501.10,103.90,52.50,50.20,263.80,0.00,0.00,17.60,10.60,20.20,0.80,9.50,87.00 Connecticut,2.30,254.70,94.90,9.50,25.10,168.30,0.80,173.40,2.10,25.20,12.90,0.05,4.10,0.10 Delaware,8.20,113.60,14.30,0.70,32.80,54.30,1.10,0.00,0.00,1.80,4.20,0.40,1.10,0.05 DC,0.05,30.10,2.80,0.00,3.45,13.30,0.00,0.00,0.00,0.80,1.00,0.05,0.30,0.00 Florida,426.20,1414.10,312.10,155.40,86.30,1008.80,59.10,306.70,1.60,182.50,69.80,10.10,30.20,0.00 Georgia,399.30,728.00,226.50,29.30,58.40,540.30,8.50,360.60,31.10,214.20,37.40,0.30,10.20,0.00 Hawaii,16.40,0.20,26.20,74.30,20.90,52.80,60.90,0.00,0.80,8.50,4.00,2.40,9.80,5.90 Idaho,2.40,110.30,70.90,5.50,13.20,88.20,0.05,0.00,83.40,22.70,6.70,2.20,0.40,23.80 Illinois,702.50,1045.20,297.30,161.00,241.50,544.70,0.60,1031.30,1.20,24.30,40.30,2.00,2.00,98.40 Indiana,948.40,780.10,235.00,50.20,121.10,357.50,1.70,0.00,3.90,30.40,25.20,4.60,2.40,45.20 Iowa,298.00,317.20,150.10,5.50,84.90,192.10,0.05,49.20,8.50,20.10,16.30,1.30,0.60,185.30 Kansas,253.10,278.10,119.50,8.70,59.80,154.20,3.60,86.20,0.30,6.30,10.70,1.00,0.10,130.30 Kentucky,736.60,284.10,156.20,68.00,123.70,250.80,0.05,0.00,32.10,35.20,17.80,2.70,0.40,0.00 Louisiana,140.50,1697.40,192.20,166.10,1253.90,254.50,37.70,179.40,10.20,136.30,19.50,1.80,1.80,0.00 Maine,2.20,54.50,70.70,6.50,20.30,89.60,3.80,0.00,27.70,90.60,6.60,0.10,0.40,15.40 Maryland,162.90,229.60,98.50,8.80,33.70,306.50,0.70,154.40,12.90,26.00,23.20,0.60,6.80,4.90 Massachusetts,20.10,442.70,144.60,60.90,33.90,315.10,4.70,56.60,6.60,37.40,24.10,0.90,17.50,2.00 Michigan,471.20,927.50,171.70,22.80,119.00,536.90,3.20,330.00,14.40,92.90,37.30,5.20,1.10,43.40 Minnesota,261.20,466.50,160.30,27.30,113.60,296.10,0.80,145.00,11.20,72.50,27.60,1.10,0.60,91.70 Mississippi,61.20,563.40,122.00,97.20,63.00,196.10,3.60,61.70,0.00,56.30,15.00,1.00,0.10,0.00 Missouri,639.90,273.60,188.10,16.60,57.00,362.70,0.10,98.60,11.70,26.40,26.10,0.40,1.90,10.40 Montana,161.90,77.60,50.20,5.40,50.80,61.00,0.00,0.00,93.10,4.40,4.70,0.30,0.10,19.80 Nebraska,240.50,172.90,111.40,7.50,17.70,102.20,0.00,97.80,7.90,4.10,7.10,1.20,0.10,35.10 Nevada,30.80,316.00,64.30,35.00,14.10,131.80,0.00,0.00,16.50,2.50,10.00,32.50,33.30,3.20 New Hampshire,5.30,59.50,40.30,2.50,21.60,80.20,1.50,112.60,10.60,35.80,6.00,0.05,0.50,4.00 New Jersey,17.50,795.10,176.30,187.20,109.40,469.70,25.00,312.60,0.10,28.40,35.90,0.50,22.20,0.20 New Mexico,197.10,259.60,92.30,7.20,30.80,107.80,0.00,0.00,1.40,6.30,8.30,0.50,8.60,33.30 New York,29.70,1335.10,330.10,201.20,98.70,635.30,40.00,434.80,248.20,76.50,46.60,1.20,10.60,36.40 North Carolina,381.80,540.20,190.90,14.90,81.50,531.00,0.50,447.50,40.80,110.20,36.70,1.00,33.40,0.10 North Dakota,394.60,105.80,84.80,5.60,27.40,49.60,0.00,0.00,17.70,2.60,3.80,1.00,0.05,75.40 Ohio,825.30,996.90,290.50,67.40,180.50,576.80,3.90,175.90,4.60,52.70,40.10,3.40,1.90,11.50 Oklahoma,221.80,738.40,175.00,52.60,83.30,222.40,2.60,0.00,23.80,31.00,15.50,0.05,0.10,185.30 Oregon,19.40,249.80,100.20,28.60,24.60,178.50,0.80,0.00,319.00,59.40,13.50,2.90,3.10,66.10 Pennsylvania,734.80,1363.80,327.30,69.20,188.70,556.60,3.50,867.30,21.90,104.70,39.80,2.20,4.10,32.10...

  • The accompanying table shows the average price for a gallon of gas for the 50 states...

    The accompanying table shows the average price for a gallon of gas for the 50 states during April 2012. State Price per Gallon Alaska 4.36 Alabama 3.79 Arkansas 3.76 Arizona 3.87 California 4.22 Colorado 3.89 Connecticut 4.17 Delaware 3.89 Florida 3.94 Georgia 3.83 Hawaii 4.61 Iowa 3.75 Idaho 3.77 Illinois 4.06 Indiana 3.95 Kansas 3.71 Kentucky 3.92 Louisiana 3.80 Massachusetts 3.91 Maryland 3.96 Maine 4.00 Michigan 3.93 Minnesota 3.72 Missouri 3.67 Mississippi 3.78 Montana 3.77 North Carolina 3.89 North Dakota...

  • JAVA: File USCapitals.txt is here: Alabama, Montgomery Alaska, Juneau Arizona, Phoenix Arkansas, Little Rock California, Sacramento...

    JAVA: File USCapitals.txt is here: Alabama, Montgomery Alaska, Juneau Arizona, Phoenix Arkansas, Little Rock California, Sacramento Colorado, Denver Connecticut, Hartford Delaware, Dover Florida, Tallahassee Georgia, Atlanta Hawaii, Honolulu Idaho, Boise Illinois, Springfield Indiana, Indianapolis Iowa, Des Moines Kansas, Topeka Kentucky, Frankfort Louisiana, Baton Rouge Maine, Augusta Maryland, Annapolis Massachusettes, Boston Michigan, Lansing Minnesota, Saint Paul Mississippi, Jackson Missouri, Jefferson City Montana, Helena Nebraska, Lincoln Nevada, Carson City New Hampshire, Concord New Jersey, Trenton New York, Albany New Mexico, Santa Fe...

  • Write a C# windows forms program to create a States and Capitals guessing game. A method...

    Write a C# windows forms program to create a States and Capitals guessing game. A method in your program should generate a random number between 1 and 50. Your program should use this number to represent one of the 50 U.S states and then display the name of that state. The user will guess the capital of that state. Another method in your program should get the users answer and check to see whether it is correct. Yet another method...

  • Location Percent Obesity Median Income Alabama 33.5 49,936 Alaska 29.7 68,734 Arizona 28.9 62,283 Arkansas 35.9...

    Location Percent Obesity Median Income Alabama 33.5 49,936 Alaska 29.7 68,734 Arizona 28.9 62,283 Arkansas 35.9 49,781 California 24.7 70,489 Colorado 21.3 73,034 Connecticut 26.3 72,812 Delaware 30.7 65,012 District of Columbia 21.7 85,750 Florida 26.2 54,644 Georgia 30.5 55,821 Hawaii 22.1 80,108 Idaho 28.9 58,728 Illinois 29.3 70,145 Indiana 32.7 59,892 Iowa 30.9 68,718 Kansas 31.3 63,938 Kentucky 31.6 54,555 Louisiana 34.9 49,973 Maine 28.2 58,663 Maryland 29.6 86,223 Massachusetts 23.3 86,345 Michigan 30.7 60,449 Minnesota 27.6 71,817 Mississippi...

  • In Python The file Senate113_sorted.txt contains a list of the 100 US Senators that made up the 1...

    In Python The file Senate113_sorted.txt contains a list of the 100 US Senators that made up the 113th Senate, sorted in alphabetical order by Senator last name. Write a function named different_party that accepts one argument, a file name, and returns a list of US states whose Senators come from 2 different political parties (as indicated by D, R, or I). Here's a few rows from the file Lamar Alexander,Tennessee,R Kelly Ayotte,New Hampshire,R Tammy Baldwin,Wisconsin,D John Barrasso,Wyoming,R Max Baucus,Montana,D Mark...

  • Please explain how each step is performed. TABLE 1. SOFT DRINK DEMAND DATA State Cans/Capita/Yr 6-Pack...

    Please explain how each step is performed. TABLE 1. SOFT DRINK DEMAND DATA State Cans/Capita/Yr 6-Pack Price ($) IncomelCapita ($1,000) Mean Temp. (F) Alabama Arizona Arkansas California Colorado Connecticut Delaware 200 150 237 135 1.99 1.93 15.3 18.1 25.2 16.2 1.99 242 295 64 Georgia Idaho Illinois Indiana lowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island...

  • For the data below** a. Make a scatterplot, where y=mortality and x= latitude. b. Find the...

    For the data below** a. Make a scatterplot, where y=mortality and x= latitude. b. Find the least-squares line relating mortality (y) to latitude (x). c. Plot the least-squares line on the graph from part a. d. Is the slope positive or negative? Comment on what this means. Latitude Mortality 33.0 34.5 state 1. Alabama 2. Arizona 3. Arkansas 4. California 5. Colorado 6. Connecticut . DeLaware 8. Florida 9. Georgia 10. Idaho 11. Illinois 12. Indiana 13. Iowa 14. Kansas...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT