Refer to the information below Question 10 for the context of this problem. Assume that the following data were collecte

[answerhappygod]

Refer To The Information Below Question 10 For The Context Of This Problem Assume That The Following Data Were Collecte 1 (164.08 KiB) Viewed 16 times

Refer to the information below Question 10 for the context of this problem. Assume that the following data were collected. Remember that we are interested in explaining traffic using the other variables in the dataset (except for the Dealer number, which is just a label). Also remember that the data below may be different than the data from the previous question. Dealer Advertising ($100s) Size (Acres) Location Traffic 1 1 1.3 Suburban 293 2 9 1.3 Rural 94 3 11 2.6 Urban 438 Suburban 437 4 14 2.2 22 1.8 Urban 437 24 1.7 Rural 299 000 au 7 25 2.2 Rural 298 29 1.6 Rural 247 9 29 2.2 Suburban 421 10 30 1.6 Suburban 392 11 31 2.1 Urban 388 12 39 1.6 Urban 537 13 40 1.9 Rural 371 14 45 1.9 Urban 406 15 49 2 Suburban 457 16 52 2.1 Rural 525 17 54 2.8 Urban 722 18 55 1.8 Urban 452 19 60 1.9 Urban 496 20 60 1.8 Suburban 529 Use Excel to create a regression model relating customer traffic to advertising, size of the facility and location. For location, use Suburban as the base case. What do you predict customer traffic to be for a Rural location with advertising of $28 hundred and a facility size of 2.7 acres?