Question: Use the Countlf function to construct a frequency distribution of the products (revenue) Product Count Frequency Cumulative Frequency Product 1 to get rid off Compute



Use the Countlf function to construct a frequency distribution of the products (revenue) Product Count Frequency Cumulative Frequency Product 1 to get rid off Compute the relative frequencies Product 2 to get rid off Compute the cumulative frequencies Briefly explain why We need to reduce costs, which are the 2 products you would cut off the menu, and why? Product Salesperson Month Location Units Revenue Napoleon (piece) Charlene June South 79 $ 276.50 Pear Charlotte John January West 47 $ 1,175.00 Orange-passion flan Damon March West 11 $ 253.00 Petits fours, per 12 Damon January East 84 $ 1,344.00 Opera torte Vivian February East 23 $ 736.00 Raspberry Charlotte Charlene December South 44 $ 1,100.00 Caramel eclair Jason June Midwest 30 $ 105.00 Fresh fruit tart--tropical Damon June South 76 $ 1,368.004. FREQUENCIES 3. Use the Countlf function to construct a frequency distribution of the products. b. Compute the relative frequencies c. Compute the cumulative frequencies d. We need to cut costs, so we need to get rid of 2 products. Which 2 products would you suggest we get rid E? And why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
