Het gemiddelde en de standaarddeviatie berekenen in Excel 2007

Pdf downloaden
Pdf downloaden

Het berekenen van het gemiddelde en de standaarddeviatie in Excel 2007 is zo eenvoudig als 1 plus 1 en vergt niet meer dan een paar minuten.

Methode 1
Methode 1 van 2:

Het berekenen van het gemiddelde

Pdf downloaden
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bf\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Voer het bereik in van de getallen in je Excel-spreadsheet. Klik op een plek waar het gemiddelde moet komen.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1d\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Typ de getallen in je Excel-spreadsheet, in een rij of een kolom.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/69\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/29\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/29\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1b\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Advertentie
Methode 2
Methode 2 van 2:

Het berekenen van de standaarddeviatie

Pdf downloaden
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/63\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/63\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Plaats de cursor waar je wilt dat het resultaat verschijnt.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3d\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-4.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-4.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1d\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-3.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-3.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/15\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-3.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/15\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-3.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-3.jpg\/v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-3.jpg\/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Advertentie

Tips

  • Ben je eenmaal vertrouwd met het gebruik van deze functies, dan hoef je 'Functie invoegen' niet meer te gebruiken, maar kun je de formules gewoon direct in de cellen typen, als volgt:
    • Gemiddelde — '=GEMIDDELDE(bereik)' → e.g., '=GEMIDDELDE(D4:D13)'
    • Standaarddeviatie — '=STDEV(bereik) → e.g, '=STDEV(D4:D13)'
    • Vergeet hierbij het gelijkteken niet, omdat je in Excel hiermee aangeeft dat de inhoud van een cel een formule is.
  • Gebruik je een oudere versie van Excel, dan kun je dezelfde stappen uitvoeren zoals hierboven aangegeven, door op de Functiewizard ( fx ) te klikken in het hoofdmenu. Klik op Statistisch, Gemiddelde of Statistisch en daarna op STDEV.
Advertentie

Gerelateerde artikelen

Een lege pagina in Word verwijderen
Tekst doorhalen in Word
Een komma veranderen in een punt in Excel
De beveiliging verwijderen van een Excel bestand
Het eurosymbool typen
Twee Excel bestanden vergelijken
Verborgen rijen weer zichtbaar maken in Excel
Een krant maken in Word
Getallen van elkaar aftrekken in Excel
Een tekstvak maken in Google Documenten
Opmerkingen verwijderen of verbergen in een Worddocument
Twee spreadsheets samenvoegen in Excel
Advertentie

Over dit artikel

In andere talen
Deze pagina is 23.591 keer bekeken.

Was dit artikel nuttig?

Advertentie