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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock