** if there is not enough evidence to fill in the formula please clarify. TabShiftCapsLkNQuestion 8 of 9. Step 1 of 1171875156938151425205992135600187937F155392149063187880DEN HOULive 013021"1Q1730021A51523AnswerHow to enter your answer topens in new windowSelecting a checkbox will replace the entered amerSALARY,=@2NWS310X0E010010DAsSteR(F%5EXPERIENCETV6G6/10CorrectY0B11000000&7Hof the checkbor is not selected the entered answer is usedSERVICE,+UN●8J1(9KMO0000101101TablesKeypadXeyboard ShortcutsINDUSTRIAL,PASubmit AnswerStGY11PRODOC250 PL12/5/20Pale CapsLkSuppose the following data were collected from a sample of 15 CEOS relating annual salary to years of experience and the economic sector their company belongs toUse statistical software to find the following regression equation:SALARY,= b + b, EXPERIENCE, + b₂SERVICE, + b,INDUSTRIAL, +Is there enough evidence to support the claim that on average, CEOs in the service sector have lower salaries than CEOS in the financial sector at the 0.05 level ofsignificance? If yes, write the regression equation in the spaces provided with answers rounded to two decimal places. Else. select "There is not enough evidence."1724EscSalary Experience143650161138212375141700133500150787171876N11QA1225298117anOP2Service (1 if service sector. Ootherwise)0S+43#0D0011$EW4RFאת%5O.TCEO SalariesIndustrial (1 if industrial sector, 0otherwise)1(6GY&7H10100CaU*8JW11(9Financial (1 if financial sector, 0otherwise)0O001000PCopy DataSubmit Answer:1+1t11124PM12/200911²OSTE

The hypothesis test is used to test the claim statistically. The test statistics and the critical value or the -value are used to find the conclusion about the hypothesis.The problem have the salary of the CEO in the service sector, finance sector, and industrial sector.The objective is to test whether the CEO in the service sector has a lower salary than the CEO in the finance sector.The hypothesis of the test is the salary of the CEO in the service sector and the finance sector is the same. The salary of the CEO in the service sector has a lower salary than the CEO in the finance sector.Let, salary of the CEO in the service sector salary of the CEO in the finance sector.The calculation table,X1X2(X1-mean)^2(X2-mean)^21335002123752150622255044426161507872059926874884258463498.21718751879375621641003913275.2413560015539215787922511918513381490631878808064044142039.047408259495769427868381962812767There is no assumption about the equality of the population variance.Take a ratio of the higher variance to the smaller variance as'If the ratio is less than, then by rule of thumb, the population variance is assumed to be the same.The pooled variance isthe test statistics isThe degrees of freedom for the test statistics isUse the command to find the -valueCommandT.DIST(-3.4638,8,TRUE)Value0.00426Decision rule:If, then reject.., reject the..The salary of the CEO in the service sector has a lower salary than the CEO in the finance sector.The regression model of the data isUse the Excel command to estimate the regression coefficients.CommandLINEST(A1:A16,B1:E16)Value157300.31509.948-28764.6-31395.3The fitted regression model isThe test statistics is the -value is the fitted regression model is