The table provides the sales of the company and the corresponding profit for twelve different stores. To predict the profit earned if the sales are given, using the given information, it is essential to determine the regression line. If the information is plotted on a graph with each point representing sales and the corresponding profit, the regression line is one that nearly passes through each of the points. The error is minimized using statistical tools.
The regression line for the given information can be determined using a software like Excel. The result for the given information is shown in the figure accompanying this response.
From the regression line, if y represents the profit made and x represents the sales, the relation between the two is y = 1.42053*x + 5.93568
For sales of 24 million, the profit made is approximately 40 million and if the sales are 30 million, the corresponding profit is 48.5 million