Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Part 2: Use the data in Table 3 to make a table in MS Excel that lists the population name {Lake} and the sample statistics

image text in transcribedimage text in transcribed
Part 2: Use the data in Table 3 to make a table in MS Excel that lists the population name {Lake} and the sample statistics for each population including mean ducklings fledged, median, DF, 55, 52, s {or SD}, SE, and t95{SE} for each of the populations. {10 pts) Part 3: Use the data in Table 3 below as a template to construct your table in MS Word (follow the Homework Guidelines and the format we used in Lab 1). Part 4: Using either MS Excel or SigmaPlot, make a bar graph using the data in Table 3 that illustrates the mean with the 95% CI represented as \"error bars.\" (10 pts) Table 2 {Sample data for homework}. The number of ducklings that fledged (survived) from randomly located nests at ve prairie pothole lakes in southern Minnesota during the summer of 2020. Loon Eagle Hemlock Saranac Middle Lake Lake Lake Lake Lake 12 15 12 5 15 9 8 14 4 11 18 12 11 2 7 13 6 9 8 10 11 4 15 4 12 10 11 7 5 7 25 8 9 4 10 22 13 6 3 9 1 Table 3. Use this sheet as an example to set up your table for this homework assignment in Excel. (Note: format your table following the format provided in the Homework Guidelines). Lake J? Median DF 55 s2 slor SD} SE tgslSE) Loon Eagle Hemlock Saranac Middle 12 Properly formatted table and figure using the data from Table 3. Answer the following questions using full sentences. Follow the homework guidelines. 1. What is the mean and 95% Cl of Eagle lake? (2 pts) 2. Which lakes had a difference in mean number of ducklings fledged (interpret this visually from differences in the 95% CI)? State all contrasts that are significantly different. (4 pts) 3. Using a t-test, report the t-score and P-value generated when comparing fledgling population differences among Loon and Saranac Lake. State if the lake means are significantly different from each other or not. See the example on page 9 for an example of a declarative statement. (4 pts)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Principles of Economics

Authors: Tyler Cowen, Alex Tabarrok

3rd edition

1429278390, 978-1429278416, 1429278412, 978-1429278393

Students also viewed these Mathematics questions