Measures of Variability and Central Tendency

  

Imagine you have collected information on a health-related variable for 12 study participants.  For this discussion, come up with 12 different data points pertaining to one continuous variable and enter them into the first column in an Excel spreadsheet.  Examples of potential variables include: age, temperature, body weight, height, systolic blood pressure, number of minutes spent exercising/day, number of miles walked, etc. You will then use the descriptive statistics option in Excel, which is explained in Chapter 1 of your course text.  You should get an output similar to Figure 1.2.  This output must contain the following values: mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count.  Begin your discussion by identifying your variable, its unit of measurement (e.g. years for age, pounds for body weight) and report your results for each of the previously listed values.  Based on this output, which single value best describes this set of data and why?  If you could pick three of these values instead of only one, which three would you choose and why?  This exercise requires the use of the “Analysis ToolPak” within Excel.  This feature is already part of the 2007 and 2010 Excel programs; however, it must be activated.  The following directions were provided by the “Help” function within Excel.  If you experience issues while following these steps, utilize the “Help” function within Excel or contact Microsoft’s technical support for Excel. The Analysis ToolPak includes the tools described below. To access these tools, click Data Analysis in the Analysis group on the Data tab. If the Data Analysis command is not available, you need to load the Analysis ToolPak add-in program. Load the Analysis ToolPak1.  Click the File tab, click Options, and then click the Add-Ins category. 2.  In the Manage box, select Excel Add-ins and then click Go. 3.  In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. Tip:  If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

Don't use plagiarized sources. Get Your Custom Essay on
Measures of Variability and Central Tendency
Just from $13/Page
Order Essay
  
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more