Answer:
[tex]Mean (Red) = 15.11[/tex]
[tex]Mean(Blue) = 16.85[/tex]
Step-by-step explanation:
The question is incomplete.
See attachment for data sheet and the calculated mean
Required
The average of both colors using average function
For the red box, the data starts from cell B4 and ends at cell B48
Using the average function, the average is:
[tex]=AVERAGE(B4:B48)[/tex]
The above returns 15.11
So, we have:
[tex]Mean (Red) = 15.11[/tex]
For the blue box, the data starts from cell E4 and ends at cell E63
Using the average function, the average is:
[tex]=AVERAGE(E4:E63)[/tex]
The above returns 16.85
So, we have:
[tex]Mean(Blue) = 16.85[/tex]
