Height Problem

Jean Marie and Claude are planning a family reunion and they want to organize the family in terms of height.

Using the Excel Spreadsheet that has been provided, create a formula that can be used to find the average height of both the males and the females.

Height Table | |

Males | Height |

Kevin | 6.2 |

Derrick | 5.9 |

Zack | 6 |

Lavar | 5.8 |

John | 6.6 |

Avg. Height | |

Females | Height |

Stephanie | 5.8 |

Marissa | 5.3 |

Kim | 5 |

Joanna | 5.2 |

Lisa | 5.4 |

Avg. Height |

Now suppose that Marissa's Height was incorrectly recorded at 5.3 , but instead is 6.0. How does this change the average height for females in our small population size? Save this File As Height Problem 2.