part of the xls file is below the first pic!

5. Create two Pivot tables using the 3570Hw01.20.xls data file, Tab: Pivot+, the first should examine the relationship between LOS and physician and the second should examine the relationship between cost per case and physician (requires Grouping of cost), explain which physicians have the highest and lowest LOS and cost per case. fx B C D E G 1 Pivot Tables 2 3 LOS - DRG 49 4 5 LOS MD 6 A Patient 1 2 3 7 3 3 3 A 8 9 4 3 10 3 5 6 7 3 11 12 13 A 3 3 3 4 4 A 14 15 4 A A A A A A 4 Cost $4,945.94 $5,798.11 $5,838.23 $5,992.75 $5,412.11 $5,311.71 $5,122.34 $6,479.36 $5,068.82 $7,153.47 $6,213.03 $7,439.16 $7,329.46 $7,823.13 $6,008.18 $8,649.27 $8,114,49 $8,880.55 $8,385.52 $7,825.20 $6,302.04 $6,973.78 $6,682.94 $6,664.90 $6,560.83 $6978,50 Pareto 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Run 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 4 5 5 A A 5 5 5 4 A B B 4 B 4 4 B 4 B 4 Pivot. B Scatter Bariatric + Jx B D E C B 32 4 27 28 33 4 34 29 35 30 5 5 5 5 5 5 36 31 37 32 5 38 39 33 34 35 36 3 3 3 40 41 4 42 37 4 43 4 44 38 39 40 4 45 4 46 4 41 42 47 B $8,076.44 B $7,119.68 B $8,333.26 B $9,186.90 B $9,550.83 B $8,524.94 $6,529.73 C $4,875.66 C $6,450.30 $6,902.58 C $6,814.10 $7,944.82 $7,551.87 $6,179.67 $7,527.22 $6,981.44 $6,490.59 $6,248.11 $4,855.89 $5,916.17 $4,968.21 D $7,778.25 D $8,034.09 D $7,738.02 D $7,295.70 D $7,102.67 D $7,430.56 D $8,507.48 D $8,903.83 D $8,376.00 D $9,465.93 Scatter Pareto 4 48 43 4 4 3 49 50 51 52 53 54 3 3 4 4 4 55 56 57 58 59 60 61 44 45 46 47 48 49 50 51 52 53 54 55 56 57 4 4 4 5 5 5 5 Pivot 62 Run Bariatric + Home Insert D I U abe Read Only - This is an older file format. Changes can only be saved to a copy of the fill fx B C E 63 58 D 64 D 59 60 65 5 D D 66 61 4 62 4 D 67 68 63 4 D 69 4 D 64 65 $8,980.03 $9,409.59 $8,190.63 $9,363.58 $8,709.38 $9,025.52 $9,023.01 $8,679.38 $8,880.52 $9,550.46 $8,475.68 $8,958.79 $9,476.55 70 5 D 71 66 5 D D 72 73 67 68 5 5 5 D 74 D 69 70 75 6 D 76 77 78 79 80 81 82 83 84 85 86 87 88 89 5. Create two Pivot tables using the 3570Hw01.20.xls data file, Tab: Pivot+, the first should examine the relationship between LOS and physician and the second should examine the relationship between cost per case and physician (requires Grouping of cost), explain which physicians have the highest and lowest LOS and cost per case. fx B C D E G 1 Pivot Tables 2 3 LOS - DRG 49 4 5 LOS MD 6 A Patient 1 2 3 7 3 3 3 A 8 9 4 3 10 3 5 6 7 3 11 12 13 A 3 3 3 4 4 A 14 15 4 A A A A A A 4 Cost $4,945.94 $5,798.11 $5,838.23 $5,992.75 $5,412.11 $5,311.71 $5,122.34 $6,479.36 $5,068.82 $7,153.47 $6,213.03 $7,439.16 $7,329.46 $7,823.13 $6,008.18 $8,649.27 $8,114,49 $8,880.55 $8,385.52 $7,825.20 $6,302.04 $6,973.78 $6,682.94 $6,664.90 $6,560.83 $6978,50 Pareto 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Run 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 4 5 5 A A 5 5 5 4 A B B 4 B 4 4 B 4 B 4 Pivot. B Scatter Bariatric + Jx B D E C B 32 4 27 28 33 4 34 29 35 30 5 5 5 5 5 5 36 31 37 32 5 38 39 33 34 35 36 3 3 3 40 41 4 42 37 4 43 4 44 38 39 40 4 45 4 46 4 41 42 47 B $8,076.44 B $7,119.68 B $8,333.26 B $9,186.90 B $9,550.83 B $8,524.94 $6,529.73 C $4,875.66 C $6,450.30 $6,902.58 C $6,814.10 $7,944.82 $7,551.87 $6,179.67 $7,527.22 $6,981.44 $6,490.59 $6,248.11 $4,855.89 $5,916.17 $4,968.21 D $7,778.25 D $8,034.09 D $7,738.02 D $7,295.70 D $7,102.67 D $7,430.56 D $8,507.48 D $8,903.83 D $8,376.00 D $9,465.93 Scatter Pareto 4 48 43 4 4 3 49 50 51 52 53 54 3 3 4 4 4 55 56 57 58 59 60 61 44 45 46 47 48 49 50 51 52 53 54 55 56 57 4 4 4 5 5 5 5 Pivot 62 Run Bariatric + Home Insert D I U abe Read Only - This is an older file format. Changes can only be saved to a copy of the fill fx B C E 63 58 D 64 D 59 60 65 5 D D 66 61 4 62 4 D 67 68 63 4 D 69 4 D 64 65 $8,980.03 $9,409.59 $8,190.63 $9,363.58 $8,709.38 $9,025.52 $9,023.01 $8,679.38 $8,880.52 $9,550.46 $8,475.68 $8,958.79 $9,476.55 70 5 D 71 66 5 D D 72 73 67 68 5 5 5 D 74 D 69 70 75 6 D 76 77 78 79 80 81 82 83 84 85 86 87 88 89