Question

help please and thank you!

Price in Dollars Number of Bids $ 108 12 $131 13 $136 16 $142 17 $158 19 TABLE 1

Answer 1

we will use excel to find the solutions

For table 1

C. = sr - Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat B B connections 21 AR Y Clear Data Analysis 7 Reapply 2+ ZA At Sort DEE Te Das Group Ungroup Subtotal Show Detail Hide Detail From From Access Web From From Other Text Sources Get External Data Existing Connections Properties Refresh All Edit Links Connections Filter Advanced o Text to Remove Data Consolidate What If Columns Duplicates Validation Analysis Data Tools 1? x Sort & Filter Outline Analysis G7 Regression K L M N O Input Input Y Range: | $B$1:$B$6 ок Cancel price in Dollar 108 131 136 Number Of Bids 12 13 16 17 Input X Range: $A$1:$A$6| Help Constant is Zero 95 % V Labels ✓ Confidence Level: 142 158 Output options Output Range: New Worksheet Ply: New Workbook Residuals Residuals Standardized Residuals Residual Plots Line Fit Plots Normal Probability Normal Probability Plots K Sheet1 Sheet3 Sheet2 Sheet6 Sheets Sheet7 sheet4 M Enter OU 100% - - 9 0 - 40 tr * 4 6/2020

The output is

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.9349
R Square	0.8739
Adjusted R Square	0.8319
Standard Error	1.1811
Observations	5.0000
ANOVA
	df	SS	MS	F	Significance F
Regression	1.0000	29.0151	29.0151	20.7999	0.0198
Residual	3.0000	4.1849	1.3950
Total	4.0000	33.2000
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	-4.5849	4.4137	-1.0388	0.3753	-18.6313	9.4615
price in Dollar	0.1480	0.0325	4.5607	0.0198	0.0447	0.2513

Q3

R-square = 0.874

Q

when bid is $155

so we have regression equation

Number of bids = -4.5849+0.1480*Price

Number of bids = -4.5849+0.1480*155\

Number of bids =18.3551

Number of bids =18

For table 2

sr (version 1) (Autosaved] - Microsoft Excel C. - = Home Insert Page Layout Formulas Data Review View 21 AR Properties From From From From Other Existing Refresh At Sort Access Web Text Sources Connections All Edit Links Get External Data Connections E B connections Acrobat Y Filter Clear DEE Data Analysis Show Detail Hide Detail Reapply Advanced Group Ungroup Subtotal Text to Remove Data Consolidate What If Columns Duplicates Validation Analysis Data Tools Sort & Filter Outline Analysis B1 - A C D E F G H I J K M N O P Q R Regression 1 Completion Percentage Interception Percentage 59: 4.91 63! 64 4.2 Input Input Y Range: 3.1, $B$1:$B$6 OK Cancel 2.41 Input X Range: $A$1:$A$6 1.8 Help Labels Confidence Level: Constant is Zero 95 % Output options Output Range: New Worksheet Ply: New Workbook Residuals Residuals Standardized Residuals Residual Plots Line Fit Plots Normal Probability Normal Probability Plots Sheet3 Sheet2 Sheet6 Sheets Sheetz Sheets Sheet4 Sheet Ke Point Sheet1 Recovered OU 100% -

And the output is

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.8180
R Square	0.6691
Adjusted R Square	0.5588
Standard Error	0.8447
Observations	5.0000
ANOVA
	df	SS	MS	F	Significance F
Regression	1.0000	4.3277	4.3277	6.0659	0.0906
Residual	3.0000	2.1403	0.7134
Total	4.0000	6.4680
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	33.4106	12.2396	2.7297	0.0720	-5.5411	72.3624	-5.5411	72.3624
Completion Percentage	-0.4798	0.1948	-2.4629	0.0906	-1.0997	0.1402	-1.0997	0.1402

Q15

Error sum of square= 2.140

Q 15 95% confidence interval for slope

-1.0997