Project Week 5For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet. Download it here. Using the ROI data set:For each of the 2 majors consider the ‘School Type’ column.  Assuming the requirements are met, construct a 90% confidence interval for the proportion of the schools that are ‘Private’.  Be sure to interpret your results.For each of the 2 majors construct a 95% confidence interval for the mean of the column ‘Annual % ROI’.  Be sure to interpret your results.Attachment Spreadsheet:ROI Exel

1. From CityDistNetwork.csv create a new file called CityDistNetworkEdges.csv with appropriately "normalized" Distribution Network edge definitions (one row for each "end" or "vertex" for each edge). Create a new column called "Route" that appropriately concatenates the SaleOfficeCity and the CustomerCity around the "<->" symbol to uniquely identify each route reflected by an edge.2. Extract the CityDistNetworkEdges.csv and CityDistNetworkVertices.csv files into a Tableau workbook. Create an appropriate join of these two files in Tableau. Generate a Line Graph that reflects the Distribution Network between cities. Weight the lines in the graph by the sum of Distance.3. Format the Network Graph to improve the appearance of the network. Change the Shading of the Worksheet to black. Change the path lines to a lighter color and decrease the opacity of the lines appropriately. Include City name as a Detail element in the Marks card.4. Create appropriate Edges and Vertices files from CityDistNetworkArprtCd.csv. Create a Route variable from the Origin and Dest fields. Create a join of the Edges and Vertices files in a new tableau workbook. 5. Create a map of the airport codes in CityDistNetworkArprtCd.csv. After creating the map, change the graph type to Line Graph. Connect Origin and Dest airports by using your created Route variable to define the Path in the line graph.6. Save each network graph to a separate .twbx file. Ensure that the data (Edges/Vertices join) is appropriately extracted into each .twbx.