JiscMail Logo
Email discussion lists for the UK Education and Research communities

Help for ALLSTAT Archives


ALLSTAT Archives

ALLSTAT Archives


allstat@JISCMAIL.AC.UK


View:

Message:

[

First

|

Previous

|

Next

|

Last

]

By Topic:

[

First

|

Previous

|

Next

|

Last

]

By Author:

[

First

|

Previous

|

Next

|

Last

]

Font:

Monospaced Font

LISTSERV Archives

LISTSERV Archives

ALLSTAT Home

ALLSTAT Home

ALLSTAT  1999

ALLSTAT 1999

Options

Subscribe or Unsubscribe

Subscribe or Unsubscribe

Log In

Log In

Get Password

Get Password

Subject:

COURSES: MS Excel for Statistics/Scientific Data Management using MS Access

From:

Kellie Watkins <[log in to unmask]>

Reply-To:

Kellie Watkins <[log in to unmask]>

Date:

Tue, 26 Oct 1999 10:19:07 +0100

Content-Type:

text/plain

Parts/Attachments:

Parts/Attachments

text/plain (99 lines)

We are announcing the following courses, taking place at the Statistical
Services Centre, The University of Reading.


MICROSOFT© EXCEL(TM) FOR STATISTICS? WHAT YOU CAN AND CANNOT DO
15-16 November 1999

SCIENTIFIC DATA MANAGEMENT USING MS© ACCESS(TM)
17-18 November 1999


For further information and registration details please contact Kellie
Watkins ([log in to unmask]) providing an address and/or fax number.

____________________________________________________________________________
_________________

MICROSOFT© EXCEL TM FOR STATISTICS? WHAT YOU CAN AND CANNOT DO
15-16 November 1999

This two day course is designed for Excel users who need to get the most
out of Excel for statistical analysis.

Excel has both strengths and weaknesses for statistical applications and
the course aims to highlight these and to indicate at which point it would
be more advisable to switch to specialised statistical software.
In addition to Excel's worksheet functions which include a number of
facilities for probability and statistical calculations, there are also
some procedures for statistical data analysis available as "add-ins" in the
"Analysis ToolPak". The most useful of these functions and procedures will
be explored in the course.
Other important aspects of statistical data analysis are data management,
data summary and exploration, tabulations and statistical graphics. The
extent to which Excel can be used for these aspects, as well as its
limitations, are also covered.

A major element of the course is practical work which will be done in the
Centre's well-equipped computing laboratory.

Course Content
Ø Data management concepts and techniques
Ø Summary statistics and data exploration
Ø Tabulations
Ø Statistical graphics
Ø Statistical tools provided with Excel, including descriptive statistics,
hypothesis tests, correlation and regression, analysis of variance
Ø Getting the most out of Excel functions
Ø Using Excel with statistics packages


Participants are assumed to have some familiarity with basic Excel skills
and with elementary statistical methods.


____________________________________________________________________________
________________________

SCIENTIFIC DATA MANAGEMENT USING MS© ACCESS TM
17-18 November 1999

Research generates data of different levels of complexity for which a
spreadsheet has limitations if used as a data management tool. This is
especially true for hierarchical structures. Using the wrong approach to
the management of data can lead to data redudancy and can compromise data
integrity. Often a relational database management system is the answer,
and during the course Access is demonstrated, as it is widely available,
although the concepts apply to any relational database package.

The course will cover database design, data entry and validation. This
includes creating tables, assigning primary keys, setting up relationships
between tables, designing forms for data entry and imposing restrictions on
the type of data that can be entered in particular fields. We will also
look at ways of transferring subsets of data to Excel or to a statistics
package for analysis. Implicit in this is the use of queries. During the
course we will use example databases on survey, monitoring and experimental
data.

There are many training courses and books available which deal with Access
for business application - in contrast this course will focus on scientific
work.

Kellie Watkins
Statistical Services Centre
The University of Reading
Harry Pitt Building
PO Box 240
Whiteknights Road
Reading RG6 6FN
UK

Tel: +44 (0)118 931 8689
Fax: +44 (0)118 975 3169
Email: [log in to unmask]

See our website on http://www.reading.ac.uk/ssc


%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Top of Message | Previous Page | Permalink

JiscMail Tools


RSS Feeds and Sharing


Advanced Options


Archives

March 2024
February 2024
January 2024
December 2023
November 2023
October 2023
September 2023
August 2023
July 2023
June 2023
May 2023
April 2023
March 2023
February 2023
January 2023
December 2022
November 2022
October 2022
September 2022
August 2022
July 2022
June 2022
May 2022
April 2022
March 2022
February 2022
January 2022
December 2021
November 2021
October 2021
September 2021
August 2021
July 2021
June 2021
May 2021
April 2021
March 2021
February 2021
January 2021
December 2020
November 2020
October 2020
September 2020
August 2020
July 2020
June 2020
May 2020
April 2020
March 2020
February 2020
January 2020
December 2019
November 2019
October 2019
September 2019
August 2019
July 2019
June 2019
May 2019
April 2019
March 2019
February 2019
January 2019
December 2018
November 2018
October 2018
September 2018
August 2018
July 2018
June 2018
May 2018
April 2018
March 2018
February 2018
January 2018
December 2017
November 2017
October 2017
September 2017
August 2017
July 2017
June 2017
May 2017
April 2017
March 2017
February 2017
January 2017
December 2016
November 2016
October 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
February 2014
January 2014
December 2013
November 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2013
April 2013
March 2013
February 2013
January 2013
December 2012
November 2012
October 2012
September 2012
August 2012
July 2012
June 2012
May 2012
April 2012
March 2012
February 2012
January 2012
December 2011
November 2011
October 2011
September 2011
August 2011
July 2011
June 2011
May 2011
April 2011
March 2011
February 2011
January 2011
December 2010
November 2010
October 2010
September 2010
August 2010
July 2010
June 2010
May 2010
April 2010
March 2010
February 2010
January 2010
December 2009
November 2009
October 2009
September 2009
August 2009
July 2009
June 2009
May 2009
April 2009
March 2009
February 2009
January 2009
December 2008
November 2008
October 2008
September 2008
August 2008
July 2008
June 2008
May 2008
April 2008
March 2008
February 2008
January 2008
December 2007
November 2007
October 2007
September 2007
August 2007
July 2007
June 2007
May 2007
April 2007
March 2007
February 2007
January 2007
2006
2005
2004
2003
2002
2001
2000
1999
1998


JiscMail is a Jisc service.

View our service policies at https://www.jiscmail.ac.uk/policyandsecurity/ and Jisc's privacy policy at https://www.jisc.ac.uk/website/privacy-notice

For help and support help@jisc.ac.uk

Secured by F-Secure Anti-Virus CataList Email List Search Powered by the LISTSERV Email List Manager