MS 150 Statistics

Fall 2008
Spreadsheets	Notes	Quizzes and Tests
Calendar Course Outline Project Attaching files in Yahoo! Email addresses for life commentary Favorite colors • html Baby names! • Local Baby name choices of students fall 2008 FSM Statistics Unit Pacificweb.org FSM Census projections Long term weight loss is a challenge Body fat data • Excel format • web page html	Cover • Title page • Table of Contents 1 Introduction 2 Visualizing data 3.1 Measures of center 3.2 Variation 3.4 Relative standing 4 Regression 5 Probability 6 Probability distributions 7 Normal distribution 8 Sampling distributions 9 Estimating population parameters 10 Hypothesis testing 11 Inferences about sample means for two samples Textbook:	Prequiz 15 Aug 08 q01 1.3

Summer 2008
Spreadsheets	Quizzes and Tests
Calendar Course Outline Project Attaching files in Yahoo! Email addresses for life commentary Favorite colors summer 2008 • ods Favorite colors • xls • ods Body fat spreadsheet • ods • html Pennies.ods Youth pedometer data Dorm TV confidence interval BFI July Long term weight loss is a challenge	test one 2.2 • t1a • ods test two 4.3 • t2 xhtml variant • t2a.ods test three (midterm) 5.3 • t3a.ods t4 Normal Distribution 7.5 • ans test five confidence interval • t5a.ods test six paired t-test for the means • solutions test seven (final examination) Data sheet for final • t7a

Spring 2008
Calendar Course Outline Project Favorite colors Random function examples • Excel format Day name spreadsheet Body fat data • xls • html Marble race: an advanced stat project HW 11 Feb • xls • html Pennies homework 03/05 • html distribution of the sample mean Body fat paired t-test 4/21 • xls • html Activity levels among college students as measured by a pedometer • PDF Activity levels among second grade students as measured by a pedometer • PDF Activity levels versus age • PDF	Prequiz 11 Jan 08 • ans • html q01 1.3 q02 2.2 • q02 ans .ods t1 3.4 • t1a.ods q03 4.4 q03a.ods q04 5.1 • q04heat.ods q05sms • q05a.ods • q05a Megasteps • .ods q06 7.1 q04 7.4 t2 9.2 • t2a html • ods q08 9.3 ci p • ods q09 10.2 hyp test q10 10.3 p-value q11 11.2 hyp test indep samples q12 linear regression q13 page one of whirlpool q14 confidence interval fx steps • data sheet ans • .ods

Spring 2008

Spreadsheets

Quizzes and Tests

Calendar
Course Outline
Project

Favorite colors
Random function examples • Excel format
Day name spreadsheet

Body fat data • xls • html
Marble race: an advanced stat project
HW 11 Feb • xls • html
Pennies homework 03/05 • html
distribution of the sample mean
Body fat paired t-test 4/21 • xls • html

Activity levels among college students as measured by a pedometer • PDF
Activity levels among second grade students as measured by a pedometer • PDF
Activity levels versus age • PDF

Prequiz 11 Jan 08 • ans • html
q01 1.3
q02 2.2 • q02 ans .ods
t1 3.4 • t1a.ods
q03 4.4 q03a.ods
q04 5.1 • q04heat.ods
q05sms • q05a.ods • q05a
Megasteps • .ods
q06 7.1
q04 7.4
t2 9.2 • t2a html • ods
q08 9.3 ci p • ods
q09 10.2 hyp test
q10 10.3 p-value
q11 11.2 hyp test indep samples
q12 linear regression
q13 page one of whirlpool
q14 confidence interval
fx steps • data sheet
ans • .ods

Fall 2007
Calendar Course Outline Finding the calculator and spreadsheet Calc vs Excel differences • odt Assistance with email Info on social networking sites Social networking taxonomy Email to statistics students about addresses Favorite colors • .ods Flickr favorite color Baby names! First names • .ods Body fat key FSM rank in obesity World's Fattest Countries complete list New World Syndrome Island Food Community of Pohnpei Exercise, not diet, the key Obesity Epidemic Threatens Health in Exercise-Deprived Societies Pareto chart example • .ods HW 8:30 class: male body fat histograms HW 9:30 class: female body fat histograms Body fat data as a web page body fat ods [A204 lab only] body fat xls [library and elsewhere] HW 0829 body fat .ods When a histogram shape forced a change • .ods Ages of students 2007 linear regressions • xls • html ballbounce.ods • Excel version Making an XY scattergraph with Excel or OpenOffice Linear regression/best fit line practice • ans q04 5.1 Fav color rel freq prob 6.1 hw 0929 ods psychoactive substance survey Female height normal curve Pennies and the normal curve formulae.odg 21 Nov BFI homework Excel • .ods • .ods Marble size independent ttest.ods • html	Prequiz • .ods q01 1.2 q02 2.3 • q02a.ods t1 fish 3.4 • t1a html • t1a ods q03 4.4 • q03a ods q04 5.1 • q04a ods q05 6.1 Metals mx 7.1 ans • .ods q06 7.2 (7.4) q07 7.3 (7.5) q08 9.0 • ans • ods t2 refraction 9.2 t2a • ods q09 10.1 • ans • .ods Worksheet 10 10.2 • q10a.ods q11 11.1 q12 11.2 fonts • ans • .ods q13 4.4 linear reg review • q13a • .ods Jump rope fx data sheet ans and analysis

Fall 2007

Spreadsheets

Quizzes and Tests

Calendar
Course Outline

Finding the calculator and spreadsheet
Calc vs Excel differences • odt

Assistance with email
Info on social networking sites
Social networking taxonomy
Email to statistics students about addresses

Favorite colors • .ods
Flickr favorite color

Baby names!
First names • .ods
Body fat key
FSM rank in obesity
World's Fattest Countries complete list
New World Syndrome
Island Food Community of Pohnpei
Exercise, not diet, the key
Obesity Epidemic Threatens Health in Exercise-Deprived Societies
Pareto chart example • .ods

HW 8:30 class: male body fat histograms
HW 9:30 class: female body fat histograms
Body fat data as a web page
body fat ods [A204 lab only]
body fat xls [library and elsewhere]
HW 0829 body fat .ods
When a histogram shape forced a change • .ods
Ages of students 2007
linear regressions • xls • html
ballbounce.ods • Excel version
Making an XY scattergraph with Excel or OpenOffice
Linear regression/best fit line practice • ans
q04 5.1
Fav color rel freq prob 6.1
hw 0929 ods
psychoactive substance survey
Female height normal curve
Pennies and the normal curve
formulae.odg
21 Nov BFI homework Excel • .ods • .ods
Marble size independent ttest.ods • html

Prequiz • .ods
q01 1.2
q02 2.3 • q02a.ods
t1 fish 3.4 • t1a html • t1a ods
q03 4.4 • q03a ods
q04 5.1 • q04a ods
q05 6.1
Metals mx 7.1
ans • .ods
q06 7.2 (7.4)
q07 7.3 (7.5)
q08 9.0 • ans • ods
t2 refraction 9.2
t2a • ods
q09 10.1 • ans • .ods
Worksheet 10 10.2 • q10a.ods
q11 11.1
q12 11.2 fonts • ans • .ods
q13 4.4 linear reg review • q13a • .ods
Jump rope fx
data sheet
ans and analysis

Summer 2007

Spreadsheets

Quizzes and Tests

Calendar
Course Outline

Finding the calculator and spreadsheet
Calc vs Excel differences • odt

Assistance with email
Info on social networking sites
Social networking taxonomy
Email to statistics students about addresses

Favorite colors
Body fat data
BFI male data for a number of terms
Population 2007 • html • openoffice calc ods file
In class age distribution example ods only
In class ESL 079 distribution example ods only
EN 110 Distribution homework • html • .ods
Tennis ball bounce histogram: MS • WK
superballs
Gates-McGinite correlation
.ods • .html
Yap 1947
Goby larval stage length
Pennies.xls • .ods
Utilities data sheet
Goby larval stage length
Cigarette butt data
Normal distribution worksheet
Market ci
Hypothesis test worksheet
CI worksheet
Superballs worksheet
BFI differences term start to end

t1 2.3
t2 3.1 • t2a.xls • t2a.html • t2a.ods
Midterm 4.4 • mxa.ods • html
t3 normal dist • t3work.ods
t4.odt tinv ci • t4a.ods
t5 ttest indep samples • pdf
t5a 11.2 [OOo Calc text]
t5a.xls • t5a.ods
Homeless fx
homeless.html
homeless.xls Excel
homeless.ods OpenOffice

Spring 2007

Spreadsheets

Quizzes and Tests

Calendar
Course Outline

Body fat data • xls
Female height data work
Homework 2.4 p84
Golf ball drop ods
HW 9.2 2a 10 • ods
FSM 2000 soln html • ods • xls
FSM Statistics Unit
United States Insular Areas Statistics
2005 Housing Income and Expenditure Survey
FSM 2005 Housing Survey (local copy)
Pennies data
Mean of means
World Health Org FSM Obesity data
CI HW using t-distribution • .xls • html
Fair die?

q01
q02 • data xls • data ods
t1 2.4 • t1a • ods • xls
q03 lin reg • q03a ods Excel: xls
q04 power bills
Mx • ans • ods
q05 confidence interval using NORMINV
q05a ods • xls • html
q06
t2 ci • ans • pdf • ods
q07 • q07a.ods
q08.ods t-test independent samples
q09 Linear regression review quiz • q09a.ods
q10 review histograms, ci • q10a.html• q10a.ods
Glaciers • data • ans .xls • .pdf • .ods

Fall 2006

Spreadsheets

Quizzes and Tests

Calendar

Assignments overview

Baby names rank order popularity
body fat.ods • xls • html

L1 data from JG • html
Vilfredo Pareto
Creating histograms with Excel • odt
Creating histograms with OpenOffice.org Calc • odt
HW 3.1 ods • html • xls
HW 3.2 ods
Golf ball drop • html • xls
HW 4.3 • html
Pohnpei 1958 • Yap 1947 • All-in-one
Track laps • html
Pennies.ods • .xls (Excel)
Cherry leaf measurements ods • html • xls
One hundred confidence intervals
Traffic study project
Variation in the confidence interval with change in the sample size n
Traffic study data
Effect of c on interval: two t c.i.
Hypothesis testing

PreQuiz
q01 1.2
Quiz 2 2.2
t1 3.2 • t1a • ods • xls
q03 4.2 • q03a ods • html • xls
q04 5.1 • q05 6.1
Midterm 6.1 • mxa.ods • html
q06 6.1 pennies odt • html
q07 7.3a • q08 7.3b
q09 9.1
t2 • t2.ods
q10 hyp test with confidence interval 9-10 • q10a.ods
q11 hyp test 10.3 10.4
q12 linear regression review • q12a
q13
Sakau • data • Pehleng • pehleng.xls • fxa.xls

Spring 2006

Spreadsheets

Quizzes and Tests

Calendar
Course Outline
xls • html • ods
Central tendency • html • ods
FSM 2000 data • m10 soln
Alcohol survey
pennies • html • ods
x to z to area to the left of z
x to z to area with normal curve displayed
Guava leaf lengths
sample mean to z to area
Linear correlation species .ods
confidence interval
confidence interval z
confidence interval t • .ods
Duke pre-post.ods
EC-300 calibration lin reg
data • .ods
bloodpressure • .ods

PreQuiz • s53fxa
q01 • q02 2.2
t1 3.2 • t1a
q03 4.2 • q03a • html • ods
q04 5.1
Midterm • answers • html • ods
q05 7.1 • q6 7.3a • q6a
q7 7.3b
t2 9.2 • ans
Q08 9-10
Q09 hypothesis
Q10 review quiz
Found data fx • fxa.ods

Fall 2005

Spreadsheets

Quizzes and Tests

Calendar
BFI xls • html • ods
rain xls • ans • ods
Frequency function
Another frequency explanation • xls
Homework 3.2 p100 • html • ods
Drop bounce xls • html • ods
Run to NBFS • html • ods
raise one eyebrow • html • ods
Pohnpei population 1958 • html • ods
Pennies • html • ods
PICS CHS normal 7.3
PICS CHS normal 7.3 • ods
Guava leaf lengths
Guava confidence intervals
Hypothesis test worksheet
BFI paired t-test • html • ods
Fibobelly 11.3 • html • ods
p488 #1 • html • ods
Belly button ratio: M9
Belly button ratio: M9 & M10

Q01 1.1
Q02 2.2 • xls • html • ods
Q03 3.2 • ans • html • ods
t1 4.2 • xls • html • ods
Q04 4.2 • xls • html • ods
Q05 6.1 • xls • html • ods
Mx 6.1 • ans • html • ods • prep
Q07 7.3 • ans • html • ods
q08 9.2
t2 9.4 • t2a • html • ods
q09 9-10 • q10 10 • q11 11.1
q12 r4.3 • ans • html • ods
Faraway Rainbow
data • ans • html • ods
Generating spreadsheet • xls

Spring 2005

Spreadsheets

Quizzes and Tests

calendar
bfi • html • sxc
Pop data • html • sxc
8 bin hw • html • sxc
run hw data
run html sxc
Yap 47 • html • sxc
substance use • html • sxc
Pennies
tracklanes • sxc
Pick ten • html • sxc • ods
ci to hypothesis test
Kosrae High School
HS data • + stats
Duke Kahanamoku
xll • xla1 • xla2 • xla3
ADV XHS CCA
Lap worksheet • ans • sxc

Quiz 1
q2 2.1 • xls • html • sxc
t1 2.2 • xls • html • sxc
Q3 4.2 • Q4 5.1 • Q5 6.1
Mx 6.3 • xls • html • sxc • ods q06 6.1 • html • sxc
q07 7.3
q08 9.2 • xls • html • sxc • ods
t2 • t2a • xls • html • sxc • ods
q9 hyp test • xls • html • sxc • ods
q10 binom hyp • sxw • odt
q11 r4.3 • Some solns
q12 r3.2 + ci
Fish • data sheet • ods
ans xls • html • sxc • ods

Fall 2004

Spreadsheets

Quizzes and Tests

Calendar
BFI • html • sxc
High School • html • sxc
Body fat HW • html • sxc
Central tendency handout
sxc • xls
Track laps central tendency hw
ans • html • sxc
lin reg hw • html • sxc
bounce ans • html • sxc
Non-linear regression
Infant mortality homework
xls • html • sxc
Mean from RF • html • sxc
xls • html • sxc
Track laps redux • html • sxc
ans • html • sxc
track laps normal • html • sxc
PICS essay • html • sxc
Normal statistics with curve
Sample mean normal statistics with curve • sxc
Female bfi homework
roasting coffee homework
z versus t confidence interval
Confidence interval based on t
t ci bats!
ci to hypothesis
Duke paired t-test
Bats
Daily temps for Pohnpei for 47 years!

Quiz 1 1.2 • Quiz 2 2.1
t1 2.2 • xls • html • sxc
q3 3.2 • q4 4.3 • q4a
q5 6.1 • xls • html • sxc
MX Tires • xls • html • sxc q6 7.2
q7 7.3 • q7a • xls
t2 7.3 • q8 9.1 • xls
q9 ci hyp test 9-10
q10 hyp test
q11 r4.3 • Data • q11a
q12 • xls • html • oos
Fitness
ans • html • ods

Spring 2004
Spreadsheets	Quizzes and Tests
Calendar Charts • html • sxc Linear xls • html • sxc M&M's® xls • html • M&M's® web site • sxc z to x • Normal statistics High School data • sxc Body fat end m9 • m10 V = iR 3.3 review • html • sxc • sxw	q1 1.1 q2 1.4 • q2a • sxc t1 2.2 • t1a • html • sxc q3 3.2 • q3a xls • html • sxc q4 4.1 q5 5.1 • xls • html • sxc Mx 5.1 • 5.1a • html • sxc q06 pennies • html • sxc q07 6.1 t2 6.3 • xls support • sxc q8 7 • q9 82 q10 94 q11 r3.3 (s23q3 s23q10) q11ans • html • sxc Golfdrop fx • ans • xls • sxc • planning

Quizzes, Tests, Midterms, and Finals
Fall 2003	Spring 2003	Fall 2002
q01 1.1 • q02 1.4 q02 ans • t1 2.2 • t1 2.2a q03 3.3 • q03a • q04 4.1 Mx 5.1 • Ans xls • html • sxc WS q05 • soln • html • sxc q06 6.2 • t2 6.3 • sxc q07 8.1 • q07a • html • sxc q08 8-9 • q09 3.3rev ws10 1.4 5.1 • html • sxc s33q11 • xls • html • sxc Whirlpool fx • xls • sxc	Q1 1.1 • Q2 1.4 Bins T1 2.2 • T1 Ans • s31t1 Q3 3.1 • Q4 3.3 4.1 Midx 5.1 • Mx Ans • s31ans District two 2003 Penny distribution Q5 5.1 6.1 • Q6 6.3 T2 6 8.2 Q8 8.1 Q9 9.1 Q10 3.3 Revisited Freeway fx Dev worksheet	Q01 1.1 • Q02 1.4 Test 1 2.2 Q03 3.3 • Q04 4.1 Midterm 4.1 • Solns Q05 5.1 • Penny lab results Q06 6.2 • T2 6.3 Q07 8.1 • Q08 8 - 9 Q09 9.4 • Q10 3.3r Tuna CPUE fx Fx Ans xls

Spring 2002	Fall 2001	Summer 2001	Spring 2001	Fall 2000
Quiz 01 1.3 Test 01 2.1 Quiz 02 3.1 Quiz 03 3.3 Midterm Quiz 04 5.1 Quiz 05 6.1 Test 2 6.3 Quiz 06 8.1 Quiz 07 8 - 9 Quiz 08 9.4 Micro Final Ans XLS	Q01 1.2 Q02 1.4 Test 01 2 Q03 3 Q04 4.1 Q05 4.2 Midterm 5.1 Q06 6.1 Q07 6.3 Q09 8.2 Q10 8-9 Q11 9.4+ Q12 10.1 Q13 10.2 Final: Empty shell Infant fx Final data Excel fcns Final: Slns	Quiz 01 1 Test 01 123 Quiz 02 4 Mid 12345 Quiz 03 6 Test Two 78 Quiz 04 9 Adult lit	Quiz 01 Quiz 02 Test 01 PostTest Survey Quiz 03 Quiz 04 Quiz 05 Midterm Solns w/ student comments Decline doc Q06 6.1 Q07 6.3 Quiz 08 8.1 Quiz 09 8.4 Quiz 10 9.1 Quiz 11 9.4 Age t-test for diff of two means Life exp fx FX ans (xls 97)	Quiz 1 Q02 1.4 T01 2.3 Q03 3.3 Quiz 4 Mx 5.2 Q05 6.1 Q06 6.3 Q07 7.3 T2 7.1 Q08 8.2 Q09 Q10 Fx

Support Materials
Fall 2003	Spring 2003	Fall 2002
Calendar Body Fat Data • html • sxc Pop. Pareto • (html) PE Survey sxc Female BFI histo from class Male body fat histo • html • sxc Utwe 2.2 handout • html • sxc Soy Sauce Worksheets Soysauce example • html • sxc Waikiki Soy xls • html • sxc Soy Data M09 xls • html • sxc Soy data M10 xls • html • sxc Alcohol xls • html • sxc Pennies • PNG • sxc Normal statistics • sxc Distribution of the mean Poll Conf Int • Pulse • sxc	Calendar/Syllabus Course Outline Excel OpenOffice Calc Age Hist 5.1 xls Norm dist xls • html • sxc Homework exemplar Mean Dist • png • sxc Entrance ci worksheet Conf Interval 8.2 for 14 April Paired Mean WS • sxc • T-test: Two sample for means	Excel Calendar

Spring 2002	Fall 2001	Summer 2001	Spring 2001	Fall 2000
Excel Calendar Linear Reg Ex Lunch Rainbow Duke Kahanamoku	Excel Syllabus	Excel	Excel Syllabus Gradebook Non-linear curve	Excel Calendar 6.3 notes

Courses • COMFSM