Lab #$1$ Assignment:

$8.$ Put Assignment in a new worksheet in the same file and title the tab $$Assignment $1.$

The following data is a list of weight of discarded food in one week $($lb$)$ from $27$ households.

Use Excel to create a frequency table, relative frequency table, and histogram for the $27$ values below. Use $6$ classes of $0\mathrm{.}00-1\mathrm{.}99,2\mathrm{.}00-3\mathrm{.}99,4\mathrm{.}00-5\mathrm{.}99,$ etc. Modify the frequency table and histogram as above, including relevant titles etc. You can copy the data from the $$Assignment Data$$ tab into your $$Assignment $1$ tab.

$1\mathrm{.}412\mathrm{.}864\mathrm{.}332\mathrm{.}091\mathrm{.}034\mathrm{.}648\mathrm{.}289\mathrm{.}264\mathrm{.}142\mathrm{.}379\mathrm{.}133\mathrm{.}955\mathrm{.}631\mathrm{.}747\mathrm{.}602\mathrm{.}251\mathrm{.}575\mathrm{.}461\mathrm{.}396\mathrm{.}646\mathrm{.}275\mathrm{.}679\mathrm{.}270\mathrm{.}615\mathrm{.}2511\mathrm{.}294\mathrm{.}86$

$9.$ Save and Submit

In cell F$1$ type $$Name$$ and type your name in cell G$1$

In cell F$2$ type $$Student Number$$ and type your student number in cell G$2.$

Once you have completed the assignment, save your assignment to your desktop by selecting File $->$ Save As$.$ Ensure that the name of your file is in the following format $->$Student Number $$ Section # $-$ Lab #$.$

For example, if your student number is $0123456$ and your section number is $2,$ then the name of this assignment$$s file should be:

$012345621$

Once you have saved your assignment to your desktop, submit your file on Blackboard using the Assignment Dropbox tab.