Question: For the data in the excel file closing stocks prices, do the following Develop spreadsheet models for forecasting each of the stock prices using simple

For the data in the excel file closing stocks prices, do the following

Develop spreadsheet models for forecasting each of the stock prices using simple 2-period average and simple exponential smoothing with a smoothing constant of 0.3
Use MAD as guidance and find the best number of moving average period and best smoothing constant for exponential smoothing.

For the data in the excel file closing stocks prices, do the

Closing Stock Prices DJ Industrials Date IBM INTC CSCO GE Index 3/9/2010 $127.58 $18.43 $21.04 $15.39 10447.93 7/9/2010 $125.95 $18.12 $20.58 $15.44 10340.69 8/9/2010 $126.08 $17.90 $20.64 $15.70 10387.01 9/9/2010 $126.36 $18.00 $20.61 $15.91 104 15.24 10/9/2010 $127.99 $17.97 $20.62 $15.98 10462.77 13/9/2010 $129.61 $18.56 $21.26 $16.25 10544.13 14/9/2010 $128.85 $18.74 $21.45 $16.16 10526.49 15/9/2010 $129.43 $18.72 $21.59 $16.34 10572.73 16/9/2010 $129.67 $18.97 $21.93 $16.23 10594.83 17/9/2010 $130.19 $18.81 $21.86 $16.29 10607.85 20/9/2010 $131.79 $18.93 $21.75 $16.55 10753.62 21/9/2010 $131.98 $19.14 $21.64 $16.52 10761.03 22/9/2010 $132.57 $19.01 $21.67 $16.50 10739.31 23/9/2010 $131.67 $18.98 $21.53 $16.14 10662.42 24/9/2010 $134.11 $19.42 $22.09 $16.66 10860.26 27/9/2010 $134.65 $19.24 $22.11 $16.43 10812.04 28/9/2010 $134.89 $19.51 $21.86 $16.44 10858.14 29/9/2010 $135.48 $19.24 $21.87 $16.36 10835.28 30/9/2010 $134.14 $19.20 $21.90 $16.25 10788.05 1/10/2010 $135.64 $19.32 $21.91 $16.36 10829.68

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Static pressure P is measured at two locations along the wall of a laminar boundary layer (Fig. P1087). The measured pressures are P 1 and P 2 , and the distance between the taps is small compared to...

Gasoline Prices - Average U.S. Prices for Regular Gasoline \begin{tabular}{|c|c|} \hline Date & Price \\ \cline { 1 - 2 } Jan 03, 2000 & $1.26 \\ Jan 10, 2000 & $1.25 \\ Jan 17, 2000 & $1.27 \\ Jan...

Using the "Oscm pro, the supply chain professional spreadsheet templates" (Google search this) : "5 Natural Gas Import Prices" template, complete the following: a) Develop spreadsheet models for...

For the data in the Excel file Gasoline Prices, do the following: Develop a spreadsheet for forecasting prices using a simple three - period moving average. Compute MAD, MSE, and MAPE error measures.

Download the Excel file Closing Stock Prices on Canvas, which provides data for IBM stock over a 1 - month period. You need submit your EXCEL file on Canvas. 1 . ( 2 pts ) Forecast IBM stock prices...

5. For the data in the Excel file Gasoline Prices do the following: a. Develop spreadsheet models for forecasting prices using simple moving average and simple exponential smoothing. b. Compare your...

For the data in the Excel file Airport Passengers , do the following: a.Develop a spreadsheet for forecasting the number of airport passengers using a simple 3- and 5-month moving average. b.Compare...

For the data in the Excel file Gasoline Prices, do the following: a. Develop a spreadsheet for forecasting prices using a simple three-period moving average. b. Compute MAD, MSE, and MAPE error...

For the data in the Excel file Gasoline Prices, do the following: Develop a spreadsheet for forecasting prices using simple exponential smoothing with smoothing constants from 0 . 1 to 0 . 9 in...

9. The Excel file Closing Stock Prices provides data for fours stocks and the Dow Jones Industrials Index over a one-month period. Develop a spreadsheet model for forecasting the stock price of IBM...

Problem The Excel file Closing Stock Prices provides data for four stocks and the Down Jones Industrial Average (DJIA) over one month. a. Develop a spreadsheet model for forecasting each of the stock...

Given the diagram below and knowing that point E lies on side AC, and point D lies on BE. If BC = n and DB = n 1 for some positive integer n and ABC = ACB = CED = CDE. Find the number of positive...

Discuss the view that the introduction of a minimum wage in Kenya would increase unemployment among teenagers (7 marks)

During 2 0 2 0 , Larkspur Company started a construction job with a contract price of $ 1 , 5 8 0 , 0 0 0 . The job was completed in 2 0 2 2 . The following information is available. Costs incurred...

A debt of $8000 is due 4 years from now. Its to be paid off by three payments: a first payment made 10 months from now, a second payment (that is double the first) 2 years from now, and a final...

Describe the five specific guidelines for appropriate use of the indirect plan.

Prepare effective negative messages for a variety of purposes using the indirect plan.

Describe the nature of negative messages.