As presented in the chapter, the City of San Francisco uses data analytics to regularly update its parking rates. In addition, because it is a governmental agency, their data is available to the public. Excerpts from the public data concerning its changes in pricing for October 2021 are presented in the Excel file and include the location, the type of meter class, the date type as weekend versus weekday, time of day, occupancy rate, the original parking rate, the proposed change to the parking rate, and the final rate after adjustment. Module 4 CTA Excel File TemplateDownload Module 4 CTA Excel File Template Requirements There are four parts to this problem. Use Excel and the Excel file provided to perform the following. Create a scatter plot that illustrates the occupancy rate and the final parking rate charged. Add a trendline, the equation of the line, and R-squared. Include a descriptive chart title, axes labels, and properly formatted axes in the chart. Discuss the relationship between the data and the expected trend line you see in part 1. Do the data points suggest a strong relationship? Create a scatter plot that illustrates the occupancy rate and the rate change recommended. Include