fish math

Excel Basics and Logarithmic Functions

  • Logging Values

    • Begins with entering a formula: "=log()" followed by selecting the corresponding cell.

    • Example: "dollar b" indicating monetary input.

  • Example of Coefficients

    • Total coefficient noted as $5.04.

    • Discussing differences in numerical entries when comparing calculations.

Challenges with Data Entry

  • Common Issues

    • Individuals facing discrepancies in their calculations (e.g., 33 points noted).

    • Misidentification of species (e.g., working on the wrong species contributed to confusion).

  • Technical Difficulties

    • Frustration expressed regarding spread of columns and differences in calculated numbers.

    • Humor on the difficulties of mastering Excel compared to business majors being easier.

Emotional Responses and Everyday Life

  • Personal Anecdotes

    • Mention of wanting dinner options but only having fast food available due to busy periods (e.g., Friday nights).

    • Complaints about water utilities and poor service leading to discomfort.

Discussion of Logarithmic Weighting in Fish Manipulation

  • Logarithmic Standard Weight

    • Logarithm serves to determine standard weight of fish populations.

    • Steps to transition from log weights to actual weights:

      1. Using 10 raised to the power of log value.

      2. Example: If log value is known, contribute to finding the actual weight.

      3. Important note: If given log base 10, conversion involves exponential functions.

Understanding Fish Population Dynamics

  • Key Terms

    • PSD (Proportional Stock Density)

      • Represents size structure of fish populations.

      • Example given: High PSD in Bluegill populations with enough big fish.

    • Batch PSD

      • Assessing fish size measurement, distinguishing between big vs. little fish.

  • Interpretations of Data

    • High number indicates many large fish; low in overcrowded environments.

    • Example noted: Bluegill overpopulation leading to lower PSD for Bass.

      • High PSD for bass indicates an abundance of little fish.

Population Management Considerations

  • Management Goals

    • Aim for a balance of fish species to ensure sustainable populations.

    • Management strategies could include harvesting small bass to restore balance.

  • Operational Strategies

    • Implementing fishing activities to reduce bass numbers to revert to a balanced ecosystem.

Calculating Relative Weight

  • Formulation

    • Relative weight calculated by:
      Relative Weight=WeightStandard Weight×100\text{Relative Weight} = \frac{\text{Weight}}{\text{Standard Weight}} \times 100

    • Components identified:

      • Actual fish weight noted as 400 grams and length as 300 millimeters.

      • Standard weight derived from equations using logarithmic values.

  • Logarithmic Calculations

    • Health assessment based on comparing actual fish weights to standard.

      • Conversion noted: using a log scale for weights leads to potential negative values (e.g., -5.528).

  • Final Weight Outcome

    • Final calculations yield an expectation of fish weight at 371.53 grams for health indication.

    • Fish above standard weight reflects well-nourished status.

Homework Assignments

  • Checklist provided for homework:

    • Complete calculations based on given data and methods discussed in the session.

    • Prepare work for submission by noting procedures followed.