changing default setting of frequency tables

Discussion in 'SPSS' started by Jun Suzuki, Dec 20, 2011.

  1. Jun Suzuki

    Jun Suzuki Guest

    Hi,
    Is there a way to change the default setting of frequency tables so
    that percent columns are shown with %? When cut/paste frequency tables
    to Excel, you need to devide it by 100, and it's annoying. Crosstabs
    and other custom tables outputs do have percent shown with %, but not
    frequency tables. Thanks for your help!

    Jun
     
    Jun Suzuki, Dec 20, 2011
    #1
    1. Advertisements

  2. Jun Suzuki

    Jon Peck Guest

    Excel and Statistics have different ideas about what % means. In Statistics, it is just a format, and it displays the numerical value. In Excel, percent format automatically scales. So you will have to either divide by 100 or change the format in Statistics or Excel.

    You could manipulate the pivot table in Statistics with an autoscript to transform the data automatically.

    HTH,
    Jon Peck
     
    Jon Peck, Dec 20, 2011
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.