没有合适的资源?快使用搜索试试~ 我知道了~
首页Statistics_for_Managers_Using_Microsoft_Excel_8th.pdf
Statistics_for_Managers_Using_Microsoft_Excel_8th.pdf
需积分: 10 241 浏览量
更新于2023-05-24
评论 2
收藏 33.31MB PDF 举报
Statistics_for_Managers_Using_Microsoft_Excel_8th.pdf
资源详情
资源评论
资源推荐


A R S
S M
Data Analysis Task For Numerical Variables For Categorical Variables
Describing a group or
several groups
Ordered array, stem-and-leaf display, frequency
distribution, relative frequency distribution,
percentage distribution, cumulative percentage
distribution, histogram, polygon, cumulative
percentage polygon, sparklines, gauges, treemaps
(Sections 2.2, 2.4, 2.6, 17.4)
Mean, median, mode, geometric mean, quartiles,
range, interquartile range, standard deviation, variance,
coecient of variation, skewness, kurtosis, boxplot,
normal probability plot (Sections 3.1, 3.2, 3.3, 6.3)
Index numbers (online Section 16.8)
Summary table, bar chart, pie
chart, doughnut chart, Pareto chart
(Sections 2.1 and 2.3)
Inference about one
group
Confidence interval estimate of the mean (Sections
8.1 and 8.2)
t test for the mean (Section 9.2)
Chi-square test for a variance or standard deviation
(online Section 12.7)
Confidence interval estimate of the
proportion (Section 8.3)
Z test for the proportion
(Section 9.4)
Comparing two
groups
Tests for the dierence in the means of two
independent populations (Section 10.1)
Wilcoxon rank sum test (Section 12.4)
Paired t test (Section 10.2)
F test for the dierence between two variances
(Section 10.4)
Z test for the dierence between
two proportions (Section 10.3)
Chi-square test for the dierence
between two proportions
(Section 12.1)
McNemar test for two related
samples (online Section 12.6)
Comparing more than
two groups
One-way analysis of variance for comparing several
means (Section 11.1)
Kruskal-Wallis test (Section 12.5)
Two-way analysis of variance (Section 11.2)
Randomized block design (online Section 11.3)
Chi-square test for dierences
among more than two proportions
(Section 12.2)
Analyzing the
relationship between
two variables
Scatter plot, time-series plot (Section 2.5)
Covariance, coecient of correlation (Section 3.5)
Simple linear regression (Chapter 13)
t test of correlation (Section 13.7)
Time-series forecasting (Chapter 16)
Sparklines (Section 2.6)
Contingency table, side-by-side bar
chart, doughnut chart, PivotTables
(Sections 2.1, 2.3, 2.6)
Chi-square test of independence
(Section 12.3)
Analyzing the
relationship between
two or more
variables
Multiple regression (Chapters 14 and 15)
Regression trees (Section 17.5)
Multidimensional contingency
tables (Section 2.6)
Drilldown and slicers (Section 2.6)
Logistic regression (Section 14.7)
Classification trees (Section 17.5)
A01_LEVI3054_08_SE_FM.indd 1 12/22/15 4:25 PM

A01_LEVI3054_08_SE_FM.indd 2 12/22/15 4:25 PM
This page intentionally left blank

David M. Levine
Department of Statistics and Computer Information Systems
Zicklin School of Business, Baruch College, City University of New York
David F. Stephan
Two Bridges Instructional Technology
Kathryn A. Szabat
Department of Business Systems and Analytics
School of Business, La Salle University
Boston Columbus Indianapolis New York San Francisco
Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto
Delhi Mexico City S
~
ao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo
8th Edition
Statistics for
Managers Using
Microsoft
®
Excel
A01_LEVI3054_08_SE_FM.indd 3 12/22/15 4:25 PM

Editorial Director: Chris Hoag
Editor in Chief: Deirdre Lynch
Acquisitions Editor: Suzanna Bainbridge
Senior Editorial Assistant: Justin Billing
Program Manager: Chere Bemelmans
Project Manager: Sherry Berg
Program Management Team Lead: Karen Wernholm
Project Management Team Lead: Peter Silvia
Media Producer: Jean Choe
TestGen Content Manager: John Flanagan
QA Manager, Assessment Content: Marty Wright
Senior MathXL Content Developer: Robert Carroll
Marketing Manager: Tiffany Bitzel
Field Marketing Manager: Adam Goldstein
Marketing Assistant: Jennifer Myers
Senior Author Support/Technology Specialist: Joe Vetere
Manager, Rights Management: Gina Cheselka
Senior Procurement Specialist: Carol Melville
Associate Director of Design: Andrea Nix
Program Design Lead and Cover Design: Barbara Atkinson
Text Design: Cenveo Publisher Services
Production Coordination, Composition, and Illustrations: Lumina Datamatics
Cover Image: Serp/Shutterstock
Copyright © 2017, 2014, 2011 by Pearson Education, Inc. All Rights Reserved. Printed in the United States of America. This publication is protected by copyright,
and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any
means, electronic, mechanical, photocopying, recording, or otherwise. For information regarding permissions, request forms and the appropriate contacts within
the Pearson Education Global Rights & Permissions department, please visit www.pearsoned.com/permissions/.
PEARSON, ALWAYS LEARNING, and MYSTATLAB are exclusive trademarks owned by Pearson Education, Inc. or its affiliates in the U.S. and/or other
countries.
Unless otherwise indicated herein, any third-party trademarks that may appear in this work are the property of their respective owners and any references to
third-party trademarks, logos or other trade dress are for demonstrative or descriptive purposes only. Such references are not intended to imply any sponsorship,
endorsement, authorization, or promotion of Pearson’s products by the owners of such marks, or any relationship between the owner and Pearson Education, Inc.
or its affiliates, authors, licensees or distributors.
MICROSOFT
®
AND WINDOWS
®
ARE REGISTERED TRADEMARKS OF THE MICROSOFT CORPORATION IN THE U.S.A. AND OTHER
COUNTRIES. THIS BOOK IS NOT SPONSORED OR ENDORSED BY OR AFFILIATED WITH THE MICROSOFT CORPORATION. ILLUSTRATIONS
OF MICROSOFT EXCEL IN THIS BOOK HAVE BEEN TAKEN FROM MICROSOFT EXCEL 2013, UNLESS OTHERWISE INDICATED.
MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE INFORMATION
CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED AS PART OF THE SERVICES FOR ANY PURPOSE. ALL SUCH
DOCUMENTS AND RELATED GRAPHICS ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE
SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION, INCLUDING ALL WARRANTIES
AND CONDITIONS OF MERCHANTABILITY, WHETHER EXPRESS, IMPLIED OR STATUTORY, FITNESS FOR A PARTICULAR PURPOSE, TITLE
AND NON-INFRINGEMENT. IN NO EVENT SHALL MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS BE LIABLE FOR ANY SPECIAL, INDIRECT
OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER
IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
PERFORMANCE OF INFORMATION AVAILABLE FROM THE SERVICES.
THE DOCUMENTS AND RELATED GRAPHICS CONTAINED HEREIN COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL
ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAY
MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S) AND/OR THE PROGRAM(S) DESCRIBED HEREIN AT ANY TIME. PARTIAL
SCREEN SHOTS MAY BE VIEWED IN FULL WITHIN THE SOFTWARE VERSION SPECIFIED.
Library of Congress Cataloging-in-Publication Data
Levine, David M., 1946– author.
Statistics for managers using Microsoft Excel / David M. Levine, David F. Stephan, Kathryn A. Szabat.—8th edition.
pages cm
Includes bibliographical references and index.
ISBN 978-0-13-417305-4 (hardcover)
1. Microsoft Excel (Computer file) 2. Management—Statistical methods. 3. Commercial statistics. 4. Electronic spreadsheets.
5. Management—Statistical methods—Computer programs. 6. Commercial statistics—Computer programs. I. Stephan,
David F., author. II. Szabat, Kathryn A., author. III. Title.
HD30.215.S73 2017
519.50285'554—dc23
2015027139
1 2 3 4 5 6 7 8 9 10—CRK—19 18 17 16 15
ISBN-10: 0-13-417305-8
ISBN-13: 978-0-13-417305-4
www.pearsonhighered.com
A01_LEVI3054_08_SE_FM.indd 4 12/22/15 4:25 PM
剩余799页未读,继续阅读














安全验证
文档复制为VIP权益,开通VIP直接复制

评论0