Solve the problem.P(x) = -x3 + x2 – 60x + 100, x ≥ 5 is an approximation to the total profit (in thousands of dollars) from the sale of x hundred thousand tires. Find the number of tires that must be sold to maximize profit.

Solve the problem.The annual revenue and cost functions for a manufacturer of precision gauges are approximately and where x denotes the number of gauges made. What is the maximum annual profit?

True or False, VLOOKUP can return lookup values that are to left of the lookup column?

Match the financial analysis task (left) with the most appropriate Python library or API (right).

True or False, the INDEX MATCH formula does NOT require that the lookup values are sorted in ascending order.

Using Logic_assignment.xlsx, choose the correct AVERAGEIF formula in cell J9 (ETF loric_problem tab/worksheet).

True or False, the pivot table’s main advantages are: 1) its ability to efficiently assemble reports and 2) the flexibility to quickly adjust column, row, values or filter. 

Choose the end point you would reference on FMP to retrieve sales of Amazon.  

On the INDEXMATCH tab using LOOKUP assignment.xlsx, what was the volume (column F) on the day when the minimum share price was reached (cell L9)?    

Based on the information provided in the table below and an IF formula that returns the number 1 IF the 3-yr performance is above 10% AND the expense ratio is less than 0.65% otherwise the IF statement returns the number 0 (Question 2). How many 1’s were returned in column D. A B C D 1 Fund ticker Expense ratio 3-yr performance 2 DODWX 0.63% 17.6% 3 HAVLX 0.68% 12.77% 4 OFAIX 0.60% 10.10% 5 MABAX 0.55% 5.40% 6 NOLVX 0.57% 7.09% 7 POAGX 0.64% 14.56%