NEED STEP BY STEP INSTRUCTIONS ON HOW TO ANSWER THIS USING EXCEL, IF IT DOESNT HAVE STEP BY STEP I WILL PUT A THUMBSDOWN BECAUSE YOU DIDNT FOLLOW DIRECTIONS.

Box Plots

Task $2-1)$ Create a box plot that compares the total delay for arrival of old data and new

data for the end stations $($NYC and Schenectady$).$ The box plot should look like the

following example $($the chart below uses some random data so your chart will look

different$).$ Use Excel to create the chart and copy it here.

Explain what you understand from these charts.

Task $2-2)$ Create a Box plot that compares the added times of departure for old and

new data by station. Your chart should be similar to the following chart. $($the chart below

uses some random data for only $4$ stations, so your chart will look different and includes

all $6$ stations$).$ Use Excel to create the chart and copy it here. Control charts

Task $1-1)$ Create an I$-$MR control charts that show before and after situations and

highlights the improvements in added time of departures. Use Excel to create the

charts. The before$-$after improvement control chart should look like the following example

$($the chart below uses some random data so your chart will look different; remember that

you need both I$-$chart and MR$-$chart$).$ You need to combine the old and new data to

create these charts. Follow the instructions from the lectures to create these control

charts in Excel.

Explain what you understand from these charts. Is the process in control after

improvements?

Control charts

Task $1-1)$ Create an I$-$MR control charts that show before and after situations and

highlights the improvements in added time of departures. Use Excel to create the

charts. The before$-$after improvement control chart should look like the following example

$($the chart below uses some random data so your chart will look different; remember that

you need both I$-$chart and MR$-$chart$).$ You need to combine the old and new data to

create these charts. Follow the instructions from the lectures to create these control

charts in Excel.

Explain what you understand from these charts. Is the process in control after

improvements?