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.
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.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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 |
Transcribed Image Text: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!
Transcribed Image Text: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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 6 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman