Type 1

The procedure to carry on this portfolio was followed according to the given instructions which are mentioned in the attached sheet.

DATA ANALYSIS

The following table was made by taking the weight of 100 students of classes 10th and 12th from the school’s dispensary. (With the use a Microsoft Excel Sheet)

This table was further processed by making a table (shown bellow) containing weights (xi), number of students having the respective weight (fi) and the product of both (with the help of Microsoft Excel) of them (fixi).

After obtaining this table I calculated the mean, median, mode and standard deviation for this sample of population.

First the mean was calculated (µ) by using the following formula:

µ = (∑fixi)/fi 

Where,

µ: Mean

fi: Frequency

xi: Weight of students

∑: Sum total all the fi( frequency) and xi (weight)

Hence, the mean (µ) obtained was:  60.59

After calculating the mean (µ) then the median (M) was found by using the following formula:

[(n+1)/2]

Where,

M: Median

n: Sum total of number of students

Hence, the median (∂) obtained was 50.5

After calculating the median (∂) the mode was found.

This was done by just looking at the table and seeing the highest frequency which is marked with yellow on the table it self. (i.e. 50)

        

Lastly, the standard deviation (σ) by using “STDEV (: ; : )” on the Microsoft Excel Sheet.

Hence, the standard deviation (σ) obtained was 35.17023617

After finding the mean, median, mode and standard deviation for the 100 weights, the same but this time by taking two different class intervals (i.e. 10 & 5) was calculated.

The first one class interval taken was of 10. In the table a class interval of 10 (C.I), the middle value of the class interval range (xi), frequency (fi) and the product of the middle value and the frequency (fixi)    

Join now!

From the above table C.I - 10 (of 100 weights) Mean, Median, Mode and Standard Deviation by using same above mentioned formulas.

Hence,

Mean: 61.6

Median: 50.5

Mode (marked in yellow): 55

        

Standard Deviation: 31.17594522

**From these calculations (above) we can clearly see that the mean obtained is not the same as the mean calculated when all the 100 weights are taken at a time, this is because in the above calculations we have divided it into class intervals (i.e. 10). This shows as that when the data is arranged in a different class interval range it ...

This is a preview of the whole essay