The file Energy contains the per capita energy consumption, in kilowatt- hours, for each of the 50 states and the District of Columbia during a recent year.

b. What proportion of these states has per capita energy consumption within 1

standard deviation of the mean, within 2 standard deviations of the mean, and

within 3 standard deviations of the mean?

c. Compare your findings with what would be expected based on the empirical rule. Are

you surprised at the results in ( b)?

(I'm having trouble with B, and I know that can't do the other problems until I figure it out. This is on Excel.

Wyoming24567D.C20073Kentucky19970South Carolina18865Alabama18399Louisiana17902Idaho17453Tennessee16993Washington16357Indiana16277Mississippi15885Arkansas15595Texas15059North Carolina15033West Virginia15022Ohio14593Nevada14511Georgia14465North Dakota14380Oregon14172Delaware13926Oklahoma13918Montana13743Nebraska13691Virginia13536Iowa13255Kansas12743Missouri12614Florida12393Wisconsin12103Arizona12067Minnesota12019Maryland11425Illinois10903South Dakota10806Michigan10491New Mexico10344Utah10273Colorado10002Maine9532Vermont9309Connecticut9081New Jersey8667Alaska8543New Hampshire8095Pennsylvania8006Hawaii7913Massachusetts7744New York7135Rhode Island6716California6396