9. To better understand the month-to-month variation of the business, you want to know if average daily revenue across months is the same. You want to use an appropriate statistical technique to test your hypothesis. From the results of your hypothesis test, what is the p-value?

Use the Task 9-10 worksheet as your work area.

Hint-Use a PivotTable to group the transactions by month and then reformat the data to be suitable for the appropriate test. Be careful not to do any of this work inside the hypothesis test area.

Place your hypothesis test beginning in cell E3

Select your p-value answer from the drop down in cell B3.

Can you please show step by step. thank you!

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline A & B & c & 0 & E & F & G & H & 1 & 1 \\ \hline 1.9 & \begin{tabular}{l} From the resalts of your hypothesis test, what is the \\ p-value? \end{tabular} & & & Place your test beginning in cell ES. & & & & & \\ \hline & & & & & & & & & \\ \hline 1.10 & \begin{tabular}{l} The degrees of freedom (which is needed for Tuksy \\ test) within groups is? \end{tabular} & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline \end{tabular}