Use Excel’s regression function to predict o-ring damage on the Space Shuttle Challenger

I have made two previous posts where I have analysed the Space Shuttle Challenger’s o-ring damage, being:-

1. Analysis of o-ring damage using Python:- https://medium.com/@tracyrenee61/analyse-space-shuttle-challengers-o-ring-damage-using-python-and-statsmodels-b2fd4aad800a
2. Analysis of o-ring damage using R:- https://medium.com/@tracyrenee61/analyse-o-ring-damage-of-space-shuttle-challenger-using-r-259ad3a31c88

In this video I am going to perform a linear regression of the o-ring damage using Excel.

Excel is a very powerful tool because most establishments use this software package, and it is becoming more sophisticated with every update.

I have taken the o-ring dataset that I had manually entered into the Python interpreter and copied and pasted it into the Excel sheet that I intended to keep the raw data in. I accomplished this by using the Text to Columns in the Data tab of the ribbon:-

The resulting dataset can be seen below:-

I then copied and pasted by transposing the dataset in the dataset into the page that I intended to work on:-