Explore BrainMass
Share

Business statistics

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Construct a column chart for the data in the excel file state unemployment rates to allow a comparison of the June rate with historical highs and lows. Would any other charts be better to visually covey this information? Why or why not?

State Unemployment Rates

State June 2008 Rate Historical High Historical Low
Alabama 4.7 14.4 3.3
Alaska 6.8 11.5 5.9
Arizona 4.8 11.5 3.6
Arkansas 5 10.2 4.1
California 6.9 11 4.7
Colorado 5.1 9.1 2.5
Connecticut 5.4 10 2.1
Delaware 4.2 8.2 2.9
District of Columbia 6.4 11.4 4.8
Florida 5.5 9.7 3.3
Georgia 5.7 8.3 3.4
Hawaii 3.8 10.2 2.2
Idaho 3.8 9.4 2.7
Illinois 6.8 12.9 4.1
Indiana 5.8 12.8 2.6
Iowa 4 8.5 2.6
Kansas 4.3 7.4 2.9
Kentucky 6.3 12.1 4
Louisiana 3.8 12.9 3.2
Maine 5.3 9 3
Maryland 4 8.3 3.3
Massachusetts 5.2 10.9 2.7
Michigan 8.5 16.9 3.2
Minnesota 5.3 9 2.5
Mississippi 6.9 13.7 4.9
Missouri 5.7 10.5 2.6
Montana 4.1 8.7 3.1
Nebraska 3.3 6.8 2.2
Nevada 6.4 10.7 4.1
New Hampshire 4 7.7 1.9
New Jersey 5.3 10.6 3.5
New Mexico 3.9 9.9 3.1
New York 5.3 10.5 4
North Carolina 6 10.2 3.1
North Dakota 3.2 6.9 2.5
Ohio 6.6 13.8 3.9
Oklahoma 3.9 9.4 2.7
Oregon 5.5 12.1 4.7
Pennsylvania 5.2 12.9 4
Rhode Island 7.5 9.7 2.9
South Carolina 6.2 11.4 3.1
South Dakota 2.8 5.9 2.4
Tennessee 6.5 12.4 3.8
Texas 4.4 9.3 4.1
Utah 3.2 9.7 2.4
Vermont 4.7 9 2.2
Virginia 4 7.8 2.2
Washington 5.5 12.2 4.4
West Virginia 5.3 18.2 4.3
Wisconsin 4.6 11.8 2.9
Wyoming 3.2 10.1 1.9

© BrainMass Inc. brainmass.com October 17, 2018, 2:50 am ad1c9bdddf
https://brainmass.com/statistics/statistical-figures/business-statistics-398172

Attachments

Solution Summary

Excel file shows column chart for the data of state unemployment rates to allow a comparison of the June rate with historical highs and lows.

$2.19
Similar Posting

Business Statistics: Mean, Standard Deviations

I could use some help with the following. Could you please explain how you get the answer to the following questions in detail please so I can compare them to mine? I do not understand my book very well and I want to make sure I understand them correctly before I turn them in. Thank you

My first question is;

The mean starting salary for college graduates in the spring of 2004 was $36,280.
I am asking to assume the distribution of starting salaries follows the normal distribution with a standard deviation of $3,300.

What percentage of the graduates has starting salaries?

a) Between $35,000 and 45,000
b) More than $45,000
c) Between $40,000 and 45,000

My second question is;

I am ask to assume a binomial probability distribution with n=40 and (pi) =.55 and compute the following
a) The mean and standard deviation of random variable
b) The probability that X is 25 or greater
c) The probability that X is 15 or less
d) The probability that X is between 15 and 25 inclusive

My third question;

A recent study by the Greater Los Angeles Taxi Drivers Association showed that the mean fare charged for service from Hermosa Beach to the Los Angeles International Airport is $18.00 and the standard deviation is $3.50.

I am ask to select a sample of 15 fares and answer a and b. Please explain how you got your answer so I can compare it to mine.

a) What is the likelihood that the sample mean is btw $17.00 and 20.00?
b) What must you assume to make the above calculation?

My last question;
Dr. Patton is a Professor of English. Recently he counted the number of misspelled words in a group of student's essays. For his class of 40 students, the mean number of misspelled words was 6.05 and the standard deviation 2.44 per essay.

I need help constructing a 95 percent confidence interval for the mean number of misspelled words in the population of student essays.

View Full Posting Details