Regression nuts and bolts

Assignment Help Basic Statistics
Reference no: EM13106393

Regression Nuts and Bolts

Consider the following income and consumption data (each measured in $1,000s) from 10 randomly sampled households. Copy the data into excel.

a) For income and consumption: at the bottom of each column calculate the mean (=AVERAGE),the variance (=VAR), and the standard deviation (=STDEV) for each variable.

b) For x=income, create a column which contains (xi - x ¯ ), the deviations from the mean. What is the mean of this column? Explain. Excel Hint: suppose the first data element is in cell c1 and mean is in cell c25. When you write the formula for the difference from the mean write it as c1-c$25, not c1-c25.

c) Create another column that has these terms squared:(xi - x ¯ )2 . Then use the column to manually calculate the variance and get the same answer as in question 1. Again, as in (3a) divide by n-1 instead of n when calculating the variance. Write the formula that you used.

d) Now let y=consumption, and create a column with the values of (yi y ¯), and yet another column with the products, (xi - x ¯ ) (yi - y ¯ ). Using the data in this column, manually calculate the sample covariance between income and consumption. As with the sample estimate of the variance, divide by n-1 instead of n. State which formula you used. (If you check your work using the covar function in Excel, note that Excel divides by n when calculating the covariance but n-1 when calculating the variance. but when calculating the covariance it divides by n.6) Using the means, variances and covariances calculated above, find the following:

a) The slope coefficient β1. Note: to get the right β1 you must ensure that the covariance and variance have the same denominator (i.e. both n-1).

b) The intercept: β0

c) A column of predicted values: y^

d) A column of residuals:u^

Verify that the fitted values have the same mean as the actual y-values, and that the residuals have mean zero.

Show that the variance of the fitted values plus the variance of the residuals adds up to the variance of y. Find the R-squared.

Reference no: EM13106393

Questions Cloud

Determining the multifactor productivity : A grocery chain is considering the installation of a set of 4 self-checkout lanes. The new self-checkout lane setup will replace 2 old cashier lanes that were staffed by a cashier and bagger on each lane.
Calculate the potential difference between its feet : Birds resting on high-voltage power lines are a common sight. The copper wire on which a bird stands is 2.5 cm in diameter and carries a current of 55 A. If the bird's feet are 3.9 cm apart, calculate the potential difference between its feet. (Th..
Pareto chart to identify significant types of rejection : A= Poor electrolyte coverage B=Improper lamination C= Low copper plating D= Plating separation E= Improper etching For 50 circuit boards that had been rejected last month.
Terrorism-criminal activity from economic-security viewpoint : Write down 1,000 to 1,500 word paper, exploring differences between terrorism and criminal activity from economic, security, and psychological perspective.
Regression nuts and bolts : Verify that the fitted values have the same mean as the actual y-values, and that the residuals have mean zero and show that the variance of the fitted values plus the variance of the residuals adds up to the variance of y. Find the R-squared.
In which direction and how far should the crew fly : you are on a plane that leaves DIA and flies 170 km at 68 east of north and then changes direction to fly 230 km at 48 south of east, after which it makes an emergency landing in a pasture next to a large herd of buffalo.
Analysis of micromanager : Perhaps some have found themselves in circumstances in which they have been micromanaged and thus have gained some firsthand understanding of it.
How far in front of the cattle should the pilot release : How far in front of the cattle should the pilot release the hay so that the bales will land at the point where the cattle are stranded.
Determine level to utilize for indifferent between two palns : Kim daivs has decided to buy cellular phone, but she is answer about which rate plan to choose. The " regular " plan charges fixed fee of 55% per month for 1000 minutes of airtime plus %0.33 per minute.

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