Using the data in the excel file home market value

Assignment Help Mathematics

Reference no: EM13535347

Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 square feet and a 95% prediction interval for a house that is 30 years old with 1,800 square feet.
Home Market Value

House Age Square Feet Market Value
33 1,812 $90,000.00
32 1,914 $104,400.00
32 1,842 $93,300.00
33 1,812 $91,000.00
32 1,836 $101,900.00
33 2,028 $108,500.00
32 1,732 $87,600.00
33 1,850 $96,000.00
32 1,791 $89,200.00
33 1,666 $88,400.00
32 1,852 $100,800.00
32 1,620 $96,700.00
32 1,692 $87,500.00
32 2,372 $114,000.00
32 2,372 $113,200.00
33 1,666 $87,500.00
32 2,123 $116,100.00
32 1,620 $94,700.00
32 1,731 $86,400.00
32 1,666 $87,100.00
28 1,520 $83,400.00
27 1,484 $79,800.00
28 1,588 $81,500.00
28 1,598 $87,100.00
28 1,484 $82,600.00
28 1,484 $78,800.00
28 1,520 $87,600.00
27 1,701 $94,200.00
28 1,484 $82,000.00
28 1,468 $88,100.00
28 1,520 $88,100.00
27 1,520 $88,600.00
27 1,484 $76,600.00
28 1,520 $84,400.00
27 1,668 $90,900.00
28 1,588 $81,000.00
28 1,784 $91,300.00
27 1,484 $81,300.00
27 1,520 $100,700.00
28 1,520 $87,200.00
27 1,684 $96,700.00
27 1,581 $120,700.00

Reference no: EM13535347

Questions Cloud

Determine how much force does the ring push on her : In an amusement park ride called The Roundup, passengers stand inside a 16.0 -diameter rotating ring. Suppose the ring rotates once every 5.40 . If a rider's mass is 57.0 , with how much force does the ring push on her at the top of the ride

What are the wavenumber and angular frequency : Cables that are used to support structures sometimes need to be tested in place to ensure that they are in good shape and at the proper tension. One way to do this is to send waves through them and examine the speed and other properties of the wav..

Would you classify a realty business like ruby river : Would you classify a realty business like Ruby River as a manufacturing, merchandising, or service business and analyzing the interrelationships among the four financial statements, determine the proper amounts for (a) through (o).

Calculate what is the cars speed : You've taken your neighbor's young child to the carnival to ride the rides. She wants to ride The Rocket. Eight rocket-shaped cars hang by chains from the outside edge of a large steel disk. What is the car's speed

Using the data in the excel file home market value : Using the data in the Excel file Home Market Value

Compute the wavelength of an electron traveling : In an electron microscope, electrons are accelerated to great velocities. Calculate the wavelength of an electron traveling with a velocity of 7.0 × 103 kilometers per second. The mass of an electron is 9.1 × 10-28 g.

What is the new pressure of the gas in the container X : A container X has 2 moles of gas with a pressure of 120 KPa at a constant temperature of 300K. 1) Find the volume of the gas in the container X. 2) If the temperature is now increased to 450K, what is the new pressure of the gas in the container X.

Calculate what was the objects speed as you released it : A popular pastime is to see who can push an object closest to the edge of a table without its going off. You push the 100 g object and release it 1.50 from the table edge. what was the object's speed as you released it

Prepare circuit citys retained earnings statement : Prepare Circuit Citys retained earnings statement for the year ending May 30, 2001.

User Account

All Pages