Using the Analysis ToolPak described in the text, calculate descriptive statistics for all variables EXCEPT FOR Launch Sorted by Temperature in the Challenger dataset attached. Use the default statistics provided by the Analysis ToolPak.

Logistics and Supply chain

Part 1. Using the Analysis ToolPak described in the text, calculate descriptive statistics for all variables EXCEPT FOR Launch Sorted by Temperature in the Challenger dataset attached. Use the default statistics provided by the Analysis ToolPak.

Provide at least one appropriate graph for Fahrenheit.

Plot the cumulative relative frequency (proportion) for Damage Index as a function of Temperature. This type of plot requires that you sum the damage index and calculate the proportion of that damage index by temperature. (Here is a table populated through 68 degrees F.The rest are for you to do.) Then, plot the cumulative relative frequency (proportion) by Fahrenheit. (Be sure to set the x axis limits to between 52 and 82 for ease in reading…. At and below what temperature were about 88% of the observations? 58% of the observations? What does this mean? BONUS: fit a line to this cumulative relative frequency using the technique provided in my video. Add the regression equation and R^2.