I know to use excel for this assignment, I am just confused on the steps for using data analysis or any add-ons.

Q4. Add dummy variable to the equation in 4 (above). In other words, Develop an estimated regression equation with Population (in millions), GDP (in billions), Oil_CO₂ , Gas Prices, and Temp and and World Events Dummy as the independent variables. Discuss your findings. (Use CO₂ as Dependent Variable).

Q5. Discuss the need for other independent variables that can be added to the model (i.e. What additional variables might be helpful and why when predicting CO2 emissions in USA?) (minimum 3 variables and why)

Here is the data:

Please do not transfer all of the data to excel, I know that would be difficult. If I am provided the steps to complete the answer, that would be appreciated.

Sheet1 Sheet2 Sheet3 + Ready \&x Accessibility: Investigate