I need immediate help with ITIS Homework with excel, plz upload screenshots from excel thank you. The following questions (in the image) are based on the dataset listed below.

PLEASE help if you are good with EXCEL and Multiple Regression analysis!

1. Multiple Regression Dataset: XR25-16A A marketing manager for a chain of hardware stores needed more information about the effectiveness of the four types of advertising that the chain used. The four advertising types are direct mailing, newspaper advertising, radio advertising, and television commercials. Data in the file XR25-16A contains the weekly gross sales, and advertising expenditures for the four types of advertising. All values are in thousands of dollars. 1) Use Excel formula to create dummy variable(s) for Location. 2) Construct a multiple regression model with Excel Data Analysis add-on to predict Sales with all useful independent variables. 3)What is the regression function? If Location is ON, Direct =1, Radio=1, Newspaper=1, and Television=1, what is the predicted sales based on the model created? 4) Should any of the independent variables be removed from the model? Explain your answer. 5) Explain R3 in the model