Problem description:

If you are the manager of a grocery company with 50 stores across the city. The excel file contains data on the demand for grocery delivery:

Delivery (Y) is the number of delivery per month

Price (X1) is the average price of a delivery Income (X2) is average income in the neighbourhood

A B C D Location Delivery (Y) Price (X1) Income (X2) 13282 20 60371 IN W 10819 20 38520 3 9134 27 35696 UT 13639 25 68050 13312 30 75874 17351 11 76808 16048 BT 80063 8 3449 20 18456 10 g 7517 28 24949 11 10 6821 23 8352 12 11 16779 22 89554 13 12 9822 26 38471 14 13 14579 11 53832 15 14 9855 14 18661 16 15 14731 22 73971 17 16 8834 16 13187 18 17 6712 20 5922 19 18 8760 12 7423 20 19 15741 15 71016 21 20 9516 18 23251 22 21 6601 29 19886 23 22 17522 16 86367 24 23 16293 22 88489 25 24 17862 19 95633 26 25 12225 24 58008 27 26 11424 28 54972 28 27 16781 25 95223 29 28 18150 16 91013 30 29 9769 19 26102 31 30 14890 24 78469 32 31 8580 20 19684 33 32 9419 12 14296 34 33 16676 13 77037 35 34 15603 17 73354 36 35 15903 30 97961 37 36 17785 14 87681 38 37 13250 25 67846 39 38 7959 12 2895 40 39 6142 26 7867 41 40 10895 21 40952 42 41 18763 10 86958 43 42 9212 25 34244 44 43 13941 26 73846 45 44 16636 19 84855 46 45 16785 19 86327 47 46 9149 25 32398 48 47 5341 7312 49 13066 BT 52588 50 49 10264 21 35408 51 50 9509 21 30831 52Location Alpha Location Beta Average Price 18 23 Average Income 60,000 45,000