Coverart for item
The Resource Microsoft Office Excel 2007 : data analysis and business modeling, Wayne L. Winston

Microsoft Office Excel 2007 : data analysis and business modeling, Wayne L. Winston

Label
Microsoft Office Excel 2007 : data analysis and business modeling
Title
Microsoft Office Excel 2007
Title remainder
data analysis and business modeling
Statement of responsibility
Wayne L. Winston
Creator
Subject
Genre
Language
eng
Summary
Provides an introduction to data analysis and business modeling using Microsoft Excel
Related
Member of
Action
digitized
Cataloging source
NTG
http://library.link/vocab/creatorName
Winston, Wayne L
Dewey number
658.403/0285
Illustrations
illustrations
Index
index present
LC call number
HD30.215
LC item number
.W56 2007eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Industrial management
  • Decision making
  • COMPUTERS
  • Industrial management
  • Decision making
  • Business
  • Decision making
  • Industrial management
  • Betriebsdaten
  • Datenanalyse
  • Excel 2007
Label
Microsoft Office Excel 2007 : data analysis and business modeling, Wayne L. Winston
Instantiates
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
other
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
1. Range names -- 2. Lookup functions -- 3. The INDEX function -- 4. The MATCH function -- 5. Text functions -- 6. Dates and date functions -- 7. Evaluating investments by using net present value criteria -- 8. Internal rate of return -- 9. More Excel financial functions -- 10. Circular references -- 11. IF statements -- 12. Time and time functions -- 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. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions -- 19. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions -- 20. The OFFSET function -- 21. The INDIRECT function -- 22. Conditional formatting -- 23. Sorting in Excel -- 24. Tables -- 25. Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes -- 26. An introduction to optimization with Excel solver -- 27. Using solver to determine the optimal product mix -- 28. Using solver to schedule your workforce -- 29. Using solver to solve transportation or distribution problems -- 30. Using solver for capital budgeting -- 31. Using solver for financial planning -- 32. Using solver to rate sports teams -- 33. Importing data from a text file or document -- 34. Importing data from the Internet -- 35. Validating data -- 36. Summarizing data by using histograms -- 37. Summarizing data by using descriptive statistics -- 38. Using PivotTables to describe data -- 39. Summarizing data with database statistical functions -- 40. Filtering data and removing duplicates -- 41. Consolidating data -- 42. Creating subtotals -- 43. Estimating straight line relationships -- 44. Modeling exponential growth -- 45. The power curve -- 46. Using correlations to summarize relationships -- 47. Introduction to multiple regression -- 48. Incorporating qualitative factors into multiple regression -- 49. Modeling nonlinearities and interactions -- 50. Analysis of variance : one-way ANOVA -- 51. Randomized blocks and two-way ANOVA -- 52. Using moving averages to understand time series -- 53. Winter's method -- 54. Forecasting in the presence of special events -- 55. An introduction to random variables -- 56. The binomial, hypergeometric, and negative binomial random variables -- 57. The poisson and exponential random variable -- 58. The normal random variable -- 59. Weibull and beta distributions : modeling machine life and duration of a project -- 60. Introduction to Monte Carlo simulation -- 61. Calculating an optimal bid -- 62. Simulating stock prices and asset allocation modeling -- 63. Fun and games : simulating gambling and sporting event probabilities -- 64. Using resampling to analyze data -- 65. Pricing stock options -- 66. Determining customer value -- 67. The economic order quantity inventory model -- 68. Inventory modeling with uncertain demand -- 69. Queuing theory : the mathematics of waiting in line -- 70. Estimating a demand curve -- 71. Pricing products by using tie-ins -- 72. Pricing products by using subjectively determined demand -- 73. Nonlinear pricing -- 74. Array formulas and functions
Control code
184871045
Dimensions
unknown
Extent
1 online resource (xix, 601 pages)
Form of item
online
Isbn
9780735642584
Lccn
2007924648
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000014
Reproduction note
Electronic reproduction.
Specific material designation
remote
System control number
(OCoLC)184871045
System details
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Label
Microsoft Office Excel 2007 : data analysis and business modeling, Wayne L. Winston
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
other
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
1. Range names -- 2. Lookup functions -- 3. The INDEX function -- 4. The MATCH function -- 5. Text functions -- 6. Dates and date functions -- 7. Evaluating investments by using net present value criteria -- 8. Internal rate of return -- 9. More Excel financial functions -- 10. Circular references -- 11. IF statements -- 12. Time and time functions -- 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. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions -- 19. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions -- 20. The OFFSET function -- 21. The INDIRECT function -- 22. Conditional formatting -- 23. Sorting in Excel -- 24. Tables -- 25. Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes -- 26. An introduction to optimization with Excel solver -- 27. Using solver to determine the optimal product mix -- 28. Using solver to schedule your workforce -- 29. Using solver to solve transportation or distribution problems -- 30. Using solver for capital budgeting -- 31. Using solver for financial planning -- 32. Using solver to rate sports teams -- 33. Importing data from a text file or document -- 34. Importing data from the Internet -- 35. Validating data -- 36. Summarizing data by using histograms -- 37. Summarizing data by using descriptive statistics -- 38. Using PivotTables to describe data -- 39. Summarizing data with database statistical functions -- 40. Filtering data and removing duplicates -- 41. Consolidating data -- 42. Creating subtotals -- 43. Estimating straight line relationships -- 44. Modeling exponential growth -- 45. The power curve -- 46. Using correlations to summarize relationships -- 47. Introduction to multiple regression -- 48. Incorporating qualitative factors into multiple regression -- 49. Modeling nonlinearities and interactions -- 50. Analysis of variance : one-way ANOVA -- 51. Randomized blocks and two-way ANOVA -- 52. Using moving averages to understand time series -- 53. Winter's method -- 54. Forecasting in the presence of special events -- 55. An introduction to random variables -- 56. The binomial, hypergeometric, and negative binomial random variables -- 57. The poisson and exponential random variable -- 58. The normal random variable -- 59. Weibull and beta distributions : modeling machine life and duration of a project -- 60. Introduction to Monte Carlo simulation -- 61. Calculating an optimal bid -- 62. Simulating stock prices and asset allocation modeling -- 63. Fun and games : simulating gambling and sporting event probabilities -- 64. Using resampling to analyze data -- 65. Pricing stock options -- 66. Determining customer value -- 67. The economic order quantity inventory model -- 68. Inventory modeling with uncertain demand -- 69. Queuing theory : the mathematics of waiting in line -- 70. Estimating a demand curve -- 71. Pricing products by using tie-ins -- 72. Pricing products by using subjectively determined demand -- 73. Nonlinear pricing -- 74. Array formulas and functions
Control code
184871045
Dimensions
unknown
Extent
1 online resource (xix, 601 pages)
Form of item
online
Isbn
9780735642584
Lccn
2007924648
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000014
Reproduction note
Electronic reproduction.
Specific material designation
remote
System control number
(OCoLC)184871045
System details
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...