Hi, I need to have a cross sectional data in order to do regression analysis. and...

Hi,

I need to have a cross sectional data in order to do regression analysis. and the data should be as follows. and i cant find the data online.

note: the data can be for any product

Observation I	Quantity Demanded/Sold Y	Price X₁	Income/person X₂	Price of Substitutes X₃	Price of Complements X₄
1	265.2	12.0	6	17	0
2	279.6	20.2	7	18	0
3	311.2	27.0	7	17	1
4	328.0	30.0	8	18	1
5	352.0	30.0	8	15	1
6	281.2	21.4	8	20	1
7	288.4	21.6	7	8	0
8	292.8	25.2	7	15	1
9	356.0	37.2	9	31	1
10	263.2	14.4	7	8	0
11	272.4	15.0	7	17	0
12	291.2	22.4	6	9	0
13	299.6	23.9	7	20	1
14	307.6	26.6	6	23	1
At Least 30	320.4	30.7	7	23	1

Expert Solution

using excel>addin>phstat>Regression

we have

Regression Analysis

Regression Statistics
Multiple R	0.944947372
R Square	0.892925536
Adjusted R Square	0.850095751
Standard Error	11.13462078
Observations	15

ANOVA
	df	SS	MS	F	Significance F
Regression	4	10339.03953	2584.759883	20.84823738	7.69113E-05
Residual	10	1239.7978	123.97978
Total	14	11578.83733

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	185.2648642	27.48349362	6.740950288	5.09894E-05	124.0278243	246.5019041
X1	3.92143217	0.755261838	5.192149229	0.000405877	2.238603925	5.604260414
X2	3.585118059	4.470708295	0.801912767	0.441243018	-6.376240789	13.54647691
X3	-0.118144737	0.640698242	-0.184399971	0.857385546	-1.545709383	1.309419909
X4	-2.83169472	9.716503777	-0.291431443	0.776676987	-24.48141429	18.81802485

the regression equation is

y = 185.27 +3.92 X1 3.59 X2 -0.12 X3 -2.83 X4

orchestra answered 2 years ago

a. Upon reviewing the results of a multiple regression involving 30 observations on cross sectional data...

a. Upon reviewing the results of a multiple regression involving 30 observations on cross sectional data the Econometric Society suspected that the variances of the error terms might be related to the predicted values of the dependent variable. Alarmed by the prospects they quickly ran a simple regression yielding the following results: ei 2 = 10.956 + 3.068?̂? R 2 = 0.096 Using hypothesis testing, test at a 5% level to see if the variance of error terms is related...

a. Upon reviewing the results of a multiple regression involving 30 observations on cross-sectional data the...

a. Upon reviewing the results of a multiple regression involving 30 observations on cross-sectional data the Econometric Society suspected that the variances of the error terms might be related to the predicted values of the dependent variable. Alarmed by the prospects they quickly ran a simple regression yielding the following results: ei2 = 10.956 + 3.068?̂? R2 = 0.096 Using hypothesis testing, test at a 5% level to see if the variance of error terms is related to the predicted...

Discuss panel data and the use of pooled cross-sectional analysis and give an example of a...

Discuss panel data and the use of pooled cross-sectional analysis and give an example of a research question. Then discuss and predict the outcomes with the use of panel data and the use of pooled cross-sectional analysis for that same research.

Put the Cross-Sectional investments algorithm steps in the correct order. (i) Buy the winners and sell...

Put the Cross-Sectional investments algorithm steps in the correct order. (i) Buy the winners and sell the losers. (ii) Rank assets based on their performance in the recent K periods. (iii) Set the look-back period, K. (iv) Calculate the K-period return for each asset. (v) Consider the universe of N assets. Select one: a. (iv), (v), (ii), (i), (iii) b. (v), (iii), (iv), (ii), (i) c. (iii), (v), (iv), (ii), (i) d. (v), (iii), (ii), (iv), (i)

In Nonlinear regression analysis, if we have a data set and if we need to model...

In Nonlinear regression analysis, if we have a data set and if we need to model nonlinear, once we enter the data either in R or SPSS software we observe the results, but we cannot see the exact equation as we can write for linear regression.as an example if we want to see the relationship between Sales the response variable and the advertising budget for TV media and News paper we have to independent variables,once the data we entered how...

why cross sectional regression rule out perfect collinearity among the regressors

I have a solid square aluminum beam. It is 12 inches long with cross sectional area...

I have a solid square aluminum beam. It is 12 inches long with cross sectional area .25" x .25". A force is applied to the center of the rod and supported at the ends. I need to know the maximum force before the aluminum fails. Equations and work done would be great so I can change the length and cross section if needed bigger or smaller max load.

Hi there, I need mpx2100ap arduino code do I need an amplifier to make this work...

Hi there, I need mpx2100ap arduino code do I need an amplifier to make this work ?

The target company is First Data, it was acquired by Fiserv. I need to do analysis...

The target company is First Data, it was acquired by Fiserv. I need to do analysis of the First Data company. Why it was acquired by Fiserv. The CEO of the company is looking for some expansion opportunities. He/She approaches the corporate finance division within the company for advice. Suppose you are one of the analysts in the corporate finance team. Your job is to identify a potential takeover target for the company and outline the reasons why such an...

Where would I need to go and what would I need to do in order to...

Where would I need to go and what would I need to do in order to obtain the trademark? (please list all of the steps for this process from beginning to end)

Question