$******$please note the second photo is an example$******$

For Lab $1$ you will be finding two sets of data with at least $30$ elements in each

One set must be numeric, the other categorical.

Collect$/$Find data sets that interest you!

You can gather your own: get a bag of skittles and count the colors,

weigh the bullets in a box, tally the types of vehicles that pass through an intersection, etc.

You can search the internet: Ski to Sea racer ages, average income by state

crimes by state, car accidents by state, gas prices by state, unemployment rates

batting averages MLB$,$ weights or rushing yards NFL$,$ heights or top scorers NBA, etc.

$1.$ List your data sets in column A of the blue worksheets $($see tabs at the bottom of this page$).$

$2.$ Answer the questions in each blue worksheet. Make sure to leave all your formulas in$,$ so I can check your work.

RAW

SORTED

DATA

Des

Measures of Center:

Mean

Median

Mode

Other Positiion Measures:

Min

Import raw data to coumn A$,$ copy the data into column B and sort from least to greatest, then add description and source above.

Calculate the statistics in the green boxes.

Helpful functions: $=$AVERAGE, $=$MAX, $=$ MIN, $=$ MEDIAN, $=$ MODE, $=$ QUARTILE, $=$ STDEV

Max

$1$st Quartile

$3$rd Quartile

$3.$ Make a histogram that is titled, labeled, colorful and professional Make the bins start at end at nice round numbers

Hints: Creating a histogram in Excel is a little weird $($and dependend on version $/$ operating system$)$ try selecting your data $($sorted or unsorted$)$ and then "insert" and "histogram".

To alter the appearance "Chart Design", "Add Chart Element" and "Format Data Series" are all useful.

$3.$ Place vour histoaram in this box:

Measures of Spread:

Range

Inter$-$Quartile Range

Standard Deviation

Fences:

Lower Fence

Upper Fence

Raw$197190195315210305210255308202212318252285308243220255225190177237228212248240294325243225215206238238318315190254197315222185250192301250306214308225315209200220258195277242205302196218315292226215209204209235215292220200205255225195193330315230260304260210260320$RTELDATA$177185190190190192193195195195196197197200200202204205205205206209209210210210212212214215215215218220220220222225225225225226228235237238238240242243243248250250252254255255255258260260260277285292292294301302304305306308308308315315315315315315318318320325330$Descrintion of vour data:Dallas Cowboys Player Weights $2021$ SeasonSource of vour datahttps:$/$www$.$dallascowbovs.com$/$team$/$players$-$roster$1.$ Import raw data, copy the data into column B and sort from least togreatest, then add description and source above$\mathrm{.}2.$ Calculate the statistics in the green boxes.Helpful functions: $=$AVERAGE, $=$MAX, $=$MIN, $=$MEDIAN, $=$MODE, $=$QUARTILE, $=$STDEV$3.$ Make a histogram that is titled, labeled, colorful and professionalMake the bins start at end at nice round numbersHints: Creating a histogram in Excel is a little weird $($and dependend on version $/$ operating system$)$try selecting your data $($sorted or unsorted$)$ and then "instert" and "hiostogram".To alter the appearance "Chart Design", "Add Chart Element" and "Format Data Series" are all useful$\mathrm{.}201510$Place VOur histoaram in this box:$180$Dallas cowboy...$(180,200](200,2201(220,240](240,260](260,280](280,300|(300,320](320,340]$player weightsMeasures of CenterMeanMedianModeMinMaxOther Position Measures$1$st Quartile$3$rd QuartileMeasures of SpreadRangeInter$-$Quartile RangeStandard DeviationFences:Lower Fence$244\mathrm{.}2$Upper Fence$232\mathrm{.}5315177330209286\mathrm{.}75153\mathrm{.}077844092\mathrm{.}38403\mathrm{.}38$