Copy the following data and paste it in Microsoft Excel. Perform the following tests in Microsoft Excel. Each of the following is 0.5 points, with a total of 6 points. Provide your answers in the following table.MedianStandard DeviationMinimumMaximumRange1st Quartile2nd Quartile3rd QuartileSkewness; provide a one sentence explanation of what does the skewness value indicatesKurtosis; provide a one sentence explanation of what does the kurtosis value indicatesMake a labelled histogram; no point awarded if it is not labelledMake a labelled boxplot; no point awarded if it is not labelled Data2730222524222028202621232420283020282930212629252625203026282521222727242622292830222222302121302620 Histogram; no pointawarded if it is notlabelledInserting Snapshots into Word: Take snapshots of histogram in Excel and paste here:Mac Users: Press Command + Shift + 4 to take snapshots, then paste them into the Word file.Windows Users: Use the Snipping Tool to capture each answer separately. Search for "SnippingTool" in the search bar to access it.Box plot; no pointawarded if it is notlabelledInserting Snapshots into Word: Take snapshots of boxplot in Excel and paste here:Mac Users: Press Command + Shift + 4 to take snapshots, then paste them into the Word file.Windows Users: Use the Snipping Tool to capture each answer separately. Search for "SnippingTool" in the search bar to access it.Hey! Don't tell me you forgot to upload both the Word and Excel files to Blackboard! Please don't! Statistical TestMedianStandard deviationMinimumMaximumRangeFirst quartile2nd quartThird quartileSkewness; Provideskewness value anda one sentenceexplanation of whatdoes the skewnessvalue indicatesKurtosis; Providekurtosis value and aone sentenceexplanation of whatdoes the kurtosisvalue indicateYour answer rounded to three decimal places, e.g., 1.234. Transfer youranswers from Excel to this Table.

Answered: Histogram; no point awarded if it is…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Copy the following data and paste it in Microsoft Excel. Perform the following tests in Microsoft Excel. Each of the following is 0.5 points, with a total of 6 points. Provide your answers in the following table.

Median
Standard Deviation
Minimum
Maximum
Range
1st Quartile
2nd Quartile
3rd Quartile
Skewness; provide a one sentence explanation of what does the skewness value indicates
Kurtosis; provide a one sentence explanation of what does the kurtosis value indicates
Make a labelled histogram; no point awarded if it is not labelled
Make a labelled boxplot; no point awarded if it is not labelled

Data
27
30
22
25
24
22
20
28
20
26
21
23
24
20
28
30
20
28
29
30
21
26
29
25
26
25
20
30
26
28
25
21
22
27
27
24
26
22
29
28
30
22
22
22
30
21
21
30
26
20

Histogram; no point
awarded if it is not
labelled
Inserting Snapshots into Word: Take snapshots of histogram in Excel and paste here:
Mac Users: Press Command + Shift + 4 to take snapshots, then paste them into the Word file.
Windows Users: Use the Snipping Tool to capture each answer separately. Search for "Snipping
Tool" in the search bar to access it.
Box plot; no point
awarded if it is not
labelled
Inserting Snapshots into Word: Take snapshots of boxplot in Excel and paste here:
Mac Users: Press Command + Shift + 4 to take snapshots, then paste them into the Word file.
Windows Users: Use the Snipping Tool to capture each answer separately. Search for "Snipping
Tool" in the search bar to access it.
Hey! Don't tell me you forgot to upload both the Word and Excel files to Blackboard! Please don't!

Statistical Test
Median
Standard deviation
Minimum
Maximum
Range
First quartile
2nd quart
Third quartile
Skewness; Provide
skewness value and
a one sentence
explanation of what
does the skewness
value indicates
Kurtosis; Provide
kurtosis value and a
one sentence
explanation of what
does the kurtosis
value indicate
Your answer rounded to three decimal places, e.g., 1.234. Transfer your
answers from Excel to this Table.

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution