Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started