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.

Excel Data File

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

Instruction:If the estimate is negative, enter a negative number (?) in the equation. Enter your responses rounded to two decimal places.

WPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:34 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD GQ 7 0 - Home Insert Page Layout Formulas Data Review View Tools to Cut Arial 10 A A General E YA Paste . L Copy Format Merge & Center Wrap $ % 000 .00 Conditional Format as Symbol AutoSum Filter Sort Format . Fill Text Formatting Table F1 Q fx WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X A B C D P Q R AA AB AC AD AE AF AG Quantity Price Income 575 31.26 33.95 674 30.6 35.51 616 31.54 28.78 183 30.44 501 27.4 31.28 578 9.48 28.94 33.77 38.31 445 18.17 34.01 603 713 28.5 32.53 18.57 31.69 337 30 .06 32.26 230 29.36 31.57 403 383 32.75 568 29.48 35.91 34.85 $4.06 6.48 38.29 36 .9 9.22 34.21 3.97 32.94 32.7 33. 14 1.92 41.92 12.71 $30 7.96 37 . 38 824 2.89 31.7 37 .1 K > Data for IL Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - -O- + 70 % 507 SEP 4 29 stv 4 VJ WWPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:35 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD GQ 7 0 - Home Insert Page Layout Formulas Data Review View Tools to Cut Arial 10 A A General E YA Paste . L Copy Format Merge & Center Wrap $ % 000 .00 Conditional Format as Symbol AutoSum Filter Sort . Format . Fill Text Formatting Table U25 Q fx WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X A B C D P Q R S AA AB AC AD AE AF AG Quantity Price Income 83 30.8 31.9 31.94 31.77 30.6 36 . 86 32.27 40.79 37. 06 30.01 -34:03 30.35 33.52 30.58 32.78 30.1 37.02 27.43 35.88 27.02 36 . 01 28 . 84 32.55 37 .1 33.84 35.82 4.97 15. 24 34 .1 32 .3 35.26 33.53 34.15 29 .5 3.95 30 .72 14.48 36 . 19 4.09 10.78 5.15 32.75 37 . 34 K >1 Data for IL Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - -O- 507 SEP 4 29 stv 4 VJ WWPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:35 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD GQ 7 0 - Home Insert Page Layout Formulas Data Review View Tools to Cut Arial 10 A A E General E YA Paste . Copy Format BIV B E Z A Q E Merge & Center Wrap $ % 000 .00 Conditional Format as Symbol AutoSum Filter Sort . Format . Fill Text Formatting Table Q fx Quantity WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X A B C D P Q R AA AB AC AD AE AF AG Quantity Price Income 216 33.19 35.34 198 32.83 34.59 195 31.7 32 .61 204 28.75 35.12 218 35.25 32.2 25.69 28.19 205 32.09 36.99 37.09 24.97 34.85 34 .61 196 29.89 32.9 36.14 31.65 35.19 36 . 98 30 . 2 12.35 18.94 13.18 1.07 33 .53 31.7 209 24.13 38.71 27.8 181 33.2 176 31.84 28.42 33.7 29.33 215 39.6 29 .14 37.53 40.9 206 37 .64 201 23 . 74 36.1 K >1 Data for IL Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - -O- 507 SEP 4 29 stv 4 VJ WWPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:35 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD GQ 7 0 - Home Insert Page Layout Formulas Data Review View Tools to Cut Arial 10 A A General E YA Paste . L Copy Format Merge & Center Wrap $ % 000 .00 Conditional Format as Symbol AutoSum Filter Sort Format . Fill Text Formatting Table H21 Q fx WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X A B C D P Q R AA AB AC AD AE AF AG Quantity Price Income 183 29.25 30.72 207 30.1 37.57 183 30.54 29.43 192 28.6 35.87 297 30.23 35.16 180 29.76 27.7 32.96 200 31.0 29.21 32 .3 30 .79 36.1 29.75 32.68 37.49 0.06 31 . 32 218 8.94 38 . 67 $4.82 12.27 0.03 10.02 34 . 3 30 .6 0.42 30 .46 8.23 $6.87 29.34 36.59 225 30 . 1 29 .56 28.88 36.26 34.29 183 28.56 41.7 30 .9 : 31.22 32.39 K >1 Data for IL Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - O- 507 SEP 4 29 stv 4 OR VJ wWPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:35 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD GQ 7 0 - Home Insert Page Layout Formulas Data Review View Tools To Cut Arial 10 A A General E YA Paste . Copy Format Merge & Center Wrap $ % 000 .00 Conditional Format as Symbol AutoSum Filter Sort . Format . Fill Text Formatting Table 129 Q fx !) WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X A B C P Q R AA AB AC AD AE AF AG Quantity Price Income 365 35.8 37.77 341 27.62 35.37 377 25.71 35.67 419 26.5 43.91 387 32.83 37 68 387 392 25.05 36.26 33.49 36.38 29.81 29 .11 409 28.69 39.77 38 8 37 .16 376 30.68 35 .37 360 29.84 33.84 25 . 52 30.06 338 26.61 33.2 29.55 32.48 363 33 .62 36.24 28 .3 36 .1 32.81 37.06 33.81 15.55 33.19 35.13 33 .2 36 13 30 . 35 410 39 57 333 29.65 32.4 31.98 396 26.47 39 . 38 307 31.6 10.35 354 36 . 1 5.48 334 28.74 31.35 K >1 Data for IL Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - -O- 507 SEP 4 29 stv 4 VJ WWPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:35 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD GQ 7 0 - Home Insert Page Layout Formulas Data Review View Tools to Cut Arial 10 A A E General E YA Paste . Copy Format BIV B E Z A Q E Merge & Center Wrap $ % 000 .00 Conditional Format as Symbol AutoSum Filter Sort . Format . Fill Text Formatting Table Q fx Quantity WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X A B C D P Q R AA AB AC AD AE AF AG Quantity Price Income 286 28.09 36.08 75 27.68 5.17 351 28.4 43.92 313 30.24 37.28 368 28.4 47.62 203 26.83 37.65 205 28.18 23.22 321 30.91 22.62 30.87 41.12 233 31.5 28.3 261 31.51 32.3 148 30.18 17.17 37.68 270 34.39 267 1.65 15.7 1.04 8.94 1.63 14 .3 4.67 35 6.06 8.7 31.09 26 .37 22.47 44. 68 191 DOON 21 164 18.98 408 30.57 36.99 30.07 $4.36 28 .3 6.64 310 8.53 308 3.85 43.3 285 9.69 5 .18 K >1 Data for IL Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - -O- + 70 % 507 SEP 4 29 stv 4 VJ WWPS Office File Edit View Insert Format t Tools Data Chart Workspace Window Help Q Wed Sep 29 10:35 PM Home Learn...x.pdf W Busin..Idocx W Litera... Draft 2 BUSI_..l.pdf P 22-80...B.pdf S Baye03-20 S Baye03-19 + = Menu BAD Q 5 0 - Home Insert Page Layout Formulas Data Review View Tools to Cut Arial 10 A A General E YA Paste . L Copy Format Merge & Center Wrap $ % 000 .00 7.0 Conditional Format as Symbol AutoSum Filter Sort . Format . Fill Text Formatting Table H41 Q fx WPS Premium have supported more than 30 kinds of privileges, Buy now and enjoy the first 7 days for free! Buy Now X B C P Q R AA AB AC AD AE AF AG Quantity Price Income 309 29.77 25.59 $41 26.49 28.16 500 28.56 54.66 298 32.38 26 .15 241 26.15 17.63 202 30 . 37 14 .63 27.29 60.42 40 .15 32 .83 44.4 36 .68 351 29 .81 157 27.39 29.46 10.93 322 28.45 0-72 306 29.91 32 . 3 25.48 35.43 20 . 15 10 .8 28 . 6 28.36 32 .2 37.04 43.47 26.36 22.97 29. 52 35.14 34 . 1 38.4 35.73 2 28.5 269 565 30 . 6 33 . 23 51 .13 515 26.2: 46.6 K Data for IN Data for MI Data for MN Data for MS Data for OH Data for WI ... + Local backup on - O- 507 SEP 4 29 stv A VJ W