R through Excel: a spreadsheet interface for statistics, data analysis, and graphics
Gespeichert in:
Beteiligte Personen: | , |
---|---|
Format: | Buch |
Sprache: | Englisch |
Veröffentlicht: |
New York, NY
Springer
2009
|
Schriftenreihe: | Use R!
|
Schlagwörter: | |
Links: | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018602006&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
Umfang: | XXV, 342 S. zahlr. Ill., graph. Darst. |
ISBN: | 9781441900517 |
Internformat
MARC
LEADER | 00000nam a2200000 c 4500 | ||
---|---|---|---|
001 | BV035741800 | ||
003 | DE-604 | ||
005 | 20170614 | ||
007 | t| | ||
008 | 090925s2009 xx ad|| |||| 00||| eng d | ||
015 | |a GBA963050 |2 dnb | ||
020 | |a 9781441900517 |c pbk |9 978-1-4419-0051-7 | ||
035 | |a (OCoLC)885148963 | ||
035 | |a (DE-599)HBZHT016036026 | ||
040 | |a DE-604 |b ger |e aacr | ||
041 | 0 | |a eng | |
049 | |a DE-945 |a DE-859 |a DE-M49 |a DE-11 |a DE-824 |a DE-188 |a DE-706 | ||
050 | 0 | |a QA276.4 | |
082 | 0 | |a 519.5 | |
084 | |a SK 830 |0 (DE-625)143259: |2 rvk | ||
084 | |a SK 850 |0 (DE-625)143263: |2 rvk | ||
084 | |a ST 250 |0 (DE-625)143626: |2 rvk | ||
084 | |a ST 600 |0 (DE-625)143681: |2 rvk | ||
084 | |a ST 601 |0 (DE-625)143682: |2 rvk | ||
084 | |a DAT 304f |2 stub | ||
084 | |a DAT 307f |2 stub | ||
084 | |a MAT 620f |2 stub | ||
100 | 1 | |a Heiberger, Richard M. |d 1945- |e Verfasser |0 (DE-588)141419997 |4 aut | |
245 | 1 | 0 | |a R through Excel |b a spreadsheet interface for statistics, data analysis, and graphics |c Richard M. Heiberger ; Erich Neuwirth |
264 | 1 | |a New York, NY |b Springer |c 2009 | |
300 | |a XXV, 342 S. |b zahlr. Ill., graph. Darst. | ||
336 | |b txt |2 rdacontent | ||
337 | |b n |2 rdamedia | ||
338 | |b nc |2 rdacarrier | ||
490 | 0 | |a Use R! | |
630 | 0 | 4 | |a Microsoft Excel |x Computer file |
650 | 4 | |a Datenverarbeitung | |
650 | 4 | |a Mathematical statistics |x Data processing | |
650 | 4 | |a Graphical modeling (Statistics) | |
650 | 4 | |a R (Computer program language) | |
650 | 0 | 7 | |a R |g Programm |0 (DE-588)4705956-4 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
689 | 0 | 0 | |a R |g Programm |0 (DE-588)4705956-4 |D s |
689 | 0 | 1 | |a EXCEL |0 (DE-588)4138932-3 |D s |
689 | 0 | |5 DE-604 | |
700 | 1 | |a Neuwirth, Erich |d 1948- |e Verfasser |0 (DE-588)111104416 |4 aut | |
776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-4419-0052-4 |
856 | 4 | 2 | |m Digitalisierung UB Bamberg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018602006&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-018602006 |
Datensatz im Suchindex
DE-BY-TUM_call_number | 1002 DAT 307f 2010 A 2491 |
---|---|
DE-BY-TUM_katkey | 1723499 |
DE-BY-TUM_location | 10 |
DE-BY-TUM_media_number | 040050828423 |
_version_ | 1821933839228862464 |
adam_text | Contents
Preface
............................................................
vii
Notes
to Readers
................................................... xiii
1
Getting Started
................................................ 1
1.1
Starting RExcel with the RExcel Icon
.......................... 1
1.2
Starting RExcel from a Running Excel Window
................. 3
1.2.1
Starting RExcel from a Running Excel
2007
Window
...... 3
1.2.2
Starting RExcel from a Running Excel
2003
Window
...... 5
1.3
Starting
R
Commander Without Excel
......................... 7
1.4
Window Arrangement
....................................... 10
1.5
Graphics History
........................................... 10
1.6
Quitting RExcel
............................................ 11
2
Using
МЕжсеї
and
R
Commander
................................ 13
2.1
Appearance
............................................... 13
2.2
The
Dataset
and Model Menus
............................... 22
2.3
R
Console
................................................. 32
2.4
R
Commander Window
..................................... 34
2.5
R
Help Files
............................................... 35
2.6
Messages from R, Rcmdr, or Excel
............................ 35
3
Getting Data into
R
............................................ 37
3.1
Example
Datasets
.......................................... 37
3.2
Named Columns of Data
.................................... 40
3.3
Unnamed Columns of Data
.................................. 46
3.4
Numeric Columns and Factor Columns
......................... 49
3.5
Multiple Numeric Columns» One per Factor Level
............... 52
3.6
Transferring Data from
R
to Excel
............................ 57
3.7
Other
tapat
Formats, Including
ASCH Text Fites................ 60
Contents
Normal
and ŕ
Distributions......................................
61
4.1
Accessing
R
Functions with the Rcmdr Menus
.................. 61
4.2
Accessing
R
Functions from Within Excel Cells
................. 66
4.3
Graphical Displays of the Standard Normal Distribution
.......... 69
4.4
Significance Level, Rejection Region, and Type I Error
........... 71
4.5
Type II Error and Power
..................................... 74
4.6
Displaying Graphs
.......................................... 79
Normal and
t
Workbook
........................................ 81
5.1
Standard Normal and
t
Distributions
........................... 81
5.2
Relation Between or and
z
................................... 86
5.3
Normal Tests, Type II Error, and Power
........................ 87
5.4
Significance, Rejection Region, and Power
—
Continued
.......... 91
5.5
How Does the Normal and
t
Workbook Work?
................. 95
5.5.1
InputFields
......................................... 95
5.5.2
Display Parameters
................................... 96
5.5.3
Numerical Output
.................................... 96
5.6
Confidence Intervals
........................................ 97
5.6.1
Algebra
............................................ 97
5.6.2
Workbook
.......................................... 98
5.7
Scaling to Keep Constant Area
............................... 99
5.8
Normal Approximation to the Binomial
........................ 102
i-Tests
........................................................105
6.1
Data
—
Canned Vegetables
...................................106
6.1.1
Plot the Data
........................................109
6.1.1.1
Histogram
..................................109
6.1.1.2
Dotplot
.....................................
Ill
6.1.1.3
Boxplot
....................................113
6.1.2
Calculate the
ŕ-Test
...................................115
6.1.3
Plot the r-Test
.......................................117
6.2
Data—Heights
.............................................121
6.2.1
Plots
...............................................124
6.2.1.1
Scatterplots
.................................124
6.2.1.2
Dotplots
....................................126
6.2.1.3
Boxplots
...................................127
6.2.1.4
Bar Graph for Frequencies
....................128
6.2.2
Summary Statistics
...................................129
6.2.3
Sttbsetting
the Data for Males
..........................130
6.2.4
One-Sample
ŕ-Test
for Males
..........................136
6.2.5
Two-Sample
ř-Test Compariag
Males and Females
........139
6.3
Matched Pairs f-Test
......,.........___....................144
6.4
Confidence Interval Plot
.....................................152
6.4.1
Confidence Intervals with the normal and
t
Worksheet
___152
Contents xxiii
6.4.2
Confidence
Intervals with the
Plot [normal [t] hypotheses or Confidence Intervals.
..
Menus
.............................................154
6.5
Hypothesis Plot and Confidence Interval Plot from Summary
Information
...............................................155
6.5.1
Hypothesis Plots with the Plot hypotheses and
Confidence Intervals Menu and Workbook
.............155
6.5.2
Hypothesis Plot
......................................156
6.5.3
Confidence Interval Plot
..............................158
6.6
Alternate Styles for the Calculation of Confidence Intervals
.......160
6.6.1
Recommended Style
.................................160
6.6.2
Not Recommended Style
..............................163
7
Ове
-Way
ANOVA
..............................................165
7.1
Data
......................................................165
7.2
Plots
.....................................................168
7.2.1
Dotplot
.............................................168
7.2.2
Boxplot
............................................170
7.3
ANOVA Specification
.......................................172
7.4
ANOVA Table and F-Test
...................................174
7.5
Table of Means
............................................178
7.6
Multiple Comparisons
......................................179
7.7
Mean-Mean Multiple Comparisons Plot
.......................182
7.8
Linear Contrasts
...........................................187
8
Simple Linear Regression
...........................___........193
8.1
Least-Squares Regression with RExcel/Rcmdr
..................194
8.2
Scatterplot
................................................197
8.3
Linear Regression Analysis
..................................200
8.4
Residuals Analysis
.........................................204
8.5
Confidence Bands and Prediction Bands
.......................209
9
What Is Least Squares?
.........................................213
9.1
Minimizing the Sum of Squares
..............................213
9.2
Hat Diagonals and Leverage
___.............................223
9.3
Residuals and Leverage
.....................................229
9.4
Reset the Workbook to the Values in the Text
...................233
W
Multiple Regression—Two
Ж
-Variabies
...........................
235
10.1
The Multiple Regression Model
............,.................235
10.2
Example
....................-----.......................... 236
í
0.3
Specify and Fit Several Linear Models
.........................243
10.4
Graphical Comparison of Models
............................. 247
10.4.1
Plot Residuals ~ Fitted
..............................250
10.4.2
Rescale Plots for
lase
of Comparison
................... 252
10.4.3
Lattice Plots with Coordinated Scales
................... 254
xxiv Contents
10.4.4
Stacking with the Right-Click Menu
....................255
10.4.5
Menu and Dialog Box for Lattice Plot
...................261
10.5 ANÖVA
Table
.............................................263
10.6
Coafidence Intervals and Prediction Intervals
................... 265
11
Polynomial Regression
..........................................269
11.1
Regression on a Quadratic Function of X
.......................269
11.2
Linear Fit
.................................................274
11.3
Quadratic Fit
..............................................278
11.4
Plot of Squared Residuals
....................................283
12
Multiple Regression
—
Three or More X-Variables
.................285
12.1
Shoe Sizes of Austrian Students
..............................286
12.2
Plots
.....................................................293
12.3
Regression Analysis
........................................300
12.4
Basic Diagnostic Plots
......................................304
12.5
Confidence Intervals
........................................305
13
Contingency Tables and the Chi-Sqaare Test
......................309
13.1
Gender and Smoking
........................................310
13.1.1
Two-Way Table Chi-Square Test
.......................310
13.1.2
Two-Sample Proportions Test
..........................312
13.2
German and Math Grades
....................................318
A Installation of RExcel
...........................................323
A.I Basic Installation Procedures
.................................323
A.2 Supported Excel Versions
....................................324
A.3 Download and Installation of
R
and RExcel for MS Windows
.....324
A.3.1 Preparation
.........................................325
A.3.2 An Ancient Previous Version of RExcel Must
Be Uninstalled
......................................325
A.3.3 Installation
..........................................326
A.4 Installing RExcel for MS Windows When
R
Is Already Installed
... 327
A.5 Upgrade an Existing
R
Installation
............................328
A.6
R
and Rcmdr Without Excel
—
Windows, Macintosh, Linux
.......329
A.6.
1
Install the Remdr, Hit and RcmdrPtogin-HH packages
___329
A.6.2 Use the
R
Commander Directly
........................329
Ä.6.3
Datalnput
..........................................329
AJ R
and Open Office.
.........................................330
A.8 License for statconnDCOM
.................................. 330
A.9 Digital Certiicate
..........................................330
В
NaîsaHces
—
Installation, Startup, or Execution
....................333
ВЛ
Installation
.....................,___......................333
B.2 Startup
...................................................334
B.3 Execution
..................,.............................. 334
Contents xxv
References
.........................................................339
Index.............................................................341
|
any_adam_object | 1 |
author | Heiberger, Richard M. 1945- Neuwirth, Erich 1948- |
author_GND | (DE-588)141419997 (DE-588)111104416 |
author_facet | Heiberger, Richard M. 1945- Neuwirth, Erich 1948- |
author_role | aut aut |
author_sort | Heiberger, Richard M. 1945- |
author_variant | r m h rm rmh e n en |
building | Verbundindex |
bvnumber | BV035741800 |
callnumber-first | Q - Science |
callnumber-label | QA276 |
callnumber-raw | QA276.4 |
callnumber-search | QA276.4 |
callnumber-sort | QA 3276.4 |
callnumber-subject | QA - Mathematics |
classification_rvk | SK 830 SK 850 ST 250 ST 600 ST 601 |
classification_tum | DAT 304f DAT 307f MAT 620f |
ctrlnum | (OCoLC)885148963 (DE-599)HBZHT016036026 |
dewey-full | 519.5 |
dewey-hundreds | 500 - Natural sciences and mathematics |
dewey-ones | 519 - Probabilities and applied mathematics |
dewey-raw | 519.5 |
dewey-search | 519.5 |
dewey-sort | 3519.5 |
dewey-tens | 510 - Mathematics |
discipline | Informatik Mathematik |
format | Book |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02163nam a2200553 c 4500</leader><controlfield tag="001">BV035741800</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20170614 </controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">090925s2009 xx ad|| |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBA963050</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781441900517</subfield><subfield code="c">pbk</subfield><subfield code="9">978-1-4419-0051-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)885148963</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)HBZHT016036026</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="049" ind1=" " ind2=" "><subfield code="a">DE-945</subfield><subfield code="a">DE-859</subfield><subfield code="a">DE-M49</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-824</subfield><subfield code="a">DE-188</subfield><subfield code="a">DE-706</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA276.4</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">519.5</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">SK 830</subfield><subfield code="0">(DE-625)143259:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">SK 850</subfield><subfield code="0">(DE-625)143263:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 250</subfield><subfield code="0">(DE-625)143626:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 600</subfield><subfield code="0">(DE-625)143681:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 601</subfield><subfield code="0">(DE-625)143682:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 304f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 307f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">MAT 620f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Heiberger, Richard M.</subfield><subfield code="d">1945-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)141419997</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">R through Excel</subfield><subfield code="b">a spreadsheet interface for statistics, data analysis, and graphics</subfield><subfield code="c">Richard M. Heiberger ; Erich Neuwirth</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York, NY</subfield><subfield code="b">Springer</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXV, 342 S.</subfield><subfield code="b">zahlr. 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">Use R!</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel</subfield><subfield code="x">Computer file</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Datenverarbeitung</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematical statistics</subfield><subfield code="x">Data processing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Graphical modeling (Statistics)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">R (Computer program language)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">R</subfield><subfield code="g">Programm</subfield><subfield code="0">(DE-588)4705956-4</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="689" ind1="0" ind2="0"><subfield code="a">R</subfield><subfield code="g">Programm</subfield><subfield code="0">(DE-588)4705956-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><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="700" ind1="1" ind2=" "><subfield code="a">Neuwirth, Erich</subfield><subfield code="d">1948-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)111104416</subfield><subfield code="4">aut</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-4419-0052-4</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg</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=018602006&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-018602006</subfield></datafield></record></collection> |
id | DE-604.BV035741800 |
illustrated | Illustrated |
indexdate | 2024-12-20T13:59:08Z |
institution | BVB |
isbn | 9781441900517 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-018602006 |
oclc_num | 885148963 |
open_access_boolean | |
owner | DE-945 DE-859 DE-M49 DE-BY-TUM DE-11 DE-824 DE-188 DE-706 |
owner_facet | DE-945 DE-859 DE-M49 DE-BY-TUM DE-11 DE-824 DE-188 DE-706 |
physical | XXV, 342 S. zahlr. Ill., graph. Darst. |
publishDate | 2009 |
publishDateSearch | 2009 |
publishDateSort | 2009 |
publisher | Springer |
record_format | marc |
series2 | Use R! |
spellingShingle | Heiberger, Richard M. 1945- Neuwirth, Erich 1948- R through Excel a spreadsheet interface for statistics, data analysis, and graphics Microsoft Excel Computer file Datenverarbeitung Mathematical statistics Data processing Graphical modeling (Statistics) R (Computer program language) R Programm (DE-588)4705956-4 gnd EXCEL (DE-588)4138932-3 gnd |
subject_GND | (DE-588)4705956-4 (DE-588)4138932-3 |
title | R through Excel a spreadsheet interface for statistics, data analysis, and graphics |
title_auth | R through Excel a spreadsheet interface for statistics, data analysis, and graphics |
title_exact_search | R through Excel a spreadsheet interface for statistics, data analysis, and graphics |
title_full | R through Excel a spreadsheet interface for statistics, data analysis, and graphics Richard M. Heiberger ; Erich Neuwirth |
title_fullStr | R through Excel a spreadsheet interface for statistics, data analysis, and graphics Richard M. Heiberger ; Erich Neuwirth |
title_full_unstemmed | R through Excel a spreadsheet interface for statistics, data analysis, and graphics Richard M. Heiberger ; Erich Neuwirth |
title_short | R through Excel |
title_sort | r through excel a spreadsheet interface for statistics data analysis and graphics |
title_sub | a spreadsheet interface for statistics, data analysis, and graphics |
topic | Microsoft Excel Computer file Datenverarbeitung Mathematical statistics Data processing Graphical modeling (Statistics) R (Computer program language) R Programm (DE-588)4705956-4 gnd EXCEL (DE-588)4138932-3 gnd |
topic_facet | Microsoft Excel Computer file Datenverarbeitung Mathematical statistics Data processing Graphical modeling (Statistics) R (Computer program language) R Programm EXCEL |
url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018602006&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
work_keys_str_mv | AT heibergerrichardm rthroughexcelaspreadsheetinterfaceforstatisticsdataanalysisandgraphics AT neuwirtherich rthroughexcelaspreadsheetinterfaceforstatisticsdataanalysisandgraphics |
Inhaltsverzeichnis
Paper/Kapitel scannen lassen
Paper/Kapitel scannen lassen
Teilbibliothek Weihenstephan
Signatur: |
1002 DAT 307f 2010 A 2491
Lageplan |
---|---|
Exemplar 1 | Ausleihbar Am Standort |