4. You are hired by Bob's Pizza to compute a prediction interval for total receipts in Maine because they are thinking of locating there. The data is contained in Bobs.xls. (a) (b) (C) (d) (8) Using the regression function in Excel, perform a regression analysis and write out the estimated regression equation. Predict the total receipts for Maine. Compute a prediction interval for a mean of total receipts for Maine and explain what the interval means. Compute a prediction interval for an individual of total receipts for Maine and explain what the interval means. If the manager needs 53 15,000 worth of receipts for the restaurant to be Drofitable. would you suggest locating in Maine? Explain your