28. Compute the common increment for a data set with the following properties: a. Minimum value 27 b. Maximum value 1969 c. Number of data points is 201 d. The common increment (between points) is: e. If the data points using the above parameters start with the min-value in worksheet cell G12, the last data point would be in G 29. Compute many data points are required for a data set with the following properties: a. Minimum value =.75 b. Maximum value = 1.51 c. The common increment is.0176 d. The number of data points in this range is e. If the first minimum value is in cell C12, the maximum value (1.51) is located in cell C 30. Let xl and yl be variables assigned data. Show how to swap the contents of the two variables. The variable xl should contain the value originally stored in yl; and, yl should contain the value originally stored in x1. 31. Trace the two VBA loops Dim xx As Integer, total As Integer total -0 xx= 10 Do While xx0 Dim xx As Integer, total as Integer total 100 For xx 10 To 0 Step -2 total-total-xx/2 total = total + 24xx Next xx xx , total Loop XX = , total = 32. Fill in the blanks so both Vectl and Vect2 are identical. Vectl = [ 27-3-27 ]; Vect2 linspace( - linspace 33. Fill in the blanks: Range("B5:F22") has_rows and columns. (Count the rows and columns in the range.) 28. Compute the common increment for a data set with the following properties: a. Minimum value 27 b. Maximum value 1969 c. Number of data points is 201 d. The common increment (between points) is: e. If the data points using the above parameters start with the min-value in worksheet cell G12, the last data point would be in G 29. Compute many data points are required for a data set with the following properties: a. Minimum value =.75 b. Maximum value = 1.51 c. The common increment is.0176 d. The number of data points in this range is e. If the first minimum value is in cell C12, the maximum value (1.51) is located in cell C 30. Let xl and yl be variables assigned data. Show how to swap the contents of the two variables. The variable xl should contain the value originally stored in yl; and, yl should contain the value originally stored in x1. 31. Trace the two VBA loops Dim xx As Integer, total As Integer total -0 xx= 10 Do While xx0 Dim xx As Integer, total as Integer total 100 For xx 10 To 0 Step -2 total-total-xx/2 total = total + 24xx Next xx xx , total Loop XX = , total = 32. Fill in the blanks so both Vectl and Vect2 are identical. Vectl = [ 27-3-27 ]; Vect2 linspace( - linspace 33. Fill in the blanks: Range("B5:F22") has_rows and columns. (Count the rows and columns in the range.)