Question

Math 243 Activity #4 Correlation Names Do the following problems with your team. Show all your work. This activity is due at the next class meeting. Zoologists wish to study the feeding behavior of a species of blackbream fish. They record the number of 1) strikes of randomly selected fish as they feed off the bottom of an aquarium. This data is shown with the age of the fish (in days) in the table given below. Week Number of Strikes Age of Fish 1 85 2 63 136 3 34 160 5 58 152 39 159 6 35 169 7 57 158 8 12 189 9 15 197 117 a) Create a scatterplot of the data using Statkey. Let the number of strikes be the predictor and the age of the fish be the response. Neatly sketch it below. Use a ruler or straight edge, please. b) Looking ONLY at scatterplot itself, does the plot look "not linear","fairly linear", or "very linear"? Describe your reasoning. Do not use anything but the scatterplot in your determination c) What is the correlation between the age of the fish and the number of strikes? Does this correlation tend to agree with your assessment of the scatterplot? Why?

Answer 1

Dear student we can provide you with the solution of 1 question at a time.

1)

a)

Age of fish 250 200 150 Age of Fish 100 50 0 0 10 20 30 40 50 60 70 80 90 No. of strike

b)The plot appears to be very linear as the data points are close to the line of best fit. The slope is reducingwhich tells that there is a negative relationship between the two variable.

c) Correlation is 0.9175 which is close to 1, Hence correlation tend to agree with scatterplot assessment.

BS Book1 - Excel Gurvinder Singh X File Home Insert Page Layout Formulas Data Review View Help & Share FREE el Group A Za TI I Data Analysis Tell me what you want to do Clear Reapply AL Sort Filter Advanced ENT Connections E Properties Edit Links Show Queries From Table New Query Lo Recent Sources Get & Transform << > Get External Data 3 Refresh All- Stocks Geography Text to Ungroup Subtotal What If Forecast Analysis – Sheet Forecast Columns Connections Data Types Sort & Filter Data Tools Outline Analysis Q16 fic Regression ? X A B C D E F G Н - P Q RA Input Input Y Range: OK $B$1:$B$10 1 Cancel SUMMARY OUTPUT Input X Range: SA$1:$A$10 1 Help Constant is Zero 1 number of strike Age of fish 2 85 117 3 63 136 4 34 160 5 39 159 6 58 152 7 35 169 8 57 158 9 12 189 Labels Confidence Level: 95 % Regression Statistics Multiple R 0.95788707 R Square 0.91754763 Adjusted R Square 0.90576872 Standard Error 7.50668399 Observations 9 SDS2 Output options OlQutput Range O New Worksheet Ply: O New Workbook Residuals Residuals Standardized Residuals 10 15 197 ANOVA 12 df F 77.8975 Significance F 4.84255E-05 Residual Plots Line Fit Plots 80 90 13 Regression Residual SS MS 4389.547868 4389.548 394.4521316 56.3503 4784 1 7 8 14 Normal Probability Normal Probability Plots Total 15 16 17 18 Intercept number of strike Coefficients Standard Error t Stat P-value Lower 95% Upper 95% ower 95.09 pper 95.0% 203.452132 5.556307234 36.61643 2.94E-09 190.3135528 216.59071 190.3136 216.5907 -0.99012358 0.112183153 -8.82596 4.84E-05 -1.255394584 -0.7248526 -1.25539 -1.25539 -0.72485 19 20 21 22 Sheet1 Sheet2 Sheet3 Sheet4 Sheets Ready PER + 100% Type here to search o i e Ta ) ENG 04:25 19-05-2020 w (33