I have the following data which regards to travel time to work (minutes) for adu
ID: 2958628 • Letter: I
Question
I have the following data which regards to travel time to work (minutes) for adults employed outside the home:Alabama 23.6
Alaska 17.7
Arizona 25
Arkansas 20.7
California 26.8
Colorado 23.9
Connecticut 24.1
Delaware 23.6
Florida 25.9
Georgia 27.3
Hawaii 25.5
Idaho 20.1
Illinois 27.9
Indiana 22.3
Iowa 18.2
Kansas 18.5
Kentucky 22.4
Louisiana 25.1
Maine 22.3
Maryland 30.6
Massachusetts 26.6
Michigan 23.4
Minnesota 22
Mississippi 24
Missouri 22.9
Montana 17.6
Nebraska 17.7
Nevada 24.2
NewHampshire 24.6
NewJersey 29.1
New Mexico 20.9
New York 30.9
North Carolina 23.4
North Dakota 15.5
Ohio 22.1
Oklahoma 20
Oregon 21.8
Pennsylvania 25
Rhode Island 22.3
South Carolina 22.9
South Dakota 15.9
Tennessee 23.5
Texas 24.6
Utah 20.8
Vermont 21.2
Virginia 26.9
Washington 25.2
West Virginia 25.6
Wisconsin 20.8
Wyoming 17.9
Dist. Of Columbia 29
I need to make a histogram with width 2 minutes starting at 14 minutes so the first bar is 14.9 to 15.9 minutes. how would I make a histogram on the program NCSS 2007 or Microsoft Excel?
Explanation / Answer
For excel: You need to install the Data Analysis pack, if you don't have that then this would be a good tutorial: http://www.math.kent.edu/~honli/teaching/statistics/Chapter2/Excell_Histogram.html If you already have it then go to "tools" then "data analysis" and choose "histogram" your "bin" would be (i think) 14 16 18 . . etc