Year 2005 2006 2007 2008 2009 Electronic 13.23 1.97 2.77 -50 81.65 Electronics Utilities 9.36 32.33 21.03 -35.27 14.71 Utilities Mean Standard Error 9.0975 Mean 27.1526829169 Standard Error 8.2 14.9412371197 Standard Deviation Sample Variance Standard 54.3053658337 Deviation Sample 2949.07275833 Variance 29.8824742394 892.962266667 B. THE ELECTRIC FUND WITH A MEAN OF 9.924 C. STANDARD DEVIATION IS PROBABLY USED MORE OFTEN THAN ANY OTHER MEASURE TO GAUGE A FUNDS RISK. STANDARD DEV SIMPLE QUANTIFIE D. E QUANTIFIES HOW MUCH A SERIES OF NUMBERS, SUCH AS FUND RETURNS, VARIES AROUND ITES MEAN, OR AVERAGE 91 Attendance Frequency 1,000 ^ 1,250 5 1,250 ^ 1,500 6 1,500^ 1,750 10 1,750 ^ 2,000 20 2,000 ^ 2,250 15 2,250 ^ 2,500 4 calculate the mean attendance calculate the variance and the standard deviation Metropolitan area Washington, D.C. Seattle Baltimore Boston Denver San Francisco San Diego Sacramento Los Angeles Chicago Philadelphia Minneapolis New York Atlanta Dallas Phoenix Portland Cincinnati Houston Columbus St. Louis Miami Detroit Cleveland Tampa Pittsburgh Income Unemployment Debt Payments 103.5 6.3 1,285 81.7 8.5 1,135 82.2 8.1 1,133 89.5 7.6 1,133 75.9 8.1 1,104 93.4 9.3 1,098 75.5 10.6 1,076 73.1 12.4 1,045 68.2 12.9 1,024 75.1 9.7 1,017 78.3 9.2 1,011 84 7 1,011 78.3 9.3 989 71.8 10.3 986 68.3 8.4 970 66.6 9.1 957 71.2 10.2 948 69.5 9.3 920 65.1 8.7 889 68.6 8.3 888 68.3 9.9 886 60.2 14.5 867 69.8 15.7 832 64.8 9.6 812 59.4 12.6 791 63 8.3 763 State Alaska Alabama Arkansas Arizona California Colorado Connecticut Delaware Florida Georgia Hawaii Iowa Idaho Illinois Indiana Kansas Kentucky Louisiana Massachusetts Maryland Maine Michigan Minnesota Missouri Mississippi Montana North Carolina North Dakota Nebraska New Hampshire New Jersey New Mexico Nevada New York Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Virginia Vermont Washington Wisconsin West Virginia Wyoming Regular 4.36 3.79 3.76 3.87 4.22 3.89 4.17 3.89 3.94 3.83 4.61 3.75 3.77 4.06 3.95 3.71 3.92 3.80 3.91 3.96 4.00 3.93 3.72 3.67 3.78 3.77 3.89 3.84 3.84 3.87 3.80 3.79 3.96 4.15 3.79 3.68 4.08 3.97 3.98 3.72 3.82 3.77 3.81 3.71 3.89 3.99 4.13 3.84 3.94 3.63 Player Philip Rivers Jay Cutler Eli Manning Kurt Warner Matt Schaub Matt Cassel Peyton Manning Drew Brees Donovan McNabb Brett Favre JaMarcus Russell Carson Palmer Joe Flacco Aaron Rodgers David Garrard Tom Brady Matt Ryan Ben Roethlisberger Marc Bulger Jake Delhomme Matt Hasselbeck Alex Smith Matthew Stafford Ryan Fitzpatrick Jason Campbell Mark Sanchez Vince Young Brady Quinn Josh Freeman Kyle Orton Chad Henne Tony Romo 1.Use excel to compute and interpret the mean and the median salary for a quarterback Salary (in $million) 25.5566 22.0441 20.5000 19.0047 17.0000 15.0052 14.0057 12.9895 12.5073 12.0000 11.2554 9.5000 8.6018 8.6000 8.5000 8.0073 7.9073 7.7516 6.5073 6.3250 6.2562 4.0073 3.1000 2.9956 2.8648 2.5450 2.1673 2.0079 1.3800 1.0950 0.9503 0.6260 State Regular 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 3.84 Nebraska 3.84 New Hampshire 3.87 New Jersey 3.80 New Mexico 3.79 Nevada 3.96 New York 4.15 Ohio 3.79 Oklahoma 3.68 Oregon 4.08 Pennsylvania 3.97 Rhode Island 3.98 South Carolina 3.72 South Dakota 3.82 Tennessee 3.77 Texas 3.81 Utah 3.71 Virginia 3.89 Vermont 3.99 Washington 4.13 Wisconsin 3.84 West Virginia 3.94 Wyoming 3.63 a. Construct a box plote for the gasoline price and use it to identify outliers, if any. b. Confirm your analysis by using zscores to determine if there are nay outliers in the gasoline price. Year 2005 2006 2007 2008 2009 Electronic 13.23 1.97 2.77 -50 81.65 Electronics Utilities 9.36 32.33 21.03 -35.27 14.71 Utilities Mean Standard Error 9.0975 Mean 27.1526829169 Standard Error 8.2 14.9412371197 Standard Deviation Sample Variance Standard 54.3053658337 Deviation Sample 2949.07275833 Variance 29.8824742394 892.962266667 B. THE ELECTRIC FUND WITH A MEAN OF 9.924 C. STANDARD DEVIATION IS PROBABLY USED MORE OFTEN THAN ANY OTHER MEASURE TO GAUGE A FUNDS RISK. STANDARD DEV SIMPLE QUANTIFIE D. E QUANTIFIES HOW MUCH A SERIES OF NUMBERS, SUCH AS FUND RETURNS, VARIES AROUND ITES MEAN, OR AVERAGE 91 Attendance Frequency 1,000 ^ 1,250 5 1,250 ^ 1,500 6 1,500^ 1,750 10 1,750 ^ 2,000 20 2,000 ^ 2,250 15 2,250 ^ 2,500 4 calculate the mean attendance calculate the variance and the standard deviation Metropolitan area Washington, D.C. Seattle Baltimore Boston Denver San Francisco San Diego Sacramento Los Angeles Chicago Philadelphia Minneapolis New York Atlanta Dallas Phoenix Portland Cincinnati Houston Columbus St. Louis Miami Detroit Cleveland Tampa Pittsburgh Income Unemployment Debt Payments 103.5 6.3 1,285 81.7 8.5 1,135 82.2 8.1 1,133 89.5 7.6 1,133 75.9 8.1 1,104 93.4 9.3 1,098 75.5 10.6 1,076 73.1 12.4 1,045 68.2 12.9 1,024 75.1 9.7 1,017 78.3 9.2 1,011 84 7 1,011 78.3 9.3 989 71.8 10.3 986 68.3 8.4 970 66.6 9.1 957 71.2 10.2 948 69.5 9.3 920 65.1 8.7 889 68.6 8.3 888 68.3 9.9 886 60.2 14.5 867 69.8 15.7 832 64.8 9.6 812 59.4 12.6 791 63 8.3 763 State Alaska Alabama Arkansas Arizona California Colorado Connecticut Delaware Florida Georgia Hawaii Iowa Idaho Illinois Indiana Kansas Kentucky Louisiana Massachusetts Maryland Maine Michigan Minnesota Missouri Mississippi Montana North Carolina North Dakota Nebraska New Hampshire New Jersey New Mexico Nevada New York Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Virginia Vermont Washington Wisconsin West Virginia Wyoming Regular 4.36 3.79 3.76 3.87 4.22 3.89 4.17 3.89 3.94 3.83 4.61 3.75 3.77 4.06 3.95 3.71 3.92 3.80 3.91 3.96 4.00 3.93 3.72 3.67 3.78 3.77 3.89 3.84 3.84 3.87 3.80 3.79 3.96 4.15 3.79 3.68 4.08 3.97 3.98 3.72 3.82 3.77 3.81 3.71 3.89 3.99 4.13 3.84 3.94 3.63 Player Philip Rivers Jay Cutler Eli Manning Kurt Warner Matt Schaub Matt Cassel Peyton Manning Drew Brees Donovan McNabb Brett Favre JaMarcus Russell Carson Palmer Joe Flacco Aaron Rodgers David Garrard Tom Brady Matt Ryan Ben Roethlisberger Marc Bulger Jake Delhomme Matt Hasselbeck Alex Smith Matthew Stafford Ryan Fitzpatrick Jason Campbell Mark Sanchez Vince Young Brady Quinn Josh Freeman Kyle Orton Chad Henne Tony Romo 1.Use excel to compute and interpret the mean and the median salary for a quarterback Salary (in $million) 25.5566 22.0441 20.5000 19.0047 17.0000 15.0052 14.0057 12.9895 12.5073 12.0000 11.2554 9.5000 8.6018 8.6000 8.5000 8.0073 7.9073 7.7516 6.5073 6.3250 6.2562 4.0073 3.1000 2.9956 2.8648 2.5450 2.1673 2.0079 1.3800 1.0950 0.9503 0.6260 State Regular 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 3.84 Nebraska 3.84 New Hampshire 3.87 New Jersey 3.80 New Mexico 3.79 Nevada 3.96 New York 4.15 Ohio 3.79 Oklahoma 3.68 Oregon 4.08 Pennsylvania 3.97 Rhode Island 3.98 South Carolina 3.72 South Dakota 3.82 Tennessee 3.77 Texas 3.81 Utah 3.71 Virginia 3.89 Vermont 3.99 Washington 4.13 Wisconsin 3.84 West Virginia 3.94 Wyoming 3.63 a. Construct a box plote for the gasoline price and use it to identify outliers, if any. b. Confirm your analysis by using zscores to determine if there are nay outliers in the gasoline price