Part 2:

• Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem.
• If Excel was used, please indicate that as well on the word document.
• A word document and/or the Excel Workbook (if used) should be submitted to the Dropbox with labels on the worksheets to indicate which problem is being evaluated.
• All answers should be clearly indicated.
• Written explanation, reasoning, and rationale should use complete sentences.

Cell A2=Number of crimes, Cell B2=Number of Police and Cell C2= Total enrollment.

Visit the dataset link to view the datasets that accompany our textbook. Review the dataset titles and select a data set of interest to you that has at least 30 data values. See Example and CA Video Starter in this modules LiveBinder. (Campus Crime Chosen)

1. Summarize data (Campus Crime) with frequency distribution tables.
   1. Create a frequency distribution table from the data selected. (Please show excel work)
   2. Write a sentence for each of three findings based on the frequency distribution table in terms of the variable chosen.
2. Visualize numeric variables through histograms. (Please include Excel data table explaining how histogram was created so I know what was done). Thank you :)
   1. Using your frequency information construct a histogram (for continuous variables) or bar chart (for discrete variables). Make sure to title your chart appropriately. Excel worksheet is to show work done.
   2. Based on this visual representation, does the data appear to be left skewed, right skewed, or symmetrical. Explain your rationale for the choice.

Information about what sum? Please explain as I dont understand. can I upload the excel worksheet that ive given a photo of? I'm not sure how.

Clipboard K12 AX 1-Yes 0 1 Campus Crime Data 2 Number Number a Total fra Private School 3 60 12 1.131 4 138 21 12,954 0 5 32 16.003 0 5 80 22 1.602 1 35 2.08 1 1:01 17,497 0 115 3,023 1 10 50 4,306 1 11 201 75 34.511 0 12 203 34 37,240 0 13 35 2.918 1 14 234 103 39,414 O 15 141 4,000 1 56 14 50 20.950 0 17 152 41 1 18 158 52 26.519 0 11 69 27.687 20 25 2.810 123 50 27.619 0 56 1 HE Clipboard K12 AX 1-Yes 0 1 Campus Crime Data 2 Number Number a Total fra Private School 3 60 12 1.131 4 138 21 12,954 0 5 32 16.003 0 5 80 22 1.602 1 35 2.08 1 1:01 17,497 0 115 3,023 1 10 50 4,306 1 11 201 75 34.511 0 12 203 34 37,240 0 13 35 2.918 1 14 234 103 39,414 O 15 141 4,000 1 56 14 50 20.950 0 17 152 41 1 18 158 52 26.519 0 11 69 27.687 20 25 2.810 123 50 27.619 0 56 1 HE