Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with chapter 2 question 18 in Data Analytics: data analysis and decision making by s. christian albright. the example given on this

I need help with chapter 2 question 18 in Data Analytics: data analysis and decision making by s. christian albright. the example given on this website is using stat tools and i need to learn how to do it without stat tools. is this possible?
image text in transcribed
what other information do i need to provide? can you not go to the textbook that is on the chegg website? i provided a photo of the question that i need help with the solution page on the text book only shows how to solve with stattools but i dont have access to stattools so i need help learning how to do another way. i cant upload the excel sheet bc there is no attatchment link and its 11523 cells long
ules indicate k this has my arkets? (Note . The file P02_18.xlsx contains daily values of the Standard & Poor's 500 Index from 1970 to mid-2015. It also contains percentage changes in the index from each day to the next. a. Create a histogram of the percentage changes and describe its shape. b. Check the percentage of these percentage changes that are more than k standard deviations from the mean for k = 1, 2, 3, 4, and 5. Are the approximately what the empirical rules indi or are there "fat" tails? Do you think this ha real implications for the financial markets? that we have discussed the empirical rules on for k = 1, 2, and 3. For k= 4 and 5, they indi that only 0.006% and 0.0001% of the observa should be this distant from the mean.) observations 5 TIME SERIES DATA When we analyze time series variables, summary measures such as means and stand deviations and charts such as histograms and box plots are often inappropriate. main interest in time series variables is how they change over time, and this informa is lost in traditional summary measures and in histograms or box plots. Imagine example, that you are interested in daily closing prices of a stock that has histor been between 20 and 60. If you create a histogram with a bin such as 45 to SC will get a count of all daily closing prices in this intervalbut you won't know they occurred. The histogram is missing a key feature: time. Similarly, if you rep mean of a time series such as the monthly Dow Jones own you will get a measure that ules indicate k this has my arkets? (Note . The file P02_18.xlsx contains daily values of the Standard & Poor's 500 Index from 1970 to mid-2015. It also contains percentage changes in the index from each day to the next. a. Create a histogram of the percentage changes and describe its shape. b. Check the percentage of these percentage changes that are more than k standard deviations from the mean for k = 1, 2, 3, 4, and 5. Are the approximately what the empirical rules indi or are there "fat" tails? Do you think this ha real implications for the financial markets? that we have discussed the empirical rules on for k = 1, 2, and 3. For k= 4 and 5, they indi that only 0.006% and 0.0001% of the observa should be this distant from the mean.) observations 5 TIME SERIES DATA When we analyze time series variables, summary measures such as means and stand deviations and charts such as histograms and box plots are often inappropriate. main interest in time series variables is how they change over time, and this informa is lost in traditional summary measures and in histograms or box plots. Imagine example, that you are interested in daily closing prices of a stock that has histor been between 20 and 60. If you create a histogram with a bin such as 45 to SC will get a count of all daily closing prices in this intervalbut you won't know they occurred. The histogram is missing a key feature: time. Similarly, if you rep mean of a time series such as the monthly Dow Jones own you will get a measure that

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

Beginning C# 2005 Databases

Authors: Karli Watson

1st Edition

0470044063, 978-0470044063

More Books

Students also viewed these Databases questions

Question

Briefly explain LMX theory.

Answered: 1 week ago