1. Use an array to calculate the unit price of each item in exercise 7 tab, part
2. Use a single cell array to calculate the total value of the inventory in part 2 of exercise 7.
3. Use a single cell array to calculate the following in part 3 of exercise 7 when comparing 2018 to 2017 data: average difference, total difference, largest difference, smallest difference, and the average percentage increase of 2018 over 2017.

3 Part.1 5 Product units 6 CZ 7 BZ 8 MR 9 TR 10 TS 11 ZL 12 CN 13 BW Total Value of inventory 10 630 360 360 240 16 Part 2 17 18 Product units 19 AR 20 BT 21 MP 22 TU 23 TL 24 ZW 25 CJ 26 BU 27 28 Part 3 Unit cost 75 10 24 30 Product 31 AR 32 BT 33 MP 34 TU 35 TL 36 ZW 37 CJ 38 BU 39 2018 2017 4,523,332 $ $ 2,548,540 $ $3,254,782 $ $5,786,541 $ $ 7,651,204 $ $ 9,658,742 $ 12,458,741 $ $ 9,654,287 $ 3,215,987 3,257,841 2,587,965 6,598,321 6,598,741 8,965,321 11,269,852 10,236,549 3 Part.1 5 Product units 6 CZ 7 BZ 8 MR 9 TR 10 TS 11 ZL 12 CN 13 BW Total Value of inventory 10 630 360 360 240 16 Part 2 17 18 Product units 19 AR 20 BT 21 MP 22 TU 23 TL 24 ZW 25 CJ 26 BU 27 28 Part 3 Unit cost 75 10 24 30 Product 31 AR 32 BT 33 MP 34 TU 35 TL 36 ZW 37 CJ 38 BU 39 2018 2017 4,523,332 $ $ 2,548,540 $ $3,254,782 $ $5,786,541 $ $ 7,651,204 $ $ 9,658,742 $ 12,458,741 $ $ 9,654,287 $ 3,215,987 3,257,841 2,587,965 6,598,321 6,598,741 8,965,321 11,269,852 10,236,549