Question
In: Statistics and Probability
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 58 (9) 67 (10) 66 (11) 70 (12) 76
| Instructions |
The Data 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: 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 decimal places. |
|---|
Data
The actual values for 12 periods (shown in order) are:
(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 58 (9) 67 (10) 66 (11) 70 (12) 76
Questions
d) With linear regression, the forecast for period 13 will be:
e) With quadratic regression, the forecast for period 13 will be:
f) Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?
Solutions
Expert Solution
d) Forecast is 75.14 for linear regression
e) Forecast is 77.18 for quadratic regression
f) MAD(linear)=2.81, MAD(Quadratic)=2.68
The lowest MAD value is 2.68, which corresponds to quadratic regression.
orchestra answered 2 years agoRelated Solutions
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 59 (9) 72 (10) 66 (11) 67 (12) 78
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...
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) 58 (7) 64 (8) 61 (9) 71 (10) 66 (11) 69 (12) 77
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) 58 (7) 64 (8) 61 (9) 71 (10) 66 (11) 69 (12) 77
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) 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...
x y 14 50 10 55 12 54 11 56 10 58 9 59 6 61...
x
y
14
50
10
55
12
54
11
56
10
58
9
59
6
61
4
62
1.What is the slope?
2. What is the intercept?
3. Using the prediction of x=11 what are the residuals?
4. The sum of squared residuals is 12.038 calculate the standar
deviation of the regression
5. What is the test statistic?
Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18%...
Periods
1%
2%
3%
4%
5%
6%
7%
8%
9%
10%
12%
14%
15%
16%
18%
20%
1
0.990
0.980
0.971
0.962
0.952
0.943
0.935
0.926
0.917
0.909
0.893
0.877
0.870
0.862
0.847
0.833
2
0.980
0.961
0.943
0.925
0.907
0.890
0.873
0.857
0.842
0.826
0.797
0.769
0.756
0.743
0.718
0.694
3
0.971
0.942
0.915
0.889
0.864
0.840
0.816
0.794
0.772
0.751
0.712
0.675
0.658
0.641
0.609
0.579
4
0.961
0.924
0.888
0.855
0.823
0.792
0.763
0.735
0.708
0.683
0.636...
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5...
3
6
4
8
1
10
2
9
11
12
15
22
3
6
7
5
8
1
12
14
Each column represents a different treatment given to sick rats.
Each cell is a different rat. Use statistical analysis and use post
hoc testing using contrasts to find the best
treatment.
Treatment 1: vitamins
Treatment 2: prescription pills
Treatment 3: brain surgery
Treatment 4: shock therapy
Treatment 5: dietary changes
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
Match No.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Player A
8
42
56
68
91
123
12
46
57
137
5
80
14
10
19
Player B
38
44
46
59
57
61
48
42
51
39
58
41
55
45
68
1. For the given data set representing the runs scored by two
players in last 15 matches, conduct the following analysis:
i. Which average you will use to summarize...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Gauss Jordan elimination using python for a 2d list (3x3) without using any library. Thanks
- What are some of the greatest barriers preventing our schools from meeting the educational goals for...
- What aspect of the materials used in nanotechnology differentiates it from the nanoscale devices that the...
- Postfix Arithmetic Operation (C++) Friday, 27 September 2019, 04:21 PM Use stack to implement postfix arithmetic...
- * What is the link between SOX compliance and law and information systems security? ** Why...
- A chemist has a substance which was either phenol or resorcinol. He puts the substance in...
- I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
ADVERTISEMENT