Using Statcrunch- Data provided

Part 1

Using the data in the file Math2100-05ProjectPart1.xlsx,

1. Summarize the data in a frequency/relative frequency table
2. Create a bar plot of the data
3. Create a pie chart of the data
4. Conduct a hypothesis test of whether the stock is up more than 50% of the time with a level of significance of 5%

1. State the null and alternative hypothesis
2. Find the test statistic
3. Find the critical value
4. Find the p-Value
5. State your conclusion

1. Using the previously obtained results, would you state the same conclusion if the level of significance were 1% instead of 5%?

Part 2

Using the data in the file Math2100-05ProjectPart2.xlsx,

1. Find the mean
2. Find the standard deviation
3. Find the 5-number summary
4. Find the interquartile range
5. Create a histogram with lowest bin starting at 25 and bin width of .5
6. Create a boxplot
7. What are the lower and upper fences
8. If there are outliers, state their value(s).
9. Conduct an hypothesis test at the 1% level of whether the mean stock price is different from 35.5
   1. State the null and alternative hypothesis
   2. Find the test statistic
   3. Find the number of degrees of freedom
   4. Find the critical value(s)
   5. Find the p-Value
   6. Find the 99% confidence interval for the mean stock price
   7. State your conclusion