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

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 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 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 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.

Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit sides. Indicate next to each entry the

Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit sides. Indicate next to each entry the number for that transaction. After all transactions have been recorded, foot the accounts where necessary and enter the balance in the proper place for each

hello, I need help with an assignment: Overview An important aspect of federal income tax preparation for individuals is understanding the key terms

hello, I need help with an assignment: Overview An important aspect of federal income tax preparation for individuals is understanding the key terms associated with tax rate structures, marginal versus average tax rates, the income tax formula, and the components of a basic Form 1040. This assignment will allow you

Hello, I need help with a discussion: 1-1 Discussion: Introduction and Tax Avoidance Versus Tax Evasion Do you have any experience with tax preparation or

Hello, I need help with a discussion: 1-1 Discussion: Introduction and Tax Avoidance Versus Tax Evasion Do you have any experience with tax preparation or completing your own tax return? NO, I DON’T HAVE EXPERIENCE. (Please keep personal financial details confidential.) What did you learn or find interesting? If not,

How does Rupa Huq’s argument in “Rethinking Subculture” relate to Dick Hebdige’s understanding of subculture, as explained by Huq? Explain how Hebdige or

How does Rupa Huq’s argument in “Rethinking Subculture” relate to Dick Hebdige’s understanding of subculture, as explained by Huq? Explain how Hebdige or Huq’s understanding of style relates to how youth express identity and community today.

In 2013, the H.J. Heinz Corp. was considering an acquisition offer from Warren Buffett’s Berkshire Hathaway and 3G, a Brazilian private equity firm. Your

In 2013, the H.J. Heinz Corp. was considering an acquisition offer from Warren Buffett’s Berkshire Hathaway and 3G, a Brazilian private equity firm. Your valuation analysis will help Heinz negotiate for a fair price from its prospective acquirors. H. J. Heinz Company was incorporated in Pennsylvania on July 27, 1900.

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

PART 1 – MY BELIEFS: According to the New Oxford American Dictionary, ethics is defined as “moral principles that govern a person’s or group’s behavior.”

PART 1 – MY BELIEFS: According to the New Oxford American Dictionary, ethics is defined as “moral principles that govern a person’s or group’s behavior.” Therefore, in an ideal world, ethics should play the ultimate role when making a decision. If ethics are the principles which guides one’s behavior then, ideally,

An understanding of the factors surrounding women’s and men’s health can be critically important to disease diagnosis and treatment in these areas. This

An understanding of the factors surrounding women’s and men’s health can be critically important to disease diagnosis and treatment in these areas. This importance is magnified by the fact that some diseases and disorders manifest differently based on the sex of the patient. Effective disease analysis often requires an understanding

1. Task: Your task is to analyze (Assessment) Manipulation Application Data, and comment on ways that the data could be manipulated and transformed. Write

1. Task: Your task is to analyze (Assessment) Manipulation Application Data, and comment on ways that the data could be manipulated and transformed. Write a written reflection on the above b) i) What is the purpose of data manipulation? ii) What are the different data manipulations? iii) What are structure

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

Issue paper on a recent (within 2 years) international financial topic of your choice. The paper should be analytical rather than descriptive The paper

Issue paper on a recent (within 2 years) international financial topic of your choice. The paper should be analytical rather than descriptive The paper should be no longer than 3 pages, double spaced. The Internet is probably the best source of information (Wikipedia is not an acceptable source). The paper

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.