SECTION - Classify the following as Descriptive, Predictive or Prescriptive analytics: a) An insurance firm is analyzing fraudulent claims to predict their future losses. b) A secretary is summarizing past events such as regional sales, customer attrition and success of marketing campaigns for her manager to understand the company's progression. c) A gas producer identifies the factors affecting the price of oil and gas to get the best terms and hedge risks. d) A store manager is reviewing the store's historical operations, sales, financials, and customers report to improve the store's business. e) The Met Office is forecasting weather for nine to 10 days more accurately than the 24- hour forecasts, compared to forecasting 40 years ago 2. Below is a spreadsheet of purchase orders for a computer hardware retailer. A B D E G H F 1 Purchase Orders 2 Item Item Cost per A/P Terms Order Order 3 Supplier Description Cost Quantity Order Months) No. Size Graphics 4 Rex Technologies Card $ 89 35 $3115 20 AL123 Large 5 Rex Technologies Monitor $150 115 $2250 25 AL234 Small 5 Rex Technologies Keyboard $ 15 40 |$600 15 AL345 Large 7 Rex Technologies Speakers $ 15 20 $300 25 JAL456 Small 3 Max's Wavetech HD Cables S5 110 |$50 125 IKO876 Small Max's Wavetech Processor $278 27 $6950 KO765 Large 10 Max's Wavetech Hard disk $120 18 $2160 20 KO654 Small 30 3 a) To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used? b) To find the number of orders with A/P terms less than 25 months, what Excel formula should be used? c) If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size