Question

price	# of bids
108	12
131	13
136	16
142	17
158	19

1. What is the Standard Error of the Regression Model?

2. Find the estimated y-intercept.  

3. Find the estimated slope.  

4. What is the Total Sum of Squares?

5. What is the R-square Value of the regression model?

6. What is the Sum of Squares for the Regression?

7. Using your regression output. What is the predicted number of bids (excluding error) when the price is $155?

8. Based upon the Price in Dollars, using an alpha level at 0.05, evaluate the P-value for significance. Does this model test to be significant? Chose your answer based upon the Regression Data output.

9. Using your regression output. What is the predicted number of bids (excluding error) when the price is $125?

10. What is the Sum of Squares for Error?

Answer 1

from excel: data-data analysis: regression":

below is regression output:

Regression Statistics
Multiple R	0.934852
R Square	0.873949
Adjusted R Square	0.831932
Standard Error	1.181086
Observations	5
ANOVA
	df	SS	MS	F	Significance F
Regression	1	29.01511	29.01511	20.79988	0.019765
Residual	3	4.184894	1.394965
Total	4	33.2
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-4.58489	4.413709	-1.03878	0.375274	-18.6313	9.461499	-18.6313	9.461499
price	0.148036	0.032459	4.560689	0.019765	0.044737	0.251336	0.044737	0.251336

1)  Standard Error of the Regression Model =1.1811

2)y intercept=-4.5849

3)estimated slope=0.1480

4) Total Sum of Squares =33.2
5) R-square Value of the regression model =0.8739

6) Sum of Squares for the Regression =29.0151

7) predicted value =18.3607

8) p value =0.0198

since p value <0.05 ; model is significant

9()

predicted value =13.9196

10)Sum of Squares for Error=4.1849