1. Write an Excel expression that will generate a random integer value in the range 25 to 35 inclusive.
RANDBETWEEN(25,35)
2. Assume that 55% of Asbury University students consider themselves to be conservatives, 25% are liberals, and the rest are moderates. What Excel expression should go in cell B3 to simulate the response of a randomly selected student.
There are six correct answers (since the political tendencies can be listed in six different orders):
=IF(A3<0.55,"Conservative",IF(A3<0.80,"Liberal","Moderate")) =IF(A3<0.55,"Conservative",IF(A3<0.75,"Moderate","Liberal")) =IF(A3<0.25,"Liberal",IF(A3<0.80,"Conservative","Moderate")) =IF(A3<0.25,"Liberal",IF(A3<0.45,"Moderate","Conservative")) =IF(A3<0.20,"Moderate",IF(A3<0.75,"Conservative","Liberal")) =IF(A3<0.20,"Moderate",IF(A3<0.45,"Liberal","Conservative"))