# spssforum.com

by SPSS users, for SPSS users
 It is currently Thu Jun 20, 2013 12:42 pm

 All times are UTC

 Page 1 of 1 [ 4 posts ]
 Print view Previous topic | Next topic
Author Message
 Posted: Sat Aug 13, 2011 6:41 pm

Joined: Fri Aug 12, 2011 10:06 pm
Posts: 4
Hi,

I'm new to the forum and I was wondering if someone can help me out. I'm not sure if this question is under the correct forum topic - my apologies for that!

I have been using excel all this while for basic frequencies and descriptives calculations. I'm trying to transition to SPSS and I was comparing the numbers for based on the excel calculation and SPSS output.

All the numbers match, except for Confidence Intervals - I'm getting a difference of 0.04 in the output. Everything is the same - mean, standard deviation and the sample size but, Lower and Upper bounds are off by 0.04.

Does anyone know why there would be a difference in both the calculations? Is there any way to correct that?

Thanks!
NKT

*Just realized that this was posted under the wrong forum topic.

Top

 Posted: Mon Aug 29, 2011 2:23 pm
 Moderator

Joined: Tue Jun 10, 2008 4:50 pm
Posts: 437
rounding?
or different confidence intervals (e.g. 1.96 vs. 1.98)?

Top

 Posted: Mon Aug 29, 2011 4:52 pm

Joined: Fri Aug 12, 2011 10:06 pm
Posts: 4
Different confidence interval.

Based on my research, I realized that Excel (everything later than 2007) uses Z-Test to calculate CI and SPSS only has the option for a T-Test for means and hence, the difference in confidence intervals.

Would you by any chance happen to know the syntax for a Z-Test?

Top

 Posted: Tue Aug 30, 2011 8:17 am
 Moderator

Joined: Tue Jun 10, 2008 4:50 pm
Posts: 437
I assume you mean: a variable with z-scores? or what do you mean?

you can write that yourself fairly easily based on the formula.
Use the aggregate function to create a variable with mean and sd.
If you can't get it to work come back

Top

 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending
 Page 1 of 1 [ 4 posts ]

 All times are UTC

#### Who is online

Users browsing this forum: No registered users and 1 guest

 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum

Search for:
 Jump to:  Select a forum ------------------ SPSS    General    Data input    Output    SPSS for beginners    Enhancing data    Modifying SPSS output    Coding SPSS syntax SPSS the software    Errors    Where is .. in SPSS Statistics    Statistics for beginners    Heavy statistics SPSS Jobs    SPSS Jobs SPSS Forum    Read this first    General feedback or questions about this forum    Library