I am currently working on my master thesis and finishing my quantitative analysis.
The last step is to create visuals/graphs to support my findings, however I have not had any success with finding the correct approach on how to do this.
To quickly sum up my research; which internal & external influences/factors have impact on the probability that a new position is acquired on the board of directors.
my Dependent Variable (DV): DigitalOfficer_Total
Which is either a 0 or 1 (No or Yes)
my Independent Variable (IV): Digital_Pressure_Investor_Test
my Moderators: Director_Age / Max_Digital_Exp_sum
my Control Variables: BoardSize_log / FirmSize_log / Sector_N_Total / Company_Age
The logistic regression I have used for both moderators separately are;
Code:
logistic DigitalOfficer_Total c.Digital_Pressure_Investor_Test i.Max_Digital_Exp_sum c.Director_Age c.Digital_Pressure_Investor#i.Max_Digital_Exp_sum c.BoardSize_log c.FirmSize_log c.Sector_N_Total c.Company_Age, coef
Code:
logistic DigitalOfficer_Total c.Digital_Pressure_Investor_Test i.Max_Digital_Exp_sum c.Director_Age c.Digital_Pressure_Investor#c.Director_Age c.BoardSize_log c.FirmSize_log c.Sector_N_Total c.Company_Age, coef
Below I have copied an example of my panel data that goes from the years 2011 to 2017.
Thank you in advance.
Kind regards,
Jeroen M. Rooks
Code:
* Example generated by -dataex-. For more info, type help dataex clear input double(Year BoardID) str128 BoardName double DirectorID str256 DirectorName float(BoardSize_log FirmSize_log Max_Digital_Exp_sum Company_Age Director_Age Sector_N_Total DigitalOfficer_Total Digital_Pressure_Investor_Test) 2011 324 "FIFTH THIRD BANCORP" 34204 "Jack Schiff Jr" 2.6390574 3.060302 0 34 78 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 102957 "Mike McCallister" 2.6390574 3.060302 0 34 69 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 483835 "Gary Heminger" 2.6390574 3.060302 0 34 68 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 374698 "Ulysses Bridgeman Jr" 2.6390574 3.060302 0 34 68 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 201578 "Marsha Williams" 2.6390574 3.060302 0 34 70 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 34156 "Jim Hackett" 2.6390574 3.060302 0 34 66 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 34208 "Darryl Allen" 2.6390574 3.060302 0 34 77 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 491751 "The Hon. Evan Bayh III" 2.6390574 3.060302 0 34 66 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 496307 "Jewell Hoover" 2.6390574 3.060302 0 34 73 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 34211 "Doctor Mitchel Livingston" 2.6390574 3.060302 0 34 77 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 34212 "Hank Meijer" 2.6390574 3.060302 0 34 69 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 203640 "Kevin Kabat" 2.6390574 3.060302 0 34 64 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 46776 "Emerson Brumback" 2.6390574 3.060302 0 34 70 3 0 .013188346 2011 324 "FIFTH THIRD BANCORP" 183162 "Bill Isaac" 2.6390574 3.060302 0 34 78 3 0 .013188346 2011 428 "ABBOTT LABORATORIES" 33916 "Ed Liddy" 2.484907 4.5108595 0 109 75 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 15449 "Harry Fuller" 2.484907 4.5108595 0 109 83 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 36014 "Bill Osborn" 2.484907 4.5108595 0 109 74 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 25615 "Nancy McKinstry" 2.484907 4.5108595 0 109 62 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 33296 "Glenn Tilton" 2.484907 4.5108595 0 109 73 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 35330 "Sam Scott III" 2.484907 4.5108595 0 109 77 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 45561 "Phebe Novakovic" 2.484907 4.5108595 0 109 64 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 33500 "Miles White" 2.484907 4.5108595 0 109 66 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 34866 "Jim Farrell" 2.484907 4.5108595 0 109 79 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 33450 "Roxanne Austin" 2.484907 4.5108595 0 109 60 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 1138600 "Sally Blount" 2.484907 4.5108595 0 109 60 30 0 .04234563 2011 428 "ABBOTT LABORATORIES" 755263 "Professor Doctor Robert Alpern" 2.484907 4.5108595 0 109 71 30 0 .04234563 2011 446 "ABERCROMBIE & FITCH CO" 160051 "Lauren Brisky" 1.94591 4.4998097 0 117 70 19 0 .001774965 2011 446 "ABERCROMBIE & FITCH CO" 105912 "Jim Bachmann" 1.94591 4.4998097 0 117 79 19 0 .001774965 2011 446 "ABERCROMBIE & FITCH CO" 66202 "Archie Griffin" 1.94591 4.4998097 0 117 67 19 0 .001774965 2011 446 "ABERCROMBIE & FITCH CO" 447686 "Ambassador Craig Stapleton" 1.94591 4.4998097 0 117 76 19 0 .001774965 2011 446 "ABERCROMBIE & FITCH CO" 33914 "Jack Kessler" 1.94591 4.4998097 0 117 86 19 0 .001774965 2011 446 "ABERCROMBIE & FITCH CO" 66217 "Mike Jeffries" 1.94591 4.4998097 0 117 77 19 0 .001774965 2011 446 "ABERCROMBIE & FITCH CO" 1076275 "Liza Lee" 1.94591 4.4998097 0 117 77 19 0 .001774965 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 15246 "Olivier Steimer" 2.6390574 2.8033605 0 127 66 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 34353 "Jack Krol" 2.6390574 2.8033605 0 127 85 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 38036 "Mike Atieh" 2.6390574 2.8033605 0 127 67 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 38046 "Bruce Crockett" 2.6390574 2.8033605 0 127 77 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 38166 "Robert Hernandez" 2.6390574 2.8033605 0 127 . . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 806343 "Gene Shanks Jr" 2.6390574 2.8033605 0 127 75 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 1009328 "Ted Shasta" 2.6390574 2.8033605 0 127 71 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 38171 "Peter Menikoff" 2.6390574 2.8033605 0 127 81 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 36134 "Bob Ripp" 2.6390574 2.8033605 0 127 80 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 26070 "Mike Connors" 2.6390574 2.8033605 0 127 66 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 32814 "Mary Cirillo-Goldberg" 2.6390574 2.8033605 0 127 74 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 38066 "Tom Neff" 2.6390574 2.8033605 0 127 84 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 32638 "Evan Greenberg" 2.6390574 2.8033605 0 127 66 . . .03594236 2011 616 "CHUBB LTD (ACE Ltd prior to 01/2016)" 31203 "Bobby Mullin" 2.6390574 2.8033605 0 127 78 . . .03594236 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 55271 "Dan Rosensweig" 2.1972246 2.2950568 0 27 59 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 49611 "Doctor Chuck Geschke" 2.1972246 2.2950568 0 27 82 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 49571 "Doctor Robert Sedgewick" 2.1972246 2.2950568 0 27 74 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 37206 "Ned Barnholt" 2.1972246 2.2950568 0 27 78 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 49351 "Shantanu Narayen" 2.1972246 2.2950568 0 27 59 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 49581 "Doctor John Warnock" 2.1972246 2.2950568 0 27 81 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 182352 "Rob Burgess" 2.1972246 2.2950568 0 27 64 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 106007 "Mike Cannon" 2.1972246 2.2950568 0 27 68 34 0 .00042032325 2011 808 "ADOBE INC (Adobe Systems Inc prior to 10/2018)" 35535 "James Daley" 2.1972246 2.2950568 0 27 80 34 0 .00042032325 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 70132 "Doctor Bob Palmer" 2.3025851 2.4063144 1 40 81 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 4355 "John Caldwell" 2.3025851 2.4063144 0 40 72 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 32588 "Nick Donofrio" 2.3025851 2.4063144 0 40 76 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 1126646 "Rory Read" 2.3025851 2.4063144 0 40 59 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 48021 "H Eberhart" 2.3025851 2.4063144 0 40 68 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 60782 "Doctor Mike Barnes" 2.3025851 2.4063144 0 40 79 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 1110788 "Henry Chow" 2.3025851 2.4063144 0 40 . . . .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 777179 "H. Excellency Waleed Al Muhairi" 2.3025851 2.4063144 0 40 . 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 56532 "Craig Conway" 2.3025851 2.4063144 0 40 67 22 0 .002702052 2011 881 "ADVANCED MICRO DEVICES INC (AMD)" 87637 "Bruce Claflin" 2.3025851 2.4063144 0 40 70 22 0 .002702052 end
0 Response to Creating graphs for logistic regression
Post a Comment