Cargando…

Microsoft Excel data analysis and business modeling /

Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to use Microsoft Excel for data analysis, modeling, and decision making within real-world business scenarios.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Winston, Wayne L.
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Redmond, Wash. : Microsoft Press, ©2004.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000 a 4500
001 OR_ocm60779412
003 OCoLC
005 20231017213018.0
006 m o d
007 cr unu||||||||
008 050630s2004 waua o 001 0 eng d
040 |a OCL  |b eng  |e pn  |c OCL  |d OCLCQ  |d VLB  |d OCLCQ  |d B24X7  |d N$T  |d OCLCQ  |d TEFOD  |d OCLCF  |d OCLCO  |d YDXCP  |d E7B  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCQ  |d COO  |d OCLCO  |d CEF  |d WYU  |d UAB  |d VT2  |d CNCEN  |d RDF  |d UHL  |d UKBTH  |d TOH  |d OCLCQ  |d OCLCO  |d OCLCQ 
019 |a 776202979  |a 861533682  |a 1064766535  |a 1103276355  |a 1113677025  |a 1129374385  |a 1159644262  |a 1202541399  |a 1224592473  |a 1240527373 
020 |a 9780735635241  |q (electronic bk.) 
020 |a 0735635242  |q (electronic bk.) 
020 |a 9780735637146  |q (electronic bk.) 
020 |a 0735637148  |q (electronic bk.) 
020 |z 0735619018 
020 |z 9780735619012 
024 8 |a 0735619018 
029 1 |a AU@  |b 000067111286 
029 1 |a AU@  |b 000069008256 
035 |a (OCoLC)60779412  |z (OCoLC)776202979  |z (OCoLC)861533682  |z (OCoLC)1064766535  |z (OCoLC)1103276355  |z (OCoLC)1113677025  |z (OCoLC)1129374385  |z (OCoLC)1159644262  |z (OCoLC)1202541399  |z (OCoLC)1224592473  |z (OCoLC)1240527373 
050 4 |a HD30.215  |b .W56 2004 
072 7 |a COM  |x 054000  |2 bisacsh 
082 0 4 |a 005.54  |2 22 
049 |a UAMI 
100 1 |a Winston, Wayne L. 
245 1 0 |a Microsoft Excel data analysis and business modeling /  |c Wayne Winston. 
246 3 0 |a Data analysis and business modeling 
260 |a Redmond, Wash. :  |b Microsoft Press,  |c ©2004. 
300 |a 1 online resource (xi, 602 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
500 |a Includes index. 
505 0 |a 1. Range Names -- 2. Natural Language Range Names -- 3. Lookup Functions -- 4. The INDEX Function -- 5. The MATCH Function -- 6. Text Functions -- 7. Dates and Date Functions -- 8. Evaluating Investments with Net Present Value Criteria -- 9. Internal Rate of Return -- 10. Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions -- 11. Circular References -- 12. IF Statements -- 13. The Paste Special Command -- 14. The Auditing Tool -- 15. Sensitivity Analysis with Data Tables -- 16. The Goal Seek Command -- 17. Using the Scenario Manager for Sensitivity Analysis -- 18. Creating and Using Spinners for Sensitivity Analysis -- 19. The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions -- 20. The SUMIF Function -- 21. The OFFSET Function -- 22. The INDIRECT Function -- 23. Conditional Formatting -- 24. An Introduction to Optimization with the Excel Solver -- 25. Using Solver to Determine the Optimal Product Mix -- 26. Using Solver to Solve Transportation or Distribution Problems -- 27. Using Solver to Schedule Your Workforce -- 28. Using Solver for Capital Budgeting -- 29. Using Solver for Financial Planning -- 30. Using Solver to Rate Sports Teams -- 31. Importing Text or Microsoft Word Data into Excel -- 32. Importing Data from the Web into Excel -- 33. Validating Data -- 34. Summarizing Data with Histograms -- 35. Summarizing Data with Descriptive Statistics -- 36. Using PivotTables to Describe Data -- 37. Summarizing Data with Database Statistical Functions -- 38. Filtering Data -- 39. Consolidating Data -- 40. Creating Subtotals -- 41. Estimating Straight Line Relationships -- 42. Modeling Exponential Growth -- 43. The Power Curve -- 44. Using Correlations to Summarize Relationships -- 45. Introduction to Multiple Regression -- 46. Incorporating Qualitative Factors into Multiple Regression -- 47. Modeling Nonlinearities and Interactions -- 48. Analysis of Variance: One-Way ANOVA -- 49. Randomized Blocks and Two-Way ANOVA -- 50. Using Moving Averages to Understand Time Series -- 51. Forecasting with Moving Averages -- 52. Forecasting in the Presence of Special Events -- 53. An Introduction to Random Variables -- 54. The Binomial and Hypergeometric Random Variables -- 55. The Poisson and Exponential Random Variable -- 56. The Normal Random Variable -- 57. Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project -- 58. Introduction to Monte Carlo Simulation -- 59. Calculating an Optimal Bid -- 60. Simulating Stock Prices and Asset Allocation Modeling -- 61. Fun and Games: Simulating Gambling and Sporting Event Probabilities -- 62. Using Resampling to Analyze Data -- 63. Pricing Stock Options -- 64. Determining Customer Value -- 65. The Economic Order Quantity Inventory Model -- 66. Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder? -- 67. Queuing Theory: The Mathematics of Waiting in Line -- 68. Estimating a Demand Curve -- 69. Pricing Products with Tie-ins -- 70. Pricing Products Using Subjectively Determined Demand -- 71. Nonlinear Pricing -- 72. Array Formulas and Functions -- 73. Picking Your Fantasy Football Team. 
520 |a Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to use Microsoft Excel for data analysis, modeling, and decision making within real-world business scenarios. 
542 |f Copyright © Microsoft Press  |g 2004 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast  |0 (OCoLC)fst01366659 
650 0 |a Industrial management  |x Statistical methods  |x Computer programs. 
650 0 |a Decision making  |x Computer programs. 
650 6 |a Gestion d'entreprise  |x Méthodes statistiques  |x Logiciels. 
650 6 |a Prise de décision  |x Logiciels. 
650 7 |a COMPUTERS  |x Desktop Applications  |x Spreadsheets.  |2 bisacsh 
650 7 |a Decision making  |x Computer programs.  |2 fast  |0 (OCoLC)fst00889038 
650 7 |a Industrial management  |x Statistical methods  |x Computer programs.  |2 fast  |0 (OCoLC)fst00971331 
653 |a Microsoft 
776 0 8 |i Print version:  |z 0735619018  |w (DLC) 2003064860  |w (OCoLC)53360686 
856 4 0 |u https://learning.oreilly.com/library/view/~/0735619018/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a ebrary  |b EBRY  |n ebr10762418 
938 |a EBSCOhost  |b EBSC  |n 431867 
938 |a YBP Library Services  |b YANK  |n 7462423 
994 |a 92  |b IZTAP