Suppose the Kalamazoo Brewing Company $($KBC$)$ currently sells its microbrews in a seven$-$state area: Illinois, Indiana, Michigan, Minnesota, Mississippi, Ohio, and Wisconsin. The company$$s data analytics department has collected data from its distributors in each state. This data consists of the quantity and price $($per case$)$ of microbrews sold in each state, as well as the average income $($in thousands of dollars$)$ of consumers living in various regions of each state. The data for each state are available via the link below$--$please note there are multiple tabs at the bottom of the spreadsheet, each refers to one of the seven states selling the Kalamazoo Brewing Company$$s microbrews.

Assuming that the underlying demand relation is a linear function of price and income, use your spreadsheet program to obtain least squares estimates of Michigan$$s demand for KBC microbrews.