Two-factor ANOVA to investigate the relationships that worker and extraction machine type might have with CBD content for the 56 batches of oil. In Excel, via the "Data - Data Analysis - ANOVA: Two factor with replication" feature after you re-arrange the data on the spreadsheet.

a) Include the ANOVA results table in your assignment; do not include the large data summary above it that Excel also produces. Adjust the formatting to make the table more readable.

b) Briefly interpret the ANOVA table's three p values. Which relationships were statistically significant and which ones were not?

c) Build an interaction plot that displays the average CBD yield for each combination of machine and time. (It should display either 2 or 4 lines.)

d) Which combination of worker and machine had the highest yield? e) Describe the design of this experiment: What was the response? What were the factors and how many levels did each one have? How many treatment combinations were there? How many groups, replications, and runs were used?

Here is the excel data. If possible, please show the working also and what is the sample and input range in the ANOVA table.

For ANOVA
Yield vs Machine & Operator
		grams
Machine	Operator	CBD
CO2	Alex	81.71
CO2	Chris	79.14
CO2	Farah	78.37
CO2	Min	77.57
Ethanol	Alex	82.53
Ethanol	Chris	81.45
Ethanol	Farah	86.08
Ethanol	Min	86.76
CO2	Alex	81.38
CO2	Chris	82.99
CO2	Farah	81.67
CO2	Min	80.13
Ethanol	Alex	81.54
Ethanol	Chris	82.04
Ethanol	Farah	86.26
Ethanol	Min	89.33
CO2	Alex	82.40
CO2	Chris	81.01
CO2	Farah	79.41
CO2	Min	76.40
Ethanol	Alex	85.09
Ethanol	Chris	84.42
Ethanol	Farah	85.88
Ethanol	Min	88.85
CO2	Alex	85.82
CO2	Chris	80.17
CO2	Farah	78.97
CO2	Min	76.07
Ethanol	Alex	85.37
Ethanol	Chris	84.41
Ethanol	Farah	87.91
Ethanol	Min	83.66
CO2	Alex	84.81
CO2	Chris	82.65
CO2	Farah	83.30
CO2	Min	78.76
Ethanol	Alex	82.98
Ethanol	Chris	84.99
Ethanol	Farah	84.51
Ethanol	Min	84.44
CO2	Alex	82.40
CO2	Chris	80.68
CO2	Farah	77.55
CO2	Min	77.34
Ethanol	Alex	82.09
Ethanol	Chris	87.11
Ethanol	Farah	86.36
Ethanol	Min	90.88
CO2	Alex	82.73
CO2	Chris	82.28
CO2	Farah	80.85
CO2	Min	77.28
Ethanol	Alex	82.27
Ethanol	Chris	84.97
Ethanol	Farah	85.56
Ethanol	Min	86.09