Question
In: Statistics and Probability
the following table presents the orders of Samson Company for the last 36 months (3 years)....
the following table presents the orders of Samson Company for the last 36 months (3 years).
|
Month |
Order Year 1 |
Order Year 2 |
Order Year 3 |
|
January |
450 |
600 |
612 |
|
February |
418 |
575 |
668 |
|
March |
490 |
580 |
680 |
|
April |
451 |
534 |
653 |
|
May |
466 |
555 |
674 |
|
June |
511 |
604 |
702 |
|
July |
522 |
624 |
724 |
|
August |
500 |
612 |
716 |
|
September |
502 |
633 |
712 |
|
October |
523 |
634 |
724 |
|
November |
533 |
643 |
735 |
|
December |
534 |
676 |
755 |
- Use the data in the above table and regression analysis to forecast the orders for the next 12 months (4th year). Include your excel worksheet and your work in your write up. Show the regression equation, values of intercept, slope, correlation coefficient, and coefficient determination and the forecast of orders for the next 12 months.
- Explain how you could make your forecast’s results more reliable by incorporating qualitative research to your quantitative results.
PreviousNext
Solutions
orchestra answered 3 years agoRelated Solutions
The following table presents the orders of Samson Company for the last 36 months (3 years)....
The following table presents the orders of Samson Company for
the last 36 months (3 years).
Month
Order Year 1
Order Year 2
Order Year 3
January
450
600
612
February
418
575
668
March
490
580
680
April
451
534
653
May
466
555
674
June
511
604
702
July
522
624
724
August
500
612
716
September
502
633
712
October
523
634
724
November
533
643
735
December
534
676
755
Use the data in the above...
The following table presents the orders of Samson Company for the last 36 months (3 years)....
The following table presents the orders of Samson Company for
the last 36 months (3 years).
Month
Order Year 1
Order Year 2
Order Year 3
January
450
600
612
February
418
575
668
March
490
580
680
April
451
534
653
May
466
555
674
June
511
604
702
July
522
624
724
August
500
612
716
September
502
633
712
October
523
634
724
November
533
643
735
December
534
676
755
Use the data in the above...
The following table presents the orders of Samson Company for the last 36 months (3 years)....
The following table presents the orders of Samson Company for
the last 36 months (3 years).
Month
Order Year 1
Order Year 2
Order Year 3
January
502
614
712
February
408
592
698
March
491
584
686
April
456
532
644
May
481
599
694
June
511
604
702
July
522
624
724
August
500
612
716
September
510
625
732
October
512
627
740
November
520
650
745
December
536
680
756
1. Use the data in the...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...
The following table
contains the demand from the last 10 months:
MONTH
ACTUAL
DEMAND
1
36
2
38
3
40
4
41
5
43
6
42
7
43
8
45
9
46
10
48
a.
Calculate the single exponential smoothing forecast for these data
using an α of 0.30 and an initial forecast
(F1) of 36. (Round your
answers to 2 decimal places.)
b.
Calculate the exponential smoothing with trend forecast for these
data using an α of 0.30, a...
Problem 3-7 The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND...
Problem 3-7
The following table contains the demand from the last 10
months:
MONTH
ACTUAL
DEMAND
1
33
2
36
3
37
4
38
5
42
6
38
7
41
8
43
9
40
10
41
a. Calculate the single exponential smoothing
forecast for these data using an α of 0.20 and an initial
forecast (F1) of 33. (Round
your intermediate calculations and answers to 2 decimal
places.)
Month
Exponential
Smoothing
1
2
3
4
5
6
7
8
9...
A 36 years old Caucasian obese female presents to the ER with a complaint of epigastric...
A 36 years old Caucasian obese female presents to the ER with a
complaint of epigastric pain for the last 2 days. The pain radiates
through to her back, is constant, sharp in nature, and reliever
with sitting up. Associated symptoms include nausea and non-bloody
emesis. Eating makes the pain worse and therefore she has not eaten
for the last 24 hours. She is married with 2 children. She denies
any alcohol or drug use. On assessment she is afebrile,...
The following table gives the age (in years) of 36 randomly selected U.S. millionaires. The sample...
The following table gives the age (in years) of 36 randomly
selected U.S. millionaires. The sample mean x−=58.53 years. Assume
that the standard deviation of ages of all U.S. millionaires is
13.0 years.
Test at the 10% significance level whether the average year of
all U.S. millionaires is above 55 years.
What is the P-value of the hypothesis test in part (a)?
Obtain a confidence interval corresponding to the hypothesis
test in part (a).
Does the interval in part (c)...
Assume a loan of $30,000, 36 months, 6.5% interest. Generate a table of payments showing the...
Assume a loan of $30,000, 36 months, 6.5% interest. Generate a
table of payments showing the principal payment and the interest
payment for each of the 36 months.
3. The following table presents data on the presence and absence of respiratory distress syndrome (RDS)...
3. The following table presents data on the presence and absence of
respiratory distress syndrome (RDS) in two groups of infants. Group
1 consisted of 42 infants whose fetal membrances ruptured 24 hours
or less before delivery, while group 2 was composed of 22 infants
whose membrances ruptured more than 24 hours before delivery. Test
the null hypothesis that the two populations are homogeneous. Let
α=.05. Incidence of respiratory distress syndrome (RDS) in two
groups of infants RDS Group Yes...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31...
The following table contains the demand from the last 10
months:
MONTH
ACTUAL DEMAND
1
31
2
34
3
35
4
39
5
40
6
45
7
45
8
47
9
43
10
44
a. Calculate the single exponential smoothing
forecast for these data using an α of 0.30 and an initial
forecast (F1) of 31. (Round
your answers to 2 decimal places.)
b. Calculate the exponential smoothing with
trend forecast for these data using an α of 0.30, a...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Will iron(III) hydroxide precipitate from a pH = 1.00 solution with [Fe3+] = 1.0 x 10-5?...
- What do you believe happens during the final scene of the story between the brothers at....
- A 5.171 g sample of a solid, weak, monoprotic acid is used to make a 100.0...
- 1. Creep is one of deformation that occurred in concrete structure. Give one example that can...
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
ADVERTISEMENT