Question

Appreciate if you can answer this ONE QUESTION COMPLETELY and give me a detailed working with explanation for me to understand. Once completed so long as my doubts are cleared and the solutions are correct, I will definitely vote up. Some of the question are similiar to take a look carefully before you answer as it's very important for me.

Thank you.

Question 5 The management team of a US-based airline is considering making changes to its checked-in baggage allowance policy. As an information gathering exercise, the team decides to record the weight (in kilograms) for many samples of luggage items checked in on the various flights during the same week. Below is a random sample data set (sample size-8): 20.5 25.123.3 22.1 17.4 16.9 20.9 22.4 (a) Using MS Excel Analysis ToolPak, generate and show a summary of the following descriptive statistics: Mean, Median, Standard deviation, Variance, Skewness, Range (2 marks) (b) Using MS Excel function, determine the 80h percentile statistic. You need to show a (2 marks) screenshot of the Excel output results. Use R commands to compute the following descriptive statistics: Mean, Median, Standard deviation, Variance, First guatile, Third quartile, (c) Interquatile nge, 80th percentile You are required to show screenshots of the related R commands and output results. (4 marks)

Answer 1

(a)

To generate descriptive statistics for these scores, execute the following steps.

1. On the Data tab, in the Analysis group, click Data Analysis.

2. Select Descriptive Statistics and click OK.

3. Select the range A2:A8 as the Input Range.

4. Select cell C1 as the Output Range.

5. Make sure Summary statistics is checked.

6. Click OK.

Result:

You can get all the descriptive statistics in the output.

(b)

Write the below command in any cell of the excel. Note the data is from the cell A1 to A8.

=PERCENTILE(A1:A8, 0.8)

You will get the output as 22.94

(c)

Run the below commands in R to get the descriptive statistics. The output is shown below.

On running the command, we get the below output.

> x = c(20.5,25.1,23.3,22.1,17.4,16.9,20.9,22.4) #Store the value of data

> summary(x) #Give the 5 point summary
Min. 1st Qu. Median Mean 3rd Qu. Max.
16.90 19.73 21.50 21.08 22.62 25.10

> sd(x) #Standard deviation
[1] 2.80955

> var(x) #Variance
[1] 7.893571

> summary(x)[5] - summary(x)[2] #IQR = 3rd quartile - 1st Quartile
IQR
2.89

> quantile(x,0.8) #80th percentile
80%
22.94
>