Do a multiple linear regression In Excel | Poly (perfluoropropyleneoxide), i.e., PPFPO, is a viscous liquid used
Fantastic news! We've Found the answer you've been seeking!
Question:
Do a multiple linear regression
In Excel
Transcribed Image Text:
| Poly (perfluoropropyleneoxide), i.e., PPFPO, is a viscous liquid used extensively in the electronics industry as a lubricant. In a study reported in Applied Spectroscopy (Jan. 1986), the infrared reflectance spectra properties of PPFPO were examined. The optical density (y) for the prominent infrared absorption of PPFPO was recorded for different experimental settings of band frequency (x,) and film thickness (x2) in a Perkin-Elmer Model 621 infrared spectrometer. The results are given in the accompanying table. OPTICAL DENSITY BAND FREQUENCY FILM THICKNESS X1, cm-1 X2, milligrams 231 740 1.1 .107 740 .62 .053 740 31 805 805 .129 1.1 .069 .62 .030 805 31 1.005 980 1.1 559 980 .62 321 980 31 1.1 1,235 1,235 1,235 2.948 1.633 .62 31 934 Source: Pacansky, J., England, C. D., and Waltman, R. "Infrared Spectroscopic Studies of Poly (Perfluoropropyl- eneoxide) on Gold Substrates: A Classical Dispersion Anal- Inder" Anplicd Spectroscopy, Vol. 40, | Poly (perfluoropropyleneoxide), i.e., PPFPO, is a viscous liquid used extensively in the electronics industry as a lubricant. In a study reported in Applied Spectroscopy (Jan. 1986), the infrared reflectance spectra properties of PPFPO were examined. The optical density (y) for the prominent infrared absorption of PPFPO was recorded for different experimental settings of band frequency (x,) and film thickness (x2) in a Perkin-Elmer Model 621 infrared spectrometer. The results are given in the accompanying table. OPTICAL DENSITY BAND FREQUENCY FILM THICKNESS X1, cm-1 X2, milligrams 231 740 1.1 .107 740 .62 .053 740 31 805 805 .129 1.1 .069 .62 .030 805 31 1.005 980 1.1 559 980 .62 321 980 31 1.1 1,235 1,235 1,235 2.948 1.633 .62 31 934 Source: Pacansky, J., England, C. D., and Waltman, R. "Infrared Spectroscopic Studies of Poly (Perfluoropropyl- eneoxide) on Gold Substrates: A Classical Dispersion Anal- Inder" Anplicd Spectroscopy, Vol. 40,
Expert Answer:
Related Book For
Statistics For Engineering And The Sciences
ISBN: 9781498728850
6th Edition
Authors: William M. Mendenhall, Terry L. Sincich
Posted Date:
Students also viewed these physics questions
-
A multiple linear regression model involving one qualitative and one quantitative independent variable produced this prediction equation: = 12.6 + .54x1 - 1.2x1x2 + 3.9x22 a. Which of the two...
-
A multiple linear regression model is estimated for shopping-trip generation during a peak hour. The model is No. of. Peak-hr vehicle based shopping trips/household = 0.12 +0.09 (household size)...
-
Some researchers3 illustrate a multiple linear regression equation to predict the yearly output of an oil field. We use their latest 20 years of data and change the units of three of their variables...
-
Three Zero Coupon Bonds (ZCB) are issued on the market. They each have face value of 100 and maturity, respectively, of 1 year, 3 years and 4 years. Assume the first bond is sold for 99.01, the...
-
Why do we say that mindless decision-making can actually be more efficient?
-
An invoice for $2365.00 has terms 2/10, n/30. The amount credited on a payment made within the discount period was $1365.00. What was the amount of the payment?
-
Again consider the 400 parts in Table 2.2. From this table, \[ P(D \mid F)=\frac{P(D \cap F)}{P(F)}=\frac{10}{400} / \frac{40}{400}=\frac{10}{40} \] Note that in this example all four of the...
-
The data listed below are taken from a balance sheet of Trident Corporation. Some amounts, indicated by question marks, have been intentionally omitted. Required: 1. Determine the missing amounts. 2....
-
Santana Rey, owner of Business Solutions, diversifies her business by also manufacturing computer workstation furniture. Required: 1. Classify the following manufacturing costs of Business Solutions...
-
Krazy Kars Pty Ltd (Krazy Kars) equips and sells customised off-road vehicles to operators in the tourist industry. The directors are Carlos, Possum and Michele. According to its constitution,...
-
Requirement 1. For each depreciation method, prepare a depreciation schedule showing asset cost, depreciation expense, accumulated depreciation, and asset book value for each year of the asset's...
-
1:12 < Back Leadership Essay 1 Instruction... MGNT 3235 - Spring 2024 Leadership Essay 1 Instructions Due Thursday, 2/22 by 11:59 pm in the Folio Dropbox First off, essays 1 and 2 aren't intended to...
-
(Yield to maturity) Assume the market price of a 6-year bond for Margaret Inc. is $925, and it has a par value of $1,000. The bond has an annual interest rate of 7% that is paid semiannually. What is...
-
Question 4 (22 marks) Helm Ltd. has two production departments and two service department and presented the following data for the period ending 30 June 2020. The production departments are forming...
-
A manufacturing company is testing the use of two different alloys in the formulation of solder. Test of the melting points (in oC) of solder formulations are undertaken using each different alloy....
-
Calculate the delay of the critical path for the circuit given the following gate delays: AND= 3 ns, OR = 3 ns, NOT = 1 ns a 0 6 ns 4 05 gl/C1_C1 011 ns 92/C1_C1 4 g3/C1_C1 A94/C1 C1 B A 96/C1_C1 Y 8...
-
A tutor helps a student with her math homework and gets paid today, but plans to spend the money next week. This illustrates which function of money? store of value medium of exchange unit of account...
-
The production budget of Artest Company calls for 80,000 units to be produced. If it takes 30 minutes to make one unit and the direct labor rate is $16 per hour, what is the total budgeted direct...
-
The Journal of World-Systems Research (Summer 2003) reported on a study of the link between foreign investments made 16 years earlier and carbon dioxide emissions. The researchers modeled the annual...
-
If Y has a x 2 distribution with n degrees of freedom then Y could be represented by x = i n x i , where the x i 's are independent x 2 distributions, each with degree of freedom. a. Show that Z =...
-
The management of a bank must decide whether to install a commercial loan decision-support system (an online management information system) to aid its analysts in making commercial loan decisions....
-
Input information from the SBA Personal Financial Statements given to Sharptop Bank into a spreadsheet. a. Separate personal items (e.g., residence) from business items (e.g., inventory). b....
-
Compare your recalculated ending inventory to that given to Sharptop Bank and to Southern Appalachian Insurance. Is either estimated ending inventory materially different from that reported on the...
-
What accuracy certifications on the tax return and bank financial statement address providing materially inaccurate information?
Study smarter with the SolutionInn App