The Dow Jones Industrial Average (DJIA) and the Standard & Poor’s 500 (S&P 500) indexes are 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 15 weeks, beginning with January 6, 2012, follow (Barron’s website, April 17, 2012). must be solved on excel Date DJIA S&P January 6 12360 1278 January 13 12422 1289 January 20 12720 1315 January 27 12660 1316 February 3 12862 1345 February 10 12801 1343 February 17 12950 1362 February 24 12983 1366 March 2 12978 1370 March 9 12922 1371 March 16 13233 1404 March 23 13081 1397 March 30 13212 1408 April 5 13060 1398 April 13 12850 1370

Question

2. The Dow Jones Industrial Average (DJIA) and the Standard & Poor’s 500 (S&P 500) indexes are 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 15 weeks, beginning with January 6, 2012, follow (Barron’s website, April 17, 2012).

must be solved on excel

Date

DJIA

S&P

January 6

12360

1278

January 13

12422

1289

January 20

12720

1315

January 27

12660

1316

February 3

12862

1345

February 10

12801

1343

February 17

12950

1362

February 24

12983

1366

March 2

12978

1370

March 9

12922

1371

March 16

13233

1404

March 23

13081

1397

March 30

13212

1408

April 5

13060

1398

April 13

12850

1370

a. Develop a scatter diagram with DJIA as the independent variable.

b. Develop the estimated regression equation.

c. Test for a significant relationship. Use α=0.05.

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Math
Statistics

Regression Analysis

Related Statistics Q&A

Find answers to questions asked by students like you.

Q: Statistics Question

A: Note- Since both are different questions, so according to our policy we can answer only one question...

Q: In the following multiple regression equation, what is value of x2 when x1 = 12.5 and ŷ is estimated...

A: From the information, given that   The multiple linear regression equation is, Given that the value...

Q: Medical researchers performed a comparison of two drugs Clopidogrel and ticagrelor, which are suppos...

A: Click to see the answer

Q: 3. One sample nas SS = 18. %3D sla. If n = 4 for both samples, find each of the sample variances and...

A: Pooled Variance when the mean is different for each population with the assumption that variances of...

Q: Numberofgames   Frequency1 - 5              26 - 10            711 - 15          816 - 20          3...

A: Click to see the answer

Q: To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score...

A: Here you're given two variables named as Price ($) and Overall score. Let us define the independent ...

Q: stributes beer in bottles labeled 12 oun eating its customers. The agency selects ains a sample mean...

A: The objective is to test the claim that the brewery is cheating its customers. From the available in...

Q: Sleep apnea is a disorder in which there arepauses in breathing during sleep. People with thiscondit...

A: Given, Sleep apnea is a disorder in which there are pauses in breathing during sleep. People with th...

Q: Debbie and Ethan are going to construct confidence intervals from the same simple random sample.  De...

A: Given information Two confidence interval 98% and 95% Debbie’s confidence interval 98% Ethan’s confi...

Q: The following is a chart of baseball players' salaries and statistics from 2016. RBI's HR's Salary (...

A: a) Excel Procedure: Enter RBI, HR and Salary in Excel>Data>Data Analysis> ‘Regression’>S...

Q: Question No. 3:                                                                                     ...

A: It is given that the average time that Italy commute to work is 23.15 minutes (Best 4 Tourist Places...

Q: We are running a hypothesis test to see if blood pressure of African zebras differs signific antly f...

A: As given, n1: The sample size of blood pressure of African zebras. = 5 n2:  The sample size of blood...

Q: Let x be a random variable that represents the pH of arterial plasma (i.e., acidity of the blood). F...

A: The objective is to test the claim that the drug has changed (either way) the mean pH level of the b...

Q: Raphael’s grades in his statistics classes are as follows: Quizzes: 62, 88, 82 Laboratories: 89, 96 ...

A: Given, Raphael’s grades in his statistics classes are as follows: Quizzes: 62, 88, 82 Laboratories: ...

Q: You are given the sample of the population standard deviation use this information to construct the ...

A: Solution: Let X be the high daily tempt in a city. From the given information, x-bar=86.90, σ=15.39 ...

Q: An engineer has designed a valve that will regulate water pressure on an automobile engine.The engin...

A: Given information- Population mean, μ = 6.8 Sample size, n = 23 Sample mean, x-bar = 6.4 Sample stan...

Q: 3. Washers used in a certain application aresupposed to have a thickness of 2 mm. A qualitycontrol e...

A: The given hypotheses are as follows: H0: µ = 2. Ha: µ ≠ 2.

Q: The fan blades on commercial jet engines must be replaced when wear on these parts indicates too muc...

A: Note- As per our policy we can answer only the first 3 sub-parts of a question. If you want solution...

Q: Statistics Question

A: Click to see the answer

Q: The average burglary rate for a jurisdiction has been 312 per year with a standard deviation of 50. ...

A: Hi! Thanks for posting the question. Since there are more than three sub-part questions, we will ans...

Q: A mail-order company has two warehouses, one on the West Coast and the second on the East Coast. The...

A: Given information, we have two warehouses one is west coast and other is east coast. The policy of c...

Q: You have a sample of test scores, the sample mean of the test scores is 70.5, and the standard devia...

A: Determine the z-score for an individual score of 85. The z-score for an individual score of 85 is ob...

Q: In a sample of 16 fish from my pond it was found that 5 are under 165 grams in weight. Based on this...

A: Given information n = 16 fish No of fish under 165g (x) = 5

Q: An engineer has designed a valve that will regulate water pressure on an automobile engine. The valv...

A: x¯=4.5 poundsσ=0.7μ=4.4n=200α=0.01

Q: Let x = age in years of a rural Quebec woman at the time of her first marriage. In the year 1941, th...

A: Note- As per our policy we can answer only the first 3 sub-parts of a question. If you want solution...

Q: In a study of the birth order and intelligence, IQtests were given to 18- and 19-year old men toesti...

A: (a)   Obtain the 90% confidence interval for the difference in mean IQ between firstborn and second ...

Q: Many states have attempted to reduce the blood-alcohol level at which a driver is declared to be leg...

A: It is given that data 2 is defined as the difference (After − Before) in their reaction times in sec...

Q: If we are running a hypothesis test to see if the true mean breaking strength of Acme rope is less t...

A: Click to see the answer

Q: Source SS DF MS Test Statistic Regression ?? 33 1120.61120.6    Error       490.23490.23   T...

A: The given data is, SStotal = 9244.56, df regression =3 and df total = 15 MS regression = 1120.6 and ...

Q: Let z be the number of units (in thousands) that a company produces and let p(x) be the profit (in t...

A: From the given information, x x2 p(x) 2 4 0.6 4 16 -2.8 6 36 -6.7 8 64 -12.2 10 100 -1...

Q: A medical researcher wants to compare the pulse rates of smokers and non-smokers. He believes that t...

A: Given, A medical researcher wants to compare the pulse rates of smokers and non-smokers. He believes...

Q: A poll taken by a software research laboratory in 2018surveyed 341 video gamers and 110 of them said...

A: Let p denotes the population proportion of video gamers who said that they prefer to play games on a...

Q: QUESTION 8 You may need to use the appropriate appendix table or technology to answer this question....

A: Given data,p=0.501-p=1-0.50=0.50n=100μp^=p=0.50σp^=p(1-p)/n=(0.50*0.50)/1000.05

Q: See attachment.

A: Given: x~N(μ,σ)μ=8.35 hoursσ=2.5 hours

Q: The population mean and standard deviation are given below. Find the required probability and determ...

A: Click to see the answer

Q: Conduct a hypothesis test for the following problem: A medical researcher says that at least 20% of ...

A: Click to see the answer

Q: Question No.1         a) Identify the  and  intercepts for the given linear equation (X-3y)/3-12=(3x...

A: (a) Identify the x and y intercepts for the given linear equation (X-3y)/3-12=(3x+2y)/3 Solving the ...

Q: To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score...

A: Given: The data regarding price and overall score is given below x y 1250 83 1300 83 1200 ...

Q: A class with n kids lines up for recess. The order in which the kids line up is random with each ord...

A: Let define the event A and event B. Event A: Betty is first in the line. Event B: Mary is last in th...

Q: A group committed to quality television has been concerned about a new talk show. For two weeks, the...

A: Given observations

Q: Montarello and Martin (2005) found that 5th grade students completed more math problems correctly wh...

A: State the hypotheses. That is, there is no sufficient to conclude inserting the easy questions impr...

Q: I am having trouble with this problem:   In a study of the accuracy of fast food​ drive-through orde...

A: Click to see the answer

Q: Jim Mead is a veterinarian who visits a Vermont farm to examine prize bulls. In order to examine a b...

A: Note- As per our policy we can answer only the first 3 sub-parts of a question. If you want solution...

Q: A college alumni Organization sent a survey to all recent graduates to ask their annual income. 20% ...

A: Given, All recent graduates of a college were asked their annual income for a survey that was conduc...

Q: 1. In the study of linear regression analysis, distinguish between the following expressions:(a) reg...

A: Since you have posted multiple questions, so we will solve the first question for you. If you want a...

Q: If you have a sample size of 100 from a population of rope with sample mean breaking strength of 960...

A: Solution: Let X be the breaking strength. From the given information, x-bar = 960 pounds, S=200 poun...

Q: The table below summarizes data from a survey of a sample of women. Using a 0.01 significance​ level...

A: The objective is to test the claim that the proportions of​ agree/disagree responses are the same fo...

Q: If a sample of 4 fish from my pond has mean weight 157 grams with a standard deviation of 8.3 grams ...

A: Click to see the answer

Q: A bag contains 10 iron, 10 copper, 10 silver and 10 gold coins. a. How many ways are there to select...

A: It is given that a bag contains 10 iron, 10 copper, 10 silver and 10 gold coins.

Q: Researchers measured skulls from different time periods in an attempt to determine whether interbree...

A: The hypothesis that is to be tested is: H0:μBC=μADH1:μBC≠μAD The test statistic for the above hypoth...