Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
¶ … 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 ANALYSIS Problem 1Answer the question: Does practice time make a difference? Support your answer with your findings.The ANOVA single factor test was used to determine whether there was a difference in the swimming time by practice time. ANOVA was calculated using the following steps:i) Present the data in three columns by practice time as shown:less than 15 (1)15-25 (2)greater than 25(3)58.764.46855.355.865.961.858.754.749.554.753.664.552.758.76167.858.765.761.665.751.458.766.553.654.656.75951.555.454.751.561.454.856.957.2ii) State the null and alternative hypothesesHo: all means
Hospice Utilization: Survey Findings Survey Data Analysis Barriers to Hospice Care Utilization: Survey Findings Barriers to Hospice Care Utilization: Survey Findings Hospice care has been shown to improve patient quality of life, reduce depression, prolong life (reviewed by McGorty and Bornstein, 2003), and reduce the costs associated with end of life (EOL) care (Temel et al., 2010). As McGorty and Bornstein (2003) point out, however, hospice care in the United Kingdom is more
Business Intelligence and Data Analysis Tableau Project Dashboard Health insurance coverage for people below 65 among states Graphical features used Descriptive and predictive analytics used Population of Insured and Uninsured People aged 65 and below The project evaluates the rates of insurance coverage for people aged 65 and below between 2010 and 2012 in all states in the United States. The report analyzes the data using several statistical tools such as descriptive statistics, predictive statistics, and linear
3. SWOT Analysis The SWOT analysis reveals the strengths, weaknesses, opportunities and threats which are likely to affect the outcome of launching the electronic commerce at Blue Cut Fashion. The strengths and weaknesses derive from internal features and amongst others, may refer to financial highlights and previous expertise. The opportunities and threats are generated by the external environment and may refer to commercial trends and technological advancements. All these are presented
Mathematics a) Spreadsheet Data Analysis b) State hypotheses: Ho: Type of soft drink and resident are independent. (null hypothesis) Ha: Type of soft drink and resident are not independent. (alternate hypothesis) c) Conduct chi-square test of independence at 0.05 significance level: = 0.05 d) Calculate degrees of freedom: Number of rows = 2, Number of columns = 2 Degrees of freedom (df) = (Number of rows - 1) x (Number of columns - 1) = (2-1)(2-1)
Software Tools for Qualitative Research Data Analysis Software Packages Exploring Options for Research Software Tools As a quick reference tool, I created a table to compare primary features of three data analysis software packages: NVivo 10, Atlas.ti 7; and HyperRESEARCH (which also includes HyperTRANSCRIBE as a separate complementary option). This information is shown in Table 1, which is provided at the end of this work. After reviewing the software packages for data analysis, I