User Account

All Pages

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

  Write interpretations of the t test values

The population mean on the paranoia scale is 50.- Suppose 24 police officers filled out the inventory, producing a mean of 54.3. Write interpretations of these t-test values.

  Find the 90 confidence interval for the population standard

1. a previous survey showed that 83 of the people who take the daily newspaper read the sports section. what sample

  Show that r is an equivalence relation

Let A be the set of all bit strings of length 25. Let R be the relation defined on A where two bit strings are related if they have the same number of ones. (a) Show that R is an equivalence relation. (b) Enumerate one bit string from five differen..

  1 ross whites machine shop uses 2500 brackets during the

1. ross whites machine shop uses 2500 brackets during the course of the year and this usage is relatively constant

  Is statement a premise or a conclusion- wherever water exist

In the following enthymemes, determine whether the missing statement is a premise or a conclusion.- Wherever water exists, human life can be sustained, and water exists on the moon.

  Let the number of phone calls received by a switchboard

let the number of phone calls received by a switchboard during a 5-minute interval be a random variable x with

  Distributed population and test the claim

Assume that a simple random sample has been selected from a normally distributed population and test the given claim.

  The table below represents the total number of patients who

the table below represents the total number of patients who were readmitted to critical hospital within 30 days of

  A major detergent manufacturer proposes

A major detergent manufacturer proposes spending £2.5 million (US$4.5 million) on a twelve-month national advertising campaign to promote an environmentally friendly washing liquid. Advise the marketing director how the effectiveness of the campa..

  Discuss the role of established standards

Discuss the role of established standards and third-party auditors in quality auditing. What is the role of ISO 9000 standards in this context?

  Academic approach to normal probability

Suppose Z has a standard normal distribution with a mean of 0 and a standard deviation of 1.0. One-half (50%) of the possible Z values are between ________ and ___________ symmetrically distributed about the mean.

  Hotly fought battle in a small

In a very hotly fought battle in a small war 270 men fought. Of these, 90 lost an eye, 90 lost an arm, and 90 lost a leg: 30 lost both an eye

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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