Question

An analyst is running a regression model using the following data: Y x1 x2 x3 x4...

An analyst is running a regression model using the following data:

Y x1 x2 x3 x4 x5 x6
4 1 5 0 -95 17 12
10 5 8 1 -27 7 10
32 1 7 0 -82 0 9
2 2 7 0 17 5 10
9 3 9 1 -46 5 11

Excel performs the regression analysis, but the output looks all messed up: For example the F statistic cannot be computed, standard errors are all zero, etc etc.

What is wrong here, and why does it make no sense to run this ordinary least squares regression in the first place? Explain in detail!

Homework Answers

Answer #1

For the regression analysis, the number of observations should be greater than the number of parameters in the model. In this question, the number of observation is 5 (n=5, length of the variable y or any explanatory variables) whereas the number of the parameters in the model are 8 ( 1 for the intercept, 6 for the slopes of x1, x2, x3, x4, x5, x6 and 1 for the variance). Due to this result, you can to estimates the parameters, test statistics, standard errors etc.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
2) Solve the simultaneous equations in Excel. x1 x2 x3 x4 x5 x6 RHS -24 -43.9...
2) Solve the simultaneous equations in Excel. x1 x2 x3 x4 x5 x6 RHS -24 -43.9 -40.4 76.3 87.9 12.8 -77.8 -5.2 -75 44.9 57.9 62.1 7 91.8 13.3 -82.5 -6.3 47.9 -9.7 -8.8 -12 -97.8 0.4 10 3.5 -96.1 -83 86.8 63.3 10.1 46.1 -3.4 -73.7 89.8 -35.1 77.2 99.1 -67.1 -81.9 42.6 82 -20.4
y   x1   x2   x3   x4 64   74   22   24   17 43   63   29   15   30 51  ...
y   x1   x2   x3   x4 64   74   22   24   17 43   63   29   15   30 51   78   20   9   25 49   52   17   38   29 39   45   12   19   37 Consider the set of dependent and independent variables given below. Perform a best subsets regression and choose the most appropriate model for these data. Find the most appropriate model for the data. Note that the coefficient is 0 for any variable that is not included in the model. y= _____+...
Given here are data for a dependent variable and four potential predictors. y x1 x2 x3...
Given here are data for a dependent variable and four potential predictors. y x1 x2 x3 x4 x5 96 8 60 2.4 48 51 73 6 64 2.1 42 43 108 2 76 1.8 34 20 124 5 74 2.2 11 14 82 6 50 1.5 61 29 89 9 57 1.6 53 22 76 1 72 2 72 38 109 3 74 2.8 36 40 123 2 99 2.6 17 50 125 6 81 2.5 48 55 101 2...
Consider the following linear program Max 5x1+5x2+3x3 St x1+3x2+x3<=3 -x1+ 3x3<=2 2x1-x2 +2x3<=4 2x1+3x2-x3<=2 xi>=0 for...
Consider the following linear program Max 5x1+5x2+3x3 St x1+3x2+x3<=3 -x1+ 3x3<=2 2x1-x2 +2x3<=4 2x1+3x2-x3<=2 xi>=0 for i=1,2,3 Suppose that while solving this problem with Simplex method, you arrive at the following table: z x1 x2 x3 x4 x5 x6 x7 rhs Row0 1 0 -29/6 0 0 0 11/6 2/3 26/3 Row1 0 0 -4/3 1 0 0 1/3 -1/3 2/3 Row2 0 1 5/6 0 0 0 1/6 1/3 4/3 Row3 0 0 7/2 0 1 0 -1/2 0...
7) Consider the following regression model Yi = β0 + β1X1i + β2X2i + β3X3i + ...
7) Consider the following regression model Yi = β0 + β1X1i + β2X2i + β3X3i + β4X4i + β5X5i + ui This model has been estimated by OLS. The Gretl output is below. Model 1: OLS, using observations 1-52 coefficient std. error t-ratio p-value const -0.5186 0.8624 -0.6013 0.5506 X1 0.1497 0.4125 0.3630 0.7182 X2 -0.2710 0.1714 -1.5808 0.1208 X3 0.1809 0.6028 0.3001 0.7654 X4 0.4574 0.2729 1.6757 0.1006 X5 2.4438 0.1781 13.7200 0.0000 Mean dependent var 1.3617 S.D. dependent...
The following table provides data for 20 samples each of size five. Sample x1 x2 x3...
The following table provides data for 20 samples each of size five. Sample x1 x2 x3 x4 x5 1 4.960 4.946 4.950 4.956 4.958 2 4.958 4.927 4.935 4.940 4.950 3 4.971 4.929 4.965 4.952 4.938 4 4.940 4.982 4.970 4.953 4.960 5 4.964 4.950 4.953 4.962 4.956 6 4.969 4.951 4.955 4.966 4.954 7 4.960 4.944 4.957 4.948 4.951 8 4.969 4.949 4.963 4.952 4.962 9 4.984 4.928 4.960 4.943 4.955 10 4.970 4.934 4.961 4.940 4.965 11 4.975...
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 29 12 95 46 10 109 24 17 113 50 17 178 40 5 94 52 19 176 74 7 170 36 13 118 59 13 143 76 16 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1. y^=_____ + _____x1 (fill in...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable. Determine the coefficient of...
By looking at the given x, y data pairs, determine if either ratio estimation, regression estimation,...
By looking at the given x, y data pairs, determine if either ratio estimation, regression estimation, difference estimation, or all of them can be used in estimating the y variable population total. Remember to look at the requirements for using each of these techniques and justify your answers based on these requirements. Sample x y 1 12 60 2 16 87 3 18 91 4 10 50 5 17 94 6 11 62 7 14 67 8 13 64 9...
1.    In a multiple regression model, the following coefficients were obtained: b0 = -10      b1 =...
1.    In a multiple regression model, the following coefficients were obtained: b0 = -10      b1 = 4.5     b2 = -6.0 a.    Write the equation of the estimated multiple regression model. (3 pts) b     Suppose a sample of 25 observations produces this result, SSE = 480. What is the estimated standard error of the estimate? (5 pts) 2.    Consider the following estimated sample regression equation: Y = 12 + 6X1 -- 3 X2 Determine which of the following statements are true,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT