Our Services

Get 15% Discount on your First Order

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

December 8, 2024

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.

Accounting

Share This Post

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

Related Questions

MGMT 315 Marketing Campaign AssignmentI would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that

MGMT 315 Marketing Campaign AssignmentI would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that you give me some background as to what the company sells and who you are trying to reach, your campaign should target that audience. Think

I would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that you give me some background as to

I would like you to create a fictional company and present a marketing campaign to brand that company. Make sure that you give me some background as to what the company sells and who you are trying to reach, your campaign should target that audience. Think of yourself as a

Hello, I need help with the response to 2 peers on a discussion: When responding to your peers, acknowledge a statement that resonates with you in their

Hello, I need help with the response to 2 peers on a discussion: When responding to your peers, acknowledge a statement that resonates with you in their personal experience and ask a question about their approach. Peer 1 The actional best practice I chose to help promote diversity and equity

Hello I need help with a project: 4-2 Project One Milestone Two Guidelines and Rubric ACC 330 Project One Milestone Two Guidelines and Rubric Overview Tax

Hello I need help with a project: 4-2 Project One Milestone Two Guidelines and Rubric ACC 330 Project One Milestone Two Guidelines and Rubric Overview Tax organizers are used to help perform due diligence and provide an opportunity for tax planning. They assist in organizing the information provided by the

Hello, I need help with a discussion post: 4-1 Discussion: Etiquette of Business Communications Read the article linked below, which lists and describes

Hello, I need help with a discussion post: 4-1 Discussion: Etiquette of Business Communications Read the article linked below, which lists and describes actionable best practices to improve equity and inclusivity in the workplace. Discuss your personal experience with business communication and discuss possible ways to approach communicating in different

Account Excel 3. You will use the completed file from Accounting Excel 2. Complete requirements 11 through 12 of the Jane’s Skateboards case for the third

Account Excel 3. You will use the completed file from Accounting Excel 2. Complete requirements 11 through 12 of the Jane’s Skateboards case for the third milestone of the course project. Use the file you completed in milestone two.

Accounting Excel 2. You will use the completed file first from the previous assignment. Complete requirements 4 through 10 of the Jane’s Skateboards for

Accounting Excel 2. You will use the completed file first from the previous assignment. Complete requirements 4 through 10 of the Jane’s Skateboards for the second milestone of the course project. You will use the file you completed in milestone one. Make sure you updated the file if you received feedback

Instructions Complete the Budget in a Service Company (Cash Budget) assignment. Please use the template provided below. The document must have

Instructions Complete the Budget in a Service Company (Cash Budget) assignment.   Please use the template provided below. The document must have the complete budget and show the entire process along with an explanation. Add a brief explanation of the budget just like what you should do if you were in

InstructionsWrite a research paper. The assignment has two requirements: 1.) Select a publicly-traded company that is traded on U.S. exchange. Locate the a

InstructionsWrite a research paper. The assignment has two requirements: 1.) Select a publicly-traded company that is traded on U.S. exchange. Locate the annual report for at least the last three fiscal years.Analyze the financial statements for the company and review for large movements in specific accounts from one year to

Case Study PROGRAMME Bachelor of Business Administration Bachelor of Commerce in Supply Chain Management Bachelor of Commerce in Retail Management Bachelor

Case Study PROGRAMME Bachelor of Business Administration Bachelor of Commerce in Supply Chain Management Bachelor of Commerce in Retail Management Bachelor of Commerce in International Business MODULE Financial Planning and Control YEAR 3 (Three) INTAKE January 2024 Semester 1 Marks 30 Answer ALL questions. [30 MARKS] Read the following case

Hello, I need help with homework: Assume the taxpayer does NOT wish to contribute to the Presidential Election Fund, unless otherwise stated in the

Hello, I need help with homework: Assume the taxpayer does NOT wish to contribute to the Presidential Election Fund, unless otherwise stated in the problem. In addition, the taxpayers did NOT receive, sell, send, exchange, or otherwise acquire any financial interest in any virtual currency during the year. Married taxpayers

Description A.M. Vegas started a business called Blazinsevens. The following is the Trial Balance as of December 31 on the first year of operations. Using

Description A.M. Vegas started a business called Blazinsevens. The following is the Trial Balance as of December 31 on the first year of operations. Using this information, please complete the remainder of the attached worksheet. Office supplies inventory as of December 31, $190. Unexpired insurance as of December 31, $700 Depreciation of

Hello, I need help with assignment: Module Three Assignment Guidelines and Rubric ACC 330 Module Three Assignment Guidelines and Rubric Overview Due

Hello, I need help with assignment: Module Three Assignment Guidelines and Rubric ACC 330 Module Three Assignment Guidelines and Rubric Overview Due diligence is the responsibility of a paid tax preparer. The Internal Revenue Service (IRS) created Form 8867 Paid Preparer’s Due Diligence Checklist for paid tax preparers to certify,

Hello, I need help with a project: Project One Milestone One Guidelines and Rubric ACC 330 Project One Milestone One Guidelines and Rubric Overview Each

Hello, I need help with a project: Project One Milestone One Guidelines and Rubric ACC 330 Project One Milestone One Guidelines and Rubric Overview Each year the Internal Revenue Service (IRS) updates the tax code and makes changes to standard documentation. Tax professionals can see sweeping changes over their career.

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a foreign currency such as the Mexican peso or the Indian rupee instead of investing it in the U.S. In April 2024, the latest central bank interest

Hello, I need help with a second assignment: Module Two Adjusted Gross Income Assignment Guidelines and Rubric ACC 330 Module Two Adjusted Gross Income

Hello, I need help with a second assignment: Module Two Adjusted Gross Income Assignment Guidelines and Rubric ACC 330 Module Two Adjusted Gross Income Assignment Guidelines and Rubric Overview Research is a big part of being a tax practitioner. Researching income and adjustments to income are critical for arriving at

Hello, I need help with an assignment: Module Two Income Assignment Guidelines and Rubric ACC 330 Module Two Income Assignment Guidelines and

Hello, I need help with an assignment: Module Two Income Assignment Guidelines and Rubric ACC 330 Module Two Income Assignment Guidelines and Rubric Overview Research is a big part of being a tax practitioner. Researching income and adjustments to income is critical for arriving at the adjusted gross income (AGI).

Hello, I need help with the response to my peers: Topic: Tax Avoidance Versus Tax Evasion Peer 1: Tax evasion refers to the act of taxpayers concealing

Hello, I need help with the response to my peers: Topic: Tax Avoidance Versus Tax Evasion Peer 1: Tax evasion refers to the act of taxpayers concealing portions or all their income through strategies such as altering financial information, falsifying revenue documents, or keeping relevant information from their tax advisor.