As a Bream (Abramis Brama) fisherman you need to make sure you are aware of how much fish you are bringing in. If you catch too many fish by weight, you will exceed your boats capacity, and/ or be out

As a Bream (Abramis Brama) fisherman you need to make sure you are aware of how much fish you are bringing in. If you catch too many fish by weight, you will exceed your boats capacity, and/ or be out of compliance with regulations. Towards the end of you trip, some of you crew decide to weigh themselves on your fish scale and break it. You think you may have head home, which could lead to financial loss, but you think you might be able to stay out if you could estimate the weight of your fish using the data collected by the fish market last season. Instructions:

•For the Bream Species of fish create three scatter charts, including both atrendline and an R2 value. Adjust any data you may see as an outlier.

• Chart 1 – Weight vs Total Body Height
• Chart 2 - Weight vs Total Length
• Chart 3 – Weight vs Width

•Answer which measure (length, height or width) is the best predictor of weight?Statistically, do you consider it a good indicator of weight?

•Estimate what the weight would be the fish below using your chosen regressionchart.

•In the case of the fishman, would you rather predict a lower weight or higher?

•All charts should be well labeled with descriptive titles and axis labels.

Requirements:

Workbook, feel free to put the text answer in cells, textboxes or a sperate document.