2. [40% ] A growing city has installed a monorail system connecting the down- town to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. [40% ] A growing city has installed a monorail system connecting the down- town to its international airport. It has been tracking daily monorail passenger load for the last 5 years. The monorail operates 7 days per week, 52 weeks per year. The data containing the daily passenger load for each week is in file BA3653M3Monorail.xlsx, accompanying this midterm. (a) Calculate the total number of passengers per week for each week in the data. Using this total, obtain the trend projection with regression that models the monorail passenger load growth (on a weekly basis). (b) Is a trendline appropriate for this situation? Calculate the coefficient of determination to show that a trendline is appropriate. (c) Daily passenger usage varies during the week. Use the seasonal index method to create a model that can predict the daily passenger load for any given week. (d) The city considers that any passenger load larger than 50,000 passen- gers per week will require the expansion of the monorail network. Esti- mate approximately how many weeks it will take for this situation to be reached given the current level of passenger load growth. (e) Engineers estimate that it will take 3 years to complete the monorail ex- pansion. Calculate what the passenger load will be 3 years (153 weeks) after the expansion. Obtain the passenger load for the busiest day on that week. (f) A daily usage larger than 10,000 passengers/day will overwhelm the monorail and cause a bottleneck. Will the current plan (begin expansion at 50,000 passengers/week) cause a bottleneck? Is your recommendation that the plan be followed, or should it be revised? 2. [40% ] A growing city has installed a monorail system connecting the down- town to its international airport. It has been tracking daily monorail passenger load for the last 5 years. The monorail operates 7 days per week, 52 weeks per year. The data containing the daily passenger load for each week is in file BA3653M3Monorail.xlsx, accompanying this midterm. (a) Calculate the total number of passengers per week for each week in the data. Using this total, obtain the trend projection with regression that models the monorail passenger load growth (on a weekly basis). (b) Is a trendline appropriate for this situation? Calculate the coefficient of determination to show that a trendline is appropriate. (c) Daily passenger usage varies during the week. Use the seasonal index method to create a model that can predict the daily passenger load for any given week. (d) The city considers that any passenger load larger than 50,000 passen- gers per week will require the expansion of the monorail network. Esti- mate approximately how many weeks it will take for this situation to be reached given the current level of passenger load growth. (e) Engineers estimate that it will take 3 years to complete the monorail ex- pansion. Calculate what the passenger load will be 3 years (153 weeks) after the expansion. Obtain the passenger load for the busiest day on that week. (f) A daily usage larger than 10,000 passengers/day will overwhelm the monorail and cause a bottleneck. Will the current plan (begin expansion at 50,000 passengers/week) cause a bottleneck? Is your recommendation that the plan be followed, or should it be revised?
Expert Answer:
Answer rating: 100% (QA)
solution a Weekly Passenger Load Week 1 34444 Week 2 33425 Week 3 32375 Week 4 32025 Week 5 33150 Total Passenger Load 164419 Regression Model y a bx ... View the full answer
Related Book For
Financial Markets and Institutions
ISBN: 978-0077861667
6th edition
Authors: Anthony Saunders , Marcia Cornett
Posted Date:
Students also viewed these accounting questions
-
The Pedal Pusher Bicycle Shop operates 7 days per week, closing only on Christmas Day. The shop pays $300 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle...
-
Calculate the total number of germ-line-encoded VH and VL domains that can be constructed from the available Ig genes. Compare this to the numbers of germ-line-encoded V and V domains of the TCR. How...
-
Calculate the total number of electrons that can occupy (a) One s orbital, (b) Three p orbitals, (c) Five dorbitals, (d) Seven forbitals.
-
Consider the following limit order book for a stock.The last trade in the stock occurred at a price of $55. Buy Order Limit Sell Order Limit Precio share Precio share ps 54.75 500 ps 55.25 200 54.50...
-
The American black bear (Ursus americanus) is one of eight bear species in the world. It is the smallest North American bear and the most common bear species on the planet. In 1969, Dr. Michael R....
-
The following chart depicts the earnings in billions of dollars for ExxonMobil for the period 2003 until 2014. Write a brief report discussing the earnings at ExxonMobil during the period. Was one...
-
A shear layer between two fluids. Assume the following velocity distribution between two shear layers: \[v_{x}(y)=v_{0} \tanh (y / \delta)\] This is known as the Betchov and Criminale form. Calculate...
-
Neutron Stars and Super nova Remnants the Crab Nebula is a cloud of glowing gas about 10 light-years across, located about 6500 light years from the earth (Fig. 9.39). It is the remnant of a star...
-
Discuss your experience with the creation of user and group accounts in other OSs such as Windows 10 or Windows Server 2019. What do you feel are some of the advantages and disadvantages of the...
-
The financial statements of Merdana Trading Ltd. are given below: 2014 2013 2014 2013 Cash and Cash Equivalents 12,250 10,470 Total Assets 128,980 113,110 Receivables 9,065 8,055 Inventory 6,620...
-
What are the molecular mechanisms underlying the circadian rhythm and how do disruptions in circadian regulation contribute to metabolic disorders, cancer susceptibility, and overall health outcomes?
-
Lets say you are managing animals at a veterinary hospital using a new software application. Which metadata attributes would be best managed with an annotation? (Choose two.) A. The number of animals...
-
Suppose we have an empty bunny table with two columns: name and color. What is the state of the table after running this code? A. It has one row. B. It has two rows, and the color is Brown in both....
-
Given the following three class declarations, which sets of access modifiers can be inserted, in order, into the following blank lines that would allow all of the classes to compile? (Choose three.)...
-
How many of these module declarations are valid? A. None. B. One. C. Two. D. Three. E. Four. F. Five. module com.apple { exports com.apple; } module com.4apple { requires com.apple;} module...
-
Suppose the pandas table has one row with the name Mei Xiang and the location DC. What does the following code output? A. Mei Xiang B. No match C. The code does not compile due to line s1. D. The...
-
3. Define a variable y from 0 to 20 with steps of 0.2. Also, define the time variable t from 0 to 10 with steps of 0.1. Plot the graph of y v/s t. a. Label the x-axis and y-axis. 4. Write the...
-
Imagine a sound wave with a frequency of 1.10 kHz propagating with a speed of 330 m/s. Determine the phase difference in radians between any two points on the wave separated by 10.0 cm.
-
Bank 1 can issue five-year CDs at an annual rate of 11 percent fixed or at a variable rate of LIBOR + 2 percent. Bank 2 can issue five-year CDs at an annual fixed rate of 13 percent or at a variable...
-
Consider an investor who, on January 1, 2016, purchases a TIPS bond with an original principal of $ 100,000, an 8 percent annual (or 4 percent semiannual) coupon rate, and 10 years to maturity. a. If...
-
Consider a 12-year, 12 percent annual coupon bond with a required rate of return of 10 percent. The bond has a face value of $ 1,000. a. What is the fair present value of the bond? b. If the required...
-
A 1.0-cm-diameter sphere is charged to a potential of \(3400 \mathrm{~V}\). How much charge is on the sphere?
-
a. What is the potential difference between the terminals of an ordinary AA or AAA battery? (If you're not sure, find one and look at the label.) b. An AA battery is connected to a parallel-plate...
-
\(\mathrm{A}+25 \mathrm{nC}\) charge is at the origin. How much farther from the charge is the \(2000 \mathrm{~V}\) equipotential surface than the \(3000 \mathrm{~V}\) surface?
Study smarter with the SolutionInn App