Solve the problem.Suppose that P0 is invested in a savings account in which interest is compounded continuously at 5.9% per year. That is, the balance P grows at the rate given by Suppose that $8000 is invested. What is the balance after 3 years?  Show your equation and the answer. Round answer to two decimal places.

Using Logic_assignment.xlsx, calculate the value returned in cell J8 (ETF logic_problem tab / worksheet) using the SUMIF formula? ANSWER FORMAT xxx.x DO NOT WORRY IF CARMEN ADDS ZEROS AFTER YOUR ANSWER

True or False, a stock screen is basically a nested IF statement.

On the VLOOKUP_HLOOKUP tab using LOOKUP assignment.xlsx, what value does the HLOOKUP formula return for the GOOD scenario (cell B27)     ANSWER FORMAT = x.xx NOT x% DO NOT WORRY IF CARMEN ADDS ZEROS AFTER YOUR ANSWER

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

Using Python, match the variable value (left) with the correct data type (right):

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. 

What is the CPI for 2010?

Match the statements with the relevant problem of inflation.

5. Let  be a real inner product space and let u, v ∈ be nonzero vectors. Let be the vector subspace of with basis {u}, and define the orthogonalprojection from → by  a) Prove that among all scalars a ∈ R, the quantity ∥v − au∥ is minimized when (Hint: expand ∥v − au∥2 as a quadratic in a.)   b) Using your minimizing value of a, show that   c) Deduce the Cauchy–Schwarz inequality              and state precisely when equality holds. Hint: try rewriting Cauchy–Schwartz as      How can you use b) to finish?