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

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.

  1. 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.
  2. Discuss the relationship between the data and the expected trend line you see in part 1. Do the data points suggest a strong relationship?
  3. Create a scatter plot that illustrates the occupancy rate and the rate change recommended. Include a descriptive chart title, axes labels, and properly formatted axes in the chart.
  4. Discuss the relationships you see in part 3. What does the date data suggest about the rate recommendations as compared to the occupancy rate?

Submit the provided Excel spreadsheet containing your answers to each of the above requirements. Use Excel functions to make any required calculations described in the requirements. Post your completed Excel spreadsheet containing your answers for your instructor to grade. 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) reporting evaluates financial, social, and environmental impacts, providing a broader view of a company’s sustainability and long-term value creation. In analyzing trends over five years of financial

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional a

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important for making informed decisions that balance financial performance with social and environmental responsibility. It helps managers align strategies with sustainability goals, drive innovation, and support

Option #2: Ace Fertilizer Company: Ethical Cost Allocations and Price Determination Read the case: Kreuze, J. (2009, September). Ace fertilizer company:

Option #2: Ace Fertilizer Company: Ethical Cost Allocations and Price Determination Read the case: Kreuze, J. (2009, September). Ace fertilizer company: Ethical cost allocations and price determination.Links to an external site..  IMA Educational Case Journal, 2(3), ART. 3. Case Requirements: Prepare a paper and address the following questions: Did Abby compute the

The Association of Certified Fraud Examiners (ACFE) has excellent resources including: white papers from industry-leading companies on emerging trends in

The Association of Certified Fraud Examiners (ACFE) has excellent resources including: white papers from industry-leading companies on emerging trends in the fraud industry, tips to stay ahead of fraudsters, and industry-specific strategies to stay current in the forensic accounting and fraud examination professions. Review the free white papers from the ACFELinks to