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

Please do this in excel please

In 2001, a total of 40,262,000 taxpayers in the United States filed their individual tax returns electronically. By the year 2015, the number increased to 281,293,158.What is the geometric mean annual increase for the period ( round your answers to 2 decimals)

2021 2020 2019 2018 2017 Sales $ 497,289 $ 327, 164 $ 267,073 $ 197, 102 $ 141,800 Cost of goods sold 251,145 165, 182 137, 037 99,651 70,900 Accounts receivable 23,969 19, 172 18,214 11,511 9,699 Compute trend percents for the above accounts, using 2017 as the base year.

According to Time magazine, in April 2014 the average gas price in the U.S. was $ 3.70. A financial analyst believes that the average gas price is different today. Please state the null and alternative hypothesis.

The data below is from https://www.worldometers.info/world-population/mexico-population/   Year Population of Mexico 2020 128,932,753 2019 127,575,529 2018 126,190,788 2017 124,777,324 2016 123,333,376 2015 121,858,258 2010 114,092,963 2005 106,005,203 2000 98,899,845 1995 91,663,285 1990 83,943,132 1985 75,983,485 1980 67,761,372 1975 59,607,953 1970 51,493,565 1965 44,123,853 1960 37,771,859 1955 32,350,596 1.. Show how you can verify that your linear model works for this data. (Keep trying until it works, and then come back and prove that it works here.) 2. Use your linear model to predict the population in 2050. Show work, sentence answer. 3. Explain whether you think a linear model is a reasonable approximation. Give specific reasons for your answer.

Identify each of the following as either a parameter or a statistic. The average annual interest rate on 15 credit cards. The percentage of all libraries in a city equipped with VR (virtual reality) technology. The number of results on the first 3 pages of your Google search matching your exact search terms. The average price of ten randomly selected wireless earbuds. SUBMIT QUESTION SAVE PROGRESS 760 (click to select) (click to select) (click to select) (click to select) SUBMIT A

In a survey of over 2000 U.S. teenagers by Harris Interactive, 47% said that "their social life would end or be worsened without their cell phone." One survey question asked the teens how important it is for their phone to have certain features. The following figure displays data on the percent who indicated that a particular feature is vital.a. Explain how the graph gives a misleading impression.b. Would it be appropriate to make a pie chart to display these data? Why or why not?

the data contained in the datafile named crudecost shows the U.S. refiner acquisition cost of crude oil in dollars per barrel (energy information administration website,February 3, 2014).a. construct a time series plot. What type of pattern exists in the data?

The Consumer Price Index is reported monthly by the U.S. Bureau of Labor Statistics. It reports the charge in prices for a market basket of goods from one period to another. The index for 2010 was 213.967. BY 2017, it increased to 239.051 What was the geometric mean annual increase for the period? ( Round your answer to 1 decimal)