Answered: Use Excel to find the five-number…

Name: Use Excel to find the five-number summary for the Presidential Height
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: Use Excel to find the five-number summary for the Presidential Height Data.  On your worksheet, click on any cell in a new column.  Click the Insert Function fx button in the Formula Bar.  In the Insert Function dialog box, select the category Sta

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

Topic Video

Question

Use Excel to find the five-number summary for the Presidential Height Data.  On your worksheet, click on any cell in a new column.  Click the Insert Function fx button in the Formula Bar.  In the Insert Function dialog box, select the category Statistical from the dropdown bar.  In the Select a Function box, click QUARTILE.INC and click Ok.  In the Array box, enter the range of data values.  In the Quart box, enter 0 to find the minimum, 1 to find the 1st quartile, and similarly enter 2, 3, 4 for the other values. Clearly label each of the five numbers.

PRESIDENT	HEIGHT
Washington	188
J. Adams	170
Jefferson	189
Madison	163
Monroe	183
J. Q. Adams	171
Jackson	185
Van Buren	168
Harrison	173
Polk	173
Taylor	173
Pierce	178
Buchanan	183
Lincoln	193
Grant	173
Hayes	173
Garfield	183
Cleveland	180
Harrison	168
McKinley	170
T. Roosevelt	178
Taft	182
Wilson	180
Harding	183
Coolidge	178
Hoover	182
F. Roosevelt	188
Truman	175
Eisenhower	179
J. Kennedy	183
Johnson	192
Nixon	182
Carter	177
Reagan	185
G. H. W. Bush	188
Clinton	188
G. W. Bush	183
Obama	188

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions