Dear,

I performed a least squares regression. I will plot the results obtained with Gretl(coefficients) in Excel. However, I do not know how to proceed. Should I use theadjusted figures provided by Gretl or can I use a range of values ​​for the X axis?

By using a range of value for the X axis (with the regression coefficients of Gretl), the figures obtained in Excel showed exact correlation (R = 1). Therefore, I think I'm not plotting the graph correctly. 

 

I would like to plot the coefficients of the regression in the Excel, but I don´t know how to do this. I don´t know if I could use any X values or if I might use values provided by Gretl. Does anybody know how to proceed?

 
Thanks
Daniela T. Santos