Answer using excel with steps for each cell number and questions

OFILE Online_Retailers. Consider the following portion of data that lists information about an online retailer's annual revenues (Revenue in $), the number of products available on the retailer's website (SKUs), and the number of visits to the website per day (Visits): Website ID Revenue SKUS Visits 001 2,984,567 34,567 546,799 002 1,230,956 22,398 342,455 : : : 010 2,278,890 28,773 333,219 a. Without transforming the values, compute the Euclidean distance for all pairwise observations of websites 001, 003, and 005 based on annual revenues, SKUs, and visits per day. Make sure to exclude the Website IDs from your calculation. b. Compute the min-max normalized values for annual revenues, SKUs, and visits per day, and then compute the Euclidean distance for all pairwise observations of websites 001, 003, and 005. Discuss the differences in parts a and b. Make sure to exclude the Website IDs from your calculation. c. Using the min-max normalized values, compute the Manhattan distance for all pairwise observations of websites 001, 003, and 005. Discuss the difference between the Euclidean and Manhattan distances. Make sure to exclude the Website IDs from your calculation. A B D Web site ID 001 002 003 004 005 006 007 008 009 Revenue 2984567 1230956 3214563 3283837 2213944 2657859 1090056 3308766 1768986 2278890 SKUS 34,567 22,398 25,678 34,927 19,845 30,045 39,888 10,034 12,889 28,773 Visits 546,799 342,455 389,113 341,934 787,892 433,899 668,972 511,190 434,773 333,219 010 OFILE Online_Retailers. Consider the following portion of data that lists information about an online retailer's annual revenues (Revenue in $), the number of products available on the retailer's website (SKUs), and the number of visits to the website per day (Visits): Website ID Revenue SKUS Visits 001 2,984,567 34,567 546,799 002 1,230,956 22,398 342,455 : : : 010 2,278,890 28,773 333,219 a. Without transforming the values, compute the Euclidean distance for all pairwise observations of websites 001, 003, and 005 based on annual revenues, SKUs, and visits per day. Make sure to exclude the Website IDs from your calculation. b. Compute the min-max normalized values for annual revenues, SKUs, and visits per day, and then compute the Euclidean distance for all pairwise observations of websites 001, 003, and 005. Discuss the differences in parts a and b. Make sure to exclude the Website IDs from your calculation. c. Using the min-max normalized values, compute the Manhattan distance for all pairwise observations of websites 001, 003, and 005. Discuss the difference between the Euclidean and Manhattan distances. Make sure to exclude the Website IDs from your calculation. A B D Web site ID 001 002 003 004 005 006 007 008 009 Revenue 2984567 1230956 3214563 3283837 2213944 2657859 1090056 3308766 1768986 2278890 SKUS 34,567 22,398 25,678 34,927 19,845 30,045 39,888 10,034 12,889 28,773 Visits 546,799 342,455 389,113 341,934 787,892 433,899 668,972 511,190 434,773 333,219 010