Predicting daily flight cancellations using weather information

The work should be done using R and Excel analytical Solver.

Prediction
1. We aim to predict the daily flight cancellation rates using the weather information
2. The weather-related variables we plan to use for predicting flight cancellation are: 1) temperature, 2) humidity, 3) wind speed, 4) precipitation, 5) sea level pressure, and 6) visibility.

Methodology
We apply a multiple linear regression model to predict the daily cancellation rates of flights originating from New York Airports, using the following six weather predictors: 1) temperature, 2) humidity, 3) wind speed, 4) precipitation, 5) sea level pressure, and 6) visibility