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 $1$a$.$

Using the following function:

of the time",$5,$IF$($F$2=$"Most of the time",$4,$IF$($F$2=$"About as often as

not",$3,$IF$($F$2=$"Some of the Time",$2,1))))$

Insert a column at E$,$ name it Charges, and accumulate the costs for Procedure $1$ 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.$

Use the LOS worksheet in the data file Patients$\_$Assignment$1.$xlsx$,$ do the following assignments

$(30$ points$).$

Use the $=$MIN$(),=$MAx$(),$ and $=$ FREQUENCY $()$ functions, to calculate the frequencies when

separating LOS into six categories.

Using the result of $1,$ generate different charts$$column$,$ line, and pie charts. Show these charts on the

spreadsheet.

Generate a cumulative frequency for the variable LOS as well as the percentage and cumulative

percentage distributions.

Use the DRG worksheet in the data file Patients$\_$Assignment$1.$xlsx$,$ and do the following

assignments $(40$ points$).$

Do the frequency distribution by using Pivot Table.

Sort the data in the pivot table by the frequency of each DRG category and do a column chart.

Generate a cumulative distribution for the DRG data from $1$ and do a chart with both frequencies and

cumulative frequencies using different charts $($column for frequencies and line for cumulative

frequencies$)$