Analyzing business data with Excel:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing u.a.
O'Reilly
2006
|
| Ausgabe: | 1. ed. |
| Schriftenreihe: | Forecasting, statistics, and data management
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XI, 248 S. Ill., graph. Darst. |
| ISBN: | 0596100736 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV021482108 | ||
| 003 | DE-604 | ||
| 005 | 20060508 | ||
| 007 | t | ||
| 008 | 060221s2006 ad|| |||| 00||| eng d | ||
| 020 | |a 0596100736 |9 0-596-10073-6 | ||
| 035 | |a (OCoLC)475195944 | ||
| 035 | |a (DE-599)BVBBV021482108 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-824 |a DE-2070s | ||
| 050 | 0 | |a HF5548.4.M523 | |
| 082 | 0 | |a 519.50285536 |2 22 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Knight, Gerald |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Analyzing business data with Excel |c Gerald Knight |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing u.a. |b O'Reilly |c 2006 | |
| 300 | |a XI, 248 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Forecasting, statistics, and data management | |
| 650 | 4 | |a Commercial statistics |x Computer programs | |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 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 |
| 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 | |5 DE-604 | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch Darmstadt |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014664492&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-014664492 | ||
Datensatz im Suchindex
| _version_ | 1804135163714600960 |
|---|---|
| adam_text | ANALYZING BUSINESS DATA WITH EXCEL GERALD KNIGHT O REILLY 8 BEIJING *
CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI * TOKYO TABLE
OF CONTENTS PREFACE VII 1. EXCEL AND STATISTICS 1 ARRAY FORMULAS 1
ADDRESSING CELLS INDIRECTLY 3 STATISTICAL FUNCTIONS 6 2. PIVOT TABLES
AND PROBLEM SOLVING 22 PIVOT TABLE BASICS 23 CHANGING THE DATA 35 PIVOT
TABLE OPTIONS 39 3. WORKLOAD FORECASTING 42 THE PROCEDURE 43 BUILDING AN
APPLICATION 50 4. MODELING 69 REGRESSION 69 DEFINING THE PROBLEM 73
REFINING METRICS 76 ANALYSIS 77 BUILDING THE MODEL 84 ANALYZING THE
RESULTS 86 TESTING NON-LINEAR RELATIONSHIPS 90 5. MEASURING QUALITY 93
STATISTICAL PROCESS CONTROL 94 RUNNING THE APPLICATION 96 APPLICATION
DESIGN 97 CUSTOMIZING THE APPLICATION 107 6. MONITORING COMPLEX SYSTEMS
ILL THE APPLICATION 112 THE DATA 114 SETTINGS 115 WORKAREA 118 MACROS
129 7. QUEUING 133 THE DATA 134 THE APPLICATION 135 THE LOGIC 138 8.
CUSTOM QUEUING PRESENTATION 155 THE APPLICATION 155 THE DATA 160 THE
LOGIC 160 VBA 163 EXTENDING THE APPLICATION 168 9. OPTIMIZING 169 GOAL
SEEK 169 THE SOLVER 179 10. IMPORTING DATA 195 TEXT FILES 195 DATABASES
201 XML 208 11. THE TROUBLE WITH DATA 214 NUMBERS 214 DATES 218 REPORTS
219 EQUIVALENCE 224 12. EFFECTIVE DISPLAY TECHNIQUES 227 RESPECT THE
INFORMATION AND THE AUDIENCE 227 LARGE WORKSHEETS 228 IV | TABLE OF
CONTENTS CHARTS PICTURES AND OTHER OBJECTS COMPLEXITY REPEATED ELEMENTS
INFORMATION DENSITY EMPHASIS AND FOCUS INDEX 228 231 233 234 235 236 241
TABLE OF CONTENTS
|
| adam_txt |
ANALYZING BUSINESS DATA WITH EXCEL GERALD KNIGHT O'REILLY 8 BEIJING *
CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI * TOKYO TABLE
OF CONTENTS PREFACE VII 1. EXCEL AND STATISTICS 1 ARRAY FORMULAS 1
ADDRESSING CELLS INDIRECTLY 3 STATISTICAL FUNCTIONS 6 2. PIVOT TABLES
AND PROBLEM SOLVING 22 PIVOT TABLE BASICS 23 CHANGING THE DATA 35 PIVOT
TABLE OPTIONS 39 3. WORKLOAD FORECASTING 42 THE PROCEDURE 43 BUILDING AN
APPLICATION 50 4. MODELING 69 REGRESSION 69 DEFINING THE PROBLEM 73
REFINING METRICS 76 ANALYSIS 77 BUILDING THE MODEL 84 ANALYZING THE
RESULTS 86 TESTING NON-LINEAR RELATIONSHIPS 90 5. MEASURING QUALITY 93
STATISTICAL PROCESS CONTROL 94 RUNNING THE APPLICATION 96 APPLICATION
DESIGN 97 CUSTOMIZING THE APPLICATION 107 6. MONITORING COMPLEX SYSTEMS
ILL THE APPLICATION 112 THE DATA 114 SETTINGS 115 WORKAREA 118 MACROS
129 7. QUEUING 133 THE DATA 134 THE APPLICATION 135 THE LOGIC 138 8.
CUSTOM QUEUING PRESENTATION 155 THE APPLICATION 155 THE DATA 160 THE
LOGIC 160 VBA 163 EXTENDING THE APPLICATION 168 9. OPTIMIZING 169 GOAL
SEEK 169 THE SOLVER 179 10. IMPORTING DATA 195 TEXT FILES 195 DATABASES
201 XML 208 11. THE TROUBLE WITH DATA 214 NUMBERS 214 DATES 218 REPORTS
219 EQUIVALENCE 224 12. EFFECTIVE DISPLAY TECHNIQUES 227 RESPECT THE
INFORMATION AND THE AUDIENCE 227 LARGE WORKSHEETS 228 IV | TABLE OF
CONTENTS CHARTS PICTURES AND OTHER OBJECTS COMPLEXITY REPEATED ELEMENTS
INFORMATION DENSITY EMPHASIS AND FOCUS INDEX 228 231 233 234 235 236 241
TABLE OF CONTENTS |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Knight, Gerald |
| author_facet | Knight, Gerald |
| author_role | aut |
| author_sort | Knight, Gerald |
| author_variant | g k gk |
| building | Verbundindex |
| bvnumber | BV021482108 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.4.M523 |
| callnumber-search | HF5548.4.M523 |
| callnumber-sort | HF 45548.4 M523 |
| callnumber-subject | HF - Commerce |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)475195944 (DE-599)BVBBV021482108 |
| dewey-full | 519.50285536 |
| dewey-hundreds | 500 - Natural sciences and mathematics |
| dewey-ones | 519 - Probabilities and applied mathematics |
| dewey-raw | 519.50285536 |
| dewey-search | 519.50285536 |
| dewey-sort | 3519.50285536 |
| dewey-tens | 510 - Mathematics |
| discipline | Informatik Mathematik |
| discipline_str_mv | Informatik Mathematik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01576nam a2200421 c 4500</leader><controlfield tag="001">BV021482108</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20060508 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">060221s2006 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596100736</subfield><subfield code="9">0-596-10073-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)475195944</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV021482108</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-824</subfield><subfield code="a">DE-2070s</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">519.50285536</subfield><subfield code="2">22</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">Knight, Gerald</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Analyzing business data with Excel</subfield><subfield code="c">Gerald Knight</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing u.a.</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2006</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XI, 248 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="490" ind1="0" ind2=" "><subfield code="a">Forecasting, statistics, and data management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Commercial statistics</subfield><subfield code="x">Computer programs</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="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="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="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch Darmstadt</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=014664492&sequence=000001&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-014664492</subfield></datafield></record></collection> |
| id | DE-604.BV021482108 |
| illustrated | Illustrated |
| index_date | 2024-07-02T14:04:54Z |
| indexdate | 2024-07-09T20:36:08Z |
| institution | BVB |
| isbn | 0596100736 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-014664492 |
| oclc_num | 475195944 |
| open_access_boolean | |
| owner | DE-824 DE-2070s |
| owner_facet | DE-824 DE-2070s |
| physical | XI, 248 S. Ill., graph. Darst. |
| publishDate | 2006 |
| publishDateSearch | 2006 |
| publishDateSort | 2006 |
| publisher | O'Reilly |
| record_format | marc |
| series2 | Forecasting, statistics, and data management |
| spelling | Knight, Gerald Verfasser aut Analyzing business data with Excel Gerald Knight 1. ed. Beijing u.a. O'Reilly 2006 XI, 248 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Forecasting, statistics, and data management Commercial statistics Computer programs EXCEL (DE-588)4138932-3 gnd rswk-swf Betriebsdaten (DE-588)4145038-3 gnd rswk-swf Datenanalyse (DE-588)4123037-1 gnd rswk-swf Betriebsdaten (DE-588)4145038-3 s Datenanalyse (DE-588)4123037-1 s EXCEL (DE-588)4138932-3 s DE-604 HEBIS Datenaustausch Darmstadt application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014664492&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Knight, Gerald Analyzing business data with Excel Commercial statistics Computer programs EXCEL (DE-588)4138932-3 gnd Betriebsdaten (DE-588)4145038-3 gnd Datenanalyse (DE-588)4123037-1 gnd |
| subject_GND | (DE-588)4138932-3 (DE-588)4145038-3 (DE-588)4123037-1 |
| title | Analyzing business data with Excel |
| title_auth | Analyzing business data with Excel |
| title_exact_search | Analyzing business data with Excel |
| title_exact_search_txtP | Analyzing business data with Excel |
| title_full | Analyzing business data with Excel Gerald Knight |
| title_fullStr | Analyzing business data with Excel Gerald Knight |
| title_full_unstemmed | Analyzing business data with Excel Gerald Knight |
| title_short | Analyzing business data with Excel |
| title_sort | analyzing business data with excel |
| topic | Commercial statistics Computer programs EXCEL (DE-588)4138932-3 gnd Betriebsdaten (DE-588)4145038-3 gnd Datenanalyse (DE-588)4123037-1 gnd |
| topic_facet | Commercial statistics Computer programs EXCEL Betriebsdaten Datenanalyse |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014664492&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT knightgerald analyzingbusinessdatawithexcel |