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

Warehousing Book for an Airlines
Words: 2646 Length: 7 Document Type: Essay

The results of this effort needs to be shared electronically online to ensure everyone is kept informed about its progress. Memo: With the data warehouse project entering the requirements definition phase, it's important to start setting the foundation for users across the network of retail stores to begin having ownership of the new system. Getting them interested in the new data warehouse, and to take ownership of it will require getting

Impact of Fue Hedging on Airlines Profitability
Words: 5008 Length: 15 Document Type: Literature Review

Fuel Hedging and Airline Profitability -- Literature Review Airline operations are usually affected by several factors, especially the prices of oil and exchange rates since they have the capability of making things more complex. Fuel prices are some of the major risks that generate complexities in the operations of airlines and have considerable impacts on airline profitability. Consequently, airlines develop and adopt several measures for risk mitigation in order to enhance

Airlines Going Green Major Airlines
Words: 4560 Length: 13 Document Type: Research Paper

For some airlines, it is not that they do not care about the environment but only that they do not see going green as financially feasible (Friends, 2007; National, 2007; Kim, et al., 2007). If they have incentives, that can affect how they feel and whether they will go green. If there are few incentives, most airlines will decide not to go green because there will not be a

Data Warehouse a Strategic Weapon of an Organization
Words: 19027 Length: 50 Document Type: Term Paper

Growth Aided by Data Warehousing Adaptability of data warehousing to changes Using existing data effectively can lead to growth Uses of data warehouses for Public Service Getting investment through data warehouse Using Data Warehouse for Business Information Ongoing changes in Data Warehousing The Origin of Data Warehousing and its current importance Relationship between new operating system and data warehousing Developing Organizations through Data Warehousing Telephone and Data Warehousing Choose your own partner Data Warehousing for Societal Causes Updating inaccessible data Data warehousing for investors Usefulness

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