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

Choose TWO of the following passages: Genesis 3:1-7; Exodus 14:1-12; Leviticus 16:29-34; Numbers 14:11-19; Deuteronomy 30:15-20, and provide a one-page

Choose TWO of the following passages: Genesis 3:1-7; Exodus 14:1-12; Leviticus 16:29-34; Numbers 14:11-19; Deuteronomy 30:15-20, and provide a one-page interpretation of the passage for each based on what you have learned/acquired from the previous assignments performed for this course. As part of this presentation, a clear and concise principle

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following

First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an emergency

Instructions First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the

Instructions First, create an outline or concept map that summarizes your communication plan for a significant organizational change or event. Consider the following examples: a new company branding initiative; the restructuring of a team, department or business unit; a company-wide community service project; the transition of an executive leader; an

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of business. Create the business case: ·        Determine why funding is needed for the company. ·        Determine the sources of funding. Consider self-funding, borrowing, equity, venture capital, and so on.

Wells Fargo Case Study BACKGROUND: In fall of 2016 federal regulators accused Wells Fargo of falsely opening over 2 million customer credit card and

Wells Fargo Case Study BACKGROUND: In fall of 2016 federal regulators accused Wells Fargo of falsely opening over 2 million customer credit card and checking accounts to meet unrealistic sales quotas (http://money.cnn.com/2016/09/08/investing/wells-fargo-created-phony-accounts-bank-fees/?iid=EL, September 4, 2017).  Since then, Wells Fargo has also been accused of forcing over 500,000 customers into auto insurance policies they did notneed,

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital information to various stakeholders, including investors, creditors, management, and government agencies, enabling them to make informed decisions. Here’s a breakdown of key aspects within accounting: Financial Statements: These are the

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of

Comp 3 = Fin Review Walmart’s Financials and Business Model. Revised the attached paper with the requirments. Describe the business, including the type of business. Create the business case: ·        Determine why funding is needed for the company. ·        Determine the sources of funding. Consider self-funding, borrowing, equity, venture capital, and so on.