data analysis using stata - reed college€¦ · data analysis using stata kristin bott kbott @...
TRANSCRIPT
![Page 1: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/1.jpg)
DataAnalysisusingStata
KristinBottkbott @reed.edu
<<Logintoacomputerwhileyou’rewaiting>>
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
blogs.reed.edu/datablog
![Page 2: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/2.jpg)
Intro/K.Bott+Data@ReedAssociateDirector,[email protected] /ETC225
Geospatial/Statistical/ComputationalsoftwareDataanalysis+presentation
Data@Reed :[email protected]/data-at-reed
![Page 3: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/3.jpg)
averyskeletalresearchprocess
Question
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
Data
Results
Conclusions
![Page 4: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/4.jpg)
data@reed/research+datasupport
Datadiscovery
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
Datavisualization
Datacitation
Dataanalysis
Datamanagement
Datawrangling
![Page 5: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/5.jpg)
Wherewe’reheaded(<60min)
• Stepzero:howtofindandpilotStata• Stepone:basicdataskills• Steptwo:externaldata• Stepthree:dataanalysis• Helpandresources
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 6: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/6.jpg)
wheretofind/howtoaccess
![Page 7: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/7.jpg)
WhereyoucanfindStata• Aroundcampus:– IRC’s(ETC)– Library– Eliot110/PPW(socialsciences)– Psychologycomputerlab
• “GradPlan”/optionforbuyingyourowncopy
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 8: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/8.jpg)
AccessingStata
Onyourcomputers-->Applications
>>StataSE
openStata !
…andlet’stakealook.
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 9: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/9.jpg)
Review Variables
(variable)propertiesCommand
Results
![Page 10: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/10.jpg)
WhatdidIdo?WhatdataamIworkingwith?
DatadetailsCurrentactionishere!
Whathappened?
• Point+click(GUI)vs command-line
![Page 11: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/11.jpg)
Stata datasets
• Pre-loaded,usefulfortraining/learning• Type:
. set more off
. sysuse dir
. sysuse auto(1978 Automobile data)
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 12: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/12.jpg)
stata:basicdataskills
![Page 13: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/13.jpg)
Dataisloaded:nowwhat?
Whatsortofinformationdoyouwanttoknowaboutyourdata?
Howcanwegettothisinformation?
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 14: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/14.jpg)
Somethingsyoumaywanttoknow
Range ofdata/outliersMissing values[Howmany?Howcoded?]
Types ofvariablesVariation ofdata
(stepone:lookatyourdata– databrowser).browse
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 15: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/15.jpg)
first-glancetools
.summarize (wholedataset)
.summarize rep78Observation/mean/StdDev /Min/Max
.describe (wholedataset)
.describe [var]var name/storagetype/disp format/valuelabel/var label
.codebook (wholedataset)
.codebook [var]type/range/units/unique/missing/mean/std dev /%tiles
![Page 16: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/16.jpg)
first-glancetools
.summarize (wholedataset)
.summarize [var]Observation/mean/StdDev /Min/Max
.describe (wholedataset)
.describe rep78var name/storagetype/disp format/valuelabel/var label
.codebook (wholedataset)
.codebook [var]type/range/units/unique/missing/mean/std dev /%tiles
![Page 17: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/17.jpg)
first-glancetools
.summarize (wholedataset)
.summarize [var]Observation/mean/StdDev /Min/Max
.describe (wholedataset)
.describe [var]var name/storagetype/disp format/valuelabel/var label
.codebook (wholedataset)
.codebook [var]type/range/units/unique/missing/mean/std dev /%tiles
![Page 18: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/18.jpg)
Variablestoragetypes
• Describe orvariablewindowshows“storagetype”
• Numbers– byte,int(eger),long,float,double– varyinprecision+memorytheyuse(bytes)
• Letters:– String– str1,str2,…str244
• Question::Whydoesthismatter?
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 19: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/19.jpg)
Variablestoragetypes
• Describe orvariablewindowshows“storagetype”
• Numbers– byte,int(eger),long,float,double– varyinprecision+memorytheyuse(bytes)
• Letters:– String– str1,str2,…str244
• Question::Whydoesthismatter?
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
Youcan’tfindthemeanofwords...
![Page 20: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/20.jpg)
first-glancetools
.summarize (wholedataset)
.summarize [var]Observation/mean/StdDev /Min/Max
.describe (wholedataset)
.describe [var]var name/storagetype/disp format/valuelabel/var label
.codebook (wholedataset)
.codebook rep78type/range/units/unique/missing/mean/std dev /%tiles
![Page 21: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/21.jpg)
first-glancetools
.summarize (wholedataset)
.summarize [var]Observation/mean/StdDev /Min/Max
.describe (wholedataset)
.describe [var]var name/storagetype/disp format/valuelabel/var label
.codebook (wholedataset)
.codebook [var]type/range/units/unique/missing/mean/std dev /%tiles
![Page 22: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/22.jpg)
somefirst-glancetools
.tabulate foreignvariable/frequency/percent/cumulative%
.tabulate [var1] [var2]whatdoesthisdo?
.tabulate [var2] [var1]whatdoesthisdo?
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 23: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/23.jpg)
somefirst-glancetools
.tabulate (wholedataset)
.tabulate [var]variable/frequency/percent/cumulative%
.tabulate foreign rep78whatdoesthisdo?
.tabulate [var2] [var1]whatdoesthisdo?
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 24: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/24.jpg)
somefirst-glancetools
.tabulate (wholedataset)
.tabulate [var]variable/frequency/percent/cumulative%
.tabulate make rep78whatdoesthisdo?
.tabulate [var2] [var1]whatdoesthisdo?
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
Hmm…doIhaveobservationsforthesamemake+repairrecord?
![Page 25: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/25.jpg)
kbott’s first-glancetoolbox
Fordataset or[var]or[var1][var2].summarize.codebook.describe.tabulate.inspect .browse.list
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
belazy!– useonlyafew(unique)lettersforcommands
![Page 26: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/26.jpg)
Basics:[browse]subsetsofdata
browse if foreign == 1 (equals)browse if foreign ~= 1 (notequal)browse if foreign != 1 (notequal)
browse if mpg > 5 & mpg < 20 (&joinsmultiple)
browse make mpg in 1/10(rangeofvalues)
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
Canalsouseview toseeresultsinmainwindow
![Page 27: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/27.jpg)
Basics:alterdata
.sort var (sortsfromlowtohigh)
.drop var (dropvariable,keeprest)
.keep var (keepvariable,droprest)
.replace var (replaceexistingvariable)
.generate var (generatenewvariable)
.egen var (extendedgenerate)
.clear [dataset](clearsfrommemory,doesnot erasedata)
![Page 28: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/28.jpg)
dataanalysis+visualization
![Page 29: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/29.jpg)
Basics(stockdataset)
• Histograms. sysuse auto. hist price, freq. hist price, freq bin(5). hist price, freq bin(15)
. hist price if foreign==1, freq bin(15)
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 30: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/30.jpg)
![Page 31: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/31.jpg)
Basics(stockdataset)
• Scatterplots. sysuse auto. scatter mpg weight. scatter mpg weight || lfit mpg weight
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 32: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/32.jpg)
Analyze:twovariables
. correlate mpg weight
. regress mpg weight
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 33: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/33.jpg)
Analyze:twovariables
. correlate mpg weight
. regress mpg weight
Examinerelationshipbyforeign/domesticvehicles. by foreign: regress mpg weight
Examinerelationshipforonlyforeignvehicles. regress mpg weight if foreign==1
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 34: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/34.jpg)
Homework#3
additional+specifictools
![Page 35: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/35.jpg)
Homework#3
• Measuresofcentraltendency+dispersion. summarize. tabulate
• Visualization. scatter
• Analysis. regress. predict
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 36: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/36.jpg)
Homework#3
• Measuresofcentraltendency+dispersion. summarize. tabulate
• Visualization. scatter
• Analysis. regress. predict. help predict
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 37: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/37.jpg)
Help+additionalresources
![Page 38: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/38.jpg)
Help!+additionaltools
• Stata HelpMenu– contents– search– command
• Atthecommandline– help– search– findit
• External(toStata)resources• Trackworkviadofiles
K.Bott /InstructionalTechnologyServicesReedCollege/Portland,OR
![Page 39: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/39.jpg)
Keytocollaboration:Dofiles
SaveyoutimeforrepetitioustasksMinimizeserrorsStoreyourdataanalysisprocess
.doeditorviaGUI
![Page 40: Data Analysis using Stata - Reed College€¦ · Data Analysis using Stata Kristin Bott kbott @ reed.edu > K.Bott / Instructional](https://reader033.vdocuments.us/reader033/viewer/2022042916/5f576c1a5ae27c73563460c4/html5/thumbnails/40.jpg)
Kbott OfficeHoursbyappointment
helpdocumentation+moreD@Rsite:reed.edu/data-at-reed
[email protected] |ETC225