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