Use the data in the attached Excel sheet and complete the assignment detailed in the instructions below.

1. First, make sure you have the Data Analysis Toolpak for Excel installed.

2. Open the Assignment 2 Excel sheet and examine the three variables listed. The variables are the names, age, and years of service of United States Senators from 2017. You will be analyzing the data for the two quantitative variables listed (Age and Years of Service). Again, note that you will not be analyzing anything regarding the categorical variable of personal name.

3. You should then decide on a BIN range and make a histogram for each quantitative variable that makes sense given the data. You can start by picking an interval range that seems reasonable and see how it works out. Look to your textbook section on frequency distributions and the corresponding PowerPoints to get additional suggestions on how to choose an appropriate interval range for each quantitative variable. Again, note you will be making a separate histogram for each quantitative variable listed in the sheet (i.e., two histograms total).

4. Calculate the descriptive statistics for each quantitative variable. Be sure to include the following.

1. Measures of central tendency (for now, just do all three)
2. A good measure of variability (use the standard deviation because it is themost useful of the measures covered in lecture)
3. Calculate information related to the shape of the distribution (i.e., Skew and Kurt)

5. Write a report describing the results for each quantitative variable. You should report (in complete sentences, no bullet points or large tables) the measures you used, the results of the calculations, and what the numbers indicate. Be sure to report everything requested and nothing else.

• What were the mean, median, and mode for each quantitative variable? Which of these measures would best reflect the "typical" value for each distribution?
• What was the standard deviation?
• What about the shape of the distributions? Were the distributions relatively "normal"? Or, were they skewed? Were they mesokurtic, leptokurtic, or platykurtic? It is important that you report the numbers and your interpretation of what those numbers mean (e.g., if I reported a Skew value of -1.6, I would describe the distribution as being negatively skewed). Note that there are two distributions, which means that you will need to report results for each one.
• Be sure to include your histograms in the report. You are not to turn in an Excel sheet, only a Word document with the results, description of the results, and the histograms included.

US Senator Age Length of Service (Years in Senate) Richard Shelby 83 30 Luther Strange 64 Lisa Murkowski 60 14 Dan Sullivan 52 John Mccain 81 30 Jeff Flake 54 4 John Boozman 66 6 Tom Cotton 40 Dianne Feinstein 84 24 Kamala Harris 52 Michael Bennet 52 Cory Gardner 43 Richard Blumenthal 71 Chris Murphy 44 Tom Carper 70 16 Chris Coons 54 Bill Nelson 74 16 Marco Rubio 46 Johnny Isakson 72 David Perdue 67 Brian Schatz 44 Mazie Hirono 69 SOO DO A ANN Mike Crapo 66 Jim Risch 74 Dick Durbin 72 Tammy Duckworth 49 Joe Donnelly 61 Todd Young 45 Chuck Grassley 84 Joni Ernst 47 Pat Roberts 81 Jerry Moran 63 Mitch Mcconnell 75 Rand Paul 54 Bill Cassidy 59 John N. Kennedy 65 Susan Collins 64 Angus King 73 Ben Cardin 73 Chris Van Hollen 58 Elizabeth Warren 68 Ed Markey 71 Debbie Stabenow 67 Gary Peters 58 Amy Klobuchar 57 Al Franken 66 Thad Cochran 79 Roger Wicker 66 Claire Mccaskill 64 Roy Blunt 67 Jon Tester 61 Steve Daines 55 Deb Fischer 66 Ben Sasse 45 Dean Heller 57 Catherine Cortez Masto 53 Jeanne Shaheen 70 Maggie Hassan 59 Bob Menendez 63 Cory Booker 48 Tom Udall 69 Martin Heinrich 45 Chuck Schumer 66 Kirsten Gillibrand 50 Richard Burr 61 Thom Tillis 57 John Hoeven 60 Heidi Heitkamp 61 Sherrod Brown 64 Rob Portman 61 Jim Inhofe 82 James Lankford 49 Ron Wyden 68 Jeff Merkley 60 Bob Casey Jr. 57 Pat Toomey 55 Jack Reed 67 Sheldon Whitehouse 61 Lindsey Graham 62 Tim Scott 51 John Thune 56 12 Mike Rounds 62 2 Lamar Alexander 77 14 Bob Corker 65 10 John Cornyn 65 14 Ted Cruz 46 Orrin Hatch 83 40 Mike Lee 46 Patrick Leahy 77 42 Bernie Sanders 76 10 Mark Warner 62 Tim Kaine 59 Patty Murray 66 Maria Cantwell 58\f