Data Analysis Assignment

Instructions: Read all instructions before you begin this assignment.

Before creating a table or beginning to calculate data from the information displayed below, stop and figure out a systematic approach to table configuration. Determine the steps needed to complete the problem. For example, what columns and column titles will you need to organize your data? How many columns will you need?

$\backslash$table$[[$Lamb ID$,$Birth Weights,$60$ D Weights$],[$Wooly$,7,54],[$Fluffy$,10,45],[$Puffy$,15,52],[$Baa$-$ma$,22,60],[$Lucy$,11,64],[$Lucky$,13,59],[$Lamb chop,$20,69],[$Gertrude$,18,55],[$Penelope$,15,57],[$All lambs have been on feed for $60$ days.$]]$

Create a table that includes columns for: Lamb ID$,$ Birth Weight $($LBS$),60-$Day Weight $($LBS$),$ Days on Feed, Pounds $($LBS$)$ Gained, Average Daily Gain, and a row at the bottom of the table titled 'Average' that includes the averages of all of columns. Title the table Lamb Performance Records.

To calculate the LBS Gained, subtract the Birth Weight from the $60-$day Weight. To calculate the Average Daily Gain, divide the Pounds Gained by the Number of Days on Feed. Do not do the math by hand, write the appropriate equations in the formula bar as we have been doing in other problems. Be sure Average Daily Gain has two decimal places. Determine the averages of each column in the Average row using the average formula.

Next, sort the list by highest Average Daily Gain to lowest. Then copy and paste the table below the first table and sort the lambs by ID$,$ in alphabetical order.

Then, use a clustered column chart with $3-$D visual to illustrate the comparison of Average Daily Gain between Wooly, Baa$-$ma$,$ & Gertrude. Please include the chart on the same page, below the last table. Name the table Gain Comparison and label the appropriate axis $($LBS$).$

If lambs are fed from $3$ to $4\%$ of their body weight daily, they should gain between $\mathrm{.}6$ and $1\mathrm{.}0$ pound per day. Based on the data shown above for the flock's Average Daily Gain make a management recommendation regarding lamb feed intake. Should the lambs be fed more, less, or stay the same?

Remember to dress your table up to look professional $($i$.$e$.$ borders, shading, centered data, consistent rounding$)$ as was discussed in last week's learning Module on Canvas.

Be sure that all tables & chart fit comfortably on one page.