Excel File: https://docs.google.com/spreadsheets/d/1gojLBeo5TxOyL-VPHv7nGJAcqpPCkWM8/edit?usp=sharing&rtpof=true&sd=true

Problem 1 (10 points) You have been asked to create a simple linear regression model to predict weekly sales of frozen pizza (in pounds) from the average price ($/unit) charged by a sample of stores in the city of Dallas. The data is provided in the Pizza worksheet. a) What is the independent variable? What is the dependent variable? b) Construct a scatter plot (the dependent variable should be on the vertical axis). c) What are the coefficients (bo and bi) of the regression equation? d) Write the regression equation. Interpret the meaning of the slope, bi, in this problem. e) What do you predict the sales to be if the average price charged was $2.75 for a pizza