You need to create a field that provides the value "over" or "under" for sales, depending on whether the amount is greater than or equal to 15,000. Which type of function can you write to create this data?Select an answer:logical functions, such as IF, CONDITIONAL COLUMN, or IIFlookup functions, such as XLOOKUP, VLOOKUP, or HLOOKUPstring functions, such as CONCAT, MERGE, or REPLACE

Use the if function to label items that are over N$15 as HIGH and those below N$15 AS LOW

Assume the company produces and sells 87,000 units during the year at a selling price of $9.60 per unit. Prepare a contribution format income statement for the year.

Question 5The company gives a 1% discount on any Extra Large or larger orders. In the “Discount” column, create a formula that returns 0.01 if the “Expanded Order Type” is Extra Large, XX Large, or XXX Large, and returns 0 otherwise. You can accomplish this by using a (select all that apply):1 pointVLOOKUP formulaHLOOKUP formulaNested IF formulaA single IF formula (without additional formulae)

now i have the following data in the label 0 sheet,income count0 911100,000 to 150,000 4150,000 to 200,000 440,000 to 70,000 970,000 to 100,000 6Less than 40,000 7now I want to assign income to the entries which don't have income data which is row 1 how I can do this keeping the trend

Create a csv file with the following datatransaction_id,product,quantity,price1,Product A,5,10.992,Product B,3,20.503,Product A,2,9.994,Product C,4,15.755,Product B,6,22.006,Product A,8,11.507,Product C,3,14.258,Product A,10,12.759,Product B,4,21.0010,Product C,7,16.50analyze sales data for the past month and provide insights to the management team. The sales data is stored in a CSV file named "sales_data.csv", which contains information about sales transactions, including the product sold, quantity, and price. Your goal is to perform various operations on this data using NumPy to extract meaningful insights.Do the follwoing Tasks:Load the sales data from the CSV file into a NumPy array.Calculate the total sales revenue for each product by multiplying the quantity sold with the price.Identify the top-selling product based on the total revenue generated.Compute the average quantity sold per transaction.Determine the correlation coefficient between the quantity sold and the price.Generate random samples to simulate potential fluctuations in sales quantity for the next month.