Business statistics using Excel a complete course in Data Analytics
Cover -- Half Title -- Title -- Copyright -- Dedication -- Contents -- List of Figures -- List of Tables -- Glossary -- 1 Introduction -- 1.1 Real-World Problems -- 1.2 Decision Support System -- Mathematical Models -- Exact Algorithm -- Heuristics -- 1.3 Business Statistics -- 1.4 Types of Research...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Milton
Routledge, Taylor & Francis Group
2024
|
| Schlagworte: | |
| Online-Zugang: | Klappentext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | Cover -- Half Title -- Title -- Copyright -- Dedication -- Contents -- List of Figures -- List of Tables -- Glossary -- 1 Introduction -- 1.1 Real-World Problems -- 1.2 Decision Support System -- Mathematical Models -- Exact Algorithm -- Heuristics -- 1.3 Business Statistics -- 1.4 Types of Research -- 1.4.1 Exploratory Research -- 1.4.2 Conclusive Research -- 1.4.3 Modelling Research -- 1.5 Steps of Research -- 1.5.1 Problem Definition -- 1.5.2 Objectives of the Research -- 1.5.3 Research Design -- 1.5.4 Data Collection -- 1.5.5 Data Analysis -- 1.5.6 Interpretation of Results -- 1.5.7 Validation of Results -- 1.6 Statistical Techniques -- Summary -- Keywords -- Review Questions -- References -- 2 Introduction to Excel -- 2.1 Introduction -- 2.2 Excel -- 2.2.1 Excel Templates -- 2.2.2 Arithmetic Operators in Excel -- 2.2.3 Changing Width of Cells -- 2.2.4 Operations in Excel Using Simple Formulas -- 2.2.5 Formatting of Excel Templates -- 2.2.6 Adding Values in a Range of Cells by Including Cells in Formulas -- 2.2.7 Adding Values in a Range of Cells Using the SUM Function -- 2.2.8 Copying Formulas -- 2.2.9 SUMIF Function -- 2.2.10 SUMIFS Command -- 2.2.11 Absolute References to Cells While Copying Formulas -- 2.2.12 COMBIN Command -- 2.2.13 FACT Command -- 2.2.14 Invoking the Data Analysis Button in Excel -- 2.2.15 MIN Function -- 2.2.16 MINA Function -- 2.2.17 MAX Function -- 2.2.18 MAXA Function -- 2.2.19 MAXIFS Function -- 2.2.20 MINIFS Function -- 2.2.21 ROUND Function -- 2.2.22 INT Function -- 2.2.23 ROUNDDOWN Function -- 2.2.24 ROUNDUP Function -- 2.2.25 SORT Function -- 2.2.26 RANK.EQ Function -- 2.2.27 RANK.AVG Function -- 2.2.28 Hide and Unhide Commands -- 2.2.29 Filter Function -- 2.2.30 PROB Function in Excel 2019 -- Summary -- Keywords -- Review Questions -- References -- 3 Count, Frequency, and Histogram Functions. |
|---|---|
| Beschreibung: | xlvi, 647 Seiten Illustrationen, Diagramme |
| ISBN: | 9781032671710 9781032521916 |