Purchase Solution

Excel--Heart Rate

Not what you're looking for?

Ask Custom Question

Chapter 1-1 Heart Rate

Project Description:
In this problem, you will investigate the heart rate at different ages. You will also provide the results as a column chart. Use a cell reference or a single formula where appropriate.

Steps to Perform:
1 Start Excel. Download and open the workbook named:
Chapter_1-1_Heart_Rate_Start
2 In cell C11, use the appropriate formula to calculate the heart rate for the age in cell C10. Format cell C11 as Number with 1 decimal place.
3 In cell C16, use the appropriate formula to calculate the heart rate for the age in cell B16. Fill cell C16 down the column to cell C25.
4 In cells K18:R33, insert a Clustered Column Chart to show the relationship between the heart rate and the age. Select the range B16:C25. On the Insert tab, click Recommended Charts, and then click Clustered Column. Apply Style 6 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Heart Rate. Add axis titles. Replace Axis Title for the horizontal axis with Age (years) and Axis Title for the vertical axis with Beats per Minute.

Note: The category x-axis labels should be from 10 to 100 with increment 10.

Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.

Average heart rate (in beats per minute) is given by the following formula:
Heart Rate = (220 -Age) * 70%.

a) Input Age:
Output Heart Rate:
b.) Create a Table of values, separate from the input/output cells in part a, for Heart Rate as a function of Age. Use cell references and fill down.
c.) Create a well-labeled column chart of this table from part b. Add axis labels with the units of the variables, and add a title with name of the dependent variable. Axis labels and the title should be chosen from the list:
a. Heart Rate
b. Age (years)
c. Beats per Minute

Attachments
Purchase this Solution
Solution Summary

All formulas, computations, solutions and graphs are included in the Excel file.

Solution provided by:
J Pye, MSc
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Now that cigarette smoking has been clearly tied to lung can

    The graph is as follows: As we can see from the graph, there is a general trend that the number of death due to heart disease increases with the cigarette consumption. A linear model was created by excel by fitting a linear trendline.

  • One Way Analysis of Variance

    Each subject's heart rate, blood pressure, oxygen uptake, and perceived exertion during snow removal were compared with the values obtained during treadmill and arm-crank ergometer testing.

  • Descriptive Statiatics & Confidence Interval

    The variables are age (years), weight (kg), oxygen intake rate (ml per kg body weight per minute), time to run 1.5 miles (minutes), heart rate while resting, heart rate while running (same time oxygen rate measured), and maximum heart rate recorded while

  • Hypothesis Test

    327882 Hypothesis Test Here are heart rates for a sample of 30 students before and after a class break. At alpha = .05, was there a significant difference in the mean heart rate? (a) State the hypotheses. (b) State the decision rule and sketch it.

  • Computing mean, variance and standard deviation

    ANSWER: Suppose a company wants to test the effectiveness of a new drug to reduce the heart rate of patients who have heart disease.

  • Inferences from two samples: a hypothesis test

    Use a 0.05 significance level to test the claim that the rate of heart disease is higher for women with he lower levels of physical activity. What does the conclusion suggest? What test statistic is used for this type of problem?

  • Hypothesis Testing: Mean Heart Rate & Bumber Test

    327043 Significant Difference Here are heart rates for a sample of 30 students before and after a class break. At ? = .05, was there a significant difference in the mean heart rate? (a) State the hypotheses.

  • One way ANOVA

    Do the mean heart rate fro the groups appear to show that the presence of a pet or friend reduces heart rate during stressful task? B. What are the values of the ANOVA F-statistic and its P-value? What hypothesis does F test?

  • Training Heart Rate Calculations

    A person's THR can be calculated from his age and resting heart rate (pulse when first awakening) as follows: a. Calculate the maximum heart rate as 220 - age. b. Subtract the resting heart rate from the maximum heart rate. c.

View More Related Solutions