Unit 3 assessment – descriptive statistics

 

Instructions

In this assignment, you will be required to calculate descriptive statistics for each numeric variable in the Heart Rate Dataset

Steps

  1. Open the Heart Rate Excel Dataset In Read Me First
  2. Sort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate)
  3. Use the Excel Data Analysis ToolPak* tools to calculate each of the following statistics:
    1. Mean of each quantitative variable
    2. Sample variance of each quantitative variable
    3. Sample standard deviation of each quantitative variable
  4. Create a table in Excel that summarizes the statistics for each variable.
  5. Transfer your summary results to Word.
  6. Interpret what the mean and standard deviation specifically tell you about the heart rates of males and females in the sample.  Are the heart rates for males or females higher?  Which data is more spread out and which is closest to the overall mean rate? Explain your responses.

In the topic “Measures of Center”, you were provided directions on how to upload the Data Analysis ToolPak to Excel. If you have not yet uploaded the add-in Data Analysis ToolPak, please view the appropriate video and follow the instructions.  You will not be able to complete this assignment without that add-in.

How to Install the Data Analysis ToolPac in Microsoft Excel

https://youtu.be/_yNxLFagKgw

How to Add the Data Analysis ToolPak in Excel on Mac 2018

https://youtu.be/HJay_paA6T4

Installing Excel Toolpak (Data Analysis) on Mac (versions other than 2018)

https://youtu.be/mtmrAXwLcuU

For a review of how to use the Data Analysis ToolPak to create summary statistics

Review: Descriptive Statistics in Excel Mean, Median, Mode …

Directions: Review this video on how to use the Data Analysis ToolPak to create summary statistics. 

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include

  • Running head
  • A title page with
    • Assignment name
    • Your name
    • Professor’s name
    • Course

References

Ben G Kaiser. (2018).  How to add the Data Analysis ToolPak in Excel on Mac 2018 [Video]. Retrieved from https://youtu.be/HJay_paA6T4

Joseph C. (2016). Installing Excel Toolpak (Data Analysis) on Mac [Video].  Retrieved from https://youtu.be/mtmrAXwLcuU

Joshua Emmanuel. (2017). Descriptive statistics in Excel mean, median, mode, std. deviation… [Video]. Retrieved from https://youtu.be/qJR8OMQP3vw/p>

Quantitative Specialists. (2013). How to install the Data Analysis ToolPak in Microsoft Excel [Video]. Retrieved from https://youtu.be/_yNxLFagKgw







Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
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

Order your essay today and save 10% with the coupon code: best10