Business data analysis using Excel:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Oxford [u.a.]
Oxford Univ. Press
2007
|
| Edition: | 1. publ. |
| Subjects: | |
| Online Access: | Table of contents only Inhaltsverzeichnis |
| Physical Description: | XIV, 293 S. Ill., graph. Darst. |
| ISBN: | 9780199296286 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV022534575 | ||
| 003 | DE-604 | ||
| 005 | 20071129 | ||
| 007 | t | ||
| 008 | 070730s2007 xxuad|| |||| 00||| eng d | ||
| 010 | |a 2006033890 | ||
| 020 | |a 9780199296286 |9 978-0-19-929628-6 | ||
| 035 | |a (OCoLC)74648936 | ||
| 035 | |a (DE-599)BVBBV022534575 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-355 |a DE-92 | ||
| 050 | 0 | |a HF5691 | |
| 082 | 0 | |a 005.54 | |
| 084 | |a QP 880 |0 (DE-625)141964: |2 rvk | ||
| 100 | 1 | |a Whigham, David |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Business data analysis using Excel |c David Whigham |
| 250 | |a 1. publ. | ||
| 264 | 1 | |a Oxford [u.a.] |b Oxford Univ. Press |c 2007 | |
| 300 | |a XIV, 293 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Business mathematics |x Computer programs | |
| 650 | 0 | 7 | |a Betriebsdaten |0 (DE-588)4145038-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenanalyse |0 (DE-588)4123037-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4151278-9 |a Einführung |2 gnd-content | |
| 689 | 0 | 0 | |a Betriebsdaten |0 (DE-588)4145038-3 |D s |
| 689 | 0 | 1 | |a Datenanalyse |0 (DE-588)4123037-1 |D s |
| 689 | 0 | 2 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |C b |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/toc/ecip073/2006033890.html |3 Table of contents only | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015741102&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015741102 | ||
Record in the Search Index
| _version_ | 1804136645473075200 |
|---|---|
| adam_text | ¦ CONTENTS
GUIDE TO THE ONLINE RESOURCE CENTRE XV
1 Introduction to Excel 1
1.1 Terminology and navigation 1
1.2 Entering data 5
1.3 Selecting an area of the worksheet 12
1.4 Saving, closing and opening files 13
1.5 Copying data 14
1.6 Creating and using named cells 22
1.7 Inserting or deleting rows or columns 23
1.8 Working with multiple sheets 25
1.9 Avoiding errors and mistakes 27
1.10 Exercises 28
1.11 Solutions to the exercises 32
2 Understanding data 39
2.1 What are data? 39
2.2 Quantitative data 40
2.2.1 Discrete data 41
2.2.2 Continuous data 41
2.3 Qualitative data 42
2.3.1 Categorical data 42
2.3.2 Ordinal data 44
2.4 Exercises 45
2.5 Solutions to the exercises 46
3 Data handling 48
3.1 Sorting data 48
3.2 Filtering data 52
3.3 Parsing data 56
3.4 Exercises 58
3.5 Solutions to the exercises 60
4 Charting data 65
4.1 Principles of charting 65
4.2 XY scatter graphs 66
4.3 Column and bar charts 68
4.4 Pie charts 72
4.5 Some practicalities in preparing graphs 73
Xii CONTENTS
4.6 Context sensitive legends and titles 76
4.7 Exercises 78
4.8 Solutions to the exercises 79
5 Elementary modelling (1) 81
5.1 Symbols, expressions and simple models 81
5.2 Creating general algebraic models 83
5.3 Expressions involving logical tests 88
5.4 Linear functions in business 91
5.5 Exercises 93
5.6 Solutions to the exercises 95
6 Elementary modelling (2) 98
6.1 Linear functions involving logical tests 98
6.2 Vertical lookup functions 104
6.3 Combining conditional statements with lookup functions 107
6.4 Exercises 112
6.5 Solutions to the exercises 113
7 Collating and categorizing data 118
7.1 Preliminaries 118
7.2 Frequency distributions 119
7.3 Cumulative frequency distributions 123
7.4 Discrete and continuous data sets 125
7.5 Principles of selecting class intervals 127
7.6 Categorizing data 130
7.7 Exercises 132
7.8 Solutions to the exercises 133
8 Data description—central tendency 138
8.1 Introduction 138
8.2 The arithmetic mean 139
8.3 The median 141
8.4 The mode 141
8.5 Comparison between the mean, the median and the mode 142
8.6 Weighted averages 143
8.7 Exercises 145
8.8 Solutions to the Exercises 146
CONTENTS xiii
9 Data description—dispersion 149
9.1 Introduction 149
9.2 The range 150
9.3 The variance and the standard deviation 150
9.4 The coefficient of variation 153
9.5 The interquartile range 154
9.6 Exercises 157
9.7 Solutions to the exercises 157
10 Data description—further methods 159
10.1 Introduction 159
10.2 Calculating the mean, variance and standard deviation from frequency distributions 160
10.3 Descriptive statistics from the Excel Data Analysis routine 165
10.4 Statistical analysis of selected data subsets 167
10.5 Exercises 171
10.6 Solutions to the exercises 172
11 Data description—association 178
11.1 Introduction 178
11.2 Pearson s correlation coefficient 179
11.3 Spearman s rank correlation coefficient 181
11.4 Cross tabulation and contingency tables 183
11.5 Exercises 191
11.6 Solutions to the exercises 193
12 Regression analysis 196
12.1 Introduction 196
12.2 Simple linear regression 197
12.3 The scatter diagram 200
12.4 Non linear regression 204
12.5 Regression using the Excel Data Analysis routine 206
12.6 Time series analysis 207
12.7 Exercises 212
12.8 Solutions to the exercises 213
13 Financial arithmetic 217
13.1 Introduction 217
13.2 Simple interest 219
13.3 Compound interest 222
13.4 Fractional years 229
XIV CONTENTS
13.5 Variations in the compounding period 231
13.6 Continuous compounding 235
13.7 The equivalent annual rate 237
13.8 Growth rate calculations 239
13.9 Annuities 241
13.10 Sinking funds 246
13.11 Debt repayments 247
13.12 Exercises 249
13.13 Solutions to the exercises 252
14 Investment Appraisal 258
14.1 Present value 258
14.2 Discounting multiple amounts 261
14.3 Variations in the discounting period 264
14.4 Net present value 268
14.5 The internal rate of return 273
14.6 The annual percentage rate 275
14.7 Exercises 278
14.8 Solutions to the exercises 281
INDEX 291
|
| adam_txt |
¦ CONTENTS
GUIDE TO THE ONLINE RESOURCE CENTRE XV
1 Introduction to Excel 1
1.1 Terminology and navigation 1
1.2 Entering data 5
1.3 Selecting an area of the worksheet 12
1.4 Saving, closing and opening files 13
1.5 Copying data 14
1.6 Creating and using named cells 22
1.7 Inserting or deleting rows or columns 23
1.8 Working with multiple sheets 25
1.9 Avoiding errors and mistakes 27
1.10 Exercises 28
1.11 Solutions to the exercises 32
2 Understanding data 39
2.1 What are data? 39
2.2 Quantitative data 40
2.2.1 Discrete data 41
2.2.2 Continuous data 41
2.3 Qualitative data 42
2.3.1 Categorical data 42
2.3.2 Ordinal data 44
2.4 Exercises 45
2.5 Solutions to the exercises 46
3 Data handling 48
3.1 Sorting data 48
3.2 Filtering data 52
3.3 Parsing data 56
3.4 Exercises 58
3.5 Solutions to the exercises 60
4 Charting data 65
4.1 Principles of charting 65
4.2 XY scatter graphs 66
4.3 Column and bar charts 68
4.4 Pie charts 72
4.5 Some practicalities in preparing graphs 73
Xii CONTENTS
4.6 Context sensitive legends and titles 76
4.7 Exercises 78
4.8 Solutions to the exercises 79
5 Elementary modelling (1) 81
5.1 Symbols, expressions and simple models 81
5.2 Creating general algebraic models 83
5.3 Expressions involving logical tests 88
5.4 Linear functions in business 91
5.5 Exercises 93
5.6 Solutions to the exercises 95
6 Elementary modelling (2) 98
6.1 Linear functions involving logical tests 98
6.2 Vertical lookup functions 104
6.3 Combining conditional statements with lookup functions 107
6.4 Exercises 112
6.5 Solutions to the exercises 113
7 Collating and categorizing data 118
7.1 Preliminaries 118
7.2 Frequency distributions 119
7.3 Cumulative frequency distributions 123
7.4 Discrete and continuous data sets 125
7.5 Principles of selecting class intervals 127
7.6 Categorizing data 130
7.7 Exercises 132
7.8 Solutions to the exercises 133
8 Data description—central tendency 138
8.1 Introduction 138
8.2 The arithmetic mean 139
8.3 The median 141
8.4 The mode 141
8.5 Comparison between the mean, the median and the mode 142
8.6 Weighted averages 143
8.7 Exercises 145
8.8 Solutions to the Exercises 146
CONTENTS xiii
9 Data description—dispersion 149
9.1 Introduction 149
9.2 The range 150
9.3 The variance and the standard deviation 150
9.4 The coefficient of variation 153
9.5 The interquartile range 154
9.6 Exercises 157
9.7 Solutions to the exercises 157
10 Data description—further methods 159
10.1 Introduction 159
10.2 Calculating the mean, variance and standard deviation from frequency distributions 160
10.3 Descriptive statistics from the Excel Data Analysis routine 165
10.4 Statistical analysis of selected data subsets 167
10.5 Exercises 171
10.6 Solutions to the exercises 172
11 Data description—association 178
11.1 Introduction 178
11.2 Pearson's correlation coefficient 179
11.3 Spearman's rank correlation coefficient 181
11.4 Cross tabulation and contingency tables 183
11.5 Exercises 191
11.6 Solutions to the exercises 193
12 Regression analysis 196
12.1 Introduction 196
12.2 Simple linear regression 197
12.3 The scatter diagram 200
12.4 Non linear regression 204
12.5 Regression using the Excel Data Analysis routine 206
12.6 Time series analysis 207
12.7 Exercises 212
12.8 Solutions to the exercises 213
13 Financial arithmetic 217
13.1 Introduction 217
13.2 Simple interest 219
13.3 Compound interest 222
13.4 Fractional years 229
XIV CONTENTS
13.5 Variations in the compounding period 231
13.6 Continuous compounding 235
13.7 The equivalent annual rate 237
13.8 Growth rate calculations 239
13.9 Annuities 241
13.10 Sinking funds 246
13.11 Debt repayments 247
13.12 Exercises 249
13.13 Solutions to the exercises 252
14 Investment Appraisal 258
14.1 Present value 258
14.2 Discounting multiple amounts 261
14.3 Variations in the discounting period 264
14.4 Net present value 268
14.5 The internal rate of return 273
14.6 The annual percentage rate 275
14.7 Exercises 278
14.8 Solutions to the exercises 281
INDEX 291 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Whigham, David |
| author_facet | Whigham, David |
| author_role | aut |
| author_sort | Whigham, David |
| author_variant | d w dw |
| building | Verbundindex |
| bvnumber | BV022534575 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5691 |
| callnumber-raw | HF5691 |
| callnumber-search | HF5691 |
| callnumber-sort | HF 45691 |
| callnumber-subject | HF - Commerce |
| classification_rvk | QP 880 |
| ctrlnum | (OCoLC)74648936 (DE-599)BVBBV022534575 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik Wirtschaftswissenschaften |
| discipline_str_mv | Informatik Wirtschaftswissenschaften |
| edition | 1. publ. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01757nam a2200469zc 4500</leader><controlfield tag="001">BV022534575</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20071129 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">070730s2007 xxuad|| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2006033890</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780199296286</subfield><subfield code="9">978-0-19-929628-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)74648936</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV022534575</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-355</subfield><subfield code="a">DE-92</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5691</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 880</subfield><subfield code="0">(DE-625)141964:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Whigham, David</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Business data analysis using Excel</subfield><subfield code="c">David Whigham</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. publ.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Oxford [u.a.]</subfield><subfield code="b">Oxford Univ. Press</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIV, 293 S.</subfield><subfield code="b">Ill., graph. Darst.</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="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business mathematics</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Betriebsdaten</subfield><subfield code="0">(DE-588)4145038-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4151278-9</subfield><subfield code="a">Einführung</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Betriebsdaten</subfield><subfield code="0">(DE-588)4145038-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="C">b</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/ecip073/2006033890.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</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=015741102&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-015741102</subfield></datafield></record></collection> |
| genre | (DE-588)4151278-9 Einführung gnd-content |
| genre_facet | Einführung |
| id | DE-604.BV022534575 |
| illustrated | Illustrated |
| index_date | 2024-07-02T18:07:49Z |
| indexdate | 2024-07-09T20:59:42Z |
| institution | BVB |
| isbn | 9780199296286 |
| language | English |
| lccn | 2006033890 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015741102 |
| oclc_num | 74648936 |
| open_access_boolean | |
| owner | DE-355 DE-BY-UBR DE-92 |
| owner_facet | DE-355 DE-BY-UBR DE-92 |
| physical | XIV, 293 S. Ill., graph. Darst. |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Oxford Univ. Press |
| record_format | marc |
| spelling | Whigham, David Verfasser aut Business data analysis using Excel David Whigham 1. publ. Oxford [u.a.] Oxford Univ. Press 2007 XIV, 293 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Microsoft Excel (Computer file) Business mathematics Computer programs Betriebsdaten (DE-588)4145038-3 gnd rswk-swf Datenanalyse (DE-588)4123037-1 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf (DE-588)4151278-9 Einführung gnd-content Betriebsdaten (DE-588)4145038-3 s Datenanalyse (DE-588)4123037-1 s EXCEL (DE-588)4138932-3 s b DE-604 http://www.loc.gov/catdir/toc/ecip073/2006033890.html Table of contents only HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015741102&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Whigham, David Business data analysis using Excel Microsoft Excel (Computer file) Business mathematics Computer programs Betriebsdaten (DE-588)4145038-3 gnd Datenanalyse (DE-588)4123037-1 gnd EXCEL (DE-588)4138932-3 gnd |
| subject_GND | (DE-588)4145038-3 (DE-588)4123037-1 (DE-588)4138932-3 (DE-588)4151278-9 |
| title | Business data analysis using Excel |
| title_auth | Business data analysis using Excel |
| title_exact_search | Business data analysis using Excel |
| title_exact_search_txtP | Business data analysis using Excel |
| title_full | Business data analysis using Excel David Whigham |
| title_fullStr | Business data analysis using Excel David Whigham |
| title_full_unstemmed | Business data analysis using Excel David Whigham |
| title_short | Business data analysis using Excel |
| title_sort | business data analysis using excel |
| topic | Microsoft Excel (Computer file) Business mathematics Computer programs Betriebsdaten (DE-588)4145038-3 gnd Datenanalyse (DE-588)4123037-1 gnd EXCEL (DE-588)4138932-3 gnd |
| topic_facet | Microsoft Excel (Computer file) Business mathematics Computer programs Betriebsdaten Datenanalyse EXCEL Einführung |
| url | http://www.loc.gov/catdir/toc/ecip073/2006033890.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015741102&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT whighamdavid businessdataanalysisusingexcel |