hwk6 - HOMEWORK #6 Due: October 8 - 21 1. Reading...

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

View Full Document Right Arrow Icon
HOMEWORK #6 Due: October 8 - 21 1. Reading Assignment Complete the assigned reading posted on the Course Schedule on the ENGR 126 Blackboard homepage. 2. Online Module Complete the “Regression by Eye” Module posted under On-Line Modules on the ENGR 126 Blackboard homepage. Deliverable: Online Submission 3. Regression with Excel This section to be completed individually . Oil of wintergreen, which contains methyl salicylate, is extracted from the leaves of the common wintergreen plant ( gaultheria procumbens ). 1 Aspirin, salicylic acid, can be obtained by the hydrolysis of methyl salicylate. A chemist is interested in determining the relationship between the amount of aspirin yielded and the amount of wintergreen oil used. The chemist provided his data in the file hw6problem3.xlsx located on Blackboard. 1. Download the file hw6problem3.xls from Blackboard. Modify the Comments section (at the top of the Excel worksheet) for this problem. 2. Create a scatter plot of the aspirin yielded as a function of the amount of wintergreen oil used. Estimate, by hand, the best fit line using the two-point method. a. Create the plot using data markers only (i.e. do not connect the data points with a line). b. Print the plot and draw an estimate of the best-fit line by hand. c. Estimate, by hand, the best-fit line using the two-point method. Clearly state your equation on the plot. 3. In your Excel file, add the regression line to your scatter plot using the “add trendline” command. 4.
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 02/12/2012 for the course ENGR 126 taught by Professor Oakes during the Fall '08 term at Purdue University-West Lafayette.

Page1 / 3

hwk6 - HOMEWORK #6 Due: October 8 - 21 1. Reading...

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