If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel question

TheNibbler · 2008-02-01 15:16:56

Not at all sure if this is where I should be posting this or even if boards.ie is the best place to get it answered but anyway............................................................ I'm doing a project at the moment that has produced a lot of data. I usually use SPSS but think that Excel might be better for this job.…

01-02-2008 4:16pm

#1

TheNibbler

Registered Users, Registered Users 2 Posts: 271 ✭✭

Join Date: July 2006

Posts: 190

Not at all sure if this is where I should be posting this or even if boards.ie is the best place to get it answered but anyway............................................................

I'm doing a project at the moment that has produced a lot of data. I usually use SPSS but think that Excel might be better for this job. Basically I want to remove all the data points which are more than three interquartile ranges above the median of the overall distribution. Anyone know how to do this? Should also say that I am a serious beginner when it comes to Excel.

0

Comments

#2 01-02-2008 4:19pm

Sherifu

Registered Users, Registered Users 2 Posts: 17,727 ✭✭✭✭

Join Date: July 2004

Posts: 17365

Look into using macros.

0
#3 01-02-2008 4:36pm

TheNibbler

Registered Users, Registered Users 2 Posts: 271 ✭✭

Join Date: July 2006

Posts: 190

rkm wrote: »

Look into using macros.

This will probably show how new to Excel I am but what are/is macros?!!

0
#4 01-02-2008 4:48pm

Sherifu

Registered Users, Registered Users 2 Posts: 17,727 ✭✭✭✭

Join Date: July 2004

Posts: 17365

http://www.excel-vba.com/

0
#5 01-02-2008 5:55pm

faceman

Moderators, Category Moderators, Arts Moderators, Entertainment Moderators, Social & Fun Moderators Posts: 16,651 CMod ✭✭✭✭

Join Date: June 2005

Posts: 15395

how large is the data you are working with?

0