Question: Use a spreadsheet program to fit a straight line (y = ax = b), to tabulated (x, y) data. Your program should evaluate the slope

Use a spreadsheet program to fit a straight line (y = ax = b), to tabulated (x, y) data. Your program should evaluate the slope a and intercept b of the best fit to the data, and then calculate values of y using the estimated a and b for each tabulated value of x. Calculate the average deviation (residual) of the estimated y from the calculated value, and comment upon the quality of the fit to the data. Test your program by fitting a line to the data in the following table:

1.0 1.5 2.0 2.5 3.0 y 2.35 5.53 8.92 12.15 15.38

Step by Step Solution

★★★★★

3.48 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Since this example was to be solved in a spreadsheet the scre... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!

Write a computer program to fit a straight line y = ax + b to tabulated (x, y) data, assuming that no more than 100 data points will be taken in any one run. Your program should read in and store the...

The following are measured values of a system temperature versus time: (a) Use the method of least squares Appendix A.1 to fit a straight line to the data, showing your calculations. You may use a...

Natural gas that contains methane, ethane, and propane is to be burned with humid air. The adiabatic flame temperature is to be calculated from specified values of the following quantities: ycH 4 ,...

*2.44. Write a computer program to fit a straight line y s ax + b to tabulated (x,y) data, assuming that no more than 100 data points will be taken in any one run Your program should read in and...

1.0 Points Question 1 of 17 Two independent samples of sizes n1 = 50 and n2 = 50 are randomly selected from two populations to test the difference between the population means, distribution of the...

Explanation and complete code gets thumbs up. For this Matlab problem. For Problems 1-3, use Matlab to plot the data and the best fit. Show the written solutions to all the problems, and the Matlab...

Python coding question An exercise in straight-line fitting Hote. You will need to have read the lectures and or watched the converting video to attempt this cuestion. There is no introductory...

Question 8(1 point) Data for a sample of 30 apartments in a particular neighborhood are provided in the worksheet. You want to see if there is a direct relationship between Size of the Apartment and...

Data for a sample of 30 apartments in a particular neighborhood are provided in the worksheet. You want to see if there is a direct relationship between Size of the Apartment and Rent. Please see...

Rent /Size 950/850 1500/1450 1150/1085 1400/1232 950/718 1700/1485 1550/1136 935/726 875/700 1050/956 1400/1100 1650/1500 1875/1985 1800/1674 1395/1223 1375/1225 1100/1300 1500/1345 1200/1150...

Sue is 30 years old and is president and a 51% shareholder of C Corporation. She informs you that C Corporation has ten shareholders, all unrelated. Other than herself, no shareholder owns more than...

Bryan Trucking Corporation began business on January 1, 2014, and consists of the parent entity, domiciled and operating in Country X, and a subsidiary operating in Country Y. Bryan is required, as a...

15. PQRS is a parallelogram. BQ = 2RB, AR= PS = a and PQ = b. (i) Express in terms of a and/or b, (a) SA, (b) QB, (c) PB, (d) QS, (e) BA. (ii) Calculate the value of RA (b) () QS area of AABR area of...

=+ On average, there are 16 laptops in the refurbishing area waiting or being worked on.

Why is a Walden reductor always used with solutions that contain appreciable concentrations of HCl?

Treatment of hydroxylamine (H2NOH) with an excess of Fe(III) results in the formation of N2O and an equivalent amount of Fe(II): 2H2NOH + 4Fe3+ ( N2O(g) + 4Fe2+ +4H+ + H2O

An 8.13-g sample of an ant-control preparation was decomposed by wet-ashing with H2SO4 and HNO3. The As in the residue was reduced to the trivalent state with hydrazine. After removal of the excess...

DJIA was 19,864.09 on Jan 31, 2017 (refer to the Excel spreadsheet DJIA_Jan31_2017.xlsx in ASSIGNMENTS on the course web site). What was the divisor value (provide the number with 6 digits after the...

A stock has an expected return of 14 percent, the risk-free rate is 6 percent, and the market risk premium is 10 percent. What must the beta of this stock be

From the bank reconciliation no entry was recorded for the interest on a note collected. This would cause: A) liabilities to be understated. B) assets to be overstated. C) liabilities to be...