A.Estimate the demand using regression based on the data provided

B.Show the interpretation of the results, the coefficients, significance of the result and explanatory power of the regression model

1. ABC chemical factory produces different detergent, cosmetic and similar products. After cases of Covid-19 pandemic are reported in the country, the demand for disinfectant chemicals and hand sanitizer has boomed and some companies have been producing it before COVID-19. Due to the increase in demand, ABC started producing the sanitizer and distributes throughout major cities in the country. The following table shows weekly demand data and identified determinant variables in 30 major cities. The second table also shows the weekly total sales of 1-liter hand it mitizer for the past 3 months. Sanitizer Demand (1 Litre) for ABC Company Major Weekly Price cities Demand Competitors in Birr advert price in Birr | cost Household income 1 1290 137 94 (annual 2 1177 147 814 53123 21 3 296 1155 149 51749 1299 252 117 49821 5 1166 25 135 43589 86 6 1186 143 42799 7 79 1293 113 768 55565 91 1322 972 111 37959 1338 421 109 47196 10 1160 243 129 50163 82 11 14 1293 124 39080 91 12 1413 117 797 43263 1290 106 988 51291 14 1238 914 135 38343 15 913 1467 117 39473 90 1089 867 147 51501 17 76 1203 124 785 37809 83 12 217 1474 103 41471 92 19 1235 140 246 72 46563 20 1367 768 115 55839 23 21 1310 256 119 47438 76 22 1331 771 138 54348 100 23 947 1293 122 45066 90 24 1437 10 231 44160 85 25 90: 1165 145 55380 96 26 1328 996 138 38656 97 27 1515 929 116 46084 97 28 1000 1223 52249 148 84 20 1293 134 951 50855 248 1215 54546 127 87 38085