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 Sold.
Question No. 2: [10 Marks] Consider the Sample Product Sales Data: Table I: Product Sales Data Segment Country Product Units Sold Manufacturing Price Sale Price Gross Sales Sales Profit Government Pakistan Trousers 16185 RS. 3.00 RS. 20.00 RS. 32,370.00 Government China Trousers 1321 RS. 3.00 RS. 20.00 7 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 25 18 RS. 5.00 RS. 1200 7 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. 1200 RS. 18540.00 Enterprise Pakistan Shirts 2665 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 70" Percentile by using variable Units Sold. e) Compute the z-score by using Units Sold. Rubrics: Understanding & Formulate = 2 Marks Steps = 4 Marks Problem Solving = 2 Marks Correct Output = 2 MarksQuestion No. 2: [10 Marks] Consider the Sample Product Sales Data: Table I: Product Sales Data Segment Country Product Units Sold Manufacturing Price Sale Price Gross Sales Sales Profit Government Pakistan Trousers 16185 RS. 3.00 RS. 20.00 RS. 32,370.00 Government China Trousers 1321 RS. 3.00 RS. 20.00 7 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 25 18 RS. 5.00 RS. 1200 7 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. 1200 RS. 18540.00 Enterprise Pakistan Shirts 2665 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 70" Percentile by using variable Units Sold. e) Compute the z-score by using Units Sold. Rubrics: Understanding & Formulate = 2 Marks Steps = 4 Marks Problem Solving = 2 Marks Correct Output = 2 Marks