Data Set and Airlines

¶ … Excel

"According to T-100 Domestic Market, the top seven airlines in the United States by domestic boarding in a recent year were Southwest Airlines with 81.1 million, Delta Airlines with 79.4 million, American Airlines with 72.6 million, United Airlines with 56.3 million, Northwest Airlines with 43.3 million, US Airways with 37.8 million, and Continental Airlines with 31.5 million. Using Excel, construct a pie chart and a bar graph to depict this information". ( Kaplan University, 2016 p 1).

Pie Chart

Bar Graph

Department of the Interior releases figures on mineral production. The following are the 15 leading states in nonfuel mineral production in the United States in 2008". ( Kaplan University, 2016 p 2).

State

Value ($Billon)

Arizona

Nevada

Florida

Utah

California

Texas

Minnesota

Alaska

Missouri

Colorado

Michigan

Wyoming

Georgia

New Mexico

Pennsylvania

1.68

Descriptive Statistics

Value ($Billion)

Mean

3,613333

Standard Error

0,496542

Median

2,98

Mode

#N/A

Standard Deviation

1,923099

Sample Variance

3,69831

Kurtosis

3,583069

Skewness

1,783901

Range

7,27

Minimum

1,68

Maximum

8,95

Sum

54,2

Count

15

Confidence Level (95,0%)

1,064977

The Mean value represents the average value of the figures of mineral production in the selected 15 states and the mean is $3.61 Billion. The minimum is the least value which is $1.68 Billion while the maximum is the highest value, which is $8.95 billion. The standard error is the amount that deviates from the mean which is $0.49 Billion. The data is positively skewed, and is 1.78. The mode is the data set that occurs frequently, and standard deviation describes the dispersion or variation from the data set.

Question 3