Excel for Statistics | Samfundslitteratur

Søgefelt

Content section

search Kig i bogen

Excel for Statistics

How to Organize Data

This booklet is a handbook on statistical software, not on statistical theory and methodology as such.

The focus is on how to create input for Excel s statistical functions and data analyses when using raw data. The need for organizing data applies to survey data in particular. Also,a presentation of basic Excel targeted at statistics is...

Læs mere

This booklet is a handbook on statistical software, not on statistical theory and methodology as such.

The focus is on how to create input for Excel s statistical functions and data analyses when using raw data. The need for organizing data applies to survey data in particular. Also,a presentation of basic Excel targeted at statistics is included.

Prior experience with Excel is not presupposed. In conclusion, output by Excel s statistical functions and data analyses is briefly interpreted.

 

  

  

Forlag: Samfundslitteratur
Sprog: Engelsk
Illustreret: Ja
Skjul beskrivelse

Køb bogen

Bog (Softcover)
1. udgave (2013), 
100 sider
Vejl. Pris
49,-
ISBN 9788759317891
E-bog (VitalSource Bookshelf)
1. udgave (2013), 
100 sider
Vejl. Pris
106,-
ISBN 9788759323175

Yderligere information

NB: For en mere udførlig indholdsfortegnelse, vælg 'Kig i bogen' herover.

 

Chapter 1.

Basic Excel for Statistics        7

Chapter 2

Descriptive Statistics: Looking at the Data        29

Chapter 3.

Significance Tests about Means          37

Chapter 4.

Significance Tests about Proportions          63


Chapter 5.

Testing Categorical Variables for Independence (÷2-test) .
Computing expected Frequencies         69

Chapter 6.

Correlation Analysis         73

Chapter 7.

Regression Analysis with Two Variables           75

Chapter 8.

Multiple Regression Analysis with a Categorical Variable        89

Exhibit.

Functions and Data Analyses applied . Excel 2010/2007          97

Index        100

The text presupposes a basic knowledge of quantitative statistics. It can be used in a statistics course as a companion to Excel statistical software. Students writing a thesis can use the text as a handbook when applying Excel as readily available statistical software.

Sidebar section

Pensumeksemplar

Som underviser har du mulighed for at anmode om et pensumeksemplar af denne titel.

Anmod

Har du spørgsmål?

Du er altid velkommen til at kontakte os på info@samfundslitteratur.dk eller på telefon: 44 22 38 80.

Læs om vores persondatapolitik.

Kontakt fagredaktøren

Har du en idé til en lærebog, eller mangler der en bog inden for dit fag, hører vi gerne fra dig! Skriv til fagredaktør Henrik Schjerning på hs@samfundslitteratur.dk.