Question
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,
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Foundations of Financial Management
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen
15th edition
77861612, 1259194078, 978-0077861612, 978-1259194078
