In the example below, when I click results.xlsx, the file tries (and fails) to open using my browser. How do I direct Stata to open the file using MS Excel? I am using the latest version of StataSE 17 on an M1 Mac, for reference.
Code:
. sysuse auto.dta, clear
(1978 automobile data)
. reg price mpg
Source | SS df MS Number of obs = 74
-------------+---------------------------------- F(1, 72) = 20.26
Model | 139449474 1 139449474 Prob > F = 0.0000
Residual | 495615923 72 6883554.48 R-squared = 0.2196
-------------+---------------------------------- Adj R-squared = 0.2087
Total | 635065396 73 8699525.97 Root MSE = 2623.7
------------------------------------------------------------------------------
price | Coefficient Std. err. t P>|t| [95% conf. interval]
-------------+----------------------------------------------------------------
mpg | -238.8943 53.07669 -4.50 0.000 -344.7008 -133.0879
_cons | 11253.06 1170.813 9.61 0.000 8919.088 13587.03
------------------------------------------------------------------------------
. etable, export(results.xlsx)
---------------------------------
price
---------------------------------
Mileage (mpg) -238.894
(53.077)
Intercept 11253.061
(1170.813)
Number of observations 74
---------------------------------
(collection ETable exported to file results.xlsx)
