LC_Copy of Bascope_Chapter_1-1_Heart_Rate_Start

xlsx

School

Germanna Community College *

*We aren’t endorsed by this school

Course

MTH 154

Subject

Computer Science

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by PresidentCaribouMaster1204

Sub This is a machine generated report of your submission document containing error Details of all points deducted in the submitted document are listed on this sheet. Assignment Details Submission ID 326395301 Assignment Name Submission Date 23 January, 2024 Report Generated on 23 January, 2024 Points Obtained 8.668/12 (72.233%) Worksheet: 'Questions' (Points Deducted: 3.332) Points Deducted Details 2.000 Cell level Incorrect Actions 1.332 Incorrect Actions: Chart(s) 0.000 Extra: Named Ranges(s)

bmission MarkUp r details as annotations. Error Description 1 cell(s) commented inplace. Please check the sheet. 1.332 point(s) deducted in instruction #4: -In the 'Clustered Column chart' on the sheet 'Questions', the 'Source' was not set as per the This action did not result in any loss of points.

Heart R Project Des In this proble Use a cell re Steps to Pe Step 1 2 3 4 5

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Rate scription: em, you will investigate the heart rate at different ages. You will also provide the results as a column chart. eference 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 receiv erform: Instructions Start Excel. Download and open the workbook named: Chapter_1-1_Heart_Rate_Start 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. 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. Note: The category x-axis labels should be from 10 to 100 with increment 10. Save your file and submit for grading. 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 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 H horizontal axis with Age (years) and Axis Title for the vertical axis with Beats per Minute .

0 4 4 4 0 12 Points Possible

Heart Rate Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy a.) Input Age: 18 Output Heart Rate: 141.4 b.) Age Heart Rate 10 147 20 140 30 133 40 126 50 119 60 112 Chart 70 105 80 98 90 91 100 84 Average heart rate (in beats per minute) is given by the following formula: Heart Rate = (220 –Age) * 70%. a.) Enter a formula in the output cell that computes the He (years). Be sure to use cell references and format to one dec year-old who should have a heart rate of 141.4 beats per mi b.) Create a Table of values, separate from the input/outpu in part a , for Heart Rate as a function of Age . Use cell refere and fill down. c.) Create a well-labeled column chart of this table from pa b . Add axis labels with the units of the variables, and add a title with name of the dependent variable. Axis labels and t title should be chosen from the list: a. Heart Rate b. Age (years) c. Beats per Minute

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

y and paste values or type values, as you will not receive full credit for your answers. c.) eart Rate (beats per minute) for a given input of Age cimal place of accuracy. Test your formula for an 18- inute. ut cells ences art the 10 20 30 40 50 60 70 80 90 100 0 20 40 60 80 100 120 140 160 Heart Rate Age Heart Rate

Related Documents

Midterm 2 problems.pdf

Assignment 3 Fluency Intervention-5.pdf

Midterm 2015-2018 answers.pdf

Lab-Report-Template (1).docx

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Enhanced Discovering Computers 2017 (Shelly Cashm...

Computer Science

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning