Question: Can you help with the below informations to create a graph of the following information? Use Excel formulas to calculate the average distance from the
Can you help with the below informations to create a graph of the following information?
- Use Excel formulas to calculate the average distance from the floor for each aW
| Gender | Age | Distance to floor |
| Female | 13 | 0 |
| Female | 11 | 0 |
| Female | 62 | 15 |
| female | 23 | 1.25 |
| female | 43 | 4.5 |
| female | 37 | 0 |
| female | 8 | 0 |
| female | 29 | 0 |
| female | 37 | 0 |
| female | 14 | 2 |
| Female | 8 | 0 |
| female | 67 | 5 |
| female | 18 | 0 |
| female | 32 | 3 |
| female | 55 | 8 |
| female | 28 | 3 |
| female | 51 | 0 |
| female | 69 | 0 |
| female | 18 | 0 |
| female | 32 | 2 |
| female | 54 | 5 |
| Male | 12 | 0 |
| Male | 19 | 4 |
| Male | 63 | 12 |
| male | 28 | 0 |
| male | 33 | 0 |
| male | 26 | 6.75 |
| male | 34 | 0 |
| male | 44 | 0 |
| male | 10 | 1 |
| male | 29 | 0 |
| male | 37 | 3 |
| male | 4 | 0.5 |
| male | 25 | 2 |
| male | 45 | 6 |
| male | 67 | 12 |
| male | 32 | 0 |
| male | 52 | 8 |
| male | 74 | 5 |
| male | 25 | 1.5 |
| male | 45 | 4.5 |
| male | 60 | 7.2 |
| Gender | Age | Distance to floor |
| Female | 13 | 0 |
| Female | 11 | 0 |
| Female | 62 | 15 |
| female | 23 | 1.25 |
| female | 43 | 4.5 |
| female | 37 | 0 |
| female | 8 | 0 |
| female | 29 | 0 |
| female | 37 | 0 |
| female | 14 | 2 |
| Female | 8 | 0 |
| female | 67 | 5 |
| female | 18 | 0 |
| female | 32 | 3 |
| female | 55 | 8 |
| female | 28 | 3 |
| female | 51 | 0 |
| female | 69 | 0 |
| female | 18 | 0 |
| female | 32 | 2 |
| female | 54 | 5 |
| Male | 12 | 0 |
| Male | 19 | 4 |
| Male | 63 | 12 |
| male | 28 | 0 |
| male | 33 | 0 |
| male | 26 | 6.75 |
| male | 34 | 0 |
| male | 44 | 0 |
| male | 10 | 1 |
| male | 29 | 0 |
| male | 37 | 3 |
| male | 4 | 0.5 |
| male | 25 | 2 |
| male | 45 | 6 |
| male | 67 | 12 |
| male | 32 | 0 |
| male | 52 | 8 |
| male | 74 | 5 |
| male | 25 | 1.5 |
| male | 45 | 4.5 |
| male | 60 | 7.2 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
