We discussed how we can use RExcel in previous posts. By implementing RExcel we can perform cluster analysis and generate Dendogram plots.
(1) First load R and then R commander to see R menu in Excel (see previous posts)
(2) Following example uses dataset CO2 from the R dataset library. Load the data.
In statstics menu click Fit models and then linear regression.
Now we have to select one respnse variable and explanatory variables (one or more). Click OK will produce a regression model results (see outout window):
Happy plotting !!