Category: Uncategorized

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

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%

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

True or false, the correlation between Tyson Food’s stock price and Slaugther Cattle PPI is negative. https://colab.research.google.com/drive/19s5TIXBX6ct3GL4zqhINVLQtAbgMoGpH?usp=sharing  

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

Put the IF formula arguments in order (1=first argument, 3=last argument):

1. Consider the following vectors:                      Are the vectors linearly independent? Justify your answer.

4. Let {1+, 1} ,     {1+, 1 – }     be two bases of for the vector space of polynomials of degree less than or equal to 1   a) Find the change-of-basis matrix b) If a polynomial has coordinate representation with respect to :      , find its coordinates with respect to .             

The velocity of ultrasound in muscle is 1,630 m/s. If a 5MHz transducer is used, what will be the wavelength of the ultrasound? Please give me the answer in mm. 1 point for correct formula1 point for correct answer1 point for correct unit1 point for showing your work

What is the potential difference in a circuit of 6 amps and 15 ohms? 1 point for correct answer, 1 point for correct unit, and 1 point for showing your work!