000 04885cam^a2200457^a^4500
001 UDM01000140801
003 UDM
005 20210531134028.0
008 120314s2011^^^^waua^^^^^^^^^^001^0^eng^d
020 _a0735643369
_q(pbk.)
020 _a9780735643369
_q(pbk.)
040 _aBTCTA
_beng
_cBTCTA
_dDLC
_dBDX
_dUN@
082 0 4 _a005.54
_bW783ma 2011
100 1 _963720
_aWinston, Wayne L,
_eautor
245 1 0 _aMicrosoft Excel 2010 :
_bdata analysis and business modeling /
_cWayne L. Winston.
246 2 _aExcel 2010 : data analysis and business modeling.
264 3 1 _aRedmond, Wash. :
_bMicrosoft Press,
_cc2011.
300 _axv, 700 páginas :
_bilustraciones ;
_c23 cm.
336 _atexto
_btxt
_2rdacontent
337 _ano mediado
_bn
_2rdamedia
338 _avolumen
_bnc
_2rdacarrier
505 0 _aDetermining 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 -- PowerPivot.
505 0 _aIncorporating 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 --^
505 0 _aUsing 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 --^
505 0 _aWhat´s new in Excel 2010 -- 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 --^
630 0 4 _9336525
_aMicrosoft Excel para Windows (Programa para computador).
650 1 4 _9300536
_aAdministración industrial.
_xMétodos estadísticos
_xProgramas para computador.
650 1 4 _9119033
_aToma de decisiones
_xProgramas para computador.
942 _2ddc
_cGEN
991 _aC0
_bUN@
991 _aIHM
_aPR12
_a000015724, Jiménez Vega, Martín Gerardo.
991 _aMER
_bÁlvarez Milán, Agarzelim.
_cPR16
_dSEP
991 _aUVA
_aOT13
_aAmaya Alemán, María Susana.
992 _aCO1020 Fundamentos Cuantitativos en Finanzas
997 _aHZ
_b00
_c20140722
_lUDM01
_h1028
998 _aRGARZA
_b00
_c20160523
_lUDM01
_h1103
999 _c128615
_d128615
900 _aDSÑ
900 _aAYN
900 _aTC