1. The Excel file Closing Stock Prices provides data for IBM stock over a 1-month period....
1. The Excel file Closing Stock Prices provides data for IBM stock over a 1-month period. a. Develop spreadsheet models for forecasting IBN stock prices using 2-period moving average and exponential smoothing with a smoothing constant of 0.3. b. Compare your results to the outputs from Excel's Data Analysis tools. c. Using MAD, MSE, MAPE as guidance, which forecasting approach is better in this case? Note: you need show both spreadsheet results and Excel's Data Analysis tool results. show formulas please Closing Stock Prices Date IBM 9/3/10 $127.58 9/7/10 $125.95 9/8/10 $126.08 9/9/10 $126.36 9/10/10 $127.99 9/13/10 $129.61 9/14/10 $128.85 9/15/10 $129.43 9/16/10 $129.67 9/17/10 $130.19 9/20/10 $131.79 9/21/10 $131.98 9/22/10 $132.57 9/23/10 $131.67 9/24/10 $134.11 9/27/10 $134.65 9/28/10 $134.89 9/29/10 $135.48 9/30/10 $134.14 10/1/10 $135.64
Homework Answers
Add Answer to:
1. The Excel file Closing Stock Prices provides data for IBM
stock over a 1-month period....
1. The Excel file Closing Stock Prices provides data for IBM stock over a 1-month period....
1. The Excel file Closing Stock Prices provides data for IBM stock over a 1-month period. a. Develop spreadsheet models for forecasting IBN stock prices using 2-period moving average and exponential smoothing with a smoothing constant of 0.3. b. Compare your results to the outputs from Excel's Data Analysis tools. c. Using MAD, MSE, MAPE as guidance, which forecasting approach is better in this case? Note: you need show both spreadsheet results and Excel's Data Analysis tool results. show formulas...
question 3 View 9/08/2010 B C Date D A 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 2...
question 3
View 9/08/2010 B C Date D A 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 2 B C 127.88 Stock Exchange 3 18.42 20.95 125.76 15.54 18.06 10390.38 10434 81 20.57 15.36 15.74 15.85 15.92 126.44 17.98 20.58 10326.59 10315.28 126.35 17.85 20.51 127.66 17.89 20.58 10374.84 130.84 18.72 21.15 16.13 10632.82 129.46 09/14/2010 21.24 1044131 10570.39 10569.85 10697 94 10778.19 18.64 16.19 16.26 18,73 21.47 21.87 09/15/2010 128.56 16.26 19.03 130,67 09/16/2010 16.28 22.04 18.77 129.89 09/17/2010 16.71 21.91...
Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, A...
Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, All answers should be entered using two decimal places unless otherwise specified. If both decimal places are zeros-then just enter the integer value. Percentages should be entered without"%" sign- 3.45% should be entered as 3.45. M2 IND1. Mariah Henderson is a WCU student who has just finished her junior year. The data in Worksheet IND1 summarizes her grade...
Please complete the analysis for "Bill's Brew Threw" case on page 470. (edited question: spreadsheet modeling...
Please complete the analysis for "Bill's Brew Threw" case on
page 470. (edited question: spreadsheet modeling for business
decisions by john f. kros. Edition: 5)
448 CHAPTER7 Introduction to Forecasting Forecasting Using Exponential Smoothing for Bill's Brew Threw Background Bill Fredericks runs a minimart that sells basic convenience goods like soda, bee snacks. Bill's business is good and relatively stable over time (i.e., no large trend downward over time). However, he has noticed changes in the amount of soda h...
excel spreadsheet information: Month Sales (in millions of boxes) 1 1306 2 1305 3 1311 4...
excel spreadsheet information:
Month
Sales (in millions of boxes)
1
1306
2
1305
3
1311
4
1313
5
1324
6
1329
7
1346
8
1347
9
1378
10
1394
11
1441
12
1469
Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...
AutoSave of Exam3 PartB_SP20_Due_04_24 - Excel File Home insert Draw Page Layout Formulas Data Review View...
AutoSave of Exam3 PartB_SP20_Due_04_24 - Excel File Home insert Draw Page Layout Formulas Data Review View Help Search ΑΙ Formula Bar с 1 Week Week D E F G H I J On 3a [10 points). Data set to your left (sheet On3a) contains information on weekly sales for a local grocery store over a 12-week period. Use the data set to answer the following questions 1. Construct a time series plot. What type of pattern exists in the data?...
LPeint each 1) Over a 6 month period the average stock prices for Nike is $55.62...
LPeint each 1) Over a 6 month period the average stock prices for Nike is $55.62 and Under Amour is $24.86. The standard devistions are $5.10 for Nike apd $3 60 for Under Amour. Over the 6 months period, which stoek exhibits greater variability? (Prove statistically 2) Below are ticket prices for an event. Are the ticket prices normally distributed or skewed (Prove statistically) $4, S18, S11, $7, $7, $10, $5, $33, $9, $12, $3, $11, S10, S6, S16, S37,...
How can we assess whether a project is a success or a failure? This case presents...
How can we assess whether a project is a success or a
failure?
This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...
question 3
View 9/08/2010 B C Date D A 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 2 B C 127.88 Stock Exchange 3 18.42 20.95 125.76 15.54 18.06 10390.38 10434 81 20.57 15.36 15.74 15.85 15.92 126.44 17.98 20.58 10326.59 10315.28 126.35 17.85 20.51 127.66 17.89 20.58 10374.84 130.84 18.72 21.15 16.13 10632.82 129.46 09/14/2010 21.24 1044131 10570.39 10569.85 10697 94 10778.19 18.64 16.19 16.26 18,73 21.47 21.87 09/15/2010 128.56 16.26 19.03 130,67 09/16/2010 16.28 22.04 18.77 129.89 09/17/2010 16.71 21.91...
Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, All answers should be entered using two decimal places unless otherwise specified. If both decimal places are zeros-then just enter the integer value. Percentages should be entered without"%" sign- 3.45% should be entered as 3.45. M2 IND1. Mariah Henderson is a WCU student who has just finished her junior year. The data in Worksheet IND1 summarizes her grade...
Please complete the analysis for "Bill's Brew Threw" case on
page 470. (edited question: spreadsheet modeling for business
decisions by john f. kros. Edition: 5)
448 CHAPTER7 Introduction to Forecasting Forecasting Using Exponential Smoothing for Bill's Brew Threw Background Bill Fredericks runs a minimart that sells basic convenience goods like soda, bee snacks. Bill's business is good and relatively stable over time (i.e., no large trend downward over time). However, he has noticed changes in the amount of soda h...
excel spreadsheet information:
Month
Sales (in millions of boxes)
1
1306
2
1305
3
1311
4
1313
5
1324
6
1329
7
1346
8
1347
9
1378
10
1394
11
1441
12
1469
Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...
AutoSave of Exam3 PartB_SP20_Due_04_24 - Excel File Home insert Draw Page Layout Formulas Data Review View Help Search ΑΙ Formula Bar с 1 Week Week D E F G H I J On 3a [10 points). Data set to your left (sheet On3a) contains information on weekly sales for a local grocery store over a 12-week period. Use the data set to answer the following questions 1. Construct a time series plot. What type of pattern exists in the data?...
LPeint each 1) Over a 6 month period the average stock prices for Nike is $55.62 and Under Amour is $24.86. The standard devistions are $5.10 for Nike apd $3 60 for Under Amour. Over the 6 months period, which stoek exhibits greater variability? (Prove statistically 2) Below are ticket prices for an event. Are the ticket prices normally distributed or skewed (Prove statistically) $4, S18, S11, $7, $7, $10, $5, $33, $9, $12, $3, $11, S10, S6, S16, S37,...
How can we assess whether a project is a success or a
failure?
This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...
Most questions answered within 3 hours.
-
An software company has three different promotion plans for
its software purchase:
plan A: each software...
asked 6 seconds ago -
If
P(A)=.62, P(B)=.47, & P(A or B)=.88. What is the likeliness of
selecting only A?
A)...
asked 43 seconds from now -
What is the FUTURE VALUE of $500 invested for 3 years at 7% with
ANNUAL Compounding...
asked 8 minutes ago -
Modify the method so that instead of manually making teams, it
reads it from a text...
asked 7 minutes ago -
1. Which of the following is not a principle to apply to
construction:
Select one:
a....
asked 9 minutes ago -
In what way is a Christian’s position made more challenging by
revealing faith in the workplace?...
asked 16 minutes ago -
1) There are four categories of customer benefits in B2B
(business-to-business) markets. Which of the following...
asked 13 minutes ago -
What is the pH of a 150.0 mL solution of 0.0273 M NaOH (strong
base)?
asked 23 minutes ago -
A thin ball shell is shaped like a hollow ball with a radius of
26.6 cm....
asked 28 minutes ago -
What mass of KX (Mm= 180 g/mol) is required to prepare 483 mL of
a pH...
asked 27 minutes ago -
In a lottery game, 4 numbers from 1 to 29 are selected. Winners
must match all...
asked 39 minutes ago -
A catfish is 2.5 m below the surface of a smooth lake.
(a) What is the...
asked 41 minutes ago