Can you show me how to work out each problem? Please and thank you.

Demand estimation Q=f (price, income) Linear Specification Q=a + BP + BI a=intercept B1=price coefficient B=income coefficient Using the data provided to you in excel file, estimate the demand equation or specification provided above. The data consists of the quantity and price (per case) of Fanta (soft drink) sold in each state, as well as the average income (in thousands of dollars) of consumers living in various regions of each state. Please note there are multiple tabs at the bottom of the spreadsheet, each refers to one of the seven states selling the Fanta. Assuming that the underlying demand relation is a linear function of price and income, use your spreadsheet program to obtain least squares estimates of one of the state's demand for Fanta.Eiased on your results or output. complete the following questions. 1. Copy and paste the regression result here. 2. Write the estimated equation consistent with the specification given above 0: + P+ I . What is the Rsquare 1.ralue'? What does it show? . Are all the estimated equations signicant? . What will happen to the quantity demanded tor Fanta if its price goes up by $1? . What will happen to the demand for Fanta if the income of a consumer goes up by $100