Re: Can we copy residuals of predictions into excel sheet?

Great Peter, I will try it today.

Thank you for your help.

Best regards

On Tuesday, April 27, 2021, Peter Reutemann <[email protected]> wrote:

> > When we perform the prediction in the classify tab, we get the residuals
> (difference between predicted and actual values).. I want to perform the
> statistical tests based on these residuals and for that, I have to export
> these values into excel (It is difficult to manually type them).
> >
> > My question is can we directly export these values into excel ? Because
> I am unable to copy them and paste into the excel sheet.
>
> I presume you are referring to the "error" column in the predictions?
>
> In the "More options" dialog in the Explorer, instead of using
> "PlainText"  for "Output predictions", select "CSV". Open the
> properties for the CSV output and select an appropriate output file.
>
> The generated CSV file you should be able to import in Excel
> (personally, I prefer LibreOffice's import dialog for CSV files).
>
> Cheers, Peter
> --
> Peter Reutemann
> Dept. of Computer Science
> University of Waikato, NZ
> +64 (7) 577-5304
> http://www.cms.waikato.ac.nz/~fracpete/
> http://www.data-mining.co.nz/
> _______________________________________________
> Wekalist mailing list -- [email protected]
> Send posts to [email protected]
> To unsubscribe send an email to [email protected]
> To subscribe, unsubscribe, etc., visit https://list.waikato.ac.nz/
> postorius/lists/wekalist.list.waikato.ac.nz
> List etiquette: http://www.cs.waikato.ac.nz/~
> ml/weka/mailinglist_etiquette.html
>

_______________________________________________
Wekalist mailing list -- [email protected]
Send posts to [email protected]
To unsubscribe send an email to [email protected]
To subscribe, unsubscribe, etc., visit https://list.waikato.ac.nz/postorius/lists/wekalist.list.waikato.ac.nz
List etiquette: http://www.cs.waikato.ac.nz/~ml/weka/mailinglist_etiquette.html