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
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
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)