Learning Business Statistics with Microsoft Excel 2000
Learning Business Statistics with Microsoft Excel 2000

Author: John L. Neufeld

Publisher:

Published: 2001

Total Pages: 494

ISBN-13:

DOWNLOAD EBOOK

Business statistics students at both the undergraduate and MBA level who are not experts in the use of Excel. This text is designed to reflect the important changes in the teaching of statistics brought about by the usage of computers. It takes advantage of the ability of computers to help students understand statistical methods. It uses a straightforward, step-by-step approach, and uses the computer both as a tool for solving statistical problems and as pedagogical device to help students understand difficult concepts. *Excel usage has been simplified: Less emphasis on formatting. More emphasis on helping students get the 'big picture'. *Excel is used more as a scratch pad: In the revision the approach has moved from creating worksheets which automatically solve problems to using Excel as a scratch pad for each problem that arises. *All screen captures updated to Excel 2000 and all the material has been tested on Excel 2000. *Step-by-step instructions: Detailed instructions are given as each new topic is introduced. As students become more familiar with the topics less coaching is provided. *Computer demonstrations reinforce student understanding: Students are directed to use Exce

Estadística descriptiva con Microsoft Excel 2007
Estadística descriptiva con Microsoft Excel 2007

Author: Ursicino Carrascal Arranz

Publisher: Editorial Ra-Ma

Published: 2007

Total Pages: 264

ISBN-13: 9788478978038

DOWNLOAD EBOOK

El libro que tiene en sus manos constituye un manual completo de Estadística Descriptiva correspondiente a la materia que con el mismo titulo se imparte en las Licenciaturas de Economía y Administración de empresas de las universidades españolas, si bien puede ser utilizado por cualquier otro estudioso o profesional de muchas otras ramas con necesidad de analizar datos. De hecho y aunque en ocasiones aparecen en el texto otros ejemplos con carácter económico, también aparecen de otros temas. La ventaja de este manual es que se desarrolla a la vez con el programa Excel 2007, programa que incorpora cambios de forma y de fondo sobre las versiones anteriores del mismo. Sin embargo no se dedica a explicar todos los apartados de Excel, sino que se van tratando los distintos temas estadísticos y se van viendo con detalle aquellas funciones de Excel que se van necesitando en cada momento. De esta forma, cuando alguien esté interesado en hacer un determinado análisis estadístico podrá encontrar en este manual una explicación de lo que quiere hacer y el modo práctico de llevarlo a cavo con Excel 2007, ilustrado profusamente con ejemplos que se van realizando a lo largo de toda la explicación, así como un análisis de los resultados obtenidos. Todos los temas incluyen además ejercicios resueltos y ejercicios propuestos con los que el lector puede practicar por su cuenta lo explicado.

Microsoft Excel 2019 Data Analysis and Business Modeling
Microsoft Excel 2019 Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Microsoft Press

Published: 2019-03-28

Total Pages: 1490

ISBN-13: 1509306080

DOWNLOAD EBOOK

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. Solve real business problems with Excel—and build your competitive advantage: Quickly transition from Excel basics to sophisticated analytics Use PowerQuery or Get & Transform to connect, combine, and refine data sources Leverage Office 365’s new Geography and Stock data types and six new functions Illuminate insights from geographic and temporal data with 3D Maps Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts Use Excel trend curves, multiple regression, and exponential smoothing Delve into key financial, statistical, and time functions Master all of Excel’s great charts Quickly create forecasts from historical time-based data Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams Run Monte Carlo simulations on stock prices and bidding models Learn about basic probability and Bayes’ Theorem Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook Automate repetitive analytics tasks by using macros

Estadística descriptiva a través de Excel
Estadística descriptiva a través de Excel

Author: Felicidad Marqués

Publisher: RC Libros

Published: 2009

Total Pages: 49

ISBN-13: 8493700843

DOWNLOAD EBOOK

En el libro se explica el entorno de cálculo de Excel y luego temas como las variables estadisticas, las distribuciones de frecuencias, los gráficos, medidas de posición, dispersión y forma, distribuciones bidimensionales y la correción y regresion simple, variables cualitativas, tablas de contingencia y distribuciones multidimensionales y regresion múltiple.

Estadística descriptiva para economía y administración de empresas
Estadística descriptiva para economía y administración de empresas

Author: Fuensanta Arnaldos García

Publisher:

Published: 2003-01

Total Pages: 386

ISBN-13: 9788497321730

DOWNLOAD EBOOK

Esta obra esta indicada para todos aquellos alumnos que cursan esta materia en cualquier titulacion y, especialmente, en estudios de Economia, Administracion y Direccion de Empresas, Relaciones Laborales, Sociologia, Gestion y Administracion Publica, Investigacion y Tecnicas de Mercado, etc.

Microsoft Excel 2019
Microsoft Excel 2019

Author: WANYNE L. WINSTON

Publisher:

Published: 2022-04

Total Pages: 0

ISBN-13: 9789389347180

DOWNLOAD EBOOK

Contents: Introduction. 1. Basic worksheet modeling. 2. Range names. 3. Lookup functions. 4. The INDEX function. 5. The MATCH function. 6. Text functions and Flash Fill. 7. Dates and date functions. 8. NPV and XNPV functions. 9. IRR, XIRR, and MIRR functions. 10. More Excel financial functions. 11. Circular references. 12. IF, IFERROR, IFS, CHOOSE, and SWITCH functions. 13. Time and time functions. 14. The Paste Special command. 15. Three-dimensional formulas and hyperlinks. 16. The auditing tool and the Inquire add-in. 17. Sensitivity analysis with data tables. 18. The Goal Seek command. 19. Using the Scenario Manager for sensitivity analysis. 20. The COUNTIF, COUNTIFS, COUNT, COUNTA and COUNTBLANK functions. 21. The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS and MINIFS functions. 22. The OFFSET function. 23. The INDIRECT function. 24. Conditional formatting. 25. Sorting in Excel. 26. Excel tables and table slicers. 27. Spin buttons, scrollbars, option buttons, check boxes, combo boxes and group list boxes. 28. The analytics revolution. 29. An introduction to optimization with Excel Solver. 30. Using Solver to determine the optimal product mix. 31. Using Solver to schedule your workforce. 32. Using Solver to solve transportation or distribution problems. 33. Using Solver for capital budgeting. 34. Using Solver for financial planning. 35. Using Solver to rate sports teams. 36. Warehouse location and the GRG Multistart and Evolutionary Solver engines. 37. Penalties and the Evolutionary Solver. 38. The traveling salesperson problem. 39. Importing data from a text file or document. 40. Get & Transform. 41. Geography and Stock data types. 42. Validating data. 43. Summarizing data by using histograms and Pareto charts. 44. Summarizing data by using descriptive statistics. 45. Using pivot tables and slicers to describe data. 46. The Data Model. 47. Power Pivot. 48. Filled and 3D Power Maps. 49. Sparklines. 50. Summarizing data with database statistical functions.