0% found this document useful (0 votes)
16 views6 pages

Statistical Analysis of Data Set

Uploaded by

sadijutt023
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
0% found this document useful (0 votes)
16 views6 pages

Statistical Analysis of Data Set

Uploaded by

sadijutt023
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

Question Statement/Data: (Marks = 2+2+2+1+1+2 = 10)

For the given data, Find/calculate:


1. Mean
2. Median
3. Mode
4. Lowest Value
5. Highest Value
6. Variance

Data Values
193
135
166
109
106
186
184
191
169
191
151
176
212
151
232
230
213
107
160
145
Solution # 1

1. Mean 170.35
2. Median 172.5
3. Mode 191
4. Lowest Value 106
5. Highest Value 232
6. Variance 1371.4275
Assignment no 1 STA641
student id:
Question Statement/Data:

For the given data, Find/calculate:


1. Midpoints of the class boundaries
2. Relative frequency of the data
3. Percentage relative frequency
4. Histogram of the data. If needed, make graph more visible and presentable.

Lower Class Upper Class


Frequency
Boundary Boundary
5 10 13
10 15 14
15 20 17
20 25 25
25 30 19
30 35 9
Solution # 2

Class Boundaries Frequency


5-10 13
10-15 14
15-20 17
20-25 25

25-30 19
30-35 9
Total Frequency 97

Histogram
This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file format
chart.
Midpoint (X) Relative Freq Percentage Relative Freq
7.5 0.13 13.4
12.5 0.14 14.4
17.5 0.18 17.5
22.5 0.26 25.8

27.5 0.20 19.6


32.5 0.09 9.3

Histogram
version of Excel.

workbook into a different file format will permanently break the

You might also like