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.
|
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.
|