Regression and correlation analysis

Assignment Help Basic Statistics
Reference no: EM131966995

Regression and Correlation Analysis

Use the dependent variable Selling Price (labeled Y) and the independent variables Age, Rooms, Baths (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following.

1. Generate a scatterplot for the specified dependent variable (Y) and the one of the independent variables X1, X2, or X3 including the graph of the "best fit" line. Interpret.

2. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable.

3. Determine the coefficient of correlation. Interpret.

4. Determine the coefficient of determination. Interpret.

5. Test the utility of this regression model. Interpret results, including the p-value.

6. Based on the findings in Steps 1-5, analyze the ability of the independent variable to predict the designated dependent variable. 

In an attempt to improve the model, use a multiple regression model to predict the dependent variable, Y, based on all of the independent variables, X1, X2, and X3.

7. Using Excel, run the multiple regression analysis using the designated dependent and three independent variables. State the equation for this multiple regression model.

8. Perform the Global Test for Utility (F-Test). Explain the conclusion.

9. Perform the t-test on each independent variable. Explain the conclusions and clearly state how the analysis should proceed. In particular, which independent variables should be kept and which should be discarded. If any independent variables are to be discarded, re-run the multiple regression, including only the significant independent variables, and summarize results with discussion of analysis.

10. Is this multiple regression model better than the linear model generated? Explain.

Selling Price 400000 370000 382500 300000 305000 320000 321000 445000 377500 460000 265000 299000 385000 430000 214900 475000 280000 457000 210000 272500 268000 300000 477000 292000 379000 295000 499000 292000 305000 520000 308000 316000 355500 225000 270000 253000 310000 300000 295000 478000

Age 27 21 36 34 69 34 35 19 40 20 39 44 33 6 49 21 49 14 64 44 44 32 19 47 29 144 62 52 36 6 42 25 46 49 24 44 53 33 34 6

Rooms 9 8 9 8 6 7 8 9 9 10 6 7 9 8 5 7 8 11 7 6 4 9 10 8 10 6 6 7 8 11 8 7 10 6 6 6 6 8 6 8

Baths (full) 3 2 2 2 2 2 1 2 3 2 2 1 3 2 1 2 2 3 1 1 1 2 4 1 3 1 2 1 3 2 2 2 2 1 1 1 2 2 2 2

Reference no: EM131966995

Questions Cloud

Characteristic of common stock ownership : Which of the following are not characteristic of common stock ownership?
What information do you need to solve the problem : What theory or theories can you formulate concerning this problem? Carefully analyze and interpret your theories and draw reasonable inferences. E
Calculated despite unequal or missing cash flows : Can Future Value and Present Value be calculated despite unequal or missing cash flows?
Should we resist the attempt to introduce more gmos : What do you think? Should we approve of increased use of genetically modified crops to increase food availability and nutrition?
Regression and correlation analysis : Use the dependent variable Selling Price (labeled Y) and the independent variables Age, Rooms, Baths (labeled X1, X2, and X3) in the data file.
Janice believe inflation rate will be over next year : An investment offers a total return of 12 percent over the coming year. What does Janice believe the inflation rate will be over the next year?
What is our sales price per unit : Desired operating income as a percentage of total assets, 16%; What is our sales price per unit if we used the cost-plus pricing approach
What rate would you expect to see on treasury bill : Suppose the real rate is 4 percent and the inflation rate is 5.6 percent. What rate would you expect to see on a Treasury bill?
Corporation participate in the health screening : In running a promotional trial, 54 out of the 130 people who work in one office for the corporation participate in the health screening.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd