عنوان

Microsoft Excel 2013 :

شابک

0735669139

شابک

9780735669130

شماره

b427593

عنوان اصلي

Microsoft Excel 2013 :

نام عام مواد

[Book]

ساير اطلاعات عنواني

data analysis and business modeling /

نام نخستين پديدآور

Wayne L. Winston

نام خاص و کميت اثر

xxvi, 859 pages :

ساير جزييات

illustrations ;

ابعاد

23 cm

متن يادداشت

Includes index

متن يادداشت

Range names -- Lookup functions -- The INDEX function -- The MATCH function -- Text functions -- Dates and date functions -- Evaluating investments by using net present value criteria -- Internal rate of return -- More Excel financial functions -- Circular references -- IF statements -- Time and time functions -- The paste special command -- Three-dimensional formulas -- The auditing tool -- Sensitivity analysis with data tables -- The goal seek command -- Using the scenario manager for sensitivity analysis -- The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions -- The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions -- The OFFSET function -- The INDIRECT function -- Conditional formatting -- Sorting in Excel -- Tables -- Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes -- An introduction to optimization with Excel Solver -- Using Solver to determine the optimal product mix -- Using Solver to schedule your workforce -- Using Solver to solve transportation or distribution problems -- Using Solver for capital budgeting -- Using Solver for financial planning -- Using Solver to rate sports teams -- Warehouse location and the GRG multistart and Evolutionary Solver engines -- Penalties and the Evolutionary Solver -- The traveling salesperson problem -- Importing data from a text file or document -- Importing data from the internet -- Validating data -- Summarizing data by using histograms -- Summarizing data by using descriptive statistics -- Using PivotTables and slicers to describe data -- Sparklines -- Summarizing data with database statistical functions -- Filtering data and removing duplicates -- Consolidating data -- Creating subtotals -- Estimating straight line relationships -- Modeling exponential growth -- The power curve -- Using correlations to summarize relationships -- Introduction to multiple regression -- Incorporating qualitative factors into multiple regression -- Modeling nonlinearities and interactions -- Analysis of variance: one-way ANOVA -- Randomized blocks and two-way ANOVA -- Using moving averages to understand time series -- Winters's method -- Ratio-to-moving-average forecast method -- Forecasting in the presence of special events -- An introduction to random variables -- The binomial, hypergeometric, and negative binomial random variables -- The Poisson and exponential random variable -- The normal random variable -- Weibull and beta distributions: modeling machine life and duration of a project -- Making probability statements from forecasts -- Using the lognormal random variable to model stock prices -- Introduction to Monte Carlo simulation -- Calculating an optimal bid -- Simulating stock prices and asset allocation modeling -- Fun and games: simulating gambling and sporting event probabilities -- Using resampling to analyze data -- Pricing stock options -- Determining customer value -- The economic order quantity inventory model -- Inventory modeling with uncertain demand -- Queuing theory: the mathematics of waiting in line -- Estimating a demand curve -- Pricing products by using tie-ins -- Pricing products by using subjectively determined demand -- Nonlinear pricing -- Array formulas and functions

بدون عنوان

0

متن يادداشت

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables - and how to effectively build a relational data source inside an Excel workbook

موضوع مستند نشده

Microsoft Excel (Computer file)

موضوع مستند نشده

Decision making-- Computer programs

موضوع مستند نشده

Industrial management-- Statistical methods-- Computer programs

شماره رده

نشانه اثر

مستند نام اشخاص تاييد نشده

Winston, Wayne L.

تاريخ عمليات

20180808010307.0

قواعد فهرست نويسي ( بخش توصيفي )

rda

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y