Question

Please help me solve this question using Excel data!! (attached on bottom) Thank you!!!

Question 2 5 pts Continuing with our data visualization, create a scatterplot with the total number of check-ins (TotCheckins) on the y-axis and the average ratings (AvgRating) on the x-axis. Be sure that the equation for the trend line and the r value are shown on the scatterplot. While your plot may be different aesthetically, which of the following is an accurate representation of the data? Are Better Bars Busier? 30 Are Better Bars Busier? 25 20 15 10 y-54.887x-91.176 R2-0.0494 -0.8222x +23.85 R2 0.0942 Average Rating Average Rating Are Better Bars Busier? Are Better Bars Busier? 120 100 1000 800 600 y 9.4777x+29.001 R2-0.1249 -55.66x-94.07 R2-0.0507 60 40 200 Average Rating Average Rating

Answer 1

a) The scatter plot for the given data is

3)The magnitude of the relationship is positive because it is having a positive slope.

For every one increment of rating the checkins will be increased by 55.66 times.

4)For a 3 star rating the number checkins expected will be 73.

5) For a 4 star rating the number checkins expected will be 128.56 approximated to 129.

6) For a 2 star rating the number checkins expected will be 17.

For a 3 star rating the number checkins expected will be 73.

The more checkins expected in 3 star vs 2 star = 73 - 17 = 56 checkins.