Many investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2017, 9 of the 30 stocks making up the DJIA increased in price. On the basis of this fact, a financial analyst claims we can assume that 54% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day. A sample of 74 stocks traded on the NYSE that day

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 26PPS
icon
Related questions
Question
100%

Many investors and financial analysts believe the Dow Jones Industrial Average (DJIA) gives a good barometer of the overall stock market. On January 31, 2017, 9 of the 30 stocks making up the DJIA increased in price.
On the basis of this fact, a financial analyst claims we can assume that 54% of the stocks traded on the New York Stock Exchange (NYSE) went up the same day. A sample of 74 stocks traded on the NYSE that day showed that 35 went up. You are conducting a study to see if the proportion of stocks that went up is significantly smaller than 54%. You use a significance level of α=0.05α=0.05.

how to you come up with the test statistic and p value using excel

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL