Question: insert a column at D and, using Opinion 1. convert the words to numbers, with All of the time being 5, Most of the time
insert a column at D and, using Opinion 1. convert the words to numbers, with All of the time being 5, Most of the time being 4, and so on. Name this variable Opinion la. Using the following function: -IF(F2-"All of the time",5.IF(F2-"Most of the time",4.IF(F2="About as often as not"3.IF(F2="Some of the Time",2.1)))) Insert a column at E, name it Charges, and accumulate the costs for Procedure I through Procedure 4 in that column. Using the following function: =SUM Insert a column at F. name it Visit Time, and using Arrival time and Departure time, calculate the number of minutes from each visit. (Hint: format Visit time using the format option under Custom/h: mm)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
