Assignment5-2010

Assignment5-2010 - ChE 263 Assignment#5(Excel HW#5 Note This homework requires data that is contained in an Excel file found on Blackboard under

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ChE 263 Assignment #5 (Excel HW#5) Note: This homework requires data that is contained in an Excel file found on Blackboard under the “Assignments” tab listed as “data_for_hw5.xlsx”. 1. (Competencies 5.2, 6.1; 45 points) Heart rate data (Beats per minute or BPM) as a function of time (sec) for a twenty-minute period of constant exertion is found on the “Problem 1” worksheet of the workbook data_for_hw5.xlsx. The time of each measurement, in seconds, in listed in column A, and the measured heart rate, in beats per minute, in column B. Using Excel: a. Determine the values of c 0 , c 1 , c 2 , and c 3 that result in the best fit of the data to the following equation: ܤܲܯ ൌ ܿ ൅ܿ ݐെܿ ݁ ି௖ b. Plot the data and the approximating function (BPM vs time (sec). c. Calculate the R 2 value for the fit. Is the fit good? Hints: Providing good guess values is the key to getting this fit to solve. o
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/08/2012 for the course CHEM 263 taught by Professor Bradbundy during the Fall '11 term at BYU.

Page1 / 2

Assignment5-2010 - ChE 263 Assignment#5(Excel HW#5 Note This homework requires data that is contained in an Excel file found on Blackboard under

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online