Managing data

I attach how it should be if you have any questions please let me know

Managing data

Contents
Task 1.........................................................................................................................................................3
TASK 2.......................................................................................................................................................5

Task 1
1. Least expensive flight:
In order to fly to Atlanta, the least expensive flight is from Miami city. The cost from this
city is of 249.6. While in the aspect of flying to Salt Lake City the least expensive flight
is from Las Vegas in which cost is of 159.6.
2. Summary statistics and brief explain
Cost to Fly to
Atlanta
Cost to Fly
to Salt Lake
City
Mean 356.7285714 Mean 400.95
Standard Error 19.85196707 Standard Error
36.7747177
1
Median 339.85 Median 420.1
Mode 359.6 Mode #N/A
Standard
Deviation 74.27925923 Standard Deviation
137.598394
2
Sample
Variance 5517.408352 Sample Variance
18933.3180
8
Kurtosis 1.783213409 Kurtosis
-
0.95081431
1
Skewness 1.178319113 Skewness
-
0.17655926
8
Range 290 Range 458.8
Minimum 249.6 Minimum 159.6
Maximum 539.6 Maximum 618.4
Sum 4994.2 Sum 5613.3
Count 14 Count 14

3. How much is the value of percentile p?
Data
15
20
25
30
35
40
45

50
55
60
65
70
75
80
The 15th percentile value is 21.25.
Values Percentiles
10th 17.5
25th 28.75
50th 47.5
75th 66.25
90th 77.5
4. Calculation of quartile:
Sum of total numbers: 665
Q1: 665*1/3
= 221.67
Q2: 665*2/3
= 443.33
Q3: 665*3/5
= 399

TASK 2
Compute the GEOMEAN of the data set
Year
Return
(%)
1 -22.1
2 28.7
3 10.9
4 4.9
5 15.8
6 5.5
7 -37
8 26.5
9 15.1
10 2.1
12.73
The GEOMEAN for above data set is of 12.73 which has been measured by help of a formula
which is as =PRODUCT (1+B2:B11) ^ (1/COUNT (B2:B11))-1.
Reason to use GEOMEAN-
In the context of above data set this mean method has been implied because by help of such
value it becomes easier to find out more accurate measurement of true return by considering year
by year values. As in above data set, there is information related to year and return in which
GEOMEAN is suitable to compute effective outcome.