Question

car ded analysis etermind The accompanying table shows the number of cars sold last month by seven employees at a car dealership and their number of years of sales experience Management would like to use simple regression analysis to estimate monthly car sales using the number of years of sales experience. Which one of the following statements describes the results of the hypothesis test that population correlation coefficient is greater than zero, using 0.05? Click the icon to view the car sales data. at a dealer alysis to es or the regre O A. Because the absolute value of the test statistic is less than the absolute value of the critical value, we can reject the null hypothesis and conclude that a relationship exists between car sales and years of sales experience in the population O B. Because the absolute value of the test statistic is less than the absolute value of the critical value, we fail to reject the null hypothesis and cannot conclude that a relationship exists between car sales and years of sales experience in the population OC. Because the absolute value of the test statistic is greater than the absolute value of the critical value, we fail to reject the null hypothesis and conclude that a relationship exists between car sales and years of sales experience in the population. D. Because the absolute value of the test statistic is greater than the absolute value of the critical value, we can reject the null hypothesis and cannot conclude that a relationship exists between car sales and years of sales experience in the population Click to

Answer 1

Sol;

Experience sales 1 8 6 N N st 7 14 correlation coefficiei =CORREL(C9:C15,D9:( 9 0.553354324 5 6 13 8 10

r=0.5534

df=n-2=7-2=5

critical correlation coeffcient,rc=0.754

absolte value of the correlation coeffcient is less than criitcal value

Fail to reject Ho

Cannot conclude that relationship exists between experience and sales

ANSWER:

OPTION(B)