Question: PLEASE SHOW THE IF FUNCTION THAT IS USED TO FIND CATGEORIZE THE NUMBERS A B D E H K L M N 0 P Q

 PLEASE SHOW THE IF FUNCTION THAT IS USED TO FIND CATGEORIZE

PLEASE SHOW THE IF FUNCTION THAT IS USED TO FIND CATGEORIZE THE NUMBERS

A B D E H K L M N 0 P Q 1 Part IV (10 points) 2 Please Creat the variable "Ind" that shows "Good" if return is higher than 1%, "Normal" if return is between -1% and 1% (including 1%) and "Bad" otherwise. 3 4 5 Date Ind 6 7 2/1/50 3/1/50 4/1/50 8 9 5/1/50 10 6/1/50 11 12 7/1/50 8/1/50 9/1/50 13 14 10/1/50 11/1/50 15 19.56 16 12/1/50 17 18 1/1/51 2/1/51 3/1/51 4/1/51 Monthly Return of S&P 500 (1950-2018) Open High Low Adj Close Return 17.05 17.35 16.99 17.22 1.00% 17.24 17.61 17.07 17.29 0.41% 17.34 18.07 17.34 18.07 4.51% 18.22 18.78 18.11 18.78 3.93% 18.77 19.40 17.44 17.69 -5.80% 17.64 17.91 16.68 17.84 0.85% 18.02 18.82 17.95 18.42 3.25% 18.55 19.45 18.54 19.45 5.59% 19.69 20.16 19.53 19.53 0.41% 20.32 19.36 19.51 -0.10% 19.66 20.43 19.00 20.41 4.61% 20.77 21.74 20.69 21.66 6.12% 21.77 22.21 21.76 21.80 0.65% 21.85 21.95 21.25 21.40 -1.83% 21.32 22.43 21.26 22.43 4.81% 22.53 22.81 21.03 21.52 -4.06% 21.48 22.05 20.96 20.96 -2.60% 21.10 22.63 21.10 22.40 6.87% 22.51 23.28 22.51 23.28 3.93% 23.28 23.71 23.26 23.26 -0.09% 23.47 23.85 22.45 22.94 -1.38% 23.10 23.10 22.30 22.88 -0.26% 22.94 23.77 22.94 23.77 3.89% 23.80 24.66 23.74 24.14 1.56% 24.30 24.41 23.09 23.26 -3.65% 23.28 24.37 23.28 24.37 4.77% 24.18 24.18 23.32 23.32 -4.31% 19 20 21 5/1/51 22 6/1/51 23 7/1/51 24 8/1/51 25 9/1/51 26 27 28 29 10/1/51 11/1/51 12/1/51 1/1/52 2/1/52 3/1/52 4/1/52 30 31 32

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!