Question
In: Statistics and Probability
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 is the independent/explanatory variable?
Enter the data into your Excel file
c. Develop a scatterplot for these data. Interpret the scatterplot.
Run a regression analysis of the data on Excel using Data/Data Analysis
d. What is the correlation between Week and Tons loaded?
What does it say about the strength of the relationship?
e. What is the coefficient of determination?
How would you interpret it?
f. Write the hypotheses for the test of the slope.
g. What do you conclude about the slope of the line?
What are you basing your conclusion on?
h. What is the regression formula that represents the relationship between Week and tons loaded?
i. Use your formula to predict the Tons loaded for Week 19.
j. Use your formula to predict the Tons loaded for Week 25.
Solutions
orchestra answered 2 years agoRelated 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
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...
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...
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 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??...
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 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...
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?
Over a 18 day period, daily measurements of silver yield from a mine us taken. The...
Over a 18 day period, daily measurements of silver yield from
a mine us taken. The company has an original goal of the 60th
percentile being more than 50 tons. From the 18 days, 8 days
yielded less than 50 tons. No day yielded exactly 50 tons. Test to
see if the company’s goal is upheld.
(a) State the hypothesis for testing this claim.
(b) Explain and show what test statistic you're using and how
to get the p-value
(c)...
Below you will find the closing stock prices for eBay over a three-week period. Calculate the...
Below you will find the closing stock prices for eBay over a
three-week period. Calculate the simple three-day and five-day
moving averages for the stock. (Round your answers to 2
decimal places. Omit the "$" sign in your
response.)
Date
Close
4/23/2012
$
37.18
4/24/2012
37.00
4/25/2012
36.60
4/26/2012
36.86
4/27/2012
36.12
4/30/2012
36.29
5/1/2012
36.36
5/2/2012
36.40
5/3/2012
37.09
5/4/2012
37.19
5/7/2012
37.12
5/8/2012
37.28
5/9/2012
37.61
5/10/2012
37.76
5/11/2012
37.59
3-day
5-day
4/23/2012
4/24/2012...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The requirements for your assignment are: Decode the IP address 172.16.31.255 /20 Determine the following: Subnet...
- Examine the various types of contracts available to Toyota when dealing with international suppliers and advise...
- Problem 10-08 NPVs, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces...
- Give an example for market segmentation for a new company developing either products for cats or...
- Suppose you have set a specific goal for the balance in your savings account 12 years...
- Explain in very good details the hardening and procedures of Microsoft Server 2019
- Straight-Line Depreciation A building acquired at the beginning of the year at a cost of $85,300...
ADVERTISEMENT