# 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.

5 Pages

### handout9

Course: PSYCH 317, Fall 2008
School: Washington
Rating:

Word Count: 798

#### Document Preview

Tip SAMLab Sheet #9 1 The Single-Sample Z test This Tip Sheet provides an overview of how to perform the single-sample z test in Excel, which includes calculating the test statistic, finding the appropriate critical value for comparison, and finding the pvalue of the computed z statistic. The formula for the single-sample z statistic is shown below. z= X x X X is the mean of the sample, x is the mean of the...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Washington >> Washington >> PSYCH 317

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.
Tip SAMLab Sheet #9 1 The Single-Sample Z test This Tip Sheet provides an overview of how to perform the single-sample z test in Excel, which includes calculating the test statistic, finding the appropriate critical value for comparison, and finding the pvalue of the computed z statistic. The formula for the single-sample z statistic is shown below. z= X x X X is the mean of the sample, x is the mean of the reference population, X is the standard error of the sampling distribution created by drawing samples of size N from the reference population. The formula for the standard error is shown below. X = X N X is the standard deviation of the reference population, and N is the size of your sample. The image below shows how to calculate the standard error and the z in Excel. These two cells show the formulas used to calculate the adjacent values These fictitious data represent the IQ scores of a sample of Psychology students. The population values are meant to reflect the general adult population, which we will assume is normally distributed. On the next page you will see how to use Excels paste functions to find the two-tailed probability associated with the computed z statistic. You will also see how Excel can find the critical value. SAMLab Tip Sheet #9 2 The first step in finding the two-tailed p-value associated with the computed z statistic is to click in a cell near your computed z statistic and select Function from the Insert menu (below left). Next select Statistical from the Function category list and then select NORMSDIST from the Function name list (below right). Click OK. When the dialogue box below appears, click in the field next to Z and select the cell containing your computed z statistic. Click OK. As you might gather from the label below, the NORMSDIST function returns the cumulative probability in the normal distribution below the referenced z statistic. In order to find the two-tailed p-value, we will need to subtract the cumulative probability from 1 to get the one-tailed probability1 and then multiply it by 2 as shown below. SAMLab Tip Sheet #9 3 In order to find the critical value for this z-test we will use the function called NORMSINV. We will use an alpha level of .05, two-tailed. Using the same steps for inserting NORMSDIST above, insert NORMSINV in the cell below the p-value. two-tailed You should see the dialogue box below once you have selected this function. NORMSINV() will return a z-value associated with a cumulative probability. What this means is that we need to input the cumulative probability associated with a two-tailed alpha level of .05. We know that because our computed z statistic is positive and our alpha level is two-tailed, the cumulative probability below our critical value will be .975, which is what we should enter into the Probability field as shown below (note that if we wanted the negative critical value associated with a two-tailed alpha level of .05, we would have entered .025). Once you have entered the probability, click OK. . Label the cell next to your critical value and you should see something similar to the image below. SAMLab Tip Sheet #9 4 Our last task will be to check our work with one of Excels other paste functions called ZTEST. Click in the cell below the critical value and insert the ZTEST() function as done previously. You should see the dialogue box at the top of the next page. For the Array field, select the original data. For the X field, select the population mean (100 in our example), and for the Sigma field, select the population standard deviation (16 in our example). Once your dialogue box resembles the one below, click OK. You should now have a spreadsheet that looks something like the one b...

Textbooks related to the document above:
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:

Washington - PSYCH - 317
SAMLab Tip Sheet #6 Calculating the Variance and Standard Deviation The purpose of this Tip Sheet is two-fold. First, we will use Excel to calculate a variance and standard deviation using the definitional formula for a standard deviation shown below
Washington - PSYCH - 317
SAMLab Tip Sheet #4 Creating a Histogram Another great feature of Excel is its ability to visually display data. This Tip Sheet demonstrates how to create a histogram and provides a general overview of how to create graphs, which is covered more spec
Washington - PSYCH - 317
Psychology 318 Example for one-way/ single factor ANOVA for a within subject designWinter 2008Background: Alice, an undergrad honor student in the psychology department, decided to investigate factors that might influence performance in a game of
Washington - PSYCH - 318
Psychology 318 Example for one-way/ single factor ANOVA for a within subject designWinter 2008Background: Alice, an undergrad honor student in the psychology department, decided to investigate factors that might influence performance in a game of
Washington - PSYCH - 317
Icvin* hanclo.rtWeek 7, Winter 2005Psycholory3181. Example for one-way/singlefactor ANOVA with within subjectdesign Background: Alice, an undergrad honorstudent thepsycholorydepartment, in ciecided to investigate performance a gzrme Scrabble.
Washington - PSYCH - 318
Icvin* hanclo.rtWeek 7, Winter 2005Psycholory3181. Example for one-way/singlefactor ANOVA with within subjectdesign Background: Alice, an undergrad honorstudent thepsycholorydepartment, in ciecided to investigate performance a gzrme Scrabble.
Washington - PSYCH - 317
SAMLab Tip Sheet #2Shortcuts to Performing a Particular Operation Multiple TimesDynamic Cell References One of the best features of Excel is its ability to perform any particular mathematical operation multiple times with relative ease. This is ve
Washington - PSYCH - 317
Psychology 318r C h l7: M an n - W h i t n eU - T e s tNoles: to freer t-test. d TheMWUtest is theassumption alternative theindependent-groups 1. lt does assume population be normally not the to distributed. 2. It does assume not H.O.V.it d The
Washington - PSYCH - 318
Psychology 318r C h l7: M an n - W h i t n eU - T e s tNoles: to freer t-test. d TheMWUtest is theassumption alternative theindependent-groups 1. lt does assume population be normally not the to distributed. 2. It does assume not H.O.V.it d The
Washington - PSYCH - 317
SAMLab Tip Sheet #4 Creating a Histogram Another great feature of Excel is its ability to visually display data. This Tip Sheet demonstrates how to create a histogram and provides a general overview of how to create graphs, which is covered more spec
Washington - PSYCH - 317
SAMLab Tip Sheet #1Translating Mathematical Formulas Into Excels LanguageIntroduction Microsoft Excel is a very powerful calculator; you can use it to compute a wide variety of mathematical expressions. Before exploring Excels more advanced capabi
Washington - PSYCH - 317
SAMLab Tip Sheet #9 The Single-Sample Z test This Tip Sheet provides an overview of how to perform the single-sample z test in Excel, which includes calculating the test statistic, finding the appropriate critical value for comparison, and finding th
Washington - PSYCH - 317
SAMLab Tip Sheet #5 Creating Graphs The purpose of this tip sheet is to provide a basic demonstration of how to create graphs with Excel. Excel can generate a wide variety of graphs, but we will use only two as primary examples. Fortunately, many of
Washington - PSYCH - 317
SAMLab Tip Sheet #3 Using Excels Function Library Perhaps the most powerful feature of Excel is its enormous library of functions. These are mini-programs within Excel that will perform specific tasks given the proper input. This tip sheet describes
Washington - PSYCH - 317
SAMLab Tip Sheet #6 Calculating the Variance and Standard Deviation The purpose of this Tip Sheet is two-fold. First, we will use Excel to calculate a variance and standard deviation using the definitional formula for a standard deviation shown below
Washington - PSYCH - 317
SAMLab Tip Sheet #2Shortcuts for Performing a Particular Operation Multiple TimesDynamic Cell References One of the best features of Excel is its ability to perform any particular mathematical operation multiple times with relative ease. This is v
Washington - PSYCH - 317
SAMLab Tip Sheet #10 The Single-Sample t test This Tip Sheet provides an overview of how to perform the single-sample t test in Excel, which includes calculating the test statistic, finding the appropriate critical value for comparison, and finding t
Washington - PSYCH - 317
SAMLab Handout #5 Creating Graphs The purpose of this tip sheet is to provide a basic demonstration of how to create graphs with Excel. Excel can generate a wide variety of graphs, but we will use only two as primary examples. Fortunately, many of th
Washington - PSYCH - 317
SAMLab Tip Sheet #7 Computing a Pearson r In this Tip Sheet, you will learn how to calculate a Pearson r. To better understand the factors that affect the sign and magnitude of r, we will calculate r using the definitional formula shown below and the
Washington - PSYCH - 317
SAMLab Tip Sheet #11 Calculating Power using G*Power In this tip sheet we will depart from using Excel and introduce a program called G*Power. Using G*Power, we will be able to conduct both a priori and post hoc power analyses. Our example will focus
Washington - PSYCH - 317
SAMLab Tip Sheet #10 The Single-Sample t test This Tip Sheet provides an overview of how to perform the single-sample t test in Excel, which includes calculating the test statistic, finding the appropriate critical value for comparison, and finding t
Washington - PSYCH - 317
SAMLab Tip Sheet #8 The Linear Regression Equation and the Standard Error of the Estimate This Tip Sheet provides an overview of how to create a scatterplot for bivariate data and use it to find the equation for the linear regression line based on th
Washington - PSYCH - 317
Please have your portfolio checked by your TA or instructor by March 18. Portfolio MUST include examples of these significance tests (you may use handouts or assignments or your own examples)* Single sample tests Sign (binomial) test from 317 if avai
Washington - PSYCH - 318
Please have your portfolio checked by your TA or instructor by March 18. Portfolio MUST include examples of these significance tests (you may use handouts or assignments or your own examples)* Single sample tests Sign (binomial) test from 317 if avai
Washington - PSYCH - 317
Psych 318: Statistical inference using significance tests 1. A researcher is interested in citizens opinions about income redistribution in the United States. Participants in the researchers survey were asked whether they thought it is the government
Washington - PSYCH - 318
Psych 318: Statistical inference using significance tests 1. A researcher is interested in citizens opinions about income redistribution in the United States. Participants in the researchers survey were asked whether they thought it is the government
Washington - PSYCH - 317
TESTS CHART PSYCH 318 . WINTER zOW INFERENTIAL TEST z test Ho Pop p = (Value) DECISION fail to reject Ho rejectHo CONCLUSION oinsufficient evidence tell to , wh e t h e r o pU i s l a r g e ro r sm a l l e r P thanValue oconclude Popp is either that
Washington - PSYCH - 318
TESTS CHART PSYCH 318 . WINTER zOW INFERENTIAL TEST z test Ho Pop p = (Value) DECISION fail to reject Ho rejectHo CONCLUSION oinsufficient evidence tell to , wh e t h e r o pU i s l a r g e ro r sm a l l e r P thanValue oconclude Popp is either that
Washington - EDLPS - 516
SETTLEMENT AGREEMENTThis Settlement Agreement (&quot;Settlement Agreement&quot;) is made by and between the parties to the case AB., et al. v. Bremerton School District No. ZOO-C, et al.,originally filed in Thurston County Superior Court (docket No. 07-2-
Washington - KGB - 2
Literary Romanticism* Literary movement in Western Europe between the late 18th and early 19th century * Romanticism arose in reaction against the neoclassical ideals of the Enlightenment period that stressed reason, order, form, and rationality *
Washington - STAT - 217
SPSS Tutorial 2Psych 218 Between-Subjects Analysis of VarianceStep 1: Enter your data.Begin by entering your data in the same manner as for an independent groups ttest. You should have two columns: 1) the dependent variable 2) a grouping variable
Washington - PBAF - 527
Agriculture and Human Values 20: 301321, 2003. 2003 Kluwer Academic Publishers. Printed in the Netherlands.IN THE FIELDSustaining local agriculture: Barriers and opportunities to direct marketing between farms and restaurants in ColoradoAmory S
Washington - BIOEN - 302
Know how to distinguish between the saddle point, spiral point, center, and node. There are two kinds of equilibrium points where all of the trajectories converge: node and spiral point. There are various kinds of nodes, one of which is a focus, but
Washington - PH - 122
TABLE 1. Difference Between Male and Female Salaries by Rank and Type of Institution for Selected Years, Expressed As a Percent of Male SalariesRank All Institutions Category I (doctoral) Category IIA (master's) 1975 3.0 1.9 3.1 4.3 1988 4.8 5.9 7.5
Washington - PH - 122
UNIVERSITY OF WASHINGTON Women Studies 485 /Physics 451Issues for Ethnic Minorities and Women in Science and EngineeringWinter 2009: Tues/Thurs 12:30-2:20 p.m. Smith Hall 309URL: http:/courses.washington.edu/ph122mo/W09Instructors Prof. Angela
Washington - PH - 07
Course Announcement for Winter Quarter 2008 Please contact instructor for more informationNanoscale Science IContact Mechanics and Rheology on the Nanoscale ChemE 554 (3 credits)Tue/Thu: 1:30 - 2:50 p.m. CHL 025 Instructor: Ren Overney (e-mail: r
Washington - PH - 122
Course Announcement for Winter Quarter 2008 Please contact instructor for more informationNanoscale Science IContact Mechanics and Rheology on the Nanoscale ChemE 554 (3 credits)Tue/Thu: 1:30 - 2:50 p.m. CHL 025 Instructor: Ren Overney (e-mail: r
Washington - PH - 05
HW 1Due Friday, October 6page 1/21. Exercise 2 from Johnson Chapter: Find the ratio of energies in wells of width L and 2L.h2 2 . When the well size is doubled to 2L, the 2m * L2 (1/L)2 EA = 4. energy is reduced by a factor of 4 (the width en
Washington - PH - 122
HW 1Due Friday, October 6page 1/21. Exercise 2 from Johnson Chapter: Find the ratio of energies in wells of width L and 2L.h2 2 . When the well size is doubled to 2L, the 2m * L2 (1/L)2 EA = 4. energy is reduced by a factor of 4 (the width en
Washington - PH - 122
Name Signature Student Number1 2 3 Total Physics 328: Statistical Physics Midterm 1 Monday, 26 April 2004 Professor Marjorie Olmstead Instructions and Advice/38 /30 /32 /100 Solve all three problems in the space provided. Use the back if y
Washington - PH - 122
Name Signature Student Number1 2 3 Total Physics 328: Statistical Physics Midterm 2 Monday, 24 May 2004 Professor Marjorie Olmstead Instructions and Advice/40 /30 /30 /100 Solve all three problems in the space provided. Use the back if you
Washington - PH - 122
Name Signature Student Number1 2 3 Total/34 /34 /32 (60) /100Physics 328: Statistical Physics Midterm 1 Friday, 25 April 2003Professor Marjorie Olmstead Instructions and Advice Solve all three problems in the space provided. Use the back i
Washington - PH - 05
Physics 427/5761. Nucleation DensityHomework #2 - Epitaxial GrowthDue Friday Oct 21The nucleation process during MBE may be approximated by formation of roughly equally spaced islands that nucleate early in the formation of the monolayer and t
Washington - PH - 122
Physics 427/5761. Nucleation DensityHomework #2 - Epitaxial GrowthDue Friday Oct 21The nucleation process during MBE may be approximated by formation of roughly equally spaced islands that nucleate early in the formation of the monolayer and t
Washington - PH - 122
Science Report CardParent EducationThe following are all from the NCES report The Condition of Education 2002Reading Scores350 330 310Fourth Grade (Age 9)280Twelfth Grade (Age 17)260Gender240290220 White &gt;75% 200Score Score 270 W
Washington - PH - 122
R&amp;D Spending and Pubs Source: www.nsf.gov/statistics NSF 2004WorkforcePhysics 451/Women 485 W06Jan 51Physics 451/Women 485 W06Jan 52S&amp;E Degrees per 24 yr old NSF 2004Faculty Age Distribution NSF04Physics 451/Women 485 W06Jan
Washington - PH - 122
Name Signature Student Number1 2 3 Total/27 /41 /32 (56) /100Physics 328: Statistical and Thermal Physics Midterm 2 Friday, 23 May 2003Professor Marjorie Olmstead Instructions and Advice Solve all three problems in the space provided. Use
Washington - PH - 122
Name Signature Student Number1 2 3 Physics 328: Statistical Physics Final Exam Monday, 7 June 2004 Professor Marjorie Olmstead Instructions and Advice/40 /35 /204 5 Total/25 /30 /150 Solve all five problems in the space provided. Use t
Washington - PH - 122
\$556 M top 50 (\$956 M total) \$21.5 MDiversity of Chemistry Faculty\$13.1 M\$11.3 M\$9.7 M\$8.2 MPhysics 451/Women 485 W06 Jan 12http:/cheminfo.chem.ou.edu/faculty/djn/diversity/top50.htmlTime Course - Individuals UC Berkeley2001 o Full
Washington - PH - 122
Question Point DistributionMidterm Totals5Q1 (/34) Q2 (/38) Q3 (/30)7 6 5Students4 3 2 1 04 3 2 1 0 0 3 6 9 12 15 18 21 24 27 30 33 36 39PointsStudents152127333945515763697581PointsIndividual Parts16 1A 14 1
Washington - CHEM - 122
Goals for this lecture Biology for nanoscientistsFrontiers of Nanotech Beth Traxler Thur, 30/3/0650% of class has had 0 or 1 Bio class Overview of cell size, shape and organization Summarize some issues/questions in synthesis and assembly of cell
Washington - CHEM - 560
Goals for this lecture Biology for nanoscientistsFrontiers of Nanotech Beth Traxler Thur, 30/3/0650% of class has had 0 or 1 Bio class Overview of cell size, shape and organization Summarize some issues/questions in synthesis and assembly of cell
Washington - CHEM - 122
UW Center for Nanotechnologywww.nano.washington.eduStandard Ph.D. ProcessFaculty Expertise User FacilityResearch CentersFounded 1997Faculty Departments Graduate Colleges Fellowships PhD Students Centers International NT Dual PhD Partnership
Washington - CHEM - 560
UW Center for Nanotechnologywww.nano.washington.eduStandard Ph.D. ProcessFaculty Expertise User FacilityResearch CentersFounded 1997Faculty Departments Graduate Colleges Fellowships PhD Students Centers International NT Dual PhD Partnership
Washington - CHEM - 122
Nanotech Enterprise at UW since 1997Nanotech at the University of Washington The Science of the Very Small is Getting Bigger in the Pacific NorthwestWorkforce Development NSF-IGERTTools NanoTech User Facility Joint Institutes PNNLNational Infr
Washington - CHEM - 560
Nanotech Enterprise at UW since 1997Nanotech at the University of Washington The Science of the Very Small is Getting Bigger in the Pacific NorthwestWorkforce Development NSF-IGERTTools NanoTech User Facility Joint Institutes PNNLNational Infr
Washington - PHYS - 122
Name Signature Student Number1 2 3 Total Physics 328: Statistical Physics Midterm 1 Friday, 20 May 2005 Professor Marjorie Olmstead Instructions and Advice/40 /30 /30 /100Solve all three problems in the space provided. Use the back if you need
Washington - PHYS - 328
Name Signature Student Number1 2 3 Total Physics 328: Statistical Physics Midterm 1 Friday, 20 May 2005 Professor Marjorie Olmstead Instructions and Advice/40 /30 /30 /100Solve all three problems in the space provided. Use the back if you need
Washington - PHYS - 122
Name Signature Student Number1 2 3 4 Total Physics 328: Statistical and Thermal Physics Final Exam Monday, 6 June 2005 Professor Marjorie Olmstead Instructions and Advice/49 /34 /27 /40 /150 Solve all four problems in the space provided. Us
Washington - PHYS - 328
Name Signature Student Number1 2 3 4 Total Physics 328: Statistical and Thermal Physics Final Exam Monday, 6 June 2005 Professor Marjorie Olmstead Instructions and Advice/49 /34 /27 /40 /150 Solve all four problems in the space provided. Us
Washington - PHYS - 122
Name Signature Student Number1 2 3 Total Physics 328: Statistical Physics Midterm 1 Friday, 22 April 2005 Professor Marjorie Olmstead Instructions and Advice/32 /38 /30 /100Solve all three problems in the space provided. Use the back if you nee