+ + + 7 Year Deposits GSP 8 1 2.25 0.4 Q1: According to the management, what is the coefficient of correlation for deposits and GSP? 9 2 3.10 0.4 10 3 3.68 0.5 11 4 3.09 0.7 12 5 4.25 0.9 13 6 4.30 1.0 14 7 4.91 1.4 15 8 5.32 1.7 Q2: As we can see from the data, deposits has grown faster just in recent few years. The management hopes that for this year (year 45), they can have at least the same amount of deposits as last year. Using the approach of the associate method (i.e., linear regression), estimate the probability that their goal can be achieved. Show your analysis below. 16 9 4.24 1.3 17 10 4.26 1.2 18 11 5.25 1.1 19 12 3.33 0.9 20 13 5.50 1.2 21 14 5.95 1.2 22 15 6.70 1.2 23 16 6.30 1.6 24 17 9.35 1.5 25 18 7.80 1.6 26 19 8.70 1.7 27 20 9.90 1.9 28 21 10.49 1.9 29 22 11.30 2.3 30 23 13.20 2.5 31 24 14.10 2.8 32 25 17.50 33 26 19.10 2.9 3.4 Q3: The analyst chose to use the method of exponential smoothing with trend instead of the above associate method. From the previous data, he found that the forecast average of customer deposit for Year 1 was $3 million, with an expected trend of $0.5 million. The smoothing constants for the forecast average and trend were 0.5 and 0.3, respectively. Provide the calculations for the forecasted customer deposit for Year 45 based on this information. 34 27 25.70 3.8 35 28 24.10 4.1 36 29 22.20 4.0 37 30 26.10 4.0 38 31 24.10 3.9 39 32 24.60 3.8 40 33 30.30 3.8 41 34 36.00 3.7 42 35 31.10 4.1 43 36 31.70 4.1 44 37 38.50 4.0 45 38 43.90 4.5 46 39 46.10 4.6 47 40 55.80 4.5 48 41 60.25 4.6 49 42 62.90 4.6 50 43 63.10 4.7 51 44 70.00 5.5 52 53 54 55 1 2 3 4 5 6 S&L Chian bank's manager just found the data of customer deposits (in million) and GSP (state gross product, in billion) from prior 44 years (as shown in Table 3). The management believes that there is considerable association between deposits of the year and the last year's GSP. Answer the following questions Q1 Q3. Your quantitative analysis and Excel formulas should be provided to justify your answers. Table 3
+ + + 7 Year Deposits GSP 8 1 2.25 0.4 Q1: According to the management, what is the coefficient of correlation for deposits and GSP? 9 2 3.10 0.4 10 3 3.68 0.5 11 4 3.09 0.7 12 5 4.25 0.9 13 6 4.30 1.0 14 7 4.91 1.4 15 8 5.32 1.7 Q2: As we can see from the data, deposits has grown faster just in recent few years. The management hopes that for this year (year 45), they can have at least the same amount of deposits as last year. Using the approach of the associate method (i.e., linear regression), estimate the probability that their goal can be achieved. Show your analysis below. 16 9 4.24 1.3 17 10 4.26 1.2 18 11 5.25 1.1 19 12 3.33 0.9 20 13 5.50 1.2 21 14 5.95 1.2 22 15 6.70 1.2 23 16 6.30 1.6 24 17 9.35 1.5 25 18 7.80 1.6 26 19 8.70 1.7 27 20 9.90 1.9 28 21 10.49 1.9 29 22 11.30 2.3 30 23 13.20 2.5 31 24 14.10 2.8 32 25 17.50 33 26 19.10 2.9 3.4 Q3: The analyst chose to use the method of exponential smoothing with trend instead of the above associate method. From the previous data, he found that the forecast average of customer deposit for Year 1 was $3 million, with an expected trend of $0.5 million. The smoothing constants for the forecast average and trend were 0.5 and 0.3, respectively. Provide the calculations for the forecasted customer deposit for Year 45 based on this information. 34 27 25.70 3.8 35 28 24.10 4.1 36 29 22.20 4.0 37 30 26.10 4.0 38 31 24.10 3.9 39 32 24.60 3.8 40 33 30.30 3.8 41 34 36.00 3.7 42 35 31.10 4.1 43 36 31.70 4.1 44 37 38.50 4.0 45 38 43.90 4.5 46 39 46.10 4.6 47 40 55.80 4.5 48 41 60.25 4.6 49 42 62.90 4.6 50 43 63.10 4.7 51 44 70.00 5.5 52 53 54 55 1 2 3 4 5 6 S&L Chian bank's manager just found the data of customer deposits (in million) and GSP (state gross product, in billion) from prior 44 years (as shown in Table 3). The management believes that there is considerable association between deposits of the year and the last year's GSP. Answer the following questions Q1 Q3. Your quantitative analysis and Excel formulas should be provided to justify your answers. Table 3
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Please help me solve this and walk me step by step so I can do it:)
Transcribed Image Text:+
+
+
7
Year
Deposits
GSP
8
1
2.25
0.4
Q1: According to the management, what is the coefficient of correlation for deposits
and GSP?
9
2
3.10
0.4
10
3
3.68
0.5
11
4
3.09
0.7
12
5
4.25
0.9
13
6
4.30
1.0
14
7
4.91
1.4
15
8
5.32
1.7
Q2: As we can see from the data, deposits has grown faster just in recent few years.
The management hopes that for this year (year 45), they can have at least the same
amount of deposits as last year. Using the approach of the associate method (i.e.,
linear regression), estimate the probability that their goal can be achieved. Show
your analysis below.
16
9
4.24
1.3
17
10
4.26
1.2
18
11
5.25
1.1
19
12
3.33
0.9
20
13
5.50
1.2
21
14
5.95
1.2
22
15
6.70
1.2
23
16
6.30
1.6
24
17
9.35
1.5
25
18
7.80
1.6
26
19
8.70
1.7
27
20
9.90
1.9
28
21
10.49
1.9
29
22
11.30
2.3
30
23
13.20
2.5
31
24
14.10
2.8
32
25
17.50
33
26
19.10
2.9
3.4
Q3: The analyst chose to use the method of exponential smoothing with trend
instead of the above associate method. From the previous data, he found that the
forecast average of customer deposit for Year 1 was $3 million, with an expected
trend of $0.5 million. The smoothing constants for the forecast average and trend
were 0.5 and 0.3, respectively. Provide the calculations for the forecasted customer
deposit for Year 45 based on this information.
34
27
25.70
3.8
35
28
24.10
4.1
36
29
22.20
4.0
37
30
26.10
4.0
38
31
24.10
3.9
39
32
24.60
3.8
40
33
30.30
3.8
41
34
36.00
3.7
42
35
31.10
4.1
43
36
31.70
4.1
44
37
38.50
4.0
45
38
43.90
4.5
46
39
46.10
4.6
47
40
55.80
4.5
48
41
60.25
4.6
49
42
62.90
4.6
50
43
63.10
4.7
51
44
70.00
5.5
52
53
54
55
1
2
3
4
5
6
S&L Chian bank's manager just found the data of customer deposits (in million) and GSP (state gross product, in billion) from prior 44 years (as shown in Table 3). The management believes that there is
considerable association between deposits of the year and the last year's GSP. Answer the following questions Q1 Q3. Your quantitative analysis and Excel formulas should be provided to justify your answers.
Table 3
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.