Problem 1. Data are provided regarding the Length and Weight of snakes. I would

Question

Problem 1. Data are provided regarding the Length and Weight of snakes. I would like you to graph the data in the following ways: 1) Scatter Plot Length x Weight (Insert tab, Scatter) and 2) add a Linear and exponential trend line to the graph (Trendline found in Layout section of excel). Next, add the equation and the r2 value associated with each of the trend lines (Trendlines, More Treadline Options). Copy and paste the figure as a bitmap into this Word Document. Now, describe which relationship (linear or exponential) does a better job of describing the results.

Problem 2. You are investigating whether male or female birds feed more frequently. You collect data regarding the # of foraging bouts seen in one day for male and female birds of the two different species. Conduct the following analyses. 1. Calculate the Average number (Formulas, Insert Function) of foraging bouts for each sex of each species. Graph the average group data for each species/sex (Insert Graph, Column). 2. Calculate the Standard Deviation (Formulas, Insert Function). Plot the standard deviation error bars on the graph (Layout, Error Bars). Copy Graph and insert as Bitmap to this word document. Describe and interpret the results.

Problem 3. A scientist is investigating which media promotes the fastest growth for microbes producing hydrogen gas (i.e., production for hydrogen fueled automobiles). Conduct the following analyses. 1. Calculate the Average growth rate (Formulas, Insert Function) of bacteria under each media and the control. Graph the average group data for each media (Insert Graph, Column). 2. Calculate the Standard Error (Formulas, Insert Function). Plot the standard error bars on the graph (Layout, Error Bars). Copy Graph and insert as Bitmap to this word document. Describe and interpret the results.

Problem #1 Length Weight 23.33045769 63.34530465 614.1937562 843.7832807 265.1925829 50.58260753 534.433069 316.2020681 451.8574762 1693.991429 496.2126197 1068.836494 457.5309269 1617.957358 59.11956739 90.87545332 609.276437 1001.242076 10.50088729 7.731493037 638.7877096 72.56785589 427.2656504 181.7120083 153.6628706 76.79692379 366.1006527 963.5251 14.16243677 8.508209685 609.5852048 409.5949459 68.65587249 126.4398702 652.669258 912.7306349 183.0778759 48.81494923 330.4195555 1162.402007 201.5832377 788.3965374 321.3211657 1242.856575

Explanation / Answer

1.

The R2 value is describe that length and weight ishow much more correlated.

Here the R2 value of exponential trend is greater than the linear trend. We say that exponential is better for this data

2.

Mean Standard deviation Species A Male 18.40741 9.923783627 Female 10.7037 6.764243177 Species B Male 17.96296 10.94560495 Female 21.37037 10.87392134

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.