using this questions explain how you would coach this question by giving explanation and not in regression plots.

for example: what is asking and how to answer

2. The weekly utilization data is provided in the Excel data file on the BUS 302 website. Create scatter plots to show the relationships between the number of employees, number of visits per week, and total physician costs. Calculate visits per employee and the cost per visit for each week. Calculate the mean and standard deviation for these measures for this six-month period. Explain how these statistics are useful in understanding the trend in total outpatient physician costs per Sparks Interactive employee. Q. 3. Regression analysis can be useful to tease out the importance of various factors in explaining costs. a. Evaluate the relationship between visits per week and week. Interpret your regression results by discussing the significance of the regression equation and the magnitude of the estimated coefficients. b. Evaluate the relationship between cost per visit and week. Interpret your regression results by discussing the significance of the regression equation and the magnitude of the estimated coefficients. c. Compare the results from the two regressions and explain how they can be used to help Mr. Green in making his decision.