EXCEL 2010
EXCEL 2010. Cahier d'exercices. Des exercices pour vous http://mesfichespratiques.free.fr. 24/05/2013 ... Exercice n° 2 – Les lignes et les colonnes .
2010 RechercheV RechercheH
Excel. 2010. RechercheV. RechercheH. Fichiers nécessaires. • Voyages.xls. • TD_LocaVite.xls Excel 2010 juillet 2015 ... H) Exercices d'application .
Le Tableur EXCEL La Programmation en VBA
POUR SUPPRIMER UNE MACRO ACTIVER LA COMMANDE OUTILS. MACRO MACROS
Apprenez exactement ce dont vous avez besoin Progressez à votre
Téléchargez les exercices. Curtis D. Frye. Curtis D . Frye. Excel. Excel. ®. 2010. 2010. ®. Microsoft® rosoft®. Maîtrisez rapidement. Excel. ® 2010 avec le.
Christophe Malpart
Excel 2010. Module 8. Corrigé exercice 1 ... Nous voulons afficher une synthèse des ventes par matériel vendu (données en ligne) et par.
Untitled
07-Apr-2020 This book is printed on acid-free paper. ... Excel and STATA 894 ... –A Solutions Manual
2010 Tableau croisé dynamique
B) Optimisation de la mémoire à la création de plusieurs TCD dans Excel. Dans Excel quand on crée plusieurs tableaux dynamiques à partir de la même source
Table des matières
Exercices Excel. Page 1 sur 38. Table des matières Enregistrer le fichier en pdf ... Allez dans l'onglet « fichier » (Excel 2010). « options »(2010).
options futures
https://edisciplinas.usp.br/pluginfile.php/1214184/mod_folder/content/0/Hull%20J.C.-Options%2C%20Futures%20and%20Other%20Derivatives_9th%20edition.pdf?forcedownload=1
MAÎTRISER LES BASES DU TABLEUR AVEC EXCEL (version 2010)
12) Un classeur peut-il n'avoir qu'une seule feuille de calcul ? Page 22. EXERCICE DE PRÉSENTATION DU MENU. 1. RECONSTITUER LA FEUILLE
The McGraw-Hill Series Economics
ESSENTIALS OF ECONOMICS
Brue, McConnell, and Flynn
Essentials of Economics
Second Edition
Mandel
Economics:The Basics
First Edition
Schiller
Essentials of Economics
Seventh Edition
PRINCIPLES OF ECONOMICS
Colander
Economics, Microeconomics,
and MacroeconomicsSeventh Edition
Frank and Bernanke
Principles of Economics,
Principles of Microeconomics,
Principles of Macroeconomics
Fourth Edition
Frank and Bernanke
Brief Editions: Principles of
Economics, Principles of
Microeconomics, Principles of
Macroeconomics
First Edition
McConnell, Brue, and Flynn
Economics, Microeconomics,
and MacroeconomicsEighteenth Edition
McConnell, Brue, and Flynn
Brief Editions: Economics,
Microeconomics,
Macroeconomics
First Edition
Miller
Principles of Microeconomics
First Edition
Samuelson and Nordhaus
Economics, Microeconomics,
and MacroeconomicsEighteenth Edition
Schiller
The Economy Today,The Micro
Economy Today, and The Macro
Economy Today
Eleventh EditionSlavinEconomics, Microeconomics,and MacroeconomicsNinth EditionECONOMICS OF SOCIAL ISSUES
GuellIssues in Economics Today
Fourth Edition
Sharp, Register, and Grimes
Economics of Social Issues
Eighteenth Edition
ECONOMETRICS
Gujarati and Porter
Basic Econometrics
Fifth Edition
Gujarati and Porter
Essentials of Econometrics
Fourth Edition
MANAGERIAL ECONOMICS
BayeManagerial Economics and Business
Strategy
Sixth Edition
Brickley, Smith, and Zimmerman
Managerial Economics and
Organizational Architecture
Fifth Edition
Thomas and Maurice
Managerial Economics
Ninth Edition
INTERMEDIATE ECONOMICS
Bernheim and Whinston
Microeconomics
First Edition
Dornbusch, Fischer, and Startz
Macroeconomics
Tenth Edition
FrankMicroeconomics and Behavior
Seventh Edition
ADVANCED ECONOMICS
RomerAdvanced Macroeconomics
Third EditionMONEY AND BANKING
Cecchetti
Money, Banking, and Financial
Markets
Second Edition
URBAN ECONOMICS
OÕSullivan
Urban Economics
Seventh Edition
LABOR ECONOMICS
Borjas
Labor Economics
Fourth Edition
McConnell, Brue, and Macpherson
Contemporary Labor Economics
Eighth Edition
PUBLIC FINANCE
Rosen and Gayer
Public Finance
Eighth Edition
Seidman
Public Finance
First Edition
ENVIRONMENTAL ECONOMICS
Field and Field
Environmental Economics:
An Introduction
Fifth Edition
INTERNATIONAL ECONOMICS
Appleyard, Field, and Cobb
International Economics
Sixth Edition
King and King
International Economics,
Globalization, and Policy:A Reader
Fifth Edition
PugelInternational Economics
Fourteenth Edition
guj75772_IFC.qxd 01/08/2008 10:06 AM Page 2Basic Econometrics
Fifth Edition
Damodar N. Gujarati
Professor Emeritus of Economics,
United States Military Academy, West Point
Dawn C. Porter
University of Southern California
Boston Burr Ridge, IL Dubuque, IA New York San Francisco St. Louis Bangkok Bogotá Caracas Kuala Lumpur Lisbon London M adrid Mexico City Milan Montreal New Delhi Santiago Seoul Singapore Sydney Taipei Toronto guj75772_fm.qxd 05/09/2008 11:15 AM Page iBASIC ECONOMETRICS
Published by McGraw-Hill/Irwin, a business unit of The McGraw-Hill Companies, Inc., 1221 Avenue of the
Americas, New York, NY, 10020. Copyright © 2009, 2003, 1995, 1988, 1978 by The McGraw-Hill Companies,
Inc. All rights reserved. No part of this publication may be reproduced or distributed in any form or by any
means, or stored in a database or retrieval system, without the prior written consent of The McGraw-Hill
Companies, Inc., including, but not limited to, in any network or other electronic storage or transmission, or
broadcast for distance learning.Some ancillaries, including electronic and print components, may not be available to customers outside the
United States.
This book is printed on acid-free paper.
1 2 3 4 5 6 7 8 9 0 VNH/VNH 0 9 8
ISBN 978-0-07-337577-9
MHID 0-07-337577-2
Publisher:Douglas Reiner
Developmental editor:Anne E. Hilbert
Editorial coordinator:Noelle Fox
Associate marketing manager:Dean Karampelas
Lead Project manager:Christine A. Vaughan
Full-service project manager:Michael Ryder, ICC Macmillan Inc.Lead production supervisor:Carol A. Bielski
Design coordinator:Joanne Mennemeier
Media project manager:Srikanth Potluri, Hurix Systems Pvt. Ltd.Cover design:Brittany Skwierczynski
Typeface:10/12 TimesNewRomanPS
Compositor:ICC Macmillan Inc.
Printer:R. R. Donnelley
Library of Congress Cataloging-in-Publication DataGujarati, Damodar N.
Basic econometrics / Damodar N. Gujarati, Dawn C. Porter. Ñ 5th ed. p. cm.Includes bibliographical references and index.
ISBN-13: 978-0-07-337577-9 (alk. paper)
ISBN-10: 0-07-337577-2 (alk. paper)
1. Econometrics. I. Porter, Dawn C. II. Title.
HB139.G84 2009
330.01
5195Ñdc22
2008035934
www.mhhe.com guj75772_fm.qxd 05/09/2008 11:15 AM Page iiAbout the Authors
Damodar N. Gujarati
After teaching for more than 25 years at the City University of New York and 17 years in the Department of Social Sciences, U.S. Military Academy at West Point, New York, Dr. Gujarati is currently Professor Emeritus of economics at the Academy. Dr. Gujarati received his M.Com. degree from the University of Bombay in 1960, his M.B.A. degree from the University of Chicago in 1963, and his Ph.D. degree from the University of Chicago in 1965. Dr. Gujarati has published extensively in recognized national and international journals, such as the Review of Economics and Statistics,the Economic Journal,the Journal of Financial and Quantitative Analysis,and the Journal of Business.Dr. Gujarati was a member of theBoard of Editors of the
Journal of Quantitative Economics, the official journal of the Indian Econometric Society. Dr. Gujarati is also the author ofPensions and the New York City Fiscal Crisis(the American Enterprise Institute, 1978), Government and Business(McGraw-Hill,1984), and Essentials of Econometrics(McGraw-Hill, 3d ed., 2006). Dr. Gujarati's books
on econometrics have been translated into several languages. Dr. Gujarati was aVisiting Professor at the University of Sheffield, U.K. (1970-1971), a Visiting Fulbright Professor to India (1981-1982), a Visiting Professor in the School of of Econometrics, University of New SouthWales,Australia (summer of 1988). Dr. Gujarati China, Bangladesh, Germany, India, Israel, Mauritius, and the Republic of South Korea.Dawn C. Porter
Dawn Porter has been an assistant professor in the Information and Operations Manage- ment Department at the Marshall School of Business of the University of Southern California since the fall of 2006. She currently teaches both introductory undergraduate and MBA statistics in the business school. Prior to joining the faculty at USC, from2001-2006, Dawn was an assistant professor at the McDonough School of Business at
Georgetown University, and before that was a visiting professor in the psychology depart- ment at the Graduate School of Arts and Sciences at NYU. At NYU she taught a number of advanced statistical methods courses and was also an instructor at the Stern School of Business. Her Ph.D. is from the Stern School in Statistics. Dawn's areas of research interest include categorical analysis, agreement measures, multivariate modeling, and applications to the field of psychology. Her current research ex- amines online auction models from a statistical perspective. She has presented her research at the Joint Statistical Meetings, the Decision Sciences Institute meeti ngs, the International Conference on Information Systems, several universities including the London School of Economics and NYU, and various e-commerce and statistics seminar series. Dawn is also a co-author on Essentials of Business Statistics, 2nd edition, McGraw-Hill Irwin, 2008. Outside of academics, Dawn has been employed as a statistical consultant for KPMG, Inc. She has also worked as a statistical consultant for many other major companies, including Ginnie Mae, Inc., Toys R Us Corporation, IBM, Cosmaire, Inc., and New York University (NYU) Medical Center. iii guj75772_fm.qxd 05/09/2008 11:15 AM Page iiiFor Joan Gujarati, Diane Gujarati-Chesnut,
Charles Chesnut, and my grandchildren,
ÒTommyÓ and Laura Chesnut.
ÑDNG
For Judy, Lee, Brett, Bryan, Amy, and Autumn Porter.But especially for my adoring father, Terry.
ÑDCP
guj75772_fm.qxd 05/09/2008 11:15 AM Page ivBrief Contents
Preface xvi
Acknowledgments xix
Introduction 1
PART ONE
Single-Equation Regression Models 13
1The Nature of Regression Analysis
152Two-Variable Regression Analysis:
Some Basic Ideas
343Two-Variable Regression Model: The
Problem of Estimation
554Classical Normal Linear RegressionModel (CNLRM)
975Two-Variable Regression: Interval
Estimation and Hypothesis Testing
1076Extensions of the Two-Variable Linear Regression Model
1477Multiple Regression Analysis: TheProblem of Estimation
1888Multiple Regression Analysis: TheProblem of Inference
2339Dummy Variable Regression Models277
PART TWO
Relaxing the Assumptions
of the Classical Model 31510Multicollinearity: What HappensIf the Regressors Are Correlated?
32011Heteroscedasticity: What Happens Ifthe Error Variance Is Nonconstant?
36512Autocorrelation: What Happens Ifthe Error Terms Are Correlated?
41213Econometric Modeling: ModelSpecification and Diagnostic Testing
467PART THREE
Topics in Econometrics 523
14Nonlinear Regression Models
52515Qualitative Response Regression Models
54116Panel Data Regression Models591
17Dynamic Econometric Models:Autoregressive andDistributed-Lag Models
617PART FOUR
Simultaneous-Equation Models and Time
Series Econometrics 671
18Simultaneous-Equation Models
67319The Identification Problem689
20Simultaneous-Equation Methods711
21Time Series Econometrics: Some
Basic Concepts
73722Time Series Econometrics:
Forecasting
773APPENDICES
AA Review of Some Statistical Concepts
801BRudiments of Matrix Algebra838
CThe Matrix Approach to Linear Regression Model
849DStatistical Tables877
EComputer Output of EViews, MINITAB, Excel, and STATA 894FEconomic Data on the World Wide Web
900SELECTED BIBLIOGRAPHY 902
v guj75772_fm.qxd 05/09/2008 11:15 AM Page v viContents
Preface xvi
Acknowledgments xix
Introduction 1
I.1What Is Econometrics? 1
I.2Why a Separate Discipline? 2
I.3Methodology of Econometrics 2
1. Statement of Theory or Hypothesis 3
2. SpeciÞcation of the Mathematical Model
of Consumption 33. SpeciÞcation of the Econometric Model
of Consumption 44. Obtaining Data 5
5. Estimation of the Econometric Model 5
6. Hypothesis Testing 7
7. Forecasting or Prediction 8
8. Use of the Model for Control
or Policy Purposes 9Choosing among Competing Models 9
I.4Types of Econometrics 10
I.5Mathematical and Statistical Prerequisites 11
I.6The Role of the Computer 11
I.7Suggestions for Further Reading 12
PART ONE
SINGLE-EQUATION REGRESSION
MODELS 13
CHAPTER 1
The Nature of Regression Analysis 15
1.1Historical Origin of the Term Regression15
1.2The Modern Interpretation of Regression 15
Examples 16
1.3Statistical versus Deterministic
Relationships 19
1.4Regression versus Causation 19
1.5Regression versus Correlation 20
1.6Terminology and Notation 21
1.7The Nature and Sources of Data for EconomicAnalysis 22
Types of Data 22
The Sources of Data 25
The Accuracy of Data 27
A Note on the Measurement Scales
of Variables 27Summary and Conclusions 28
Exercises 29
CHAPTER 2
Two-Variable Regression Analysis: Some
Basic Ideas 34
2.1A Hypothetical Example 34
2.2The Concept of Population Regression
Function (PRF) 37
2.3The Meaning of the Term Linear38
Linearity in the Variables 38
Linearity in the Parameters 38
2.4Stochastic SpeciÞcation of PRF 39
2.5The SigniÞcance of the Stochastic
Disturbance Term 41
2.6The Sample Regression Function (SRF) 42
2.7Illustrative Examples 45Summary and Conclusions 48Exercises 48
CHAPTER 3
Two-Variable Regression Model:The
Problem of Estimation 55
3.1The Method of Ordinary Least Squares 55
3.2The Classical Linear Regression Model: The
Assumptions Underlying the Method
of Least Squares 61A Word about These Assumptions 68
3.3Precision or Standard Errors of Least-Squares Estimates 69
3.4Properties of Least-Squares Estimators: The GaussÐMarkov Theorem 71
3.5The CoefÞcient of Determination r
2A Measure of ÒGoodness of FitÓ 73
3.6A Numerical Example 78
3.7Illustrative Examples 81
3.8A Note on Monte Carlo Experiments 83Summary and Conclusions 84Exercises 85Appendix 3A 92
3A.1Derivation of Least-Squares Estimates 92
3A.2Linearity and Unbiasedness Properties of Least-Squares Estimators 92
3A.3Variances and Standard Errors
of Least-Squares Estimators 93 guj75772_fm.qxd 05/09/2008 11:15 AM Page viContentsvii
3A.4Covariance Between
1 and 2 933A.5The Least-Squares Estimator of
2 933A.6Minimum-Variance Property
of Least-Squares Estimators 953A.7Consistency of Least-Squares Estimators 96
CHAPTER 4
Classical Normal Linear Regression
Model (CNLRM) 97
4.1The Probability Distribution
of Disturbances u iquotesdbs_dbs1.pdfusesText_1[PDF] exercice excel debutant pdf
[PDF] exercice excel fonction si + corrigé pdf
[PDF] exercice excel fonction si pdf
[PDF] exercice excel pdf
[PDF] exercice excel tableau croisé dynamique pdf
[PDF] exercice exponentielle terminale s
[PDF] exercice exponentielle terminale s type bac
[PDF] exercice factorisation 3eme avec corrigé pdf
[PDF] exercice factorisation 3eme type brevet
[PDF] exercice féminin masculin ce1 ? imprimer
[PDF] exercice fibre optique corrigé
[PDF] exercice fonction de reference 1ere es
[PDF] exercice fonction dérivée
[PDF] exercice fonction seconde corrigé