Incorporating qualitative factors into multiple regression Using correlations to summarize relationships Summarizing data with database statistical functions Using PivotTables and slicers to describe data Summarizing data by using descriptive statistics Summarizing data by using histograms and Pareto charts Importing data from a text file or document
Warehouse location and the GRG Multistart and Evolutionary Solver engines Using Solver to solve transportation or distribution problems Using Solver to determine the optimal product mix Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxesĪn introduction to optimization with Excel Solver The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions Using the Scenario Manager for sensitivity analysis Three-dimensional formulas and hyperlinks Copyeditor: Kathleen Atkins Indexer: Maureen Johnson, MoJo’s Indexing and Editorial Services Cover: Twist Creative Įvaluating investments by using net present value criteria Acquisitions and Developmental Editor: Rosemary Caperton Project Editor: John Pierce Editorial Production: Kathleen Atkins, Rob Nance, and John Pierce Technical Reviewer: Ed Price Technical Review services provided by Content Master, a member of CM Group, Ltd. All other marks are property of their respective owners. Microsoft and the trademarks listed at on the “Trademarks” webpage are trademarks of the Microsoft group of companies. No real association or connection is intended or should be inferred. Some examples depicted herein are provided for illustration only and are fctitious. The views, opinions and information expressed in this book, including URL and other Internet website references, may change without notice.
This book is provided “as-is” and expresses the author’s views and opinions. If you need support related to this book, email Microsoft Press Support at Please tell us what you think of this book at. First Printing Microsoft Press books are available through booksellers and distributors worldwide. Library of Congress Control Number: 2016943109 ISBN: 978-1-5093-0421-9 Printed and bound in the United States of America. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.
PUBLISHED BY Microsoft Press A Division of Microsoft Corporation One Microsoft Way Redmond, Washington 98052-6399 Copyright © 2016 by Wayne L. Microsoft Excel 2016 Data Analysis and Business Modeling
0 kommentar(er)
