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

9 Pages

### Excel 2007 Tutorial

Course: STATISTICS 2103, Spring 2011
School: Temple
Rating:

Word Count: 3891

#### Document Preview

2007 EXCEL Statistical Functions CONTENTS I. Getting Started with MS Excel II. Statistical Functions I. Getting Started with MS Excel Introduction: Microsoft Excel is a spreadsheet application and is a powerful computation and presentation tool used extensively in just about any desk job. The format is so easy to use and flexible, that everyone uses it daily from administrators to fluid dynamic engineers and yes,...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Pennsylvania >> Temple >> STATISTICS 2103

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

Temple - STATISTICS - 2103
EXCEL Statistical Functions for Stat 2103CONTENTS I. Getting Started with MS Excel II. Statistical Functions for Stat 2103I. Getting Started with MS ExcelIntroduction: Microsoft Excel is a spreadsheet application and is a powerful computation and prese
Temple - STATISTICS - 2103
which major? finance accounting marketing legal study international business economics human resource OtherClass frequency 1 12 7 3 5 2 1 5 36Relative Frequncy14 12 0.030.3310 80.19 0.086 0.140.06 4 0.032 0 finance0.14marketClass percentage14
Temple - STATISTICS - 2103
Stat 2103, Midterm Exam 2April 5th. NAME:25 points total. You can use the distribution tables, a calculator, and a one-page formula sheet. Problem 1-2. A discrete random variable x can assume possible values 2, 3, 4, and 5. Its probability distribution
Temple - STATISTICS - 2103
Thursday, March 31, 2011 12:47 PMUnfiled Notes Page 1Unfiled Notes Page 2Unfiled Notes Page 3
Temple - STATISTICS - 2103
1 2 3 4 51 1 2 2 44.5 4 3.5 3 2.5 2 1.5 1 0.5 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5ColumColumn C4.555.5
Temple - STATISTICS - 2103
Answers to Inference Review Questions2. Individual observations:Nominal(cheated or not?) Inference procedure: One sample proportion Statistic: Z Degrees of freedom: not applicable 3. Individual observations: Interval (amount of tar for a regular cigarett
Temple - STATISTICS - 2103
Stat 2103, Midterm Exam 1(With answer)Feb. 22nd. 2011, NAME:20 points total. Only a calculator and a one-page cheatsheet allowed. 1. Each month interviewers visit about 43, 000 of the 87 million households in the region and question the occupants over 1
Temple - STATISTICS - 2103
Tuesday, January 18, 2011 5:27 PMNew Section 1 Page 1
Temple - STATISTICS - 2103
Professor: Zhigen Zhao, Ph.D.,Statistics 2103page 1 of 12TEMPLE UNIVERSITYS FOX SCHOOL OF BUSINESS Department of Statistics Spring 2011 Statistics 2103 Instructor: Office Location: TUmail: Office Phone: Office hours: Zhigen(Gene) Zhao, Ph.D., Assistant
Temple - STATISTICS - 2103
60 60 60 5 30 10 10 30 5 10 10 40 10 15 15 10 60 15 120Before removing the outlier 30.26Remove 120 25.28 45895.76 29.93448.45 21.182030.93-0.25Box Plot 60 60 60 5 30 10 10 30 5 10 10 40 10 15 15 10 60 15 1205 10 15 50 12040
Temple - STATISTICS - 2103
Sam Tamika Brian Mike85 94 78 8794 87 79 88Column1Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count-1 3.27 -1 -1 6.53 42.67 1.5 0 16 -9 7 -4 4-9 7 -1 -1
Temple - STATISTICS - 2103
Firefox IE Safari Others1 2 1 2 1 3 1 1 4 3 1 1 4 1 3 1 1 4 4 4 1 2 2 1 3 4 1 2 1 4 3 2 1 1 1 120 18 16 14 12 10 8 6 4 2 019 7 7 8Column BFirefoxIESafariOthers3 3 4 2 1Firefox IE Safari Othersolumn B
Temple - STATISTICS - 2103
Which inference? Which type of inference procedure is called for in each? One Proportion, Two sample means, Two proportions, Matched pairs, One mean, Regression, Will you use z , t? How many degrees of freedom (if appropriate)? 2. Cheating. A teacher bel
Rutgers - ECONOMICS - 200
NBER WORKING PAPER SERIESGLOBALIZATION AND CAPITAL MARKETSMaurice Obstfeld Alan M. TaylorWorking Paper 8846 http:/www.nber.org/papers/w8846NATIONAL BUREAU OF ECONOMIC RESEARCH 1050 Massachusetts Avenue Cambridge, MA 02138 March 2002This paper was pre
Rutgers - 373 - 300
Rutgers - 373 - 300
Rutgers - ECONOMICS - 373
Rutgers - ECONOMICS - 373
Rutgers - ECONOMICS - 373
Rutgers - ECONOMICS - 373
University of Texas - CMS - 306M
Working with Teams Chapter 7 Team Defined How would you define a team? Take a few minutes to think about this, and on a sheet of paper write down your definition.Team DefinedA small number of people, with complementary skills, who are committed to a c
University of Texas - EE - 302
P roblem Solving P roblem Solving: Step 1 D efine the problem Read the Problem Statement carefully. Collect the known information. Ask two important questions: What essential information is given? What is to be found? Draw an appropriate diagram, sketch,
University of Texas - MATH - 427K
University of Texas - MATH - 427K
University of Texas - MATH - 427K
University of Texas - MATH - 427K
University of Texas - CMS - 332K
Influence in Interpersonal RelationshipsApril 11, 2011Advice= persuasive communication Ex: which classes o What career paths o Where to live in Austin o What to do this weekend o How to handle relationship problems We give advice to o Parents o Friends
University of Hawaii, Manoa - SOC - 100
W right M ills: external forces (our experiences) become part of our thinking and motivations; analysis o the role of the power elite in US society Auguste Comte : founder of sociology He rbert Spencer : Social Darwinism Karl M a rx : class conflict Emile
University of Hawaii, Manoa - SOC - 100
Sociological Perspective: social contexts in which people live, how context influence peoples lives Sociological Imagination: being able to look beyond common sense for explanations of why people act the way they do Social location: the places, positions,
University of Hawaii, Manoa - SOC - 100
E thnography: go into field and observe people doing things Class conflict: more money, more production Proletariat: workers Bourgeoisie: own/control production Protestant Ethic: self-denial Symbolic interaction: people use symbols to attach meaning to wo
University of Hawaii, Manoa - SOC - 100
T heory: general statement 3 major sociological theories: 1. Symbolic interactionism: symbols used to attach meaning to world; way we u nderstand 2. Functional analysis: society is whole unit made up of interrelated parts 3. Conflict theory: class conflic
University of Hawaii, Manoa - SOC - 100
Cultural relativism Hawaiian local 1. Born and raised in Hawaii 2. Family born and raised in Hawaii Pidgin as language 100s plantation life, mix of English &amp; other languages Pidgin test How do we know how to behave in society? Values: whats desirable Norm
University of Hawaii, Manoa - SOC - 100
Culture: language, beliefs, values, norms, behaviors Material culture: jewelry, art, buildings, weapons Non-material culture: beliefs, values, assumptions about world Ethnocentrism: use own groups way of doing something Symbolic culture Symbol Nature vs N
University of Hawaii, Manoa - SOC - 100
Social environment Feral children Institutionalized children Socialization: process of how you learn about culture Self Cooley-Looking Glass 1. We imagine how we appear to others 2. We interpret their reactions Mead &amp; Role Taking Children go through 3 sta
University of Hawaii, Manoa - SOC - 100
Personality consist of 3 elements 1. Id 2. Ego 3. Superego Peer group Mass media Gender roles Social inequality Agents of socialization Anticipatory socialization Life course: stages from bir th to death Total institution Resocialization Degradation cerem
University of Hawaii, Manoa - SOC - 100
M acrosociology M icrosociology Social class 1. Income 2. Education 3. Occupational prestige Culture: language, beliefs, values, behaviors, gestures Social status Ascribed status Achieved status Status set Status symbol Master status Roles Groups Social i
University of Hawaii, Manoa - SOC - 100
Major components of social structure: Roles Groups Social institutions Durkeim 1. mechanical solidarity 2. organic solidarity Tonnies: gemeinschaft Stereotypes Personal space 4 levels of personal space 1. intimate 2. personal 3. social 4. public Erving Go
University of Hawaii, Manoa - SOC - 100
Aggrate: people who temporarily share a space but dont see themselves as belonging t ogether Category: people who share similar experiences Social groups Primary groups: spring of life-Charles Cooley Secondary groups: people come together Inner circle: sm
University of Hawaii, Manoa - SOC - 100
Reference groups Social networks Electronic communities M ilgrams small world phenomenon Bureaucracies 1. Clear cut levels of responsibilities 2. Division of labor 3. Writ ten rules 4. Writ ten communication and records 5. Impersonality and replace abilit
University of Hawaii, Manoa - SOC - 100
Deviance Relativity of deviance Stigma Norms and social life Social order Sanctions Explanations of deviance 1. Sociobiology: nature &amp; nurture 2. Psychology: psyche 3. Sociology: macro and micro factors 3 sociological explanations of deviance 1. Symbolic
University of Hawaii, Manoa - SOC - 100
5 techniques of neutralization 1. Denial of responsibility 2. Denial of injury 3. Denial of a victim 4. Condemnation of the condemner 5. Appeal to higher loyalties Deviance is functional because It affirms moral boundaries Promotes social unity Promotes s
University of Hawaii, Manoa - SOC - 100
Social stratification- 3 types 1. Slavery 2. Caste 3. Class Marx division into 2 classes 1. Bourgeoisie 2. Proletariats Webers 3 Ps 1. Property 2. Power 3. Prestige Global stratification into 3 worlds 1. 1st world = most industrialized 2. 2nd world= indus
University of Hawaii, Manoa - SOC - 100
World system theory 1. Core nations 2. Semiperiphery 3. Periphery 4. External area nations Globalization of capitalism Culture of poverty Maintaining global stratification Necolonism Multinational corporations Colonialism
University of Hawaii, Manoa - SOC - 100
Social class Components of social class Wealth Power Prestige Jobs that have greater levels o prestige 1. Generally pay more 2. Entail more abstract thought 3. Require more education 4. Have greater autonomy Wright 4 classes 1. Capitalists 2. Petty bourge
University of Hawaii, Manoa - SOC - 100
3 t ypes of social mobility 1. Intergenerational mobility 2. Structural mobility 3. Exchange mobility Poverty components Age Race/ethnicity Gender Education Geography Why are people poor? Social structure Characteristics of individuals
University of Hawaii, Manoa - SOC - 100
Race Ethnicity Minority group Dominant group Theories of prejudice 1. Frustration and scapegoats 2. The authoritarian personality Low sense of ethnicity Part of the majority Greater power Similar to the national identity No discrimination Discrimination 1
University of Hawaii, Manoa - SOC - 100
Genocide Population t ransfer Segregation Assimilation Multiculturalism Race and ethnic relations in the US European Americans = set stage of current ethnic relations Latinos= largest racial/minority group African Americans = gap between middle class and
University of Hawaii, Manoa - SOC - 100
Race: deeply rooted in social systems Race as a biological construct Race as a social construct Ethnicity: Deeply linked to race Very unstable and ever changing Based on interaction because people and social systems Applied differently Symbolic interactio
LSE - FINANCE - 1042
229 Pakistan Economic and Social ReviewVolume 47, No. 2 (Winter 2009), pp. 229-242ANALYSIS OF MILK PRODUCTION SYSTEM IN PERI-URBAN AREAS OF LAHORE (PAKISTAN) A Case StudyHAMID JALIL, HAFEEZ UR REHMAN, MAQBOOL H. SIAL and SYED SHAHID HUSSAIN*Abstract.
University of Phoenix - SCI - 240
Carbohydrate PresentationHeather Gray SCI/240 November 7, 2010 Joyce RodeCarbohydrate PresentationWhat are carbohydrates?Carbohydrate PresentationSimple CarbohydrateCarbohydrate PresentationComplex CarbohydrateCarbohydrate PresentationHow sugar i
University of Phoenix - COM - 220
for com 220
U. Houston - ECON - 2304
!Chapter 8 P r inciples of M icroeconomics: Eqm w ith no tax P r ice=P E Q uantity = Q E E qm with Tax = T per unit:B uyers pay P B sellers receive P S T otal surplus will change after tax and it w ill decrease. Because of net weight. Without a Tax.C
Houston Downtown - POLS - 1336
Campaigns and Elections CampaignsLecture Outline LecturePresidential Elections Presidential Primaries The Electoral College What Decides a Presidential Election? 2008 Election Analysis Presidential Campaigns Presidential Debates Political Advertising L
U. Houston - ECON - 2304
M icroeconomics Point Anotes -Chapter 10 Externa l ityPrices are determined by supply and demand, and competitive markets: Allocating Resources efficiently and in some cases do not. At any quantity the height of the demand curve reflects the maximum wil
U. Houston - ECON - 2304
M icroeconomics - Chapter 11: P ublic Goods and Common Resources There are some goods and services for which people do not pay, and enjoy i t for free. Some of them are provided by nature (forests, beaches, mountains etc) while some a re provided by the g
U. Houston - ECON - 2304
M icroeconomics M idterm 2 ReviewChapter 15: M onopoly: A market unlike a perfectly competitive fi rm has somewhat market power. I t can raise its p rice, within limi ts and without the quantity demand falling to zero. The main way it retain i ts market
U. Houston - ECON - 2304
Total Revenue, Total Cost and Profit. We assume that the firms goal is to maximize profit. Profit= Total Revenue-Total Cost =-&gt;TR-(&lt;-)TCImplicit costs do not require a cash outlay e.g. The opportunity cost of the owners time.Case 1: Explicit Cost= 5000
U. Houston - ECON - 2304
Firms in Competitive Markets Chapter 14 Profit Maximization: Mr=Mc=P Price Tackers. Perfectly competitive Market mR=P At Qa MC&lt;MR So increase Q to raise Profit At Qb, MC&gt;MR. The additional Unit will cost more than revenue to the firm. Does not satisfy MR=
U. Houston - ECON - 2304
C hapter 13- The Cost of P roductionI n t roduction:Our economy is made up of thousands of large fi rms that produce goods and services you enjoy every day.La rge Fi rms: General Motors: Automobiles General Electric: L ight Bulbs General Mi lls: Cereal
U. Houston - ECON - 2304
Microeconmics - Chapter 12: Tax Collection As the Nation gets more the government takes larger shares of Income Taxes. U.S Government Collects 2/3rd of the taxes in our economy. To take the average of the total tax divide the number of tax by the populati