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

1) Prepare the following consolidation and equity accounting entries for Purple Co. and its subseries and Associate for the year ended 31 December

1) Prepare the following consolidation and equity accounting entries for Purple Co. and its subseries and Associate for the year ended 31 December 20X5.                                                                 CJE1: Elimination of investment in Yellow Co.; Dr. share capital (Yellow Co.) $ 3,120,000 Dr. Retained Earnings (Yellow Co.) $ 3,510,000 Dr. Goodwill $ 1,560,000 Cr.

Handy Headphones is an Irish company that is manufacturing lightweight, flexible, Bluetooth[1] enabled and waterproof headphones. It is proving to be

Handy Headphones is an Irish company that is manufacturing lightweight, flexible, Bluetooth[1] enabled and waterproof headphones. It is proving to be very popular among people wanting to listen to music in the shower or while swimming on holiday or at community leisure centers lane swimming sessions (mainly because of their 159 price tag). Before the

Module 5: Discussion Forum In this week’s Required Readings from your course textbook, you have a specific and detailed example of hedging a forecasted for

Module 5: Discussion Forum In this week’s Required Readings from your course textbook, you have a specific and detailed example of hedging a forecasted foreign currency transaction to hedge an anticipated but not yet committed purchase of inventory using a foreign currency cash flow hedge (Case 3 on Pages 572-574) and hedging an unrecognized foreign

Hsjusbsbsbdhdhene

Hsjusbsbsbdhdhene sbsndndnjxjxjfkdjdjsisiiseiieiejrjdjiejeuieiejjeejgeygvwcwcwcxxqxfaajannsmsmsmsowlwbsvshsiwhejeowjsegheieududhtwiwowpwbwjeuebibjsiebuebeiebsuebwowbwiebeibsowbwo93hshshshhsbebsjsjshshdyehdhdhdrjrjdirbdjdjbdjdbejsebeiuwgdidhd8dbdbdjdbbdmmsjshejueusowowjw9qgwiehegeiehejeoejeiehe9ejejeheiehdidbsjduueehueehjeehsusjsienienbsgshduevgtwhwowpebdbjoabeheiwvueeksvejeenejdbuhdbeoe eiennejejejebsjisejeoejbdjdbebddonbsheeiejiejeijeje ejeieiehgeeiejeu9ewhe8hh

You should refer to the FASB Accounting Standards Codification (FASB ASC), specifically, when answering some of the questions below: For foreign-currency

You should refer to the FASB Accounting Standards Codification (FASB ASC), specifically, when answering some of the questions below: For foreign-currency related transactions, whether they are accounts receivable or accounts payable denominated in a foreign currency, describe briefly how such transactions are recorded and reported on the income statement when