[10 Marks]

Consider the Sample Product Sales Data:

Table 1: Product Sales Data

Segment Country Product Units Sold Manufacturing Price Sale Price Gross Sales Sales Profit

Government Pakistan Trousers 1618.5 RS. 3.00 RS. 20.00 ? RS. 32,370.00 ?

Government China Trousers 1321 RS. 3.00 RS. 20.00 ? RS. 26,420.00 ?

Midmarket UAE Trousers 2178 RS. 3.00 RS. 15.00 ? RS. 32,670.00 ?

Midmarket Iran Trousers 2470 RS. 3.00 RS. 15.00 ? RS. 37,050.00 ?

Government China Trousers 1513 RS. 3.00 RS. 350.00 ? RS. 529,550.00 ?

Midmarket China Shirts 921 RS. 5.00 RS. 15.00 ? RS. 13,815.00 ?

Channel

Partners Pakistan Shirts 2518 RS. 5.00 RS. 12.00 ? RS. 30,216.00 ?

Government UAE Shirts 1899 RS. 5.00 RS. 20.00 ? RS. 37,980.00 ?

Channel

Partners China Shirts 1545 RS. 5.00 RS. 12.00 ? RS. 18,540.00 ?

Enterprise Pakistan Shirts 2665.5 RS. 5.00 RS. 125.00 ? RS. 333,187.50 ?

Small

Business Iran Shirts 958 RS. 5.00 RS. 300.00 ? RS. 287,400.00 ?

Enterprise Pakistan Shirts 345 RS. 5.00 RS. 125.00 ? RS. 43,125.00 ?

a) Calculate Frequency Distribution of Segment & Product.

b) Calculate the Relative Frequency of Gross Sales.

c) Calculate the Percent Frequency of Profit.

d) Compute the 70th Percentile by using variable Units Sold.

e) Compute the z-score by using Units Sol