Dependent Samples

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.

Days of Release/ Phoenix Prince Book 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 LD 7.6 6.9 10 10.2 9.3Critical Value: Test Statistic: SHOW EXCEL FOMULAS USED, PLEASE! THANK YOU! p-value