Develop a scatter diagram for these data

Assignment Help Business Management

Reference no: EM133360634

Problem Solving Methods and Analysis- Data analysis

Provide the appropriate solution as per the request below and accurate explanations or solutions for each subsequent question as it follows:
PLEASE include screenshots of your workings using tool of your choice (e.g. Excel)

The Dow Jones Industrial Average (DJIA) and the Standard & Poor (S&P) 500 Index are both used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P 500 is a better measure of stock market performance because it is broader based. The closing price for the DJIA and the S&P 500 for 10 weeks, beginning with February 11,2000 are shown (Barron's April 17, 2000)

Date	Dow Jones	S&P 500
11.Feb	10425	1387
18.Feb	10220	1346
25.Feb	9862	1333
03.Mar	10367	1409
10.Mar	9929	1395
17.Mar	10595	1464
24.Mar	11113	1527
31.Mar	10922	1499
07Apr	11111	1516
14Apr	10306	1357

Note: Consider DJIA as the independent variable

Question 1. Develop a scatter diagram for these data and interpret the same.

Question 2. Compute the sample correlation coefficient for these data.

Question 3. Are they poorly correlated, or do they have a close association?

Question 4. Develop the least squares estimated regression equation.

Question 5. Compute the coefficient of Determination? Would you recommend the regression model for the purpose of estimation?

Reference no: EM133360634

Questions Cloud

Discuss which of these differing views is most opposite : Reform versus revolution - focuses on whether planned changes can occur by simply modifying the existing social system or by replacing it

What is cryptography and what is ceaser-cipher : What is Cryptography? What is Ceaser-cipher? What are the changes you have to make in according to "Algorithm 1: ceaser-cypher encryptor for lower-case"

How can Bambo Natures Dream Diaper be fit : What factors might a marketing manager need to consider when selecting or managing a marketing channel, and how can Bambo Nature's Dream Diaper be a fit?

Participate in a technique or exercise you suggest : Imagine a setting in which a group member declines to participate in a technique or exercise you suggest.

Develop a scatter diagram for these data : Develop a scatter diagram for these data and interpret the same and Compute the sample correlation coefficient for these data

Compare random rewards and easter eggs as game design : Compare random rewards and easter eggs as game design elements. How can they help to motivate players to play the game? Rewards can change the relationship

Explain how marketing creates utility : Define "utility" and explain how marketing creates utility. Describe the relationship era of marketing. What is a strategic alliance?

Which is known as a thumbnail : which is known as a thumbnail. Creators who post videos on YouTube are often told that the choice of thumbnail they attach to a video is one of the most

Describe the demographics and geographic : Describe the demographics. Describe the geographic. Describe the psychographic.

User Account

All Pages