# Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

2 Pages

### Lab5_Excelstatistics

Course: GEO 647, Fall 2009
School: San Diego State
Rating:

Word Count: 533

#### Document Preview

and Excel statistics Due Feb 28th Part 1. Normal distribution 1)Using Excel, make a plot of the normal distribution for a mean of zero and a standard deviation of 1. Plot from -3 to 3. Use the normdist function. Setting the last argument as TRUE yields the cumulative probability distribution function; FALSE yield the classic curve. Plot both on the same chart as below. Hint: You will likely want to create a column...

Register Now

#### Unformatted Document Excerpt

Coursehero >> California >> San Diego State >> GEO 647

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
and Excel statistics Due Feb 28th Part 1. Normal distribution 1)Using Excel, make a plot of the normal distribution for a mean of zero and a standard deviation of 1. Plot from -3 to 3. Use the normdist function. Setting the last argument as TRUE yields the cumulative probability distribution function; FALSE yield the classic curve. Plot both on the same chart as below. Hint: You will likely want to create a column of number spaced at perhaps 0.05 from -3 to 3. There are a couple of ways to do this. One way is to type in by hand. Another is to set cell A2 to the value of 3, then set A3 to =A2+0.1 (as an equation). Then copy and paste in that equation for the next 60 or so rows. In column B, type in the equation for normdist using FALSE and referring back to column A for the value of X. then TRUE for the next one. Plotting them (maybe with a scatter plot) should yield something like this. Normal distribution 1.0 0.8 probability 0.5 0.3 0.0 -3 -2 -1 0 X 1 2 3 PDF CDF 2) Now in column D use normdist with a mean of 1, standard deviation of 1 and FALSE. In column E use normdist with a mean of 0, standard deviation of 2, and FALSE. Make a chart. a) What does changing the mean do to the plot? b) What does changing the standard deviation do? c) What is the mathematical relationship between the PDF and the CDF? (hint: the CDF is equal to the area of the PDF as a function of x. The area under the PDF between -3 and 0 is 0.5. The value of the CDF at x=0 is 0.5. Can d) the CDF ever exceed 1.0? Why or why not? Make a hardcopy of your plots and the answer on one or two pages. Part 2. The Schmidt Hammer It has a powerful kick and will make marks and chip rocks, etc. If using the Schmidt Hammer or standing nearby, wear googles! Do not use the Schmidt Hammer on anything that will break or deface Break into three groups. Each group will make a set of measurements using the Schmidt Hammer and then analyze using our new techniques. Each group will: Make 25 measurements using the Schmidt Hammer (vertical) on the concrete sidewalk. Make 25 measurements (vertical) on one of the large granite boulders. Make 25 measurements (horizontal) on one of the large granite boulders. Make 25 measurements on another large rock type. Enter your data into Excel and make sure that every one in the group has a copy of the data. a) Calculate the mea...

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

San Diego State - GEO - 300
GIS and arcviewDatabases and geologyWhat is a Geographical Information System (GIS)? Maps points symbols lines closed lines (polygons) {lakes} unclosed lines {roads} areas states outcrops text all information has a spatial referenceArcinfo and A
San Diego State - GEO - 647
GIS and arcviewDatabases and geologyWhat is a Geographical Information System (GIS)? Maps points symbols lines closed lines (polygons) {lakes} unclosed lines {roads} areas states outcrops text all information has a spatial referenceArcinfo and A
San Diego State - GEO - 300
Hypotheses testingAn exampleMean Known as arithmetic mean, mean, or average. We will deal largely with discrete samples. In Excel use average() Yields an unbiased estimate of the mean value (). Approaches the real expected value for large n
San Diego State - GEO - 647
Hypotheses testingAn exampleMean Known as arithmetic mean, mean, or average. We will deal largely with discrete samples. In Excel use average() Yields an unbiased estimate of the mean value (). Approaches the real expected value for large n
San Diego State - GEO - 300
Color and computersHow people seeWe do not see the full spectrum equally. Pretty good at seeing the light reflected by vegetation. 3 types of &quot;cones&quot; in retina and the more numerous but grayscalesensing rods.Computers make color the same w
San Diego State - GEO - 647
Color and computersHow people seeWe do not see the full spectrum equally. Pretty good at seeing the light reflected by vegetation. 3 types of &quot;cones&quot; in retina and the more numerous but grayscalesensing rods.Computers make color the same w
San Diego State - GEO - 300
Data fittingCorrelation &amp; line fittingWhat are they? Correlation- tells how much two variables are related X and Y measured independently Line fitting derives a best-fitting model between two variables. Least squares (linear regression - str
San Diego State - GEO - 647
Data fittingCorrelation &amp; line fittingWhat are they? Correlation- tells how much two variables are related X and Y measured independently Line fitting derives a best-fitting model between two variables. Least squares (linear regression - str
San Diego State - GEO - 300
Confidence intervalsMean Known as arithmetic mean, mean, or average. We will deal largely with discrete samples. In Excel use average() Yields an unbiased estimate of the mean value (). Approaches the real expected value for large nX 1 + X 2
San Diego State - GEO - 647
Confidence intervalsMean Known as arithmetic mean, mean, or average. We will deal largely with discrete samples. In Excel use average() Yields an unbiased estimate of the mean value (). Approaches the real expected value for large nX 1 + X 2
San Diego State - BIO - 202
Chapter 2: Small Molecules: Structure and BehaviorSmall Molecules: Structure and BehaviorCHAPTER 2Chapter 2: Small Molecules: Structure and BehaviorElectrons are distributed in shells of orbitals. Each orbital contains a maximum of two electr
San Diego State - BIO - 202
a small digression before talking about EnzymesThermodynamics2nd Law of Thermodynamics - for any spontaneous process, the Entropy (disorder) of the universe, Suniverse, must increase. This is very difficult to measure, however =&gt; we need a criter
San Diego State - BIO - 202
X-ray DiffractionFigure 4.1a - How do we look at cells?Usually with some sort of microscope. A light microscope can be used to look at structures as small as 1/4 micron because the wavelength of light is about 1/2 micron. To see smaller details o
San Diego State - BIO - 202
in the ratio CH2OCarbohydrates:Contain Carbon, Hydrogen and OxygenThe simplest Carbohydrates are the Simple Sugars, these are classified by: Type of Carbonyl group Ketone Ketose Aldehyde Aldose or by Number of Carbon atoms: 3 Cs 4 Cs 5 Cs 6 Cs
San Diego State - BIO - 202
Amino AcidsR = one of 20 possible organic compoundsAmino acids have both acidic (carboxyl) and basic (amino) functional groupsStereochemistry - Tetrahedral -Carbon1Hydrophobic Amino Acids have nonpolar R-GroupsPolar Amino Acids have polar
San Diego State - GEO - 580
Improving the images and artifactsPitfalls and basic interpretationSeismic processing is not perfect; images can have artifacts1.) The classics: velocity, geometry, processing. 2.) Current 3D data and improved processing have reduced some of the
San Diego State - PLSYS - 530
PLANTSYSTEMATICSBiology530Spring2007,TTh811:40am,LS270Dr.MichaelG.Simpson,Instructor&lt;msimpson@sunstroke.sdsu.edu&gt; Office:LS268,619.594.4479Officehrsbyappointment &lt;http:/blackboard.sdsu.edu&gt;&amp;&lt;http:/www.sci.sdsu.edu/plants/plsys530&gt;1 of 5GoalsandE
San Diego State - SOLUTION - 1
HEADER TRANSFERASE(PHOSPHOTRANSFERASE) 08-JAN-93 1ATP TITLE 2.2 ANGSTROM REFINED CRYSTAL STRUCTURE OF THE CATALYTIC TITLE 2 SUBUNIT OF CAMP-DEPENDENT PROTEIN KINASE COMPLEXED WITH TITLE
San Diego State - GEO - 580
Faults and horizonsBasic geometric objects used in interpretation Horizons follow distinct reflectors or sequence boundaries Geometry assumed fairly simple (cannot overlap 1 horizon on itself) Each horizon stored as a separate file Usually use snapp
San Diego State - GEO - 300
Geology 300 Geology 300 Computer applications in GeologyInstructor: Rob MellorsThe purpose of this class is : 1) Learn some of the commonly used software and programs in this department. 2) Learn some statistics as applied to geology and geophy
San Diego State - GEO - 580
Measurement of wave motionUse a geophone (land) or hydrophone (water) Geophones measure particle velocity - mass on a spring - motion measured with a coil - voltage proportional to velocity - voltage as function of time Hydrophones measure pressure
San Diego State - GEO - 300
programmingWhat is it? Tell the computer to do something. Everything a computer does is based on some sort of program Compiled languages (convert to machine code) C, C+ Fortran Java Basic Many others Script languages (input to special pro
San Diego State - GEO - 300
Geology 300 Geology 300 Computer applications in GeologyInstructor: Rob MellorsThe purpose of this class is : 1) Learn some of the commonly used software and programs in this department. 2) Learn some statistics as applied to geology and geophy
San Diego State - GEO - 300
Significant figures and propagation of errors Significant figures This refers to the number of useful digits in a measurement. They are usually determined by the precision of the measuring device. Significant figures are basically a quick way to avoi
San Diego State - GEO - 300
Geology 300 Notes Chapter 1 Computational Basics Computer hardware. A computer consists of a few basic parts: the CPU, memory, disk space, power supply, and IO (input/output) devices. The most important is the CPU (Central Processing Unit), which is
San Diego State - GEO - 300
Geology 300 Notes Chapter 1 Computer hardware. A computer consists of a few basic parts: the CPU, memory, disk space, power supply, and IO (input/output) devices. The most important is the CPU (Central Processing Unit), which is the brains of the co
San Diego State - GEO - 300
Geology 300 Notes Chapter 2 Web pages Web pages. A relatively recent (last fifteen years) innovation has been the development of web-pages. These are text, images, and other files accessible over the internet. These require two things: a computer th
San Diego State - GEO - 300
Geol 300 - The Last Lab of Spring 2008 Part 1 - ArcMap First, download the image Hawaii_321pan_v1.tif of the lava fields on the island of Hawaii. (this is a Landsat image of .Hawaii!). Then load into ArcMap (File, add Data). You will likely get an er
San Diego State - GEO - 300
Lab 7: Excel and statistical tests Due March 20, 20081) T-test: the old-fashioned way. If all the data are available, Excel makes it easy (via ttest() to calculate the probability that two means are significantly different. If we do not have all the
San Diego State - GEO - 300
Lab 8 DEM with Surfer &amp; Matlab Due April 10 Goals: 1.) Learn and use a digital elevation model in Matlab and Surfer. 2.) Learn about formation of marine terraces in the San Diego region. 3.) Estimate uplift rates in San Diego region using least squar
San Diego State - GEO - 300
Significant figures and propagation of errors Significant figures This refers to the number of useful digits in a measurement. They are usually determined by the precision of the measuring device. Significant figures are basically a quick way to avoi
San Diego State - GEO - 300
Lab 12 ArcGISGoals: Learn how to start ArcGIS; make simple maps; Manipulate maps and layers; make reports and nice maps Download and add data; select layers Save the world. All questions and images listed in italics should be in your lab write-up. L
San Diego State - GEO - 300
Excel and statistics Due Feb 28th Part 1. Normal distribution 1)Using Excel, make a plot of the normal distribution for a mean of zero and a standard deviation of 1. Plot from -3 to 3. Use the normdist function. Setting the last argument as TRUE yiel
San Diego State - GEO - 300
GPS scavenger hunt Due May 1Global Positioning Satellites (GPS) GPS works by receiving signals from a set of 24 (or more) satellites orbiting the earth. The most commonly used satellites were constructed by the US Department of Defense, although the
San Diego State - GEO - 300
Lab 6: Schmidt Hammer data analysis Due March 8 Last lab we collected some data with the Schmidt Hammer. This week we will conduct an analysis of the data. The questions we want to answer are: Does our data obey a normal distribution? Is there is
San Diego State - GEO - 300
Chapter 4 Probability and distributions The probability (often referred to as p) of an event is the likelihood that it will occur expressed as a number between 0 and 1. Zero (0.0) means no chance, as in the probability of me winning American Idol is
San Diego State - GEO - 300
San Diego State - ALGEBRA - 08
Mike OSullivan Department of Mathematics San Diego State UniversityFall 2005Math 627A: Modern Algebra IHomework IProblem 1: Use the Euclidean algorithm to express the greatest common divisor as a linear combination of the given 89, 24 24, 10
San Diego State - ALGEBRA - 08
Mike O'Sullivan Department of Mathematics San Diego State UniversityFall 2008Math 627A: Modern Algebra IHomework IIIProblem 8 For an abelian group A and integer m we let mA = {ma : a A} . Verify for yourself that this is a group. Let p be a p
San Diego State - ABSALG - 08
NAME:Abstract Algebra Math 521A Michael E. OSullivan Review of the courseRings and Ideals Know the denitions: ring, commutative, identity, eld; unit, zero divisor, characteristic; homomorphism, isomorphism. Know how to: Prove that a subset o
San Diego State - ALGEBRA - 08
Mike O'Sullivan Department of Mathematics San Diego State UniversityFall 2008Math 627A: Modern Algebra INotes on the Isomorphism Theorems for Groups1Fundamental Results: Up to the First Isomorphism TheoremThe material up to the first isomo
San Diego State - ALGEBRA - 08
Mike O'Sullivan Department of Mathematics San Diego State UniversityFall 2008Homework V due: Wed. 11/26/08Clarity of exposition is crucial in this assignment. You work should be understandable to a fellow student. You may work together to solve
San Diego State - ABSALGB - 08
NAME:Abstract Algebra B Math 521B Michael E. OSullivan Review for rst exam Be able to precisely dene the following terms. Be careful about the logic in the denition! Group, subgroup, cyclic group, generators of a group. Order of an element, orde
San Diego State - DISCRETE - 05
DISCRETE MATHEMATICS Math 245 Michael E. O'Sullivan Suggestions for preparing for the Third ExamI. Know the definitions! Subset. Intersection, union, set difference, complement. Power set, Cartesian product, partition. Relation, inverse of a rel
San Diego State - ABSALG - 08
NAME:Abstract Algebra Math 521A Michael E. OSullivan Review for rst exam Be able to state accurately and precisely these main theorems: Division theorem; The gcd of two integers may be written as a linear combination of them; Unique factorizati
San Diego State - DISCRETE - 05
DISCRETE MATHEMATICS Math 245 Michael E. OSullivan Suggestions for preparing for the Second ExamI. Properties of the integers and rational numbers: Be able to use (and recognize that you are using) commutativity, associativity, the additive and mu
San Diego State - CODING - 04
&quot;8 } C e`Y p%ah4 QW VU} 9R% Q %E Q 8 S T D X 0 \$ 8 P 20 \$ 0 4E&quot;\$ 2 2 %ah\$ 2 } 8 P H G E D 8@ R Q' I5 !r FB CBA6 &quot;\$ 2 1p 2 p 97\$ 2 C C 5% % \$ 86 2 0 0 \$ 2 \$ %4 &quot;% \$ A#a 3 ' }
San Diego State - CODING - 06
Lecture Notes for Math 696 Coding TheoryMichael E. OSullivan mosulliv@math.sdsu.edu wwww-rohan.sdsu.edu/ mosulliv February 23, 2006Chapter 1Reed-Solomon Codes and the Berlekamp-Massey Algorithm1.1 CodesLet F be a eld and let F n be a vector
San Diego State - DISCRETE - 03
DISCRETE MATHEMATICS Math 245 Michael E. OSullivan Suggestions for preparing for the Second ExamI. Know how to prove the classics: There exist an innite number of primes. 2 is irrational. II. Know the denitions! The sum of a rational number and
San Diego State - DISCRETE - 05
DISCRETE MATHEMATICS Math 245 Michael E. OSullivan Suggestions for Preparing for the Fourth ExamI. Know the basics! State the well-ordering principle. State the principle of induction. Be able to use summation and product notation. Be able to u
San Diego State - INFO - 01
b ' drFy`VI{W UT eW D GEHUT| G 'udrFy`VI{W UT eW D GEHUT| G T H T W | E Eg E Hg W P s a {`VI{q'S`'SkX'E g a H T U T T R E c T R T GP W E TP U T R G rI`V`IIdV\$dbSb'\$`I`CbW h U W G EP cP R T x E H T T c U a E
San Diego State - NUMB - 05
NUMBER THEORY Math 522 Michael E. OSullivan Preparing for the Final ExamI. Cumulative Material Prove simple properties of the Fibonacci numbers. Convert from one base to another. Compute in a given base (addition, multiplication in bases 2, 3).
San Diego State - ABSALGB - 08
Abstract Algebra B Math 521B Michael E. O'Sullivan Review for third exam Be able to define precisely the following terms. Be careful about the logic in the definition! transcendental element, algebraic element, minimal polynomial (Thm. 10.6). alge
San Diego State - ABSALG - 08
Abstract Algebra Math 521A Michael E. OSullivan Review for second examRings Know the denitions: ring, commutative, identity, eld; unit, zero divisor, characteristic; homomorphism, isomorphism. Know how to: Prove that a subset of a ring is a su
San Diego State - DISCRETE - 04
g { j j { h d g {djh }j } h|j #i dafiGSi&quot; {mvh&quot;eSCh iCEiirii4 p { { { { g {djh }j } h|j vd {ml Ig E| nSCh iCEiirii4 p ghgk d { { { { {g }kjd l j } j } h #CCeG { i #g | 6i d Ii(IewiwGiGwiSdvi {j rp o j } m } {g d #
San Diego State - NUMB - 03
y s se ~ g r st g t e r59vlkopflk7`5rfe`t5C ybe 5bg lv`guf rblkforeh v`I7v`v`f5\$vl9kbljfe v7I gz t ~ ~ s e e i g r r ~ s ~ sg~ s i ~ e yC9vwee v\$j559s `oE5\$bhopklljoee v`v } n ~ e z s n e ~e i t r y
San Diego State - INFO - 01
E X e QS a QS s QS U I p W U U Q e s QS U I p Q W pS b W c z bS X e q I c X Iq W c I R s QS b Q W c Wg ` cS c e X s I X ` k e W bS X h F d{Y%ad{uVwwdwaawBruBTdBYoodaBw#wdwv| t tE U Q wt w %aae w ~u E t tE U Qe E t w %B}~ rt t w
San Diego State - DISCRETE - 03
kewwk j we s e h ew z ~ jk ~ h ih we 9itddivYi}9rrqlhudqfduhf&quot;|diffh9rdA efdw7Ilhsf{hw7t|&quot;xf}iktatedWulhf{hW}iftddf9td}fdfh9rYhd|fld!tlj pn ~ ~ h e j y h e e i h w ~ s w ~ ek eww kew e x h i we s j j j e e i s z e s ji w ~ jk ~
San Diego State - CODING - 04
Lecture Notes for Math 696 Coding TheoryMichael E. OSullivan mosulliv@math.sdsu.edu wwww-rohan.sdsu.edu/ mosulliv January 7, 2004Reed-Solomon Codes and the Berlekamp-Massey Algorithm1 CodesLet F be a eld and let F n be a vector space of dimens
San Diego State - DISCRETE - 03
f l m o u qv u u u q m m q }u r r q rvr r u nq mxrpwyGbnSyu r rnC0!svtGCspsy# S q xv q mrv qv ur u xv m m r ru q m r q rvr r rv r u #CESyyryu p#yp!Es!du xyw b!styS GCspsSprs#0 x v q m rvr x rygC\$pv sr sp#sn xih
San Diego State - JAN - 06
Overview of Technology-Based Additions to Chem 200/202 (General Chemistry I)Overview of Technology-Based Additions to Chem 200/202 (General Chemistry I)&quot;Innovation&quot; #1: Showed More Animations During LecturesOverview of Technology-Based Additions