A+ Rental Cars corporate office offers each franchise location $20,000 each month to spend on local advertising. Some franchises take advantage of this offer, while others do not. We have gone back...

1 answer below »
attached is the file


A+ Rental Cars corporate office offers each franchise location $20,000 each month to spend on local advertising. Some franchises take advantage of this offer, while others do not. We have gone back and forth on whether or not this makes sense. Does it make sense to spend money on local advertising? (You may need to run new regressions or analyze the data provided in assignment 2 in different ways to help you answer this question).   In your memo, explain you answer to the question above. If you feel that local advertising makes sense, what can you say in regard to optimal mix of advertisement types? Are there factors missing that would help you improve your analysis of whether local advertising makes sense? What would be your approach to improve the quality of your analysis? A+ Rental Cars: Description of the variables in the data set predicator variable independent variable PownE Average daily rate A+ Rental Cars charged for its economy cars in a given week PownL Average daily rate A+ Rental Cars charged for its luxury vehicles in a given week Pcomp Average daily rate of the only competitor across all vehicle categories Session Binary variable with 1 indicating weeks when college is in session Weather Number of days in a week with severe weather Unemployment Number of unemployed workers in the county as of Tuesday each week FlghtWk Number of flights (in- and outbound) serving the local airport that week CancWk Total number of flights cancelled that week Holiday Binary variable with 1 indicating weeks of national holidays (long weekends) Wrecks Number of major accidents that week Discount Number of customers in a given week using the 15 percent discount off the base rate offered through our affiliate partner, a credit card company Upgrade Number of customers who received a free upgrade to a luxury vehicle due to the unavailability of economy vehicles TotalAd Amount spent on local advertising each week AdBlbd Weekly spending on billboard ads AdPaper Weekly spending on ads in local newspapers, including the online version AdTV Weekly spending on ads placed with local TV QE Number of rental contracts initiated each week in the economy category Q_length Number of paid days of rentals, grouped by the agreement starting date Age<25 number="" of="" rental="" agreements="" in="" a="" given="" week="" for="" which="" the="" person="" listed="" as="" the="" primary="" driver="" on="" the="" rental="" agreement="" was="" less="" than="" 25="" years="" old="" age25_50="" number="" of="" rental="" agreements="" for="" which="" the="" person="" listed="" as="" the="" primary="" driver="" on="" the="" rental="" agreement="" was="" between="" 25="" and="" 50="" years="" of="" age="" age51+="" number="" of="" rental="" agreements="" in="" a="" given="" week="" for="" which="" the="" person="" listed="" as="" the="" primary="" driver="" on="" the="" rental="" agreement="" was="" 51="" yea="" rs="" of="" age="" or="" older="" fleetage="" average="" age="" of="" our="" fleet="" measured="" in="" weeks="" bedtax="" amounts="" collected="" from="" the="" 1%="" local="" hospitality="" tax="" in="" the="" county="" -="" this="" information="" is="" reported="" only="" on="" a="" monthly="" basis="" a+="" rental="" cars:="" description="" of="" the="" variables="" in="" the="" data="" set="" predicator="" variable="" independent="" variable="" powne="" average="" daily="" rate="" a+="" rental="" cars="" charged="" for="" its="" economy="" cars="" in="" a="" given="" week="" pownl="" average="" daily="" rate="" a+="" rental="" cars="" charged="" for="" its="" luxury="" vehicles="" in="" a="" given="" week="" pcomp="" average="" daily="" rate="" of="" the="" only="" competitor="" across="" all="" vehicle="" categories="" session="" binary="" variable="" with="" 1="" indicating="" weeks="" when="" college="" is="" in="" session="" weather="" number="" of="" days="" in="" a="" week="" with="" severe="" weather="" unemployment="" number="" of="" unemployed="" workers="" in="" the="" county="" as="" of="" tuesday="" each="" week="" flghtwk="" number="" of="" flights="" (in-="" and="" outbound)="" serving="" the="" local="" airport="" that="" week="" cancwk="" total="" number="" of="" flights="" cancelled="" that="" week="" holiday="" binary="" variable="" with="" 1="" indicating="" weeks="" of="" national="" holidays="" (long="" weekends)="" wrecks="" number="" of="" major="" accidents="" that="" week="" discount="" number="" of="" customers="" in="" a="" given="" week="" using="" the="" 15="" percent="" discount="" off="" the="" base="" rate="" offered="" through="" our="" affiliate="" partner,="" a="" credit="" card="" company="" upgrade="" number="" of="" customers="" who="" received="" a="" free="" upgrade="" to="" a="" luxury="" vehicle="" due="" to="" the="" unavailability="" of="" economy="" vehicles="" totalad="" amount="" spent="" on="" local="" advertising="" each="" week="" adblbd="" weekly="" spending="" on="" billboard="" ads="" adpaper="" weekly="" spending="" on="" ads="" in="" local="" newspapers,="" including="" the="" online="" version="" adtv="" weekly="" spending="" on="" ads="" placed="" with="" local="" tv="" qe="" number="" of="" rental="" contracts="" initiated="" each="" week="" in="" the="" economy="" category="" q_length="" number="" of="" paid="" days="" of="" rentals,="" grouped="" by="" the="" agreement="" starting="" date=""><25 number="" of="" rental="" agreements="" in="" a="" given="" week="" for="" which="" the="" person="" listed="" as="" the="" primary="" driver="" on="" the="" rental="" agreement="" was="" less="" than="" 25="" years="" old="" age25_50="" number="" of="" rental="" agreements="" for="" which="" the="" person="" listed="" as="" the="" primary="" driver="" on="" the="" rental="" agreement="" was="" between="" 25="" and="" 50="" years="" of="" age="" age51+="" number="" of="" rental="" agreements="" in="" a="" given="" week="" for="" which="" the="" person="" listed="" as="" the="" primary="" driver="" on="" the="" rental="" agreement="" was="" 51="" years="" of="" age="" or="" older="" fleetage="" average="" age="" of="" our="" fleet="" measured="" in="" weeks="" bedtax="" amounts="" collected="" from="" the="" 1%="" local="" hospitality="" tax="" in="" the="" county="" -="" this="" information="" is="" reported="" only="" on="" a="" monthly="" basis="" copy="" of="" team="" assignment="" 2="" a="" plus="" rental="" cars="" dataset(2212).xlsx="" regression="" summary="" output="" regression="" statistics="" multiple="" r="" 0.6144375622="" r="" square="" 0.3775335178="" adjusted="" r="" square="" 0.1382686687="" standard="" error="" 0.7126117456="" observations="" 52="" anova="" df="" ss="" ms="" f="" significance="" f="" regression="" 14="" 11.703859324="" 0.8359899517="" 1.7728818263="" 0.0818522405="" residual="" 38="" 19.2969890004="" 0.5078155="" total="" 52="" 31.0008483243="" coefficients="" standard="" error="" t="" stat="" p-value="" lower="" 95%="" upper="" 95%="" lower="" 95.0%="" upper="" 95.0%="" intercept="" 6.5437003315="" 1.6144283548="" 4.0532615225="" 0.0002410328="" 3.2754609919="" 9.8119396711="" 3.2754609919="" 9.8119396711="" powne="" 0.1156921151="" 0.0490629367="" 2.3580348585="" 0.0236208766="" 0.0163693923="" 0.2150148379="" 0.0163693923="" 0.2150148379="" pownl="" -0.0692778086="" 0.0264783656="" -2.6163929321="" 0.0126808733="" -0.1228804573="" -0.0156751598="" -0.1228804573="" -0.0156751598="" pcomp="" -0.0462677159="" 0.0312503609="" -1.4805498096="" 0.1469708842="" -0.1095307642="" 0.0169953324="" -0.1095307642="" 0.0169953324="" session="" 0.2105113192="" 0.2730925924="" 0.7708422894="" 0.4455670339="" -0.3423357311="" 0.7633583694="" -0.3423357311="" 0.7633583694="" weather="" -0.5786831009="" 0.2414936334="" -2.3962664881="" 0.0215907128="" -1.067561403="" -0.0898047987="" -1.067561403="" -0.0898047987="" unempl="" -0.0014753379="" 0.0017171568="" -0.8591747903="" 0.395631793="" -0.0049515401="" 0.0020008644="" -0.0049515401="" 0.0020008644="" flights/wk="" -0.0176597574="" 0.0255656693="" -0.6907606128="" 0.4939141308="" -0.069414749="" 0.0340952343="" -0.069414749="" 0.0340952343="" canc/wk="" 0.213219358="" 0.106068814="" 2.0101983793="" 0.0515476494="" -0.00150573="" 0.4279444461="" -0.00150573="" 0.4279444461="" holiday="" 0.5612387068="" 0.3783115972="" 1.4835355591="" 0.1461797383="" -0.2046130826="" 1.3270904962="" -0.2046130826="" 1.3270904962="" wrecks="" -0.0037588601="" 0.0279921823="" -0.1342824976="" 0.8938878996="" -0.0604260705="" 0.0529083502="" -0.0604260705="" 0.0529083502="" totlad="" -0.0000615753="" 0.0002494972="" -0.246797585="" 0.8063933367="" -0.0005666559="" 0.0004435053="" -0.0005666559="" 0.0004435053="" adblbd="" 0.0012963141="" 0.0005818701="" 2.2278409101="" 0.0318878029="" 0.0001183796="" 0.0024742485="" 0.0001183796="" 0.0024742485="" adpaper="" 0="" 0="" 65535="" error:#num!="" 0="" 0="" 0="" 0="" adontv="" 0.0001919736="" 0.0002608798="" 0.7358698292="" error:#num!="" -0.0003361499="" 0.0007200971="" -0.0003361499="" 0.0007200971="" fullset="" week="" powne="" pownl="" pcomp="" session="" weather="" unempl="" flights/wk="" canc/wk="" holiday="" wrecks="" totlad="" adblbd="" adpaper="" adontv=""><2526-5051+age/weeksbedtaxe_daysq_lengthqeq_length 129.9937.9937.7504701419022430430009641450.3$104,025.673.83933487334 229.9941.9941.5017394120164304300013461751.34.30332776327 324.9926.9935.25028144130124304300020511152.33.84131582315 428.9937.9935.511880470164304300024421153.33.57127577275 524.9936.9924.510881470010430430002051554.34.15831676316 629.9943.9928.7513799476017430430001559455.3$70,251.753.85930178301 728.9944.9934.5118574700208158150014551256.34.38335581355 821.9925.993310871470048158150020611057.33.64833291332 926.7648.9929.5108704700128158150020401758.33.37726077260 1028.9942.9938.25128894730198158150022441859.3$80,998.153.77431784317 1125.9937.9928108554700921978151382014491360.33.82929176291 1225.9937.9930.25109114820425208151705010541161.34.66735075350 1325.9928.9931.5108944800151646815831022361062.36.58844868448 1424.9938.9928.500909480058158150038381363.3$72,072.625.40448189481 1524.9940.9930.25119564800128158150021351264.33.83826168261 1623.9934.9928.2510988480088158150016321528.53.60322763227 1730.9941.99361098348009815815009311229.53.57718652186 1824.9941.9930.511938623018158150020641030.5$83,166.364.30940594405 1926.9941.993110939620018158150014541031.54.02631478314 2025.9945.99321094862003145581564001266932.53.88533887338 2126.9945.9932.510902640074965815640351019341733.53.54324870248 2229.9945.99310288864101743258150351027451434.53.33728786287 2329.9941.9933.750093764101243258150351021311635.5$92,470.993.88226468264 2429.9941.9931.251095364001243258150351015511836.54.82140584405 2524.9941.9932.5109835800843258150351015521937.54.34937486374 2628.9940.9934.7510988582094325815035109601538.55.45245884458 2724.9946.99331099558011143258150351010681439.5$91,174.484.34840092400 2829.9940.9931.5009615800243258150351011531740.55.66745981459 2928.9937.9937.75109965800643258150351014601141.54.65939685396 3027.9937.9937.5109455800140185080351014631242.55.14645889458 3129.9937.9937.25109865900562685080576016481643.54.30034480344 3226.9940.9931119535900540185080351017481544.5$182,486.483.36326980269 3330.9939.9937.25009895930640185080351015561445.53.90633285332 3431.9946.9938.2500103159001340185080351022371846.53.93530377303 3530.9946.9931.25101042590054853508835351023281647.54.43329767297 3627.9938.9932.25101023590123477508835213414511648.5$56,038.775.90147881478 3728.9940.99371010456100744855081843213421481549.53.13126384263 3829.9937.9938.7510106561001126425080213420441450.54.70536778367 3930.9941.9937.7510103761001526425080213422321733.23.70426371263 4030.9942.9939.510105261001126425080213414432034.2$123,935.452.88322277222 4126.9941.9931101055610012508508009631735.23.13527989279 4231.9938.9931.251110716130125085080016381736.24.83134371343 4334.9939.9935001104610011123712370016271837.24.82029461294 4428.9940.9935.7510114561007123712370014421638.24.84734972349 4525.9941.9937.510115761006311712370188014711639.2$99,591.434.366441101441 4634.9946.9931.510113661009123712370016241240.24.13521552215 4725.9937.9933.25121140612115123712370017741241.23.767388103388 4828.9942.9939.5101146582012123712370012491442.24.72035475354 4927.9945.993712115658401438521237026157711743.2$70,942.703.91637295372 5034.9940.9930.510116653001812371237009531144.26.19245273452 5134.9939.9930011175530021123712370015551945.24.06736289362 5226.9941.9935.2500115553016123712370014511746.24.30535382353 26-50="" 51+="" age/weeks="" bedtax="" e_days="" q_length="" qe="" q_length="" 1="" 29.99="" 37.99="" 37.75="" 0="" 4="" 701="" 41="" 9="" 0="" 22="" 430="" 430="" 0="" 0="" 9="" 64="" 14="" 50.3="" $104,025.67="" 3.839="" 334="" 87="" 334="" 2="" 29.99="" 41.99="" 41.5="" 0="" 1="" 739="" 41="" 2="" 0="" 16="" 430="" 430="" 0="" 0="" 13="" 46="" 17="" 51.3="" 4.303="" 327="" 76="" 327="" 3="" 24.99="" 26.99="" 35.25="" 0="" 2="" 814="" 41="" 3="" 0="" 12="" 430="" 430="" 0="" 0="" 20="" 51="" 11="" 52.3="" 3.841="" 315="" 82="" 315="" 4="" 28.99="" 37.99="" 35.5="" 1="" 1="" 880="" 47="" 0="" 1="" 6="" 430="" 430="" 0="" 0="" 24="" 42="" 11="" 53.3="" 3.571="" 275="" 77="" 275="" 5="" 24.99="" 36.99="" 24.5="" 1="" 0="" 881="" 47="" 0="" 0="" 10="" 430="" 430="" 0="" 0="" 20="" 51="" 5="" 54.3="" 4.158="" 316="" 76="" 316="" 6="" 29.99="" 43.99="" 28.75="" 1="" 3="" 799="" 47="" 6="" 0="" 17="" 430="" 430="" 0="" 0="" 15="" 59="" 4="" 55.3="" $70,251.75="" 3.859="" 301="" 78="" 301="" 7="" 28.99="" 44.99="" 34.5="" 1="" 1="" 857="" 47="" 0="" 0="" 20="" 815="" 815="" 0="" 0="" 14="" 55="" 12="" 56.3="" 4.383="" 355="" 81="" 355="" 8="" 21.99="" 25.99="" 33="" 1="" 0="" 871="" 47="" 0="" 0="" 4="" 815="" 815="" 0="" 0="" 20="" 61="" 10="" 57.3="" 3.648="" 332="" 91="" 332="" 9="" 26.76="" 48.99="" 29.5="" 1="" 0="" 870="" 47="" 0="" 0="" 12="" 815="" 815="" 0="" 0="" 20="" 40="" 17="" 58.3="" 3.377="" 260="" 77="" 260="" 10="" 28.99="" 42.99="" 38.25="" 1="" 2="" 889="" 47="" 3="" 0="" 19="" 815="" 815="" 0="" 0="" 22="" 44="" 18="" 59.3="" $80,998.15="" 3.774="" 317="" 84="" 317="" 11="" 25.99="" 37.99="" 28="" 1="" 0="" 855="" 47="" 0="" 0="" 9="" 2197="" 815="" 1382="" 0="" 14="" 49="" 13="" 60.3="" 3.829="" 291="" 76="" 291="" 12="" 25.99="" 37.99="" 30.25="" 1="" 0="" 911="" 48="" 2="" 0="" 4="" 2520="" 815="" 1705="" 0="" 10="" 54="" 11="" 61.3="" 4.667="" 350="" 75="" 350="" 13="" 25.99="" 28.99="" 31.5="" 1="" 0="" 894="" 48="" 0="" 0="" 15="" 1646="" 815="" 831="" 0="" 22="" 36="" 10="" 62.3="" 6.588="" 448="" 68="" 448="" 14="" 24.99="" 38.99="" 28.5="" 0="" 0="" 909="" 48="" 0="" 0="" 5="" 815="" 815="" 0="" 0="" 38="" 38="" 13="" 63.3="" $72,072.62="" 5.404="" 481="" 89="" 481="" 15="" 24.99="" 40.99="" 30.25="" 1="" 1="" 956="" 48="" 0="" 0="" 12="" 815="" 815="" 0="" 0="" 21="" 35="" 12="" 64.3="" 3.838="" 261="" 68="" 261="" 16="" 23.99="" 34.99="" 28.25="" 1="" 0="" 988="" 48="" 0="" 0="" 8="" 815="" 815="" 0="" 0="" 16="" 32="" 15="" 28.5="" 3.603="" 227="" 63="" 227="" 17="" 30.99="" 41.99="" 36="" 1="" 0="" 983="" 48="" 0="" 0="" 9="" 815="" 815="" 0="" 0="" 9="" 31="" 12="" 29.5="" 3.577="" 186="" 52="" 186="" 18="" 24.99="" 41.99="" 30.5="" 1="" 1="" 938="" 62="" 3="" 0="" 1="" 815="" 815="" 0="" 0="" 20="" 64="" 10="" 30.5="" $83,166.36="" 4.309="" 405="" 94="" 405="" 19="" 26.99="" 41.99="" 31="" 1="" 0="" 939="" 62="" 0="" 0="" 1="" 815="" 815="" 0="" 0="" 14="" 54="" 10="" 31.5="" 4.026="" 314="" 78="" 314="" 20="" 25.99="" 45.99="" 32="" 1="" 0="" 948="" 62="" 0="" 0="" 3="" 1455="" 815="" 640="" 0="" 12="" 66="" 9="" 32.5="" 3.885="" 338="" 87="" 338="" 21="" 26.99="" 45.99="" 32.5="" 1="" 0="" 902="" 64="" 0="" 0="" 7="" 4965="" 815="" 640="" 3510="" 19="" 34="" 17="" 33.5="" 3.543="" 248="" 70="" 248="" 22="" 29.99="" 45.99="" 31="" 0="" 2="" 888="" 64="" 1="" 0="" 17="" 4325="" 815="" 0="" 3510="" 27="" 45="" 14="" 34.5="" 3.337="" 287="" 86="" 287="" 23="" 29.99="" 41.99="" 33.75="" 0="" 0="" 937="" 64="" 1="" 0="" 12="" 4325="" 815="" 0="" 3510="" 21="" 31="" 16="" 35.5="" $92,470.99="" 3.882="" 264="" 68="" 264="" 24="" 29.99="" 41.99="" 31.25="" 1="" 0="" 953="" 64="" 0="" 0="" 12="" 4325="" 815="" 0="" 3510="" 15="" 51="" 18="" 36.5="" 4.821="" 405="" 84="" 405="" 25="" 24.99="" 41.99="" 32.5="" 1="" 0="" 983="" 58="" 0="" 0="" 8="" 4325="" 815="" 0="" 3510="" 15="" 52="" 19="" 37.5="" 4.349="" 374="" 86="" 374="" 26="" 28.99="" 40.99="" 34.75="" 1="" 0="" 988="" 58="" 2="" 0="" 9="" 4325="" 815="" 0="" 3510="" 9="" 60="" 15="" 38.5="" 5.452="" 458="" 84="" 458="" 27="" 24.99="" 46.99="" 33="" 1="" 0="" 995="" 58="" 0="" 1="" 11="" 4325="" 815="" 0="" 3510="" 10="" 68="" 14="" 39.5="" $91,174.48="" 4.348="" 400="" 92="" 400="" 28="" 29.99="" 40.99="" 31.5="" 0="" 0="" 961="" 58="" 0="" 0="" 2="" 4325="" 815="" 0="" 3510="" 11="" 53="" 17="" 40.5="" 5.667="" 459="" 81="" 459="" 29="" 28.99="" 37.99="" 37.75="" 1="" 0="" 996="" 58="" 0="" 0="" 6="" 4325="" 815="" 0="" 3510="" 14="" 60="" 11="" 41.5="" 4.659="" 396="" 85="" 396="" 30="" 27.99="" 37.99="" 37.5="" 1="" 0="" 945="" 58="" 0="" 0="" 1="" 4018="" 508="" 0="" 3510="" 14="" 63="" 12="" 42.5="" 5.146="" 458="" 89="" 458="" 31="" 29.99="" 37.99="" 37.25="" 1="" 0="" 986="" 59="" 0="" 0="" 5="" 6268="" 508="" 0="" 5760="" 16="" 48="" 16="" 43.5="" 4.300="" 344="" 80="" 344="" 32="" 26.99="" 40.99="" 31="" 1="" 1="" 953="" 59="" 0="" 0="" 5="" 4018="" 508="" 0="" 3510="" 17="" 48="" 15="" 44.5="" $182,486.48="" 3.363="" 269="" 80="" 269="" 33="" 30.99="" 39.99="" 37.25="" 0="" 0="" 989="" 59="" 3="" 0="" 6="" 4018="" 508="" 0="" 3510="" 15="" 56="" 14="" 45.5="" 3.906="" 332="" 85="" 332="" 34="" 31.99="" 46.99="" 38.25="" 0="" 0="" 1031="" 59="" 0="" 0="" 13="" 4018="" 508="" 0="" 3510="" 22="" 37="" 18="" 46.5="" 3.935="" 303="" 77="" 303="" 35="" 30.99="" 46.99="" 31.25="" 1="" 0="" 1042="" 59="" 0="" 0="" 5="" 4853="" 508="" 835="" 3510="" 23="" 28="" 16="" 47.5="" 4.433="" 297="" 67="" 297="" 36="" 27.99="" 38.99="" 32.25="" 1="" 0="" 1023="" 59="" 0="" 1="" 2="" 3477="" 508="" 835="" 2134="" 14="" 51="" 16="" 48.5="" $56,038.77="" 5.901="" 478="" 81="" 478="" 37="" 28.99="" 40.99="" 37="" 1="" 0="" 1045="" 61="" 0="" 0="" 7="" 4485="" 508="" 1843="" 2134="" 21="" 48="" 15="" 49.5="" 3.131="" 263="" 84="" 263="" 38="" 29.99="" 37.99="" 38.75="" 1="" 0="" 1065="" 61="" 0="" 0="" 11="" 2642="" 508="" 0="" 2134="" 20="" 44="" 14="" 50.5="" 4.705="" 367="" 78="" 367="" 39="" 30.99="" 41.99="" 37.75="" 1="" 0="" 1037="" 61="" 0="" 0="" 15="" 2642="" 508="" 0="" 2134="" 22="" 32="" 17="" 33.2="" 3.704="" 263="" 71="" 263="" 40="" 30.99="" 42.99="" 39.5="" 1="" 0="" 1052="" 61="" 0="" 0="" 11="" 2642="" 508="" 0="" 2134="" 14="" 43="" 20="" 34.2="" $123,935.45="" 2.883="" 222="" 77="" 222="" 41="" 26.99="" 41.99="" 31="" 1="" 0="" 1055="" 61="" 0="" 0="" 12="" 508="" 508="" 0="" 0="" 9="" 63="" 17="" 35.2="" 3.135="" 279="" 89="" 279="" 42="" 31.99="" 38.99="" 31.25="" 1="" 1="" 1071="" 61="" 3="" 0="" 12="" 508="" 508="" 0="" 0="" 16="" 38="" 17="" 36.2="" 4.831="" 343="" 71="" 343="" 43="" 34.99="" 39.99="" 35="" 0="" 0="" 1104="" 61="" 0="" 0="" 11="" 1237="" 1237="" 0="" 0="" 16="" 27="" 18="" 37.2="" 4.820="" 294="" 61="" 294="" 44="" 28.99="" 40.99="" 35.75="" 1="" 0="" 1145="" 61="" 0="" 0="" 7="" 1237="" 1237="" 0="" 0="" 14="" 42="" 16="" 38.2="" 4.847="" 349="" 72="" 349="" 45="" 25.99="" 41.99="" 37.5="" 1="" 0="" 1157="" 61="" 0="" 0="" 6="" 3117="" 1237="" 0="" 1880="" 14="" 71="" 16="" 39.2="" $99,591.43="" 4.366="" 441="" 101="" 441="" 46="" 34.99="" 46.99="" 31.5="" 1="" 0="" 1136="" 61="" 0="" 0="" 9="" 1237="" 1237="" 0="" 0="" 16="" 24="" 12="" 40.2="" 4.135="" 215="" 52="" 215="" 47="" 25.99="" 37.99="" 33.25="" 1="" 2="" 1140="" 61="" 2="" 1="" 15="" 1237="" 1237="" 0="" 0="" 17="" 74="" 12="" 41.2="" 3.767="" 388="" 103="" 388="" 48="" 28.99="" 42.99="" 39.5="" 1="" 0="" 1146="" 58="" 2="" 0="" 12="" 1237="" 1237="" 0="" 0="" 12="" 49="" 14="" 42.2="" 4.720="" 354="" 75="" 354="" 49="" 27.99="" 45.99="" 37="" 1="" 2="" 1156="" 58="" 4="" 0="" 14="" 3852="" 1237="" 0="" 2615="" 7="" 71="" 17="" 43.2="" $70,942.70="" 3.916="" 372="" 95="" 372="" 50="" 34.99="" 40.99="" 30.5="" 1="" 0="" 1166="" 53="" 0="" 0="" 18="" 1237="" 1237="" 0="" 0="" 9="" 53="" 11="" 44.2="" 6.192="" 452="" 73="" 452="" 51="" 34.99="" 39.99="" 30="" 0="" 1="" 1175="" 53="" 0="" 0="" 21="" 1237="" 1237="" 0="" 0="" 15="" 55="" 19="" 45.2="" 4.067="" 362="" 89="" 362="" 52="" 26.99="" 41.99="" 35.25="" 0="" 0="" 1155="" 53="" 0="" 1="" 6="" 1237="" 1237="" 0="" 0="" 14="" 51="" 17="" 46.2="" 4.305="" 353="" 82="">
Answered Same DayNov 30, 2021

Answer To: A+ Rental Cars corporate office offers each franchise location $20,000 each month to spend on local...

Mohd answered on Dec 01 2021
128 Votes
A+ Rental Cars corporate office offers each franchise location $20,000 each month to spend on local advertising. Some franchises take advantage of this offer, while others do not. We have gone back and forth on whether or not this makes sense. Does it make sense to spend money on local advertising? (You may need to run new regressions or analyze the data provided in assignment 2 in different ways to help you answer this question).
 
In your memo, explain your answer to the question above. If you feel that local advertising makes sense, what can you say in regard to the optimal mix of advertisement types? Are there factors missing that would help you improve your analysis of whether local advertising makes sense? What would be your approach to improve the quality of your analysis?
As we can see from figure 2 (correlation matrix) advertising related variables having non significant correlation with response variables. As shown in figure 3 and 4 advertising related variables except (ADblbd: Ad on billboards) are insignificant contributing towards predicting response variables.
We have a coefficient of determination R2 =0.3775. It means almost 38 percent variability can be explained by our model. Advertising related variables are having higher p-values and insignificant coefficient. which makes them very poor predictors.
Maybe we have missed out on collecting important information about advertising variables. Whether we have carefully examined the consumer behaviour and rental market or not. What matters most? How do consumers behave at different siloes? Collect all data from different siloes and analyse that data. We should change our way of advertising like medium procedure.
we must examine our target group.
We can enhance our model by adding significant variables removing irrelevant insignificant variables. We must avoid spending time on those variables, which do not significantly contribute towards predicting response variables. We first identify critical advertising variables for our analysis. We must remove insignificant variables in order to avoid multicollinearity.
Figure1: Correlation matrix
Figure 3:
Figure 4:

A+ Rental Cars: Description of the variables in the data set

predicator variable
independent variable

PownE
Average daily rate A+ Rental Cars charged for its economy cars in a given
week
PownL
Average daily rate A+ Rental Cars charged for its luxury vehicles in a given
week
Pcomp
Average daily rate of the only competitor across all vehicle categories
Session
Binary variable with 1 indicating weeks when college is in session
Weather
Number of days in a week with severe weather
Unemployment
Number of unemployed workers in the county as of Tuesday each week
FlghtWk
Number of flights (in- and outbound) serving the local airport that week
CancWk
Total number of flights cancelled that week
Holiday
Binary variable with 1 indicating weeks of national holidays (long
weekends)
Wrecks
Number of major accidents that week
Discount
Number of customers in a given week using the 15 percent discount off the
base rate offered through our affiliate partner, a credit card company
Upgrade
Number of customers who received a free upgrade to a luxury vehicle due
to the unavailability of economy vehicles
TotalAd
Amount spent on local advertising each week
AdBlbd
Weekly spending on billboard ads
AdPaper
Weekly spending on ads in local newspapers, including the online version
AdTV
Weekly spending on ads placed with local TV
QE
Number of rental contracts initiated each week in the economy category
Q_length
Number of paid days of rentals, grouped by the agreement starting date
Age<25
Number of rental agreements in a given week for which the person listed as
the primary driver on the rental agreement was less than 25 years old
Age25_50
Number of rental agreements for which the person listed as the primary
driver on the rental agreement was between 25 and 50 years of age
Age51+
Number of rental agreements in a given...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here