The file Maos Palace Data.xlsx contains data on the price of bowls and demand for bowls, soda and beer at Maos Palace Restaurant over a number of days.

Questions:

Draw a scatter plot with Bowl Price on the X-axis and demand for bowls, soda and beer on the Y-axis. Add a trendline to each plot. Based on the trendline, demand for which product is (a) most impacted by the Bowl price, (b) least impacted by the Bowl price? Show the scatter plot and write the answer above it.

Run regressions with demand for each product as the dependent variable and Bowl price as the independent. Does Bowl Price significantly affect demand for each product and if so, for which product does it have the biggest impact? Show the regression output and write your answer above it.

Upload your answers in an Excel spreadsheet, with each answer on a separate tab.

BEFORE UPLOADING:

1. Move the DATA tab to the end (make it the last tab).

2. In the tabs with your answers, click on VIEW > PRINT LAYOUT. If your charts or tables are breaking across pages, move or resize them to make sure each chart/table is on one page.

3. Add a header to the page showing the question number.

(1) 39F Cloudy \begin{tabular}{rrrrr} \multicolumn{1}{l}{ A } & \multicolumn{1}{l}{ B } & \multicolumn{1}{l}{ C } \\ $8.50 & 474 & 370 & 76 \\ $8.10 & 487 & 414 & 93 \\ $8.80 & 459 & 386 & 73 \\ $9.50 & 421 & 354 & 76 \\ $9.50 & 401 & 313 & 92 \\ $8.90 & 420 & 319 & 67 \\ $8.10 & 435 & 365 & 104 \\ $8.80 & 458 & 357 & 92 \\ $10.00 & 379 & 284 & 87 \\ $9.40 & 426 & 337 & 98 \\ $8.20 & 443 & 368 & 111 \\ $8.10 & 483 & 406 & 101 \\ $8.70 & 409 & 348 & 82 \\ $9.70 & 406 & 325 & 85 \\ $8.00 & 454 & 359 & 104 \\ $8.50 & 468 & 351 & 80 \\ $8.80 & 421 & 345 & 63 \\ $9.10 & 404 & 311 & 73 \\ $9.90 & 387 & 298 & 74 \\ \hline data & Sheet 2 & Sheet3 & \\ \hline \end{tabular} Accessibility: Good to go IS Accessibility: Good to go \begin{tabular}{rrrr} $8.10 & 419 & 333 & 80 \\ $9.20 & 408 & 339 & 73 \\ $9.90 & 398 & 338 & 72 \\ $8.50 & 421 & 349 & 84 \\ $8.90 & 451 & 379 & 108 \\ $9.20 & 424 & 331 & 68 \\ $9.40 & 410 & 328 & 82 \\ $8.00 & 450 & 342 & 72 \\ $9.90 & 415 & 349 & 104 \\ $8.40 & 460 & 363 & 97 \\ $8.50 & 464 & 390 & 97 \\ $8.90 & 439 & 364 & 97 \\ $9.10 & 437 & 371 & 74 \\ $8.30 & 459 & 390 & 101 \\ \hline$9.80 & 433 & 364 & 100 \\ $8.30 & 432 & 337 & 73 \\ $9.20 & 431 & 353 & 86 \\ $8.90 & 417 & 329 & 75 \\ $9.80 & 380 & 285 & 95 \\ cn nn & 130 & sn & on \\ \hline data & Sheet 2 & Sheet 3 & \\ \hline \end{tabular} y Pf Accessibility: Good to go \begin{tabular}{r|rrrr|} 38 & $9.90 & 425 & 327 & 60 \\ 39 & $9.40 & 400 & 316 & 63 \\ 40 & $8.90 & 448 & 358 & 103 \\ 41 & $9.60 & 394 & 299 & 87 \\ 42 & $8.30 & 434 & 352 & 109 \\ 133 & $8.50 & 448 & 376 & 99 \\ 144 & $10.00 & 392 & 321 & 98 \\ 145 & $8.90 & 407 & 305 & 90 \\ 146 & $8.60 & 453 & 371 & 91 \\ 147 & $8.50 & 462 & 351 & 83 \\ 148 & $9.40 & 410 & 332 & 90 \\ 149 & $8.50 & 468 & 365 & 108 \\ 150 & $9.00 & 427 & 342 & 98 \\ 151 & $9.30 & 445 & 369 & 89 \\ 152 & $9.90 & 382 & 313 & 57 \\ 153 & $9.40 & 434 & 360 & 104 \\ 154 & $9.40 & 426 & 341 & 94 \\ 155 & $8.80 & 448 & 381 & 76 \\ 156 & $9.00 & 403 & 334 & 64 \\ \hline \end{tabular} \begin{tabular}{r|rrrr|} 161 & $9.20 & 454 & 363 & 114 \\ 162 & $9.10 & 432 & 346 & 65 \\ 163 & $10.00 & 386 & 293 & 97 \\ 164 & $9.00 & 402 & 302 & 96 \\ 165 & $8.10 & 468 & 360 & 89 \\ 166 & $9.60 & 400 & 320 & 96 \\ 167 & $8.70 & 419 & 335 & 63 \\ 168 & $9.00 & 408 & 314 & 86 \\ 169 & $8.70 & 452 & 366 & 90 \\ 170 & $8.90 & 410 & 349 & 86 \\ 171 & $9.70 & 395 & 332 & 59 \\ 172 & $9.90 & 430 & 344 & 69 \\ 173 & $9.70 & 388 & 318 & 74 \\ 174 & $9.30 & 393 & 307 & 67 \\ 175 & $8.20 & 473 & 374 & 118 \\ 176 & $8.80 & 465 & 349 & 88 \\ 177 & $9.70 & 395 & 296 & 87 \\ 178 & $8.00 & 431 & 328 & 91 \\ 179 & $9.00 & 452 & 348 & 77 \\ \hline \end{tabular} data Sheet2 Sheet3 (1) 39F Cloudy \begin{tabular}{rrrrr} \multicolumn{1}{l}{ A } & \multicolumn{1}{l}{ B } & \multicolumn{1}{l}{ C } \\ $8.50 & 474 & 370 & 76 \\ $8.10 & 487 & 414 & 93 \\ $8.80 & 459 & 386 & 73 \\ $9.50 & 421 & 354 & 76 \\ $9.50 & 401 & 313 & 92 \\ $8.90 & 420 & 319 & 67 \\ $8.10 & 435 & 365 & 104 \\ $8.80 & 458 & 357 & 92 \\ $10.00 & 379 & 284 & 87 \\ $9.40 & 426 & 337 & 98 \\ $8.20 & 443 & 368 & 111 \\ $8.10 & 483 & 406 & 101 \\ $8.70 & 409 & 348 & 82 \\ $9.70 & 406 & 325 & 85 \\ $8.00 & 454 & 359 & 104 \\ $8.50 & 468 & 351 & 80 \\ $8.80 & 421 & 345 & 63 \\ $9.10 & 404 & 311 & 73 \\ $9.90 & 387 & 298 & 74 \\ \hline data & Sheet 2 & Sheet3 & \\ \hline \end{tabular} Accessibility: Good to go IS Accessibility: Good to go \begin{tabular}{rrrr} $8.10 & 419 & 333 & 80 \\ $9.20 & 408 & 339 & 73 \\ $9.90 & 398 & 338 & 72 \\ $8.50 & 421 & 349 & 84 \\ $8.90 & 451 & 379 & 108 \\ $9.20 & 424 & 331 & 68 \\ $9.40 & 410 & 328 & 82 \\ $8.00 & 450 & 342 & 72 \\ $9.90 & 415 & 349 & 104 \\ $8.40 & 460 & 363 & 97 \\ $8.50 & 464 & 390 & 97 \\ $8.90 & 439 & 364 & 97 \\ $9.10 & 437 & 371 & 74 \\ $8.30 & 459 & 390 & 101 \\ \hline$9.80 & 433 & 364 & 100 \\ $8.30 & 432 & 337 & 73 \\ $9.20 & 431 & 353 & 86 \\ $8.90 & 417 & 329 & 75 \\ $9.80 & 380 & 285 & 95 \\ cn nn & 130 & sn & on \\ \hline data & Sheet 2 & Sheet 3 & \\ \hline \end{tabular} y Pf Accessibility: Good to go \begin{tabular}{r|rrrr|} 38 & $9.90 & 425 & 327 & 60 \\ 39 & $9.40 & 400 & 316 & 63 \\ 40 & $8.90 & 448 & 358 & 103 \\ 41 & $9.60 & 394 & 299 & 87 \\ 42 & $8.30 & 434 & 352 & 109 \\ 133 & $8.50 & 448 & 376 & 99 \\ 144 & $10.00 & 392 & 321 & 98 \\ 145 & $8.90 & 407 & 305 & 90 \\ 146 & $8.60 & 453 & 371 & 91 \\ 147 & $8.50 & 462 & 351 & 83 \\ 148 & $9.40 & 410 & 332 & 90 \\ 149 & $8.50 & 468 & 365 & 108 \\ 150 & $9.00 & 427 & 342 & 98 \\ 151 & $9.30 & 445 & 369 & 89 \\ 152 & $9.90 & 382 & 313 & 57 \\ 153 & $9.40 & 434 & 360 & 104 \\ 154 & $9.40 & 426 & 341 & 94 \\ 155 & $8.80 & 448 & 381 & 76 \\ 156 & $9.00 & 403 & 334 & 64 \\ \hline \end{tabular} \begin{tabular}{r|rrrr|} 161 & $9.20 & 454 & 363 & 114 \\ 162 & $9.10 & 432 & 346 & 65 \\ 163 & $10.00 & 386 & 293 & 97 \\ 164 & $9.00 & 402 & 302 & 96 \\ 165 & $8.10 & 468 & 360 & 89 \\ 166 & $9.60 & 400 & 320 & 96 \\ 167 & $8.70 & 419 & 335 & 63 \\ 168 & $9.00 & 408 & 314 & 86 \\ 169 & $8.70 & 452 & 366 & 90 \\ 170 & $8.90 & 410 & 349 & 86 \\ 171 & $9.70 & 395 & 332 & 59 \\ 172 & $9.90 & 430 & 344 & 69 \\ 173 & $9.70 & 388 & 318 & 74 \\ 174 & $9.30 & 393 & 307 & 67 \\ 175 & $8.20 & 473 & 374 & 118 \\ 176 & $8.80 & 465 & 349 & 88 \\ 177 & $9.70 & 395 & 296 & 87 \\ 178 & $8.00 & 431 & 328 & 91 \\ 179 & $9.00 & 452 & 348 & 77 \\ \hline \end{tabular} data Sheet2 Sheet3