Question 1: An analysis of a group of weight measurements involves converting a weight value into an integer category number that is determined as given:
Category Weight (pounds)
1 weight<=50.0
2 50
3 125.0
4 200.0
Prepare a VBA program that takes an input weight and puts the correct value (1,2,3, or 4) into CATEGR based on the value of WEIGHT.
Note that CATEGR is an integer, while the weight should be a real variable. The program should finally output the input weight and the category that it fell into
Prepare a program that takes an input weight and puts the correct value.