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 publi

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 a descriptive chart title, axes labels, and properly formatted axes in the chart.
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

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

Related Questions

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of th

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of the file. Worksheet Problem 1 Gulf Coast Paddle produces paddleboards for retailers in the United States. The cost of

Payroll cycle assessment word doc – Attached Payroll Process Template – Attached Complete Payroll Process Assignment – attached is the word document with the instructions for xlsx spreadsheet.

Deductions & journal Entries – attached Employer’s Annual Pay Tax Return Assessment word doc. has instructions for the: Attached employer’s Annual FUTA Tax Return – Attached Schedule A – Attached

Deductions & journal Entries – attached Employer’s Annual Pay Tax Return Assessment word doc. has instructions for the: Attached employer’s Annual FUTA Tax Return – Attached Schedule A – Attached

I have a project due August 3rd For my Financial Management class. I have attached the file for the rubric. I want to do it on the company Adidas.

Therapeutic Meal Plan Presentation for Gastrointestinal Disorders NRG275 – NutritionAssignment Title: Therapeutic Meal Plan Presentation for Gastrointestinal DisordersDue Date: [Insert Date]Submission

Therapeutic Meal Plan Presentation for Gastrointestinal Disorders NRG275 – NutritionAssignment Title: Therapeutic Meal Plan Presentation for Gastrointestinal DisordersDue Date: [Insert Date]Submission Format: PowerPoint Presentation (.pptx or .pdf) Dear Students, You are required to create a PowerPoint presentation on therapeutic meal planning for gastrointestinal (GI) disorders. This assignment is designed to

Module 4 – SLPEthics and TrendsAssignment OverviewEthical Dilemma Understanding how to address ethical dilemmas in accounting, even if you’re not in the accounting department, is important for organiz

Module 4 – SLPEthics and TrendsAssignment OverviewEthical Dilemma Understanding how to address ethical dilemmas in accounting, even if you’re not in the accounting department, is important for organizational integrity. It ensures compliance, fosters transparency, and protects the company from legal and reputational risks. Ethical awareness supports responsible decision-making across all

Module 4 – CaseEthics and TrendsAssignment OverviewTrends The evolving role of AI in accounting automates tasks, reduces errors, and enhances decision-making, allowing non-accounting professionals to

Module 4 – CaseEthics and TrendsAssignment OverviewTrends The evolving role of AI in accounting automates tasks, reduces errors, and enhances decision-making, allowing non-accounting professionals to focus on strategic business activities. Big data enables faster, more accurate financial decisions, helping professionals interpret trends and optimize resource use. At the same time,

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and present a recommendation to help leadership make a loan decision. Collapse AllIntroduction This portfolio work project will

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You will research reasons for the changes and develop a multifaceted economic analysis. Case 1 Resources Introduction to

Computing Salaries Assignment – Assignment Attached Employer Quarterly Payroll Tax Return Assignment .docx & Form 941 – Quarterly Payroll Tax Form.pdf – attached (these go together)

Coronado comlany produces 2 products, flower and planter. flower is a high-volume item totaling 20000 units annually. planter is low-volume item totalling only 6000 unites per year. flower requires 1

Coronado comlany produces 2 products, flower and planter. flower is a high-volume item totaling 20000 units annually. planter is low-volume item totalling only 6000 unites per year. flower requires 1 hour of direct labor for completion, while each unit of planter requires 2 hours. Therefore, total annual direct labor hours

Module 3 – CaseTransfer Pricing and Responsibility CentersAssignment OverviewTransfer Pricing In recent years, high-profile cases involving companies like Apple (Ireland, 2016), Amazon (Luxembourg. 20

Module 3 – CaseTransfer Pricing and Responsibility CentersAssignment OverviewTransfer Pricing In recent years, high-profile cases involving companies like Apple (Ireland, 2016), Amazon (Luxembourg. 2017), and Starbucks (UK, 2012) have highlighted the risks of using aggressive transfer pricing to minimize taxes. These companies faced public backlash and government scrutiny for shifting

Module 3 – SLPTransfer Pricing and Responsibility CentersAssignment OverviewBlock Chain Blockchain enhances financial transactions by providing transparent, secure, and immutable records, reducing in

Module 3 – SLPTransfer Pricing and Responsibility CentersAssignment OverviewBlock Chain Blockchain enhances financial transactions by providing transparent, secure, and immutable records, reducing intermediaries and fraud risk. In accounting, it automates auditing, reduces errors, and increases transparency with real-time, tamper-proof data. Blockchain also plays a critical role in preventing financial fraud

attached is the Payroll Records & Procedures assignment

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of th

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting hel

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting help aid associations make tough choices in Haiti?Links to an external site. Issues in Accounting Education, 33(1), 17–28. Answer the following questions:

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting hel

Professional judgment frameworkAccounting for income taxes—valuation allowanceBackground Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asba

Professional judgment frameworkAccounting for income taxes—valuation allowanceBackground Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asbat has a calendar year-end and is audited annually. Asbat only operates in the United States and is not subject to state or local income taxation. Its