Verified Document

Data Set And Airlines Essay

¶ … 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

"Suppose Procter & Gamble sells about 20 million bars of soap per week, but the demand is not constant and production management would like to get a better handle on how sales are distributed over the year. Let the following sales figures given in units of million bars represent the sales of bars per week over 1 year (in no particular order)." ( Kaplan University, 2016 p 3).

Bin

Frequency

12.2

1

16.14286

6

20.08571

16

24.02857

17

27.97143

9

31.91429

1

35.85714

1

More

1

The graph reveals that the sales of 24 of million gallon of unit per week and 20.8 million per week are more prominent in the sales. Moreover, the sales of 16 million units and 27 million units are also frequent, however, the sales of Procter and Gamble are not regular in the whole year because the sales are not constant.

Reference

Kaplan University (2016). Using Data Analysis in Excel. USA

Cite this Document:
Copy Bibliography Citation

Related Documents

Data Warehousing and Data Mining
Words: 2013 Length: 6 Document Type: Term Paper

Data Warehousing and Data Mining Executive Overview Analytics, Business Intelligence (BI) and the exponential increase of insight and decision making accuracy and quality in many enterprises today can be directly attributed to the successful implementation of Enterprise Data Warehouse (EDW) and data mining systems. The examples of how Continental Airlines (Watson, Wixom, Hoffer, 2006) and Toyota (Dyer, Nobeoka, 2000) continue to use advanced EDW and data mining systems and processes to streamline

Data Warehousing for an Airline
Words: 3749 Length: 10 Document Type: Research Proposal

The data load for CRM systems is less significant than those of Accounting and Financial systems and applications. Those specific fields captured by customers are often compressed into measures of activity as well, and as a result the data load is less significant than in the areas of Accounting and Financial Systems and Reservation and Booking Systems. Even when customized reports are created based on CRM data; the data

Airline Transportations on Economy Impacts of Airline
Words: 3473 Length: 10 Document Type: Essay

Airline Transportations on Economy Impacts of Airline Transportations on Economy INTRIDUCTION The rapid rise in the use of air transportation since deregulation in 1978, coupled with the unprecedented financial crisis in the airline industry after the September 11 terrorist attacks raises questions on how vulnerable the nation is to significant interruptions to its air transportation system[footnoteRef:1]. In an attempt to better understand its national importance; this paper examines some aspects of how the

Airline Industry Analysis
Words: 3663 Length: 10 Document Type: Term Paper

Airline Industry Analysis This report aims to present a summary of findings for a research study regarding the airline industry. The objective of this project was to first, gain new experience in the analysis process of an entire industry from an economic and business perspective as well as an environmental and social viewpoint. Secondly, the research attempts to provide direction for potential employment opportunities within the various aspects of the direct

Airline Industry There Are Two
Words: 2188 Length: 6 Document Type: Term Paper

One-to-one marketing allows premium pricing as well as increased sales volume to particular unique micro markets. Studies show that as customer satisfaction and loyalty increases, consumers are less sensitive to price changes. Generally, they are willing to pay more for their preferred brand because they perceive some unique value that other alternatives do not provide (Giddens, 2002). Long-haul international business travelers and short/medium-haul domestic business travelers are the customers that

Airline Industry Analysis the Past
Words: 3864 Length: 10 Document Type: Term Paper

S. are seeing modest improvements in economic indicators. The social environment is favorable for air travel. The mode still holds tremendous cachet with consumers and is favored when consumers can afford it. There is some consideration that the airline business is a major contributor to greenhouse gases and therefore global warming, but as of yet the industry has not come under serious public pressure as it is generally viewed by the

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now