Question
In: Math
Customer Number of cases Delivery Time 1 52 32.1 2 64 34.8 3 73 36.2 4...
| Customer | Number of cases | Delivery Time |
| 1 | 52 | 32.1 |
| 2 | 64 | 34.8 |
| 3 | 73 | 36.2 |
| 4 | 85 | 37.8 |
| 5 | 95 | 37.8 |
| 6 | 103 | 39.7 |
| 7 | 116 | 38.5 |
| 8 | 121 | 41.9 |
| 9 | 143 | 44.2 |
| 10 | 157 | 47.1 |
| 11 | 161 | 43 |
| 12 | 184 | 49.4 |
| 13 | 202 | 57.2 |
| 14 | 218 | 56.8 |
| 15 | 243 | 60.6 |
| 16 | 254 | 61.2 |
| 17 | 267 | 58.2 |
| 18 | 275 | 63.1 |
| 19 | 287 | 65.6 |
| 20 | 298 | 67.3 |
Management of a soft-drink bottling company wants to develop a method for allocating delivery costs to customers. Although one cost clearly relates to travel times within a particular route, another variable cost reflects the time required to unload the cases of soft drink at the delivery point. A sample of 20 deliveries within a territory was selected. The delivery time and the number of cases delivered were recorded. Develop a regression model to predict delivery time based on the number of cases delivered. Use the least-square method to calculate the regression coefficients, b0 and b1. Showing all formulas and equations a) Write your regression equation. b) Determine the coefficient of determination, r2, and explain it meaning in this problem. c) Perform a residual analysis. Is there any evidence of patterns in the residuals? Explain.
Solutions
milcah answered 1 year agoRelated Solutions
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 57 (7) 64 (8) 63 (9) 72 (10) 66 (11) 73 (12) 73
Question 1 contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12
periods.
The actual values for 12 periods...
1.The actual values for 12 periods (shown in order) are:(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 69 (12) 74
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 69 (12) 74
Question 1 contains the actual values for 12 periods (listed in
order, 1-12). In Excel, create forecasts for periods 6-13 using
each of the following methods: 5 period simple moving average; 4
period weighted moving average (0.63, 0.26, 0.08, 0.03);
exponential smoothing (alpha = 0.23 and the forecast for period 5 =
53); linear regression with the equation based on all 12 periods;
and quadratic regression with the equation based on all 12
periods. Round all numerical answers to two...
Student First Test Grade Second Test Grade 1 81 79 2 55 64 3 52 61...
Student
First Test Grade
Second Test Grade
1
81
79
2
55
64
3
52
61
4
81
74
5
50
65
6
70
71
7
43
64
8
43
58
9
77
75
10
97
88
11
48
64
12
48
68
13
70
70
14
75
71
15
77
72
16
76
73
17
85
80
18
91
85
19
70
75
20
69
77
21
40
57
Step 1:
Enter a negative estimate as a negative number...
What is Best fit distribution for this data/ Customer Arrival time (mins) 1 1 2 4...
What is Best fit distribution for this data/
Customer Arrival
time (mins)
1
1
2
4
3
3
4
0
5
0
6
1
7
3
8
3
9
2
10
0
11
3
12
1
13
2
14
0
15
2
16
0
17
1
18
2
19
3
20
2
21
3
22
0
23
2
24
3
25
3
26
0
Below are the number of hours spent exercising: 2 3 4 4 4 5 1 1...
Below are the number of hours spent
exercising:
2
3
4
4
4
5
1
1
4
4
4
1
2
3
3
2
Which descriptive statistics from your output would you NOT
report for Hours spent Exercising? Why not?
Write a few sentences describing the data (use APA formatting).
This interpretation should not include only the numbers, but rather
what the numbers tell you about the data.
Create a histogram for the hours spent exercising. You can do
this...
Below are the number of hours spent exercising: 2 3 4 4 4 5 1 1...
Below are the number of hours spent
exercising:
2
3
4
4
4
5
1
1
4
4
4
1
2
3
3
2
How many participants were there in the study?
What percentage of the sample exercised 4 or more hours?
Report the following regarding the number of hours spent
exercising, calculating by hand or using the Excel sheet provided
to you.
Mean:
Median:
Mode:
Range:
Variance:
4. Which descriptive statistics from
your output would you NOT report for...
SE-FamilySize 1 1 4 3 2 4 2 3 4 2 4 1 4 2 2...
SE-FamilySize
1
1
4
3
2
4
2
3
4
2
4
1
4
2
2
4
5
4
5
4
4
2
4
3
1
2
3
5
5
5
Make a confidence interval. Be sure you show all the steps you
took. Include a screen shot of any applet you used in your
calculations.
2. Choose a confidence level (1 – α).
3. What is xbar?
4. What is s?
5. What is t? (Show a screen shot...
C++ 1. What is the minimum number of steps if there are 1, 2, 3, 4,...
C++
1. What is the minimum number of steps if there are 1, 2, 3, 4,
or more disks? Try and solve the puzzle and fill in the table.
1
1
2
3
3
7
4
15
5
?
6
?
7
?
8
?
2. Write an explicit formula for the minimum number of steps
required for the puzzle? Use H(n) = ? where n is the number of
disks
3. What would be the best ADT to use...
Days 1 to 120: Number of New Cases 0 1 0 0 2 0 3 0...
Days 1 to 120: Number of New Cases
0 1 0 0 2 0 3 0 0 0 0 14 2 1 0 27 80 51 18 26 216 81 37 117 167
108 151 178 111 414 337 195 706 214 300 68 118 160 190 209 154 193
170 154 166 68 119 152 146 101 98 159 175 195 195 157 130 129 161
116 133 217 209 75 298 240 205 196 233 76 339 170...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Beasley Ball Bearings paid a $4 dividend last year. The dividend is expected to grow at...
- 7. In order to improve the network performance and security, ACLs is recommended. Please explain what...
- Noting that there has been an increasing interest in organic foodstuffs with increasing affluence, Mr Tommy...
- 1. the physical sites at which crossing over occurs are the.... A. chiasmata B. Centrioles C....
- Develop a Java program that determines the gross pay for an employee. The company pays hourly...
- Discuss the four evolving company orientations. Which orientation is considered most successful and why?
- Flexible Budgeting and Variance Analysis I Love My Chocolate Company makes dark chocolate and light chocolate....
ADVERTISEMENT