Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, Could you please show me how to answer both questions below using Excel? Thank you! The S&P Stock 500 Exchange index had the values

Hi, Could you please show me how to answer both questions below using Excel? Thank you!

The S&P Stock 500 Exchange index had the values in the attached file in January 2012.

Date S&P 500 Index
4-Jan-12 1,277.30
5-Jan-12 1,281.06
6-Jan-12 1,277.81
9-Jan-12 1,280.70
10-Jan-12 1,292.08
11-Jan-12 1,292.48
12-Jan-12 1,295.50
13-Jan-12 1,289.09
17-Jan-12 1,293.67
18-Jan-12 1,308.04
19-Jan-12 1,314.50
20-Jan-12 1,315.38
23-Jan-12 1,316.00
24-Jan-12 1,314.65
25-Jan-12 1,326.06
26-Jan-12 1,318.43

Question 1: The predicted value for the S&P index for the next business day after January 26th is _______ . (Hint: Please keep two decimal points.)

Question 2: The 95% Prediction Interval is from _______ to ________ . (Hint: Please keep three decimal points.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The FinTech Book The Financial Technology Handbook For Investors Entrepreneurs And Visionaries

Authors: Susanne Chishti, Janos Barberis

1st Edition

111921887X, 9781119218876

More Books

Students also viewed these Finance questions