Question

In: Statistics and Probability

Freight car loadings over an 18-week period at a busy port are as follows: Week Number...

Freight car loadings over an 18-week period at a busy port are as follows:

Week Number Week Number Week Number
1 370 7 415 13 450
2 380 8 425 14 455
3 390 9 435 15 475
4 380 10 425 16 485
5 390 11 435 17 495
6 395 12 445 18 505


a.
Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.)

YˆY^ =  +  t

b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.)

The forecasted demand for Week 20 is              and for Week 21 is              .

c. The manager intends to install new equipment when the volume exceeds 950 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.)

It should reach 950 loadings in Week              .

Solutions

Expert Solution

ANSWER:

Given that,

b = (1392210-1325250)/(37962-29241) = 7.68

a = (7750-7.68*171)/18 = 357.61

y = 357.61 + 7.68*t

b)

For week 20, y = 357.61 + 7.68*20 = 511.17

Week 21, y = 357.61 + 7.68*21 = 518.85

c)

950 = 357.61 + 7.68*t

t = 77.13

So, it will reach 950 on week 77.13


Related Solutions

Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 360 7 430 13 505 2 375 8 450 14 515 3 390 9 470 15 545 4 375 10 455 16 560 5 390 11 475 17 575 6 400 12 495 18 590 a. Determine a linear trend line for expected freight car loadings. YˆY^ =  +  t b. Use the above trend equation to predict expected loadings for...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number...
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 290 7 335 13 490 2 300 8 375 14 495 3 310 9 415 15 515 4 300 10 405 16 525 5 310 11 445 17 535 6 315 12 485 18 545 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) YˆY^ =  +  t...
Freight car loadings over an 18-week period at a busy port are as follows:
  Freight car loadings over an 18-week period at a busy port are as follows: Week Tons loaded 1 220 2 245 3 280 4 275 5 300 6 310 7 350 8 360 9 400 10 380 11 420 12 450 13 460 14 475 15 500 16 510 17 525 18 541 The port manager wants build a model to forecast the loads for the remainder of the year. a. Which variable is the dependent/response variable? b. Which...
The number of times a machine broke down each week was observed over a period of...
The number of times a machine broke down each week was observed over a period of 100 weeks and recorded as shown in the table below. Complete parts a and b below. Number of Breakdowns 0 1 2 3 4 5 or More Number of weeks 9 22 32 26 6 5 a. Using alphaequals?0.10, perform a? chi-square test to determine if the population distribution of breakdowns follows the Poisson probability distribution. What is the null? hypothesis, Upper H 0??...
A farmer records the number of bees spotted on his farm over a two week period...
A farmer records the number of bees spotted on his farm over a two week period in the middle of the summer. Below is a stem and leaf plot of his data: 1 67 2 269 3 29 4 399 5 4 6 14 7 8 7 key: 1 6=16 1) Find the mean, median, mode, and sample standard deviation for this data 2) List the values for your Five Number Summary for the data in order. 3) Identify any...
Which one of the following statements is not correct? A. Over a week-long period, if a...
Which one of the following statements is not correct? A. Over a week-long period, if a healthy person were to ingest 35 g of NaCl, the total amount of NaCl excreted in the urine would be less than 35 g. B. In the proximal tubule, large amounts of Na+ and water are reabsorbed but the concentration of Na+ in the proximal tubular fluid does not change. C. A drug that inhibits active NaCl reabsorption in the ascending limb of the...
The number of earthquakes that occur per week in California follows a Poisson distribution with a...
The number of earthquakes that occur per week in California follows a Poisson distribution with a mean of 1.5. (a) What is the probability that an earthquake occurs within the first week? Show by hand and provide the appropriate R code. (b) What is the expected amount of time until an earthquake occurs? (c) What is the standard deviation of the amount of time until two earthquakes occur? (d) What is the probability that it takes more than a month...
The number of faults over a period of time was collected for a sample of 100...
The number of faults over a period of time was collected for a sample of 100 data transmission lines. We want to test if the data come from a Poisson distribution. number of faults 0 1 2 3 4 5 >5 number of lines 38 30 16 9 5 2 0 (a) Assuming the number of faults for a data-transmission line, Yi , i = 1, . . . , 100, follows a Poisson distribution with parameter λ, find the...
An MRP exercise is being implemented over an 8-week period and the following relevant information is...
An MRP exercise is being implemented over an 8-week period and the following relevant information is provided: One (1) unit of A is made of two (2) units of B and three (3) units of C. One (1) unit of B is made up of three (3) units of D and two (2) units of E. One(1) unit of C is made up of two (2) units of B and two (2) units of D. Items A, C and E...
A campus deli serves 300 customers over its busy lunch period from 11:30 a.m. to 1:30...
A campus deli serves 300 customers over its busy lunch period from 11:30 a.m. to 1:30 p.m. A quick count of the number of customers waiting in line and being served by the sandwich makers shows that an average of 10 customers are in process at any point in time. What is the average amount of time that a customer spends in process?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT