Hello, Could someone help me with this assignment and show me how to do it on Excel please?

To study the effect of temperature on yield in a chemical process, five batches were produced at each of three temperature levels. The results are attached as an Excel file. Using Excel, construct an analysis of variance table. Use a .05 level of significance to test whether the temperature level has an effect on the mean yield of the process.

1. What is the value of the Test Statistic?
2. What is the p-value?
3. State your conclusion. Di you reject or not reject Ho at the 5% level?

File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments X Calibri 11 = = General Conditional Formatting Insert AY U v A A = % Format as Table Paste E = $ Delete Analyze Sensitivity Data A .00 Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity M11 X V A B C D E F G H J K L M N O P Q R S T U V W Temperature 50 C 60 C 70 C W N 34 30 23 31 31 28 36 32 28 39 24 30 35 27 31 10 a. What is the value of the Test Statistic? 11 12 13 b. What is the p-value? 14 15 16 c. State your conclusion. (Hint: Do you reject or not reject Ho at the 5% level). 17 18 19 20