Create an $=$IF$()$ statement that determines whether the day has more or fewer inpatients than the overall average and assign a $1$ to days with more and a $0$ to days with fewer. Create an $=$IF$()$ statement that determines whether the day has fewer than $90$ inpatients or more than $100$ inpatients or is between the two extremes, and assign a $$low$$ to the days with fewest patients, a $$high$$ to the days with most patients, and a $$medium$$ to the middle group of days. Create an $=$IF$()$ statement that determines whether the day had the fewest inpatients or the most, and assign a $1$ to the lowest and highest and a $0$ to all others. Create an $=$IF$()$ statement that divides the days into four patient groups $($beginning at $88$ patients$),$ and assign a $1$ to the lowest group, a $2$ to the second, and so on$.$