posted by .

In developing a multiple linear regression model in excel. How do I find the x and Y inputs. How do I find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 sq ft, and 95% prediction interval for a house that is 30 years old with 1,800 sq ft

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. statistics help...please

    i have no idea! The real estate assessor for a country government wants to study various characteristics of single family houses in the country. A random sample of 70 houses reveals the following: the mean is 1759, standard deviation …
  2. Statistics

    1. A certain population follows a normal distribution, with mean m and standard deviation s = 2.5. You collect data and test the hypotheses H0: m = 1, Ha: m 1. You obtain a P-value of 0.022. Which of the following is true?
  3. Business Statistics

    Instructions: Prepare your answers using Excel and show your work to get full or partial credit. Question 1: Using the file Wages.xlsx which contains information of working individuals, for a nationwide firm (Value 7 points). a) Run …
  4. Statistics

    A simple random sample of 50 female 14-year-olds is selected. The sample mean height of the girls is found to be 62 inches. Assume the height of 14-year-old girls is normally distributed with a standard deviation of 5 inches. 1. Based …
  5. statistics

    Linear Regression In the babies.dta full dataset, generate a covariate called painind defined as 1 if the infant experienced severe pain upon receiving the shot (pain0 = 7) and as 0 otherwise. In Stata, you can use the commands: generate …
  6. Statistics

    A random sample of 90 observations produced a mean that = 25.9 and a standard deviation s =2.4 (a)Find a 95% confidence interval for u (b)Find a 90% confidence interval for u (c)Find a 99% confidence interval for u (Use integers or …
  7. Helpppp Math!!!

    The market value (in thousands of dollars)of a certain home is a linear function of t, the time in years since 1990. In 1992 the market value was 68 thousand dollars, while in 1997 the market value was 79 thousand dollars -Find the …
  8. math

    Data were recorded for the demand and revenue of a given product. Find the linear regression line which represents the revenue function. Find the quadratic regression curve which represents the revenue function. Data Demand x Revenue …
  9. Multiple regression

    1) Estimate a multiple regression equation to predict the price of houses in a given community. Employ all available explanatory variables. Is there evident of of multi-collinearity in this model?
  10. chin

    The following data shows the annual salaries of 12 randomly selected employees of a company (in £ 1000’s) on the X-axis and the average number of days they have taken days off work in the last 10 years on the Y-axis. Y X Y X 11.1 …

More Similar Questions