Question

• Alabama 89.3%
• Alaska 78.2%
• Arizona 78%
• Arkansas 88%
• California 82.7%
• Colorado 79.1%
• Connecticut 87.9%
• Delaware 86.9%
• Florida 82.3%
• Georgia 80.6%
• Hawaii 82.7%
• Idaho 79.7%
• Illinois 87%
• Indiana 83.8%
• Iowa 91%
• Kansas 86.5%
• Kentucky 89.7%
• Louisiana 78.1%
• Maine 86.9%
• Maryland 87.7%
• Massachusetts 88.3%
• Michigan 80.2%
• Minnesota 82.7%
• Mississippi 83%
• Missouri 88.3%
• Montana 85.8%
• Nebraska 89.1%
• Nevada 80.9%
• New Hampshire 88.9%
• New Jersey 90.5%
• New Mexico 71.1%
• New York 81.8%
• North Carolina 86.6%
• North Dakota 87.2%
• Ohio 84.2%
• Oklahoma 82.6%
• Oregon 76.7%
• Pennsylvania 86.6%
• Rhode Island 84.1%
• South Carolina 83.6%
• South Dakota 83.7%
• Tennessee 89.8%
• Texas 89.7%
• Utah 86%
• Vermont 89.1%
• Virginia 86.9%
• Washington 79.4%
• West Virginia 89.4%
• Wisconsin 88.6%
• Wyoming 86.2%
• THESE ARE GRADUATION RATES FOR EACH OF THE 50 states. Here are the instructions:
• ample Data—Include a 5x10 table including your 50 values in your report. You must provide ALL of your sample data.
• Problem Computations—For the topic you chose, you must answer the following:
• Determine the mean and standard deviation of your sample.
• Find the 80%, 95%, and 99% confidence intervals.
• Make sure to list the margin of error for the 80%, 95%, and 99% confidence interval.
• Create your own confidence interval (you cannot use 80%, 95%, and 99%) and make sure to show your work. Make sure to list the margin of error.

Answer 1

data

89.30   82.70   88.30   71.10   83.70
78.20   79.70   80.20   81.80   89.80
78.00   87.00   82.70   86.60   89.70
88.00   83.80   83.00   87.20   86.00
82.70   91.00   88.30   84.20   89.10
79.10   86.50   85.80   82.60   86.90
87.90   89.70   89.10   76.70   79.40
86.90   78.10   80.90   86.60   89.40
82.30   86.90   88.90   84.10   88.60
80.60   87.70   90.50   83.60   86.20

margin of error and confidence interval are in lower and upper column

alpha = 1- confidence level

hence below are 80%,95% and 99% CI

Xbar +- margin of error

margin of error = t * sd/sqrt(n)

where t = t.inv.2t(alpha,df)

df =n-1

= 49

for 90%