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
GenderAgeDistance to floor
Female130
Female110
Female6215
female231.25
female434.5
female370
female80
female290
female370
female142
Female80
female675
female180
female323
female558
female283
female510
female690
female180
female322
female545
Male120
Male194
Male6312
male280
male330
male266.75
male340
male440
male101
male290
male373
male40.5
male252
male456
male6712
male320
male528
male745
male251.5
male454.5
male607.2
GenderAgeDistance to floor
Female130
Female110
Female6215
female231.25
female434.5
female370
female80
female290
female370
female142
Female80
female675
female180
female323
female558
female283
female510
female690
female180
female322
female545
Male120
Male194
Male6312
male280
male330
male266.75
male340
male440
male101
male290
male373
male40.5
male252
male456
male6712
male320
male528
male745
male251.5
male454.5
male607.2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!