Answer all questions

X AutoSave Ong MATH 1130 Data & Tech Part 1 of 2 HW . Saved File Home Insert Draw Page Layout Formulas Data Review View Help Comments K) Calibri 12 A ap Wrap Text General Ex APO Sort & Find & Analyze Sensitivity Paste B I U ~ FDA v Merge & Center $ % " Conditional Format as Cell Insert Delete Format Formatting Y Table y Styles D Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Undo V29 A B C D E G H K M N O P 2 California 39538223 3 Texas 29145505 The 2020 population for each state listed to the left. Answer the following questions Insert histogram with a title and the vertical axis labeled Frequency 4 Florida 21538187 using EXCEL functions. Do not use column A, state name in the calculations Use a bin size of 2,000,000 and an underflow of 2,000,000 5 New York 20201249 Chart Title 6 Pennsylvania 13002700 Min: 12812508 576,851 Max: 39,538,223 40 Illinois Ohio 11799448 9 Georgia 10711908 Median: Mean: 35 10 North Carolina 10439388 4,505,836.00 6,549,913.92 11 Michigan 10077331 9288994 30 12 New Jersey Q1: 1,900,305.00 Q3: 7,428,391.50 13 Virginia 8631393 14 Washington 7705281 25 15 /Arizona 7151502 Based on the Median and the Mean, right-tailed 6 Massachusetts 7029917 describe how the data is skewed. Frequency 20 Tennessee 6910840 Indiana 6785528 Insert Box Plot with a title and the vertical axis labeled. Maryland 6177224 15 Abt Area Missouri 6154913 State Population Wisconsin 5893718 10 Colorado 5773714 45000000 Minnesota 5706494 South Carolina 5118425 5 alaba State Population US Presidents Cereal Median Incomes + 107% EX Accessibility: Investigate 12:46 AM O 12/6/2022