A vacation resort has collected data on 150 resort guests to study their spending behavior. In particular, they are interested in whether their rewards program increases guest spending. Their data set includes the amount each guest spent during their 3-day stay, whether the guest traveled from out of state, number of children, number ofprevious stays, age, and whether the guest brought any pets or is a member of the resort's rewards program.

(A) a dummy variable for rewards program membership and run a simple linear regression model with this variable.Interpret your regression coefficient.

(B) Interpretthe ?R2? of your regression.

(C)A suitable dummy variables for the remaining non-numeric variable in the data set.a multiple regression model which includes all explanatory variables from the data file. Interpret all regression coefficients that are significant at the 5% level.

(D)Which model would you choose? Explain.

(E) You also suspect that the effect of the rewards membership on guest purchases depends on whether or not the guest travels from out of state. a suitable interaction variable and add it to your model from part (C). Interpret the coefficient of the interaction variable.

Excel File Edit View Insert Format Tools Data Window Help * ) 52% Sun Oct 25 10:30:23 PM Q AutoSave OFF dataaa Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 A A E = e Wrap Text v General Insert v Ex Delete v Paste E Merge & Center v $ ~ % " 00 20 Conditional Format Cell Format ) v Sort & Find & Ideas Sensitivity Formatting as Table Styles Filter Select 13 X fx B D E F G K L M N 0 P Q R S T U V w Z AA Guest Out of state of children vious visits ge Pets Rewards m Purchase 26 Yes No $1,518 OOOHHHOO JAOANWONN J O O NO OP VO O . H H A O W N W O D O O O M O O NOON OOO VOH 38 Nc No $1,375 35 No No $1,46 40 No No $1,188 28 Yes Yes $1,595 24 N No $1,342 27 No Yes $1,925 33 Ye No $1,18 62 N No $1,49 F O O O H O O O O H O H H O O H O O H O O H H O O O H O ONHONHOOHHNWOWNNOHWAOHHNT 1 No No $1,29 34 No Vo $1,179 37 No No $1,377 37 No No $1,373 58 No No $1,52 33 No Yes $1,859 27 No Yes $1,738 30 N No $1,188 7 No No $1,302 44 N No $1,434 29 N No $1,30 6 No No $1,298 28 Ye No $1,551 15 NO No $1,254 33 Ye No $1,529 24 Yes No $1,35 27 Y No $1,298 50 No No $1,857 18 No No $1,65 40 N No $1,49 33 N No $1,45 35 N Vo $1,265 44 N No $1,558 13 Ye No $1,36 46 N No $1,70 2 No No $1,509 7 No No $1,540 1 572 Dat - + 100% OCT 125 4 SE P W X XLSX DocsExcel File Edit View Insert Format Tools Data Window Help $ ) 52% Sun Oct 25 10:30:31 PM Q AutoSave OFF dataaa Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 A A E e Wrap Text v General Insert v Delete v Paste DVAv $ ~ % " Conditional Format Cell Ideas Merge & Center v Sensitivity Format ) v Sort & Find & Formatting as Table Styles Filter Select 13 X fx D E F G H 1 J K L M N 0 P Q R S T U V W X Z AA A B C 36 36 38 D O O O HOOOOOOHOHHHHOHHOOOOC $1,509 37 39 NW ONH HOONAWOHHNNNHOOWNHOONHOOHOWNHO o NO 42 No No 47 No No $1,540 25 No Yes $1,522 30 No No $1,25 40 No No $1,298 26 Yes No $1,683 32 No No $1,505 1 0 H U P O D - H O W O O O O O O H O O O W O O O O W O HO 51 No No $2,057 35 No Yes $1,69 37 No No $1,452 44 No Yes $1,99 53 No $1,707 40 No No $1,316 51 Yes No $1,373 No No $1,496 No $1,34 No $1,562 Yes $1,496 31 No No $1,280 N No $1,30 17 No No $1,285 37 N Yes $1,31 No $1,474 OH OH OOHH HOOKOC 55 No No $1,496 39 No No $1,30 No $1,496 37 No $1,639 30 Yes No $1,452 26 No No $1,258 41 No Yes $1,584 34 No Yes $1,64 Yes No $1,316 53 No No $1,386 32 N Yes $1,822 44 No No $1,44 25 Yes No $1,47 31 No No $1,408 $1 265 Dat + -O + 100% OCT 125 4 SE P W X XLSX DocsExcel File Edit View Insert Format Tools Data Window Help N X ) 52% Sun Oct 25 10:30:36 PM Q AutoSave OFF dataaa Share Comments Home Insert Draw Page Layout Formulas Data Review View Tell me Insert v Calibri (Body) v 11 A A E e Wrap Text v General Ex Delete v Ideas Sensitivity Paste DVAv Merge & Center v $ ~ % " 00 -20 Conditional Format Cell Formatting as Table Styles Format ) v Sort & Find & Filter Select 13 X fx 1 K L M N 0 P Q R S T U V w X Y Z AA A B C D E F G H 72 71 JON 31 No No $1,40 73 50 No No $1,355 74 47 N Yes $1,848 75 $1,727 76 O OHH H OOH OH HOHOHOOOH OU NHAHOOONHONENOOHHOONWHWAHHOONHE 5 . . W O 6 35 Yes No 43 No No $1,430 76 D NOW UMOO WOOOONONONNON VOUQUAOOOOOO 46 No No $1,395 35 Ye No $1,60 22 Yes No $1,45 58 N No $1,373 40 No No $1,496 30 No No $1,452 29 N No $1,733 31 N Yes $1,716 52 Y No $1,536 33 Ye No $1, 716 9 No No $1,49 34 N No $1,404 26 Yes No $1,62 8 Yes No $1,496 35 No $1,602 7 No Yes $1,68 51 N No $1,553 26 Yes No $1,518 33 N No $1,342 27 Yes No $1,320 96 34 No No $1,64 97 29 N No $1,76 Yes No $1,562 100 3 No No $1,540 101 100 36 N No $1,672 102 101 38 N No $1,553 103 10 50 N No $1,500 104 103 13 No Yes $1,901 105 104 106 AHHOOH OOH OHH HH 18 N No $1,58 105 32 NO No $1,522 107 10 31 Ye No $2,079 108 107 29 N No $1,593 109 10 5 No No $1 650 Data OCT 125 P W X XLSX Docs$ ) 52% Sun Oct 25 10:30:42 PM Q Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF dataaa Share Comments Home Insert Draw Page Layout Formulas Data View Tell me Insert v Calibri (Body) v 11 A A e Wrap Text v General Ex Delete v Conditional Format Cell Sort & Find & Ideas Sensitivity DVAv E Merge & Center v $ ~ % " Formatting as Table Styles Format Filter Select 13 fx R S T U V w Z AA E M N D 1 0 P Q B F G K L 110 109 12 37 No No $1,80 111 110 0 No $1,566 112 111 33 No No $1,75: 113 112 8 No Yes $2,07 114 113 44 N No $1,870 115 114 7 No Yes $2,01 116 115 1 48 N No $1,536 116 2 26 Yes Yes $1,97 118 117 2 25 N No $1,672 119 11 38 N No $1,540 120 119 41 No Yes $1,76 121 120 o 29 Ye No $1,584 122 121 59 N $1,353 123 122 29 Yes No $1,719 124 123 27 No Yes $1,782 125 124 30 N Vo $1,73 126 12 34 N No $1,580 127 12 o 35 N No $1,43 128 127 SHHH OH HOHOHO W W W O U H N U D H O O M O O UT O O H O N UT O N A O O O O O O V W V A U 50 No No $1,628 129 128 33 Nc No $1,434 130 129 N W 26 N No $1,584 130 36 N No $1,540 132 131 Yes $1,91 133 13 17 No No $1,487 134 133 51 No No $1,553 135 134 42 N Vo $1,773 136 13 31 Ye No 137 13 DOWNHOO $1,738 2 N No $1,914 138 16 Yes No $1,848 139 138 50 N No $1,773 140 139 13 Vo $1,93 141 14 WHOOWN 53 N No $1,751 142 141 8 N No $1,74 143 142 39 N No $1,980 144 143 35 No No $1,932 145 144 40 No Vc $1,672 146 145 32 No No $1,717 147 146 33 Yes Yes $2.057 OCT 125 SE P W X XLSX DocsN X ) 52% Sun Oct 25 10:30:46 PM Q Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF dataaa Share Comments Home Insert Draw Page Layout Formulas Data Review View Tell me Insert v Calibri (Body) v 11 A A E e Wrap Text v General Delete v Conditional Format Cell Sort & Find & Ideas Sensitivity DVAv Merge & Center v $ ~ % " Formatting as Table Styles Format ) v Filter Select Paste 13 X fx N 0 P Q R S T U V W X Z AA H K L M A B C D E F G 1 J 133 132 WONNH HOOWNOOPOWNHO o 47 No No $1,487 134 13 135 134 PO W H W W W OUI H N UT D H O OOO 51 No No $1,553 42 No No $1,773 136 135 $1 Yes No $1,73 137 13 62 No No $1,914 138 137 16 Yes $1,848 139 13 No $1,773 140 13 13 Yes No $1,936 141 53 No No $1,751 142 140 14: 38 No $1,74 143 142 39 No No $1,980 144 143 35 N No $1,932 145 14 4 10 N No $1,672 146 145 $2 N No $1,717 146 33 Yes $2,05 147 30 Yes Yes $2,484 149 148 37 Yes Yes $1,936 150 14 30 Yes Yes $2,079 151 150 32 No Yes $2,156 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 4 Data + OCT 25 P W X XLSX Docs