7 Find the 5 number summary for the data shown14| 2425414548626876 8388 92935 number summary(from least to greatest):

Name: 7 Find the 5 number summary for the data shown14| 2425414548626876 838
Uploaded: 2024-03-20T07:06:41.000Z
Channel: Bartleby
Description: 7 Find the 5 number summary for the data shown14| 2425414548626876 8388 92935 number summary(from least to greatest):

Obtain the values of five number summary. The values of five number summary is obtained below as follows : Use EXCEL Procedure to obtain the value of minimum. Follow the instruction to obtain the value of minimum. Open EXCEL Go to Formula bar. In formula bar enter the function as“=MIN” Enter the range as $A$1:$A$14. Click enter. EXCEL output: From the EXCEL output, the value of the minimum is 14. Thus, the value of minimum is 14. Obtain the value of Q1. Use EXCEL Procedure to obtain the value of first quartile. Follow the instruction to obtain the value of first quartile. Open EXCEL Go to Formula bar. In formula bar enter the function as“=QUARTILE” Enter the range as $A$1:$A$14. Enter the quartile as 1. Click enter. EXCEL output: From the EXCEL output, the value of the first quartile is 41. Thus, the value of the first quartile is 41 Use EXCEL Procedure to obtain the value of second quartile. Follow the instruction to obtain the value of second quartile. Open EXCEL Go to Formula bar. In formula bar enter the function as“=QUARTILE” Enter the range as $A$1:$A$14. Enter the quartile as 2. Click enter. EXCEL output: From the EXCEL output, the value of the second quartile is 62. Thus, the value of the second quartile is 62. Use EXCEL Procedure to obtain the value of third quartile. Follow the instruction to obtain the value of third quartile. Open EXCEL Go to Formula bar. In formula bar enter the function as“=QUARTILE” Enter the range as $A$1:$A$14. Enter the quartile as 3. Click enter. EXCEL output: From the EXCEL output, the value of the third quartile is 83. Thus, the value of the third quartile is 83. Use EXCEL Procedure to obtain the value of maximum. Follow the instruction to obtain the value of maximum. Open EXCEL Go to Formula bar. In formula bar enter the function as“=Max” Enter the range as $A$1:$A$14. Click enter. EXCEL output: From the EXCEL output, the value of the maximum is 93. Thus, the value of maximum is 93. Therefore, the five number summary is, (14,41,62,83,93).