+ Reply to Thread
Results 1 to 2 of 2

How to find the mean, var, SD, etc, of a large sample?

  1. #1
    Registered User
    Join Date
    09-16-2020
    Location
    Ohio, USA
    MS-Off Ver
    16.40
    Posts
    1

    How to find the mean, var, SD, etc, of a large sample?

    I can't seem to figure out how to find the values of the mean, variance, standard deviation of a large sample size like the one below.

    In this model question, I want to figure out the mean, variance, etc of the # of pens from the sample of 148 individuals.

    Screenshot 2020-09-16 at 7.13.32 PM.png

    I know how to find those values from a smaller sample size, by typing those numbers into each cell then highlighting all of them and clicking 'data analysis'. But I don't know a shortcut other from typing in the 148 values manually and figuring it out from there.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to find the mean, var, SD, etc, of a large sample?

    Quote Originally Posted by Rihcho View Post
    clicking 'data analysis'.
    where is that? is that an interface menu option?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Trying to find the two numbers averaged from an even sample when median is used
    By OliveH in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2018, 07:30 AM
  2. [SOLVED] Find, Sample, Replace
    By jatke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2017, 12:06 PM
  3. Find, Sample, Replace
    By jatke in forum Excel General
    Replies: 0
    Last Post: 07-16-2017, 01:36 AM
  4. Deleting rows in a large data sample
    By Poetae in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 04-01-2015, 02:44 AM
  5. Excel 2007 : Random Sample in Excel/Find a Row
    By wlaura in forum Excel General
    Replies: 0
    Last Post: 11-09-2011, 11:00 PM
  6. Calculating Multiple Comparisons over Large Sample
    By Pherion in forum Excel General
    Replies: 5
    Last Post: 08-06-2009, 03:25 PM
  7. Where can I find sample VBA code...
    By ExMainframer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2005, 06:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1