KEMBAR78
Excel Data Analysis Guide | PDF
Scribd
Upload
45 views3 pages

Excel Data Analysis Guide

This document contains statistical data including the median, quartiles, interquartile range, minimum and maximum values for a dataset. The median is 5, the first quartile is 3.5, the third quartile is 7.75, and the interquartile range is 4.25, indicating the middle 50% of the data is between 3.5 and 7.75.

Uploaded by

shwetha k
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
45 views3 pages

Excel Data Analysis Guide

This document contains statistical data including the median, quartiles, interquartile range, minimum and maximum values for a dataset. The median is 5, the first quartile is 3.5, the third quartile is 7.75, and the interquartile range is 4.25, indicating the middle 50% of the data is between 3.5 and 7.75.

Uploaded by

shwetha k
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

DS

1
2
3
4
5
6
7
8
15
12
4
5
6

Median 5
Q1 25Th Quartile 3.5 Min
Q3 75Th Quartile 7.75 Max

Q3-Q1 IQR 4.25


1.5*IQR 6.375

Q1-1.5*IQR -2.875

Q3+1.5*IQR 14.125
This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file format will
permanently break the chart.

1
15
t will

You might also like