Listed below are amounts of bills for dinner and the amounts of the tips that were left. Construct a scatterplot, find the value of the linear correlation coefficient r, and find the P-value of r. Determine whether there is sufficient evidence to support a claim of linear correlationbetween the two variables. Use a significance level of α = 0.05. If everyone were to tip with the same percentage, what should be the value of r?69Bill (dollars)Tip (dollars)Construct a scatterplot. Choose the correct graph below.O A.은25-0++30HPOBill Amount ($)33.81 53.42 92.83 94.96 61.31 113.943.70 7.75 13.81 10.98 9.41 21.07120QQMThe linear correlation coefficient is r=(Round to three decimal places as needed.)Determine the null and alternative hypotheses.Ho: P▼H₁: pl(Type integers or decimals. Do not round.)The test statistic is t=.(Round to two decimal places as needed.)The P-value is(Round to three decimal places as needed.)Because the P-value of the linear correlation coefficient isIf everyone were to tip with the same percentage, then r =(Round to three decimal places as needed.)O B.Tip Amount ($)25-to30LP●Bill Amount ($)120Qthe significance level, thereCO C.25-o+0-30•.TOBill Amount (S)120QQ✔O D.Tip Amount ($)25-0+30•!1:UBill Amount (S)sufficient evidence to support the claim that there is a linear correlation between bill amounts and tip amounts.120QQ✔

Given that By using excel regression excel > data > data analysis > regression > input data > alpha0.05 > output > enter. a) Consider bill as independent dollar tip as dependent dollar Scatterplot : Excel > data > input data > select > insert > charts > scatterplot Option B 33.81 3.7 SUMMARY OUTPUT 53.42 7.75 92.83 13.81 Regression Statistics 94.96 10.98 Multiple R 0.930177501 61.31 9.41 R Square 0.865230184 113.94 21.07 Adjusted R Square 0.83153773 Standard Error 2.432333586 Observations 6 ANOVA df SS MS F Significance F Regression 1 151.9306133 151.9306133 25.68023643 0.007142573 Residual 4 23.66498668 5.916246671 Total 5 175.5956 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -2.544704756 2.873528153 -0.885568061 0.425877753 -10.52289793 5.433488419 -10.52289793 5.433488419 X Variable 1 0.182086811 0.035931801 5.067567112 0.007142573 0.082324139 0.281849483 0.082324139 0.281849483 The linear correlation coefficient r = 0.930Hypothesis : Ho:p = 0H1:p≠0 Test statistics t = 5.07 p value = 0.007 Because the P-value of the linear correlation coefficient is less than the significance level, there is sufficient evidence to support the claim that there is a linear correlation between bill amounts and tip amounts. If everyone were to tip with the same percentage, then r = 1.000