Price_($) Length_(inch) Width_(mm) 56.58 16 1.1 100 16 1.5 136.53 16 1.8 197.08 18 2.2 63.63...

Price_($)	Length_(inch)	Width_(mm)
56.58	16	1.1
100	16	1.5
136.53	16	1.8
197.08	18	2.2
63.63	18	1.2
112.51	16	1.5
152.87	18	1.8
221.37	18	2.3
366.14	18	3.1
616.47	20	3.9
70.71	18	1.1
125	20	1.4
170.19	20	1.9
245.66	20	2.4
407.24	20	3.2
685.59	20	3.9
270.86	20	2.2
448.35	22	3.1
753.78	22	3.9
79.82	24	1.2
149.04	24	1.4
198.02	24	1.9
295.16	24	2.4
448.51	24	3.2
882.91	24	3.9
181.21	30	1.5
247.51	30	1.9
368.96	30	2.3

Fit the multiple regression of price on length and width

What is the fit has R^2 and Se(standard error)?

Show me how to work at the excel.

I did try to make the regression in excel that put y to price and put x to length and width but I did not get right answer that is R^2 = 0.92 Se = 64.15 (round to two decimal places)

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

1)How much more area does a 18-inch rim have compared to a 16-inch rim on a...

1)How much more area does a 18-inch rim have compared to a 16-inch rim on a car? Round the answer to 2 decimal places. 2)The area of a sector is 110.60 sq yd and the radius of the sector is 10.82 yd. What is the measure of the central angle rounded to the nearest tenth? 3)The radius of a twelve-cut pizza is 7.5 inches and the radius of an eight-cut pizza is 5.25 inches. Compare the areas of the two...

Exp. CO(atm) O2(atm) Rate (atm/s) 1 2.2 1 0.121 2 1.1 1 0.03025 3 1.5 1.5...

Exp. CO(atm) O2(atm) Rate (atm/s) 1 2.2 1 0.121 2 1.1 1 0.03025 3 1.5 1.5 0.084375 What is the reaction order of O2?

Please answer the question: A 24 inch diameter spirally reinforced concrete column with a 1.5 inch...

Please answer the question: A 24 inch diameter spirally reinforced concrete column with a 1.5 inch cover to the spiral is reinforced with Grade 60 bars and has a concrete compressive strength of 5,000 psi. Determine the required diameter and pitch of the spiral reinforcement.

Data For Tasks 1-8, consider the following data: 7.2, 1.2, 1.8, 2.8, 18, -1.9, -0.1, -1.5,...

Data For Tasks 1-8, consider the following data: 7.2, 1.2, 1.8, 2.8, 18, -1.9, -0.1, -1.5, 13.0, 3.2, -1.1, 7.0, 0.5, 3.9, 2.1, 4.1, 6.5 In Tasks 1-8 you are asked to conduct some computations regarding this data. The computation should be carried out manually. All the steps that go into the computation should be presented and explained. (You may use R in order to verify your computation, but not as a substitute for conducting the manual computations.) A Random...

A. A 75.0-mLmL volume of 0.200 MM NH3NH3 (Kb=1.8×10−5Kb=1.8×10−5) is titrated with 0.500 MM HNO3HNO3. Calculate...

A. A 75.0-mLmL volume of 0.200 MM NH3NH3 (Kb=1.8×10−5Kb=1.8×10−5) is titrated with 0.500 MM HNO3HNO3. Calculate the pHpH after the addition of 11.0 mLmL of HNO3HNO3. B. A 50.0-mLmL volume of 0.15 MM HBrHBr is titrated with 0.25 MM KOHKOH. Calculate the pHpH after the addition of 15.0 mLmL of KOHKOH. C. A 52.0-mLmL volume of 0.35 MM CH3COOHCH3COOH (Ka=1.8×10−5Ka=1.8×10−5) is titrated with 0.40 MM NaOHNaOH. Calculate the pHpH after the addition of 17.0 mLmL of NaOHNaOH.

An investor in Treasury securities expects inflation to be 1.8%in Year 1, 2.2% in Year...

An investor in Treasury securities expects inflation to be 1.8% in Year 1, 2.2% in Year 2, and 3.15% each year thereafter. Assume that the real risk-free rate is 1.75% and that this rate will remain constant. Three-year Treasury securities yield 5.20%, while 5-year Treasury securities yield 6.00%. What is the difference in the maturity risk premiums (MRPs) on the two securities; that is, what is MRP5 - MRP3? Do not round intermediate calculations. Round your answer to two decimal...

diameter age 1.8 4 1.8 5 2.2 8 4.4 8 6.6 8 4.4 10 7.7 10...

diameter age 1.8 4 1.8 5 2.2 8 4.4 8 6.6 8 4.4 10 7.7 10 10.8 12 7.7 13 5.5 14 9.9 16 10.1 18 12.1 20 12.8 22 10.3 23 14.3 25 13.2 28 9.9 29 13.2 30 15.4 30 17.6 33 14.3 34 15.4 35 11 38 15.4 38 16.5 40 16.5 42 The data table below gives the diameter and age of 27 trees that were cut down to make open space for a playground. Diameter...

What would be the concentration of a 16 mM solution after 4–fold dilution? To make 100...

What would be the concentration of a 16 mM solution after 4–fold dilution? To make 100 mL of a 5% (w/v) glucose solution, how much glucose would you use? How much NaCl would you add to make an aqueous 10% (w/v) NaCl solution with a final volume of 500 mL? A 1X reaction buffer contains the following concentrations of each compound. Calculate the amount of each compound (in g) that would be needed to make 100 mL of a 5x...

For a capacitor of area 100 mm ´100 mm operated at T = 300K, with FM...

For a capacitor of area 100 mm ´100 mm operated at T = 300K, with FM = 5.2 eV, xox = 3 nm, and ND = 1017 cm-3 a) Calculate the flat band capacitance and treshold voltage b) Draw the low frequency and high frequency CV curves Please solve it completely and step by step. I will rate the question

Consider the following. x 1 2.5 3 4 5 1.5 y 1.5 2.2 3.5 3 4...

Consider the following. x 1 2.5 3 4 5 1.5 y 1.5 2.2 3.5 3 4 2.5 (a) Draw a scatter diagram for the following data. (Do this on paper. Your instructor may ask you to turn in this work.) (b) Would you be justified in using the techniques of linear regression on these data to find the line of best fit? Explain

Subjects