Problem; Using Excel

Using data in the file sandler_movies.csv, apply k-medoids clustering with k=3 to characterize three different types of Adam Sandler movies. Base the clusters on the variables Rating and Box Office. Rating corresponds to movie ratings provided by critics with a higher score representing a better review. Box represents the gross box office earnings in millions of U.S. dollars. Standardize the values of the input variables to adjust for the different scales of the variables.

E F G I 1 Nm in 4 D Rating Box Office 37 0.2 34 35.1 21 9.3 7 11 46 40 8 32.8 60 59 17 14.7 35 236.43 67 117.5 40 234 22 54.7 B Film Title 1 Shakes the Clown 2 Coneheads 3 Airheads 4 Mixed Nuts 5 Billy Madison 6 Bulletproof 7 Happy Gilmore 8 Dirty Work 9 The Waterboy 10 The Wedding Singer 11 Big Daddy 12 Little Nicky 13 Joe Dirt 14 The Animal 15 Eight Crazy Nights 16 Mr. Deeds 17 Punch-Drunk Love 18 The Hot Chick 19 The Master of Disguise 20 Anger Management 21 Dickie Roberts: Former Child Star 22 50 First Dates 23 Spanglish 24 Deuce Bigalow: European Gigolo 25 The Longest Yard 26 Click 27 Grandma's Boy 11 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 12 22 79 21 36.5 77.85 31.3 167.5 23.66 46.5 53.5 1 43 23 44 175.9 29.4 152.7 54 27.4 53 9 31 32 18 193.2 162.6 7 18 11 14 64 25 7 68.3 138.2 22.6 122 7.2 2 53.4 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 42 38 68 33 110.9 57.69 162.7 177.29 10 27 Grandma's Boy 28 The Benchwarmers 29 I Now Pronounce You Chuck & Larry 30 Reign Over Me 31 Bedtime Stories 32 Strange Wilderness 33 The House Bunny 34 You Don't Mess With the Zohan 35 Funny People 36 Paul Blart: Mall Cop 37 Grown Ups 38 Jack and Jill 39 Just Go with it 40 Zookeeper 41 Here Comes the Boom 42 Hotel Transylvania 43 That's My Boy 44 Grown Ups 2 45 Blended 46 Men, Women & Children 47 Top Five 48 Paul Blart: Mall Cop 2 3 19 14 38 45 20 78.7 109.3 85.3 47.1 154.2 38.4 136.9 46.7 0.72 25.5 43.2 7 14 31 88 47 48 49 50 6