Is there a way to rescale the x and y axis in order to show them in in Millions dollars rather than in the format I have in the following figure?
Array
What I did is basically a simple two-way scatter:
Code:
twoway(scatter avsales_new_no_outliers lagged_tot_sales)(lfit avsales_new_no_outliers lagged_tot_sales)
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input double(Year idfirm) str18 crp float(avsales avsales_existing avsales_new) double nprod float(birthfirm firstyear agefirm) double tot_sales 2008 1 "21ST CENTURY LABS" 94701.45 . 94701.45 4 2008 2008 0 211591.55354704778 2009 1 "21ST CENTURY LABS" 83603.08 83603.08 . 4 2008 2008 1 308746.0587639413 2010 1 "21ST CENTURY LABS" 91092.75 113848.5 69.7861 5 2008 2008 2 407237.1453954251 2011 1 "21ST CENTURY LABS" 118792.94 165043.63 3166.214 7 2008 2008 3 598549.0481277383 2012 1 "21ST CENTURY LABS" 104542.8 156613.64 401.1374 9 2008 2008 4 664061.6305459269 2013 1 "21ST CENTURY LABS" 73541.766 113564.58 1500.705 14 2008 2008 5 608140.67505112 2014 1 "21ST CENTURY LABS" 48557.22 61105.52 13421.997 19 2008 2008 6 715163.0758130773 2015 1 "21ST CENTURY LABS" 52369.71 52369.71 . 18 2008 2008 7 768412.7578732732 2004 2 "3M" 2039558.8 2039558.8 . 6 1975 2004 29 12237352.38962967 2005 2 "3M" 2109991 2109991 . 6 1975 2004 30 11513177.507807251 2006 2 "3M" 2050668.5 2050668.5 . 6 1975 2004 31 12304011.532418355 2007 2 "3M" 6330808 6330808 . 6 1975 2004 32 11406777.403632266 2008 2 "3M" 2734569.5 2849051 2047681 7 1975 2004 33 12355367.684264863 2009 2 "3M" 1841746.4 1841746.4 . 7 1975 2004 34 12892224.398947667 2010 2 "3M" 5212612 5212612 . 6 1975 2004 35 10897763.444727022 2011 2 "3M" 5262992 5262992 . 6 1975 2004 36 10580189.86100467 2012 2 "3M" 2037856.5 2037856.5 . 6 1975 2004 37 10967562.283051893 2013 2 "3M" 1823603.5 1823603.5 . 6 1975 2004 38 9124157.813647183 2014 2 "3M" 1785749 1785749 . 4 1975 2004 39 7133930.997182059 2015 2 "3M" 1356981 1356981 . 4 1975 2004 40 5427924.711631365 2004 3 "A-A SPECTRUM" 53702.81 60055.78 1608.419 46 1995 2004 9 2464566.2638161103 2005 3 "A-A SPECTRUM" 81622.65 117128.7 4692.8643 57 1995 2004 10 4406664.46751826 2006 3 "A-A SPECTRUM" 67388.88 85411.82 2806.715 55 1995 2004 11 1843225.499704768 2007 3 "A-A SPECTRUM" 11123.49 12000.184 3759.274 47 1995 2004 12 476002.8259390887 2008 3 "A-A SPECTRUM" 7850.393 8111.578 3279.65 37 1995 2004 13 160865.5648153848 2009 3 "A-A SPECTRUM" 6033.619 6586.994 2021.6517 33 1995 2004 14 82650.9899064962 2010 3 "A-A SPECTRUM" 4410.1416 6201.939 1065.4524 43 1995 2004 15 126687.58501765266 2011 3 "A-A SPECTRUM" 2412.5247 2653.7156 482.997 27 1995 2004 16 35362.49685707843 2012 3 "A-A SPECTRUM" 1075.685 1263.63 261.25616 16 1995 2004 17 16035.562916347304 2013 3 "A-A SPECTRUM" 3456.24 3290.421 4340.6104 19 1995 2004 18 22272.424034809985 2014 3 "A-A SPECTRUM" 1496.9843 1496.9843 . 15 1995 2004 19 21090.64112449751 2015 3 "A-A SPECTRUM" 4020.239 4886.911 120.21213 11 1995 2004 20 23837.82400447101 2004 4 "A-S MEDICATION" 56691.86 63403.79 17030.424 152 2000 2004 4 8398246.263306491 2005 4 "A-S MEDICATION" 78010.12 90833.17 12908.477 158 2000 2004 5 8251045.135936161 2006 4 "A-S MEDICATION" 94482.98 105549.44 18526.848 173 2000 2004 6 9847010.316997783 2007 4 "A-S MEDICATION" 126469.87 141906.94 54159.39 216 2000 2004 7 13503137.133153718 2008 4 "A-S MEDICATION" 78780.68 90365.45 8950.199 253 2000 2004 8 13768126.595234673 2009 4 "A-S MEDICATION" 73256.164 80078.37 8707.616 272 2000 2004 9 13834060.86932386 2010 4 "A-S MEDICATION" 62012.55 64500.59 18223.094 279 2000 2004 10 12531817.194234656 2011 4 "A-S MEDICATION" 70322.5 72763.29 3689.045 283 2000 2004 11 12433251.178176137 2012 4 "A-S MEDICATION" 64410.49 65984.35 38950.9 292 2000 2004 12 11206517.411851741 2013 4 "A-S MEDICATION" 79104 84296.03 7899.004 309 2000 2004 13 14594676.742348071 2014 4 "A-S MEDICATION" 119126.19 129064.8 4067.63 327 2000 2004 14 26481277.906628065 2015 4 "A-S MEDICATION" 176931.8 179580.45 56984.34 324 2000 2004 15 29946995.67406721 2007 5 "A.J. BART, INC." 157.76617 . 157.76617 1 2007 2007 0 39.4415442669969 2004 6 "AAIPHARMA" 28066686 28066686 . 1 1975 2004 29 28066686.19154623 2005 6 "AAIPHARMA" 5704382 5704382 . 1 1975 2004 30 5704381.338495776 2006 6 "AAIPHARMA" 496491.9 496491.9 . 1 1975 2004 31 496491.87314146105 2007 6 "AAIPHARMA" 9421.785 9421.785 . 1 1975 2004 32 9421.785319502253 2008 6 "AAIPHARMA" 1577.368 1577.368 . 1 1975 2004 33 394.3420099042942 2009 6 "AAIPHARMA" 5520.829 5520.829 . 1 1975 2004 34 1380.2071011962253 2007 7 "AARON INDUSTRIES" 35459.79 . 35459.79 1 2007 2007 0 35459.78814655074 2008 7 "AARON INDUSTRIES" 42076.49 42076.49 . 1 2007 2007 1 42076.49109553711 2009 7 "AARON INDUSTRIES" 381988.5 381988.5 . 1 2007 2007 2 381988.536163157 2010 7 "AARON INDUSTRIES" 1804061.4 1804061.4 . 1 2007 2007 3 451015.3511721381 2011 7 "AARON INDUSTRIES" 270585.6 270585.6 . 1 2007 2007 4 270585.60116440145 2012 7 "AARON INDUSTRIES" 1318229 1318229 . 1 2007 2007 5 329557.26253078564 2013 7 "AARON INDUSTRIES" 1220001.8 1220001.8 . 1 2007 2007 6 305000.4474947418 2014 7 "AARON INDUSTRIES" 693862.8 693862.8 . 1 2007 2007 7 173465.68589452517 2015 7 "AARON INDUSTRIES" 31625.557 31625.557 . 1 2007 2007 8 31625.55690904084 2004 8 "ABBOTT" 11277370 11535204 104568.8 133 1961 2004 43 1499855855.865098 2005 8 "ABBOTT" 18729456 19310292 578339.75 129 1961 2004 44 1689540069.7170644 2006 8 "ABBOTT" 18472182 18746220 8880865 108 1961 2004 45 1598121054.119387 2007 8 "ABBOTT" 32214094 32569138 25255262 103 1961 2004 46 1656992400.409758 2008 8 "ABBOTT" 36879372 38127580 7234408 99 1961 2004 47 2142910992.52344 2009 8 "ABBOTT" 34457748 34848544 67797.15 89 1961 2004 48 2201020370.9059067 2010 8 "ABBOTT" 35879268 37502196 4232198 82 1961 2004 49 2181284539.324025 2011 8 "ABBOTT" 32816464 34031788 2651.776 84 1961 2004 50 2029940306.3960855 2012 8 "ABBOTT" 27333772 31581784 865396.8 94 1961 2004 51 2225894374.1270456 2013 8 "ABBOTT" 46580236 48500412 976053.5 99 1961 2004 52 2727305730.021949 2014 8 "ABBOTT" 33949468 35378588 7886.491 99 1961 2004 53 2359259573.3842134 2015 8 "ABBOTT" 29031148 29661780 22129.54 94 1961 2004 54 2370530389.480409 2004 9 "ABBVIE" 300541632 300541632 . 33 1963 2004 41 9917874207.75519 2005 9 "ABBVIE" 398063520 398063520 . 33 1963 2004 42 10607521709.816193 2006 9 "ABBVIE" 711789248 711789248 . 32 1963 2004 43 11125455014.939121 2007 9 "ABBVIE" 485468992 485468992 . 32 1963 2004 44 10999908825.891459 2008 9 "ABBVIE" 471612384 499406368 26908488 34 1963 2004 45 11020835162.138296 2009 9 "ABBVIE" 619878528 619878528 . 34 1963 2004 46 11052308521.725805 2010 9 "ABBVIE" 775569536 775569536 . 34 1963 2004 47 11844314656.874342 2011 9 "ABBVIE" 471647968 471647968 . 34 1963 2004 48 12248782762.78322 2012 9 "ABBVIE" 423355936 423355936 . 33 1963 2004 49 12198970579.756456 2013 9 "ABBVIE" 670351680 691815744 47894516 30 1963 2004 50 11978041077.652853 2014 9 "ABBVIE" 574183808 630412352 11898461 33 1963 2004 51 13100594403.908373 2015 9 "ABBVIE" 532608064 548018368 24068394 34 1963 2004 52 16695333854.076557 2004 10 "ABER PHARM" 10196.007 10196.007 . 2 2003 2004 1 20392.013641854945 2008 11 "ABKIT" 830263.1 . 830263.1 2 2008 2008 0 1020956.3147491836 2009 11 "ABKIT" 1215518.4 1215518.4 . 2 2008 2008 1 2431036.790986024 2010 11 "ABKIT" 302000.13 302000.13 . 2 2008 2008 2 514778.3255435499 2011 11 "ABKIT" 133911.64 133911.64 . 2 2008 2008 3 66955.82008718849 2012 11 "ABKIT" 1857.2793 1857.2793 . 1 2008 2008 4 1857.2792628005145 2013 11 "ABKIT" 229202.33 229202.33 . 1 2008 2008 5 57300.58370722538 2014 11 "ABKIT" 124664.38 124664.38 . 1 2008 2008 6 31166.09542619379 2012 12 "ABL MEDICAL" 5597.375 . 5597.375 1 2012 2012 0 1399.3437130821144 2013 12 "ABL MEDICAL" 46875.85 46875.85 . 1 2012 2012 1 46875.852646417305 2014 12 "ABL MEDICAL" 92413.03 92413.03 . 1 2012 2012 2 92413.03425338621 2015 12 "ABL MEDICAL" 120786.42 120786.42 . 1 2012 2012 3 120786.41920184325 2004 13 "ACCENTIA PHARM" 3551802 3551802 . 1 2002 2004 2 3551802.0606248565 2005 13 "ACCENTIA PHARM" 5632205 5632205 . 1 2002 2004 3 5632204.502071029 2006 13 "ACCENTIA PHARM" 3682722 6138993 1226450.6 2 2002 2004 4 6445605.7851592805 2007 13 "ACCENTIA PHARM" 11139598 11139598 . 2 2002 2004 5 5607216.736637451 end
0 Response to Rescaling
Post a Comment