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 |
| 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 |
Internformat
MARC
| LEADER | 00000nam a22000001c 4500 | ||
|---|---|---|---|
| 001 | BV049533223 | ||
| 003 | DE-604 | ||
| 005 | 20240307 | ||
| 007 | t | ||
| 008 | 240205s2024 a||| |||| 00||| eng d | ||
| 020 | |a 9781032671710 |c pbk |9 978-1-032-67171-0 | ||
| 020 | |a 9781032521916 |c hbk |9 978-1-032-52191-6 | ||
| 035 | |a (OCoLC)1424561902 | ||
| 035 | |a (DE-599)BVBBV049533223 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-384 | ||
| 082 | 0 | |a 005.54 | |
| 082 | 0 | |a 005.369 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Panneerselvam, R. |d ca. 20./21. Jh. |e Verfasser |0 (DE-588)1322591105 |4 aut | |
| 245 | 1 | 0 | |a Business statistics using Excel |b a complete course in Data Analytics |c R. Panneerselvam |
| 264 | 1 | |a Milton |b Routledge, Taylor & Francis Group |c 2024 | |
| 300 | |a xlvi, 647 Seiten |b Illustrationen, Diagramme | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 520 | 3 | |a 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. | |
| 653 | 0 | |a Microsoft Excel (Computer file) | |
| 653 | 0 | |a Business-Computer programs | |
| 653 | 0 | |a Commercial statistics-Computer programs | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-032-67170-3 |
| 856 | 4 | 2 | |m Digitalisierung UB Augsburg - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034878813&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Klappentext |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-034878813 | ||
Datensatz im Suchindex
| _version_ | 1804186364681388032 |
|---|---|
| adam_txt |
This book gives readers a hands-on understanding of Excel-assisted statistical techniques to take effective business decisions. It showcases applications of the tools and techniques of statistics for analysing business data from the domain of business statistics. The volume provides an exhaustive introduction to the application of statistics in solving business problems and implementing data analytics for effective decision making in all kinds of business situations around the world. With an emphasis on simplicity in presentation of concepts of statistical methods and associated Excel functions, the volume explores the implementation of Excel functions through well-defined sequences of steps. It covers an array of key topics which include • • • • • Discussions on real-world problems, decision support systems, scope of business statistics, types, and steps of research; Introduction to Excel and its mathematical and preliminary statistical functions; usage of different types of average functions; mean, median, and mode functions; measures of variation; measures of skewness of Excel; In-depth discussions on probability distributions, sampling distributions, testing of hypothesis, chi-square test, non-paramefric tests of Excel; Extensive coverage on correlation and covariance, forecasting, analysis of variance, charts in Excel; and Analysis of the concept of linear programming, problem formulations, and techniques of linear programming, followed by the application in Excel. Comprehensive in scope and simple in approach, this book will be key for students and researchers of
business studies, business administration, economics, finance, commerce, data analytics/science, and computer science. This will also serve as useful guidebook for business executives and working professionals across the globe. |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Panneerselvam, R. ca. 20./21. Jh |
| author_GND | (DE-588)1322591105 |
| author_facet | Panneerselvam, R. ca. 20./21. Jh |
| author_role | aut |
| author_sort | Panneerselvam, R. ca. 20./21. Jh |
| author_variant | r p rp |
| building | Verbundindex |
| bvnumber | BV049533223 |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)1424561902 (DE-599)BVBBV049533223 |
| dewey-full | 005.54 005.369 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 005.369 |
| dewey-search | 005.54 005.369 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03341nam a22003731c 4500</leader><controlfield tag="001">BV049533223</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20240307 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">240205s2024 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781032671710</subfield><subfield code="c">pbk</subfield><subfield code="9">978-1-032-67171-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781032521916</subfield><subfield code="c">hbk</subfield><subfield code="9">978-1-032-52191-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1424561902</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049533223</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-384</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.369</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Panneerselvam, R.</subfield><subfield code="d">ca. 20./21. Jh.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1322591105</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Business statistics using Excel</subfield><subfield code="b">a complete course in Data Analytics</subfield><subfield code="c">R. Panneerselvam</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Milton</subfield><subfield code="b">Routledge, Taylor & Francis Group</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xlvi, 647 Seiten</subfield><subfield code="b">Illustrationen, Diagramme</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Business-Computer programs</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Commercial statistics-Computer programs</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-032-67170-3</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Augsburg - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034878813&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Klappentext</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-034878813</subfield></datafield></record></collection> |
| id | DE-604.BV049533223 |
| illustrated | Illustrated |
| index_date | 2024-07-03T23:27:16Z |
| indexdate | 2024-07-10T10:09:57Z |
| institution | BVB |
| isbn | 9781032671710 9781032521916 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-034878813 |
| oclc_num | 1424561902 |
| open_access_boolean | |
| owner | DE-384 |
| owner_facet | DE-384 |
| physical | xlvi, 647 Seiten Illustrationen, Diagramme |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Routledge, Taylor & Francis Group |
| record_format | marc |
| spelling | Panneerselvam, R. ca. 20./21. Jh. Verfasser (DE-588)1322591105 aut Business statistics using Excel a complete course in Data Analytics R. Panneerselvam Milton Routledge, Taylor & Francis Group 2024 xlvi, 647 Seiten Illustrationen, Diagramme txt rdacontent n rdamedia nc rdacarrier 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. Microsoft Excel (Computer file) Business-Computer programs Commercial statistics-Computer programs Erscheint auch als Online-Ausgabe 978-1-032-67170-3 Digitalisierung UB Augsburg - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034878813&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Klappentext |
| spellingShingle | Panneerselvam, R. ca. 20./21. Jh Business statistics using Excel a complete course in Data Analytics |
| title | Business statistics using Excel a complete course in Data Analytics |
| title_auth | Business statistics using Excel a complete course in Data Analytics |
| title_exact_search | Business statistics using Excel a complete course in Data Analytics |
| title_exact_search_txtP | Business statistics using Excel a complete course in Data Analytics |
| title_full | Business statistics using Excel a complete course in Data Analytics R. Panneerselvam |
| title_fullStr | Business statistics using Excel a complete course in Data Analytics R. Panneerselvam |
| title_full_unstemmed | Business statistics using Excel a complete course in Data Analytics R. Panneerselvam |
| title_short | Business statistics using Excel |
| title_sort | business statistics using excel a complete course in data analytics |
| title_sub | a complete course in Data Analytics |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034878813&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT panneerselvamr businessstatisticsusingexcelacompletecourseindataanalytics |