SURFing with Statistics New Zealand Statistics Teachers' Day

SURFing with Statistics New Zealand Statistics Teachers' Day

SURFing with Statistics New Zealand Statistics Teachers' Day 30 November 2007 Nathaniel Pihama and Deborah Brunning Statistics New Zealand What you will see today SURF for Schools

The Statistics New Zealand website Table Builder ..and some ideas on how to use them! The First SURF: a Synthetic Unit Record File for Schools Overview: Confidentiality Big Picture SURF???

What is it? How and why did we make a SURF? What teachers and students can do with the SURF What is a Unit Record File? Example: A Dataset: Name Gender No.Sibs Age;yrs

Amy F 1 14 Ben M 2 13 Cher F 1 15 Other names

Data set Unit Record Data set Microdata Confidentiality Safe Non release Unsafe

Useless Useful The pocket Raw dataset Confidentialised Unit Record Files Confidentiality methods include: Categorical Data Global recoding

Local recoding Numerical Data top/bottom coding, capping, rounding, Before Top and Bottom Coding After Top and Bottom Coding

Freq Freq 8 8 6

6 4 4 2 2 0

0 0 10 20 30

40 50 Salary: k$/yr 60 70

80 90 0 10 20

30 40 50 Salary: k$/yr 60

70 80 90 What is the SURF? Data from 200 synthetic respondents.

Target population is those aged 15-45 in paid employment. 7 variables What does the SURF look like? personi d gender

qualificati on 1 female school

15 4 87 2 female

vocational 40 42 3 male

none 38 4 female vocational

5 female 6 7 age hours

income marital ethnicity never european

596 married european 40 497

married maori 34 8 299

never european school 45 16

301 married european male degree

45 50 1614 married european

female none 36 12 201

other european The first 7 of 200 complete unit records SURF- the variables How to start SURFing?

The gender gap (Level 3 and 4) Do more females have higher qualifications than males? Is this different from how it was in the past? Am I average? (Level 4)

What defines the average person? Under pressure? (Level 5) Are people who have never been married different from married people?

Equal Pay! (Level 6) Are males and females paid equally? Money for nothing (Level 7) Investigating hours worked by employees in a company

Should I do a degree? (Level 8) Investigation into whether getting a degree helps improve earning power http://www.stats.govt.nz/schools-corner Task Money for Nothing A large company is concerned that it

has too many employees who do not work a 40-hour week. You have been hired to investigate the working patterns of the employees. Further Analysis- Hours by Gender SURF CURF

Related variables Hours by Marital Status SURF CURF Related variables Hours by Age Group SURF CURF

How school friendly is SURF???? SURF Excel spreadsheet Records are in random order First 30 records could be used for manual data analysis Use Excel How??????? An example of how to take a stratified sample

Add Age_10 variable Add random numbers (then paste special as values) Sort on random numbers Use filter copy and paste records Filter function

Pivot Tables Pivot Tables Box plots !!!! QUARTILE function SORT by Marital Regression and Residuals

Trend line in a scatter plot Good for quick visual check Provides equation & R-sq But no residuals 2000 1800 y = 17.058x + 0.3487

1600 Plot the data (XY scatter) (tidy plot up) Add Trendline Chart menu > Add trendline Options tab

1400 Income 2 R = 0.6323

1200 1000 800 600 400 200 0 0 20

40 Hours 60 80 Regression and Residuals Using Excel functions

SLOPE(), INTERCEPT(), RSQ() Copy cell ref into formula bar Regression and Residuals - Easy to create predicted values and residuals (can copy formula and use $) Regression and Residuals - Plot the residuals

1200 1000 Residuals 800 600 400 200 0

-200 -400 -600 Hours The Statistics New Zealand Website Stats NZ Products and Services Schools Corner Full of resources based on the curriculum.

Information releases Hot Off the Press Full of highlights, commentary, technical notes and tables! New Zealand in Profile Quick stats of New Zealand for 2007 Analytical reports Contain in depth analysis, background and technical information

Table Builder Customisable tables of released survey data Stats NZ Products and Services Schools Corner Full of resources based on the curriculum. Information releases Hot Off the Press Full of highlights, commentary, technical notes and tables!

New Zealand in Profile Quick stats of New Zealand for 2007 Analytical reports Contain in depth analysis, background and technical information Table Builder Customisable tables of released survey data

Stats NZ Products and Services Schools Corner Full of resources based on the curriculum. Information releases Hot Off the Press Full of highlights, commentary, technical notes and tables! New Zealand in Profile Quick stats of New Zealand for 2007

Analytical reports Contain in depth analysis, background and technical information Table Builder Customisable tables of released survey data Stats NZ Products and Services Schools Corner

Full of resources based on the curriculum. Information releases Hot Off the Press Full of highlights, commentary, technical notes and tables! New Zealand in Profile Quick stats of New Zealand for 2007 Analytical reports Contain in depth analysis, background and technical

information Table Builder Customisable tables of released survey data Battle for the greener suburb: an example of using case data from Table Builder The statistical investigation cycle:

(Wild and Pfannkuch, 1999) Problem the statement of the research questions Plan planning the procedures used to carry out the study Data the data collection process Analysis the summaries and analyses of the data to

answer the questions posed Conclusion the conclusions about what has been learned. Battle for the greener suburb: an example of using case data Comparing the traveling to work habits of area units within Auckland.

Which area has the greener workers? Walking / Running / Cycling Public transport Carpooling? Working at home?

Battle for the greener suburb: where to find the data We want a data source that contains information about modes of travel to work by area units. Luckily, we have the 2006 Census of Population and Dwellings on Table Builder!

So this is some of what Statistics New Zealand has to offer for teachers. Do you know about: Statzing? CensusAtSchool? Statistics and Research?

Recently Viewed Presentations

  • Information Integration Framework for Chemical & Petroleum ...

    Information Integration Framework for Chemical & Petroleum ...

    IIF - Information Integration Framework Ronald Montgomery IBM World Wide Industrial Solutions October 2007 Chemical & Petroleum Integration and Information Framework A common model based access method where information for production operations is easily and transparently accessible across multiple assets...
  • Anne Frank ABC Book - PBworks

    Anne Frank ABC Book - PBworks

    Anne Frank ABC Book By: Lexy Jacobson A: Annex Anne Frank lived in the secret Annex B: Brave The Frank family was brave for living in the Annex and having to leave their home C: Cat A cat lived in...
  • DTP Terms & Techniques You will need to

    DTP Terms & Techniques You will need to

    DTP. Terms & Techniques. TEXT WRAP: Text can be wrapped around a graphic which can help to create space within a document ,can connect the text closely to the image creating unity or can create flowing shapes helping to create...
  • Trauma Informed Care - acesconnection.com

    Trauma Informed Care - acesconnection.com

    Over-view Definitions Prevalence Impact of Trauma Trauma Informed Care Resiliency References Resources What is trauma A traumatic event is one in which a person experiences (witnesses or is confronted with): Actual or threatened death Serious injury Threat to the physical...
  • Welcome to the Privacy and Security Training Session!

    Welcome to the Privacy and Security Training Session!

    Companies that transmit PHI to CE include health information organizations and e-prescribing gateways and that require routine access to PHI. OCR reaffirms that "mere conduits" that do not access PHI, except on a random or infrequent basis, are not BAs.
  • Chemistry in Focus 3rd edition Tro - Cengage

    Chemistry in Focus 3rd edition Tro - Cengage

    Bohr Diagrams/Electron Configurations Based on the behavior of electrons as particles Electron orbits Specified with n, the orbit's quantum number Fixed energies Fixed radii Maximum number of electrons based on n This model is an oversimplification (as are most models)....
  • Is Morality Relative or are There Universal Standards?

    Is Morality Relative or are There Universal Standards?

    Is Morality Relative or are There Universal Standards? Two Possible Answers Absolutism Ethical Relativism Absolutism The notion that there is only one correct answer to every moral problem. A completely absolutist ethical theory consists of absolute principles that provide an...
  • From Mercantilism to Adam Smith: The Evolution of the Modern ...

    From Mercantilism to Adam Smith: The Evolution of the Modern ...

    From Mercantilism to Adam Smith: The Evolution of the Modern Capitalist System Ms. Susan M. Pojer Horace Greeley HS Chappaqua, NY Characteristics of Mercantilism "Bullionism" the eco. health of a nation could be measured by the amount of precious metal...