Project on Predictive Models Your boss wants your help to understand what drives the performance of stores of the Subway franchise. You have provided data from last year's sales and the demographic factors of each store: SALES SQFT INVENTORY ADVERTISING FAMILIES STORES The EXCEL data file (Franchises.xlxs) has a data dictionary describing the variables. Using Multivariate Regression Models to Understand Franchise Performance Use the same dataset in Franchises.xlsx. Use multi-variate regression to build a prediction model to answer the questions: which collection of factors affect sales in our franchises and how? can we create a model to design a store given certain demographics so we can achieve a certain level of sales? i only need this slide with information Examine each of the variables and see if any variables need to be transformed to improve the multi-variate model. Understanding Franchise Performance SALES (000$) SQFT INVENTORY ADVERTISING FAMILIES STORES 231 3.00 294 8.20 8.20 11 156 2.20 232 6.90 4.10 12 10 0.50 149 3.00 4.30 15 519 5.50 600 12.00 16.10 1 437 4.40 567 10.60 14.10 5 487 4.80 571 11.80 12.70 4 299 3.10 512 8.10 10.10 10 195 2.50 347 7.70 8.40 12 20 1.20 212 3.30 2.10 15 68 0.60 102 4.90 4.70 8 570 5.40 788 17.40 12.30 1 428 4.20 577 10.50 14.00 7 464 4.70 535 11.30 15.00 3 15 0.60 163 2.50 2.50 14 65 1.20 168 4.70 3.30 11 98 1.60 151 4.60 2.70 10 398 4.30 342 5.50 16.00 4 161 2.60 196 7.20 6.30 13 397 3.80 453 10.40 13.90 7 497 5.30 518 11.50 16.30 1 528 5.60 615 12.30 16.00 0 99 0.80 278 2.80 6.50 14 0.5 1.10 142 3.10 1.60 12 347 3.60 461 9.60 11.30 6 341 3.50 382 9.80 11.50 5 507 5.10 590 12.00 15.70 0 400 8.60 517 7.00 12.00 8 The data are for each franchise store. SALES = annual net sales/$1000 SQFT = number sq. ft./1000 INVENTORY = inventory/$1000 ADVERTISING = amount spent on advertizing/$1000 FAMILIES = size of sales district/1000 families STORES = number of competing stores in district. I NEED Include tables and visuals to support your analysis. Your project report should be 5-7 pages. NOT COADING IT IS FOR QNT 2020 CLASS. i only need slide for this topic . Using Multivariate Regression Models to Understand Franchise Performance Use the same dataset in Franchises.xlsx. Use multi-variate regression to build a prediction model to answer the questions: which collection of factors affect sales in our franchises and how? can we create a model to design a store given certain demographics so we can achieve a certain level of sales? Examine each of the variables and see if any variables need to be transformed to improve the multi-variate model. how to do in excel step by step