please look at the attachments. It has all the Info needed
please look at the attachments. It has all the Info needed
Assignment 2: Is a move a good move?Due Date: March 23 Marks: 15% Data sets: GoodMovePost.xls and Zip Code Distance Calculator.xlsInstructionYou should submit a word file that will contain the visualizations (images) from Tableau.Your answers of the two questions will be supported by the visualizations from Tableau. Theword file should not be more than 3 pages including the visualizations. Submit the word filein Blackboard. Do not submit the tableau files in blackboard.BackgroundWhen a corporation decides to move the location of a major site, the impact on employees isnot always completely understood. Often the total impact on the quality of life and commutetime for employees to travel to a new location is not always taken into consideration.Merck recently decided to move its corporate headquarters from Whitehouse Station, NewJersey (zip code 08889) to Kenilworth, New Jersey (zip code 07033). Leadership wanted tounderstand the impact on the commute experience for the over 2,400 employees who workedat that site and whether certain organizations were more affected than others. Beyond this,there are also larger environmental impacts of such a change, caused by shifts in drivingpatterns, increased traffic at the new location, and potential impacts on public transit.Your challenge is to characterize, quantify, and visualize the impact of a change of locationfor those 2,400 Merck employees to a new location. Specifically, your analysis should addressone or more of the following questions:1. What was the impact of relocating from Whitehouse Station, NJ to Kenilworth,NJ?2. For either option, are certain organizations more negatively impacted than others?Suggested steps- - On the GoodMovePost file, you need to calculate the Distance Current office andDistance Future office (columns highlighted in yellow). To calculate the DistanceCurrent office and Distance Future office, you need to fill up the orange columns (inthe first two sheets) with the latitudes and longitudes of zip codes. Refer to the zipcode distance calculator file to understand how the latitude and longitudes areextracted.Prior to analysis, exclude the outliers from the data set. You need to decide on acriterion on how to exclude outlierYou should upload the FinalData sheet (after filling the data in the yellow highlightedcolumns) in Tableau and do the analysis.
Show more
