Week $4$ Assignment $1$: Creating a Frequency Distribution $-$ Lab Attached Files: File Week $4$ Database$\_$Lab Assignment.xlsx $(15\mathrm{.}433$ KB$)$ Using the attached excel database information, create a frequency distribution in the form of a histogram column chart, following the steps explained in Chapter $4.$ See the database below: Note: This assignment requires that you download the free analysis toolpak for Excel. In addition, review the Basic Excel Skills $($PDF$)$ Basic Excel Skills $($PDF$)-$ Alternative Formats from Business Analytics. Answer the following questions in a Word document. Upload your excel database with frequency distribution and histogram as a separate excel file. See questions below: Calculate frequency and create a frequency distribution for the products in the database using the input range and bin range steps demonstrated in Chapter $4.$ What does this chart tell us about our data? Next, calculate relative frequency using the instructions in Chapter $4$ and create a second chart. What can we conclude? Why is relative frequency important to help you understand the nature of the data?

$\backslash$table$[[$Month$,$A$,$B$,$C$,$D$,$E$],[$January$,7,792,5,554,3,105,3,168,10,350],[$February$,7,268,3,024,3,228,3,751,8,965],[$March$,7,049,5,543,2,147,3,319,6,827],[$April$,7,560,5,232,2,636,4,057,8,544],[$May$,8,233,5,450,2,726,3,837,7,535],[$June$,8,629,3,943,2,705,4,664,9,070],[$July$,8,702,5,991,2,891,5,418,8,389],[$August$,9,215,3,920,2,782,4,085,7,367],[$September$,8,986,4,753,2,524,5,575,5,377],[$October$,8,654,4,746,3,258,5,333,7,645],[$November$,8,315,3,566,2,144,4,924,8,173],[$December$,7,978,5,670,3,071,6,563,6,088],[,,,,,],[$Average$,8,198,4,783,2,768,4,558,7,861],[$Stdv$,682\mathrm{.}46,957\mathrm{.}9,372\mathrm{.}963,1029,1365\mathrm{.}1],[$Count$,12,,,,]]$