Please create personalized and substantive responses to at least two other student main posts. In your response, include the following:
Choose any two classmates and review their main posts.
- Find the dataset that each student used, and repeat their r value calculation in Excel for the variables they chose. Are they correct? Do you agree with how they described the relationship between the two variables? Explain in one paragraph and include both your results and the student results.
- For the same two classmates, also review their scatterplots. Discuss the “shape” of the scatterplot – is it mostly linear or is it all scattered around? Does the scatterplot seem to have a positive (upwards from left to right) or negative slope? Does their scatterplot visually match what the r value is suggesting? What can you say about the relationship based on the scatterplot?
Student 1 post shidadah attached
Student 2 post brianna is attached
Sheet1
| Weight-X | BMI-Y | |||||||||||||||||||
| 114.8 | 19.6 | |||||||||||||||||||
| 149.3 | 23.8 | |||||||||||||||||||
| 107.8 | r= | 0.9688432566 | FEMALE HEALTH DATA | |||||||||||||||||
| 160.1 | 29.1 | |||||||||||||||||||
| 127.1 | 25.2 | |||||||||||||||||||
| 123.1 | 21.4 | |||||||||||||||||||
| 111.7 | 22 | |||||||||||||||||||
| 156.3 | 27.5 | |||||||||||||||||||
| 218.8 | 33.5 | |||||||||||||||||||
| 110.2 | 20.6 | |||||||||||||||||||
| 188.3 | 29.9 | |||||||||||||||||||
| 105.4 | 17.7 | |||||||||||||||||||
| 136.1 | 24 | |||||||||||||||||||
| 182.4 | 28.9 | |||||||||||||||||||
| 238.4 | 37.7 | |||||||||||||||||||
| 108.8 | 18.3 | |||||||||||||||||||
| STRONG positive | ||||||||||||||||||||
| R value informs you that if Weight goes up so will BMI |
Weight vs BMI
0 114.8 149.30000000000001 107.8 160.1 127.1 123.1 111.7 156.30000000000001 218.8 110.2 188.3 105.4 136.1 182.4 238.4 108.8 0 19.600000000000001 23.8 19.600000000000001 29.1 25.2 21.4 22 27.5 33.5 20.6 29.9 17.7 24 28.9 37.700000000000003 18.3 0 0.96884325657398052
Sheet1
72
88
60
72
56
64
60
68
64
60
68
60
84
72
64
56
56
64
20 72
Men’s Pulse vs. Age
Pulse
58 22 32 31 28 46 41 56 20 54 17 73 52 25 29 17 41 52 32 20 20 29 18 26 33 55 53 28 28 37 40 33 26 53 36 34 42 18 44 20 68 65 88 72 64 72 60 88 76 60 96 72 56 64 60 64 84 76 84 88 72 56 68 64 60 68 60 60 56 84 72 84 88 56 64 56 56 60 64 72
Age
Pulse