[SOLUTION] The Market Value of Food
Your directors would also like to know how the gross sales affect the market value of food outlet they might open.1) Draw the scatter plot between market value and gross sales. Add the type of outlet variable as an indicator to the scatter plot. Interpret the graph.2) Find the regression equation between the market value and gross sales for each type of outlet. Write the equation, interpret coefficients, goodness of fit and the significance of the model (Use the Data Analysis Toolbox in Excel).