Table 3 - Store Data
Store #	Sales ($000s)	Size (000s sq ft)	Number of Product Lines	Distance (mi)
AA	250	3.0	125	0.6
BB	125	2.3	100	1.1
CC	300	3.9	170	1.2
Instructions: Enter Regression Equation Variables from the table below.
Regression Equasion Varibles Table
y Profits	Intercept	b1 Coefficient	b2 Coefficient	b3 Coefficient	b4 Coefficient
Y	-7.24067	0.025881	4.547711	0.011942	5.845695
Create functionality in Table 4 to compute the overall projected profits for each store using Table 3 data and your regression formula.
Table 4 - Profitabilty Calaculator
Store #	Intercept	Projected Profits Based on Sales ($000s)	Projected Profits Based on Size ($000s)	Projected Profits Based on Number of Product Lines ($000s)	Projected Profits Based on Distance ($000s)	Overall Projected Profits ($000s)
AA
BB
CC

Location Choice:

Identify what new store that Casey Hardware should open and explain why in one sentence