Question: Use the Excel Data Analysis Toolpack to develop a regression polynomial to the following data for the dissolved oxygen concentration of fresh water versus temperature

Use the Excel Data Analysis Toolpack to develop a regression polynomial to the following data for the dissolved oxygen concentration of fresh water versus temperature at sea level. Determine the order of polynomial necessary to match the precision of thedata.

16 24 T. C 32 40 14.62 11.84 987 8.42 7.31 6.41 O mg L

Step by Step Solution

★★★★★

3.40 Rating (181 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

An Excel worksheet can be developed with columns holding the dependent variable o along with the ind... 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

Document Format (1 attachment)

45-M-N-A-C-F (66).docx

120 KBs Word File

Students Have Also Explored These Related Numerical Analysis Questions!

Use the Excel Data Analysis Toolpack to fit a straight line to the following data. Determine the 90% confidence interval for the intercept. If it encompasses zero, redo the regression, but with the...

A Buick dealership would like to develop a regression model that would predict the number of cars sold per month by a dealership employee based on the employees number of years of sales experience....

Use the Excel data file called Cars that you will find on Blackboard to complete this assignment Describe the distribution of each of the following variables in the file mpg engine year and cylinder...

Given the data: Use Excel and MATLAB to: (a) Calculate f(3.4) using Newton's interpolating polynomials of order 1 through 3. Choose the sequence of the points for your estimates to attain the best...

QUESTION 1: Non-linear equations (15 MARKS] The Ergun equation shown below is used to describe the flow of a fluid through a packed bed. AP is the pressure drop, p is the density of the fluid, G, is...

Use case to answer question only you don't need no other reference. Case Overview Founded by Jeff Bezos, online giant Amazon.com, Inc. (Amazon), was incorporated in the state of Washington in July,...

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

NEED THE ANSWER FOR PART 2, I added part 1 too but I only NEED part TWO !!! (its at the bottom ) ------> DESCRIBE THE PROCEDURE USED IN THE LAKE STUDY EXPERIMENT INVOLVING IRON AND LEAD. INCLUDE IN...

13. PLEASE HELP!!! Assignment Submission For this assignment, you submit answers by question parts. The number of submissions remaining for each question part only changes if you submit or change the...

Lake Case Study Lab Water Sampling NEED THE ANSWER FOR PART 2, I added part 1 too but I only NEED part TWO !!! (its at the bottom ) Lake Study, Part 1 Analyzing data and developing a hypothesis. This...

A married resident citizen has five (5) qualified dependent children. The following information pertain to his income and expenses in the year 2019: Salary, net of P20,000 withholding tax Rent...

What are the general features of a typical fermenter/ bioreactor?

The management of Herbal Cafe supplies the community with healing herbs smoothies. The entity has been using the marginal costing system to calculate costs and profits. The Cost Accountant...

A transmission cable having a mass per unit length of 1 kg/m is strung between two insulators at the same elevation that are 60 m apart. Knowing that the sag of the cable is 1.2 m, determine (a) The...

Explain how the direct materials mix and yield variances provide additional information about the direct materials efficiency variance.

Four waves are to be sent along the same string, in the same direction: y1(x, t) = (4.00 mm) sin (2x 400t) y2(x, t) = (4.00 mm) sin (2x 400t + 0.7) y3(x, t) = (4.00 mm) sin (2x 400t + ) y4(x, t) =...

The Dauten Toy Corporation uses an injection molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its...

Assume that interest rate parity holds. In both the spot market and the 90-day forward market 1 Japanese yen equals 0.0086 dollar. The 90-day risk-free securities yield 4.6 percent in Japan. What is...

Refer to Table 10.2 and state the vapor pressure for water in atm at each of the following temperatures: (a) 75 C (b) 100 C. Table 10.2 TABLE 10.2 Vapor Pressure of Water Temperature (C) Pressure (mm...

Consider the defective circuit data in Exercise 8-48. (a) Do the data support the claim that the fraction of defective units produced is less than 0.05, using a = 0.05? (b) Find the P-value for the...

An article in Fortune (September 21, 1992) claimed that nearly one-half of all engineers continue academic studies beyond the B.S. degree, ultimately receiving either an M.S. or a Ph.D. degree. Data...

A manufacturer of interocular lenses is qualifying a new grinding machine and will qualify the machine if the percentage of polished lenses that contain surface defects does not exceed 2%. A random...

Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0 $ 68,000 $ 83,000 1 48,000 47,000 2 43,000 56,000 3 38,000 59,000 The cash flows of Project A are...

A project has the following estimated data: price = $50 per unit; variable costs = $33 per unit; fixed costs = $22,000; required return = 10 percent; initial investment = $21,000; life = three years....

A company has bid on two large construction projects. The company president believes that the probability of winning the first contract is 0.70, the probability of winning the second contract is 0.4...