Question

The Harry Potter books and movies made a lot of money. A fan wanted to learn which of his favorite movies made more money. He collected the amounts grossed in millions during the first few days of releases of the movies Harry Potter and the Half-Blood Prince and Harry Potter and the Order of the Phoenix. Use a 0.05 significance level to test his claim that the Prince movie did better at the box office.

Use the p-value method to determine whether or not to reject the null hypothesis and state your conclusion.

How can this be solved in Excel?

Critical Value:_________

Test Statistic:_________

p-value:_______

Days of Release/Book	Phoenix	Prince
1	44.2	58.2
2	18.4	22.0
3	25.8	26.8
4	28.3	29.2
5	23.0	21.8
6	10.4	9.9
7	9.1	9.5
8	8.4	7.5
9	7.6	6.9
10	10.2	9.3

Answer 1