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 say out if you could estimate the weight of your fish using the data collected by the fish market last season.
BUS509 – Descriptive Analytics and Decisions
Unit 4 Assignment
Due Date: 11:59 pm EST Saturday of Unit 5
Points: 60
Overview:
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 say 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 a
trendline and an R2 value. Adjust any data you may see as an outlier.
o Chart 1 – Weight vs Total Body Height
o Chart 2 – Weight vs Total Length
o 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 regression
chart.
Body
height
32.7
•
•
Total
Length
37
Diagonal
Length
40.2
Body
Height
22
Width
5
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.
Be sure to read the criteria below by which your work will be evaluated before
you write and again after you write.
Evaluation Rubric
Criteria
3 Charts
Questions posed
Exemplary
35
Chart clear, well labeled
and easily digestible.
Outlier correctly removed.
25
Questions are fully and
correctly answered.
Proficient
25-34
Chart displays data, but
not easily understandable
or labeled. Outlier
correctly removed.
17-24
Questions correctly or
mostly correctly
answered.
Deficient
0-24
Chart does not include
data, or data is not
readable by an average
reader.
0-16
Questions not fully
answered, or mostly
incorrect.
Species
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Bream
Weight (grams)
1000
975
955
950
925
920
850
725
720
714
700
700
700
685
680
650
620
610
600
600
575
500
500
500
500
475
450
450
430
390
363
340
340
290
242
Body height (cm)
Total Length (cm)
Width
33.5
37
37.4
41
35
38.5
38
41
36.2
39.5
35
38.5
32.8
36
31.8
35
32
35
32.7
36
30.4
33
30.4
33
31.9
35
31.4
34
31.8
35
31
33.5
31.5
34.5
30.9
33.5
29.4
32
29.4
32
31.3
34
26.8
29.7
28.5
30.7
28.7
31
29.1
31.5
28.4
31
26.8
29.7
27.6
30
26.5
29
27.6
30
26.3
29
23.9
26.5
29.5
32
24
26.3
23.2
25.4
6.603
6.7473
6.292
6.3705
6.7497
6.3063
6.1984
6.0532
6.09
5.8515
5.2854
5.1975
5.589
5.3704
6.1306
5.7276
5.2801
5.1338
5.58
5.1708
5.5695
5.2785
4.9594
4.8146
4.368
5.1042
4.9274
4.8438
5.134
4.69
4.4555
4.6961
5.0728
4.3056
4.02

Purchase answer to see full
attachment