Conrad Carlberg - Regression Analysis Microsoft Excel

EPUB is an open, industry-standard format for e-books. However, support for EPUB and its many features varies across reading devices and applications. Use your device or app settings to customize the presentation to your liking. Settings that you can customize often include font, font size, single or double column, landscape or portrait mode, and figures that you can click or tap to enlarge. For additional information about the settings and features on your reading device or app, visit the device manufacturers Web site.

Many titles include programming code or configuration examples. To optimize the presentation of these elements, view the e-book in single-column, landscape mode and adjust the font size to the smallest setting. In addition to presenting code and configurations in the reflowable text format, we have included images of the code that mimic the presentation found in the print book; therefore, where the reflowable format may compromise the presentation of the code listing, you will see a Click here to view code image link. Click the link to view the print-fidelity code image. To return to the previous page viewed, click the Back button on your device or app.

Conrad Carlberg

800 East 96th Street,
Indianapolis, Indiana 46240 USA

Regression Analysis Microsoft Excel

Copyright 2016 by Pearson Education, Inc.

All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-7897-5655-8
ISBN-10: 0-7897-5655-2

Library of Congress Control Number: 2016930324

Printed in the United States of America

First Printing April 2016

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an as is basis. The author and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.

Special Sales

For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding interests), please contact our corporate sales department at or (800) 382-3419.

For government sales inquiries, please contact .

For questions about sales outside the U.S., please contact

Editor-in-Chief

Greg Wiegand

Acquisitions Editor

Joan Murray

Trina MacDonald

Development Editor

Mark Renfrow

Managing Editor

Sandra Schroeder

Project Editor

Seth Kerney

Mandie Frank

Copy Editor

Paula Lowell

Indexer

WordWise Publishing Services

Proofreader

Debbie Williams

Technical Editor

Bill Pate

Editorial Assistant

Cindy Teeters

Cover Designer

Chuti Prasertsith

Compositor

codeMantra

Conrad Carlberg (www.conradcarlberg.com) is a nationally recognized expert on quantitative analysis and on data analysis and management applications such as Microsoft Excel, SAS, and Oracle. He holds a Ph.D. in statistics from the University of Colorado and is a many-time recipient of Microsofts Excel MVP designation.

Carlberg is a Southern California native. After college he moved to Colorado, where he worked for a succession of startups and attended graduate school. He spent two years in the Middle East, teaching computer science and dodging surly camels. After finishing graduate school, Carlberg worked at US West (a Baby Bell) in product management and at Motorola.

In 1995 he started a small consulting business that provides design and analysis services to companies that want to guide their business decisions by means of quantitative analysisapproaches that today we group under the term analytics. He enjoys writing about those techniques and, in particular, how to carry them out using the worlds most popular numeric analysis application, Microsoft Excel.

I thank Joan Murray for the skill and tact she employed in seeing this book through from a proposed table of contents to a bound volume (or, if your preferences in media run that way, an electronic gadget). Bill Pate provided a careful technical edit, not a straightforward task when the platform gets as idiosyncratic as Excel does from time to time. Paula Lowells copy edit unmixed my metaphors, got my subjects to reach agreement with my verbs, and gently pointed out those occasions when I accidentally duplicated figure captions. Seth Kerney, Mandie Frank and Mark Renfrow kept the whole thing from careening out of control, and Im the sole owner of any errors remaining in this book.

As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what were doing right, what we could do better, what areas youd like to see us publish in, and any other words of wisdom youre willing to pass our way.

We welcome your comments. You can email or write to let us know what you did or didnt like about this bookas well as what we can do to make our books better.

Please note that we cannot help you with technical problems related to the topic of this book.

When you write, please be sure to include this books title and author as well as your name and email address. We will carefully review your comments and share them with the author and editors who worked on the book.

Email: feedback@quepublishing.com

Mail: Que Publishing
ATTN: Reader Feedback
800 East 96th Street
Indianapolis, IN 46240 USA

Register your copy of Regression Analysis Microsoft Excel at quepublishing.com for convenient access to downloads, updates, and corrections as they become available. To start the registration process, go to quepublishing.com/register and log in or create an account*. Enter the product ISBN, 9780789756558, and click Submit. Once the process is complete, you will find any available bonus content under Registered Products.

*Be sure to check the box that you would like to hear from us in order to receive exclusive discounts on future editions of this product.

Like a lot of people, I slogged through my first undergraduate classes in inferential statistics. Im not talking here about the truly basic, everyday stats like averages, medians, and ranges. Im talking about things you dont commonly run into outside the classroom, like randomized block designs and the analysis of variance.