Question

For the data set shown​ below, complete parts ​(a) through ​(d)

below.

x	2020	3030	4040	5050	6060
y	9898	9595	8989	8383	6868

​(a) Use technology to find the estimates of

beta 0β0

and

beta 1β1.

beta 0β0almost equals≈b 0b0equals=nothing

​(Round to two decimal places as​ needed.)

beta 1β1almost equals≈b 1b1equals=nothing

​(Round to two decimal places as​ needed.)

Answer 1

we shall use excel to answer this , we enter the data in excel and then goto data > data analysis tab and select regression

Data Analysis 3 2020 89Alyis Tools 3030 9595 OK Histogram Moving Average Random Number Generation Rank and Percentile Regression Cancel 50508383 Help 6868Sampling t-Test: Paired Two Sample for Means t-Test: Two-Sample Assuming Equal Variances t-Test: Two-Sample Assuming Unequal Variances z-Test: Two Sample for Means

The regression equation is formed using the coefficient as

Y = 11655.4 -0.72*x

hypothesis for B0 and B1

H0 : The value of Beta is not sigificant
H1: The value of Beta is statistically signficant

if the p value is less than 0.,05 (assumed alpha) then we reject the null hypothesis in favor of alternate hypothesis to conclude that the results are signficant

we see the p value for intercept is 0.000212 and for x it is 0.0103 , which are less than 0.05 and hence significant