The Excel file has over 101000 cells of data and I cant post it on here. I only want to know how to solve these 2 questions on Excel.

Please show steps. Thank you

There are some who say that baseball batting performance can't be judged correctly today because of changes in rules and changes in supporting technologies--such as how bats are made. Below is a data set of baseball batting performance dating back to 1871. The data set is very large making it unfeasible to use all data in your analysis. Instead, sample it. One simple way to do this is to use Excel Power pivot or the legacy pivot table tool to extract some data from each date range. It is recommended that you collect at least 100 data points in your area of interest for each of the date ranges.

Baseball (XLSX)

Using this data set, answer the following questions and present your responses in a 5 to 7 slide presentation incorporating your findings:

Question 1:Sample the baseball batting data from 1871-1900, 1900-1950, and 1950-2000, and 2000-Present. Do you seen any patterns in the data samples? Present any patterns that you observe.

Question 2:Based on your samples, what can you say about batting performance over the years? Does the data suggest that anything has changed?

You may sample the data as you see fit, but explain your rationale for the sampling decisions you make.

Comments File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Share Calibri = General O v 11 A" A ab Wrap Text Paste $ ~ % 9 00 -20 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze BIUVV MAY EE Merge & Center Formatting Table " Styles v Filter ~ Select v Data Cells Editing Analysis Clipboard Font Alignment Number Styles Q1087 X V fox M N O P O R A B D E F G H K 3B HR RBI SB CS BB SC IBB 1 playerID yearID stint teamID gID G AP R H 2 abercda01 1871 1 TRO NA 1 4 0 O O w addybo01 1871 1 RC1 NA 25 118 30 32 13 19 4 allisar01 1871 1 CL1 NA 29 137 28 40 allisdo01 1871 1 WS3 NA 27 133 28 44 10 6 ansonca01 1871 1 RC1 NA 25 120 29 39 11 7 armstbo01 1871 1 FW1 NA 12 49 9 11 OH OD OH W NUOC ON 8 barkeal01 1871 1 RC1 NA 1 4 0 1 9 barnero01 1871 1 BS1 NA 31 157 66 63 UT 10 barrebi01 1871 1 FW1 NA 1 1 1 11 barrofro1 1871 1 BS1 NA 18 86 13 13 12 bassjo01 1871 1 CL1 NA 22 89 18 27 13 battijo01 1871 1 CL1 NA 1 3 0 0 14 bealsto01 1871 1 WS3 NA 10 36 6 15 beaveed01 1871 1 TRO NA 3 15 94 24 33 O N N U O O PO HOW OOD AN NO OH OHOOOH WOOO O 00 0 0 N H O V A W H A O O U N O N H W O O W H O N O NAC 1871 NA 20 OH H O O O O O O O H O O P O O O O H OO OO H N P P PC O O O O H O O O O O O O O O H O O O W O O O O O O N O O O ON W H H ON A NONOWNNOOOPOOHOHHNUO 16 bechtge01 1 PH1 17 bellast01 1871 1 TRO NA 29 128 26 32 N O O O D O H A W O O O O W H U H O OO H H A N UTO 18 berkena01 1871 1 PH1 NA 1 4 o 0 19 berryto01 1871 1 PH1 NA 1 4 0 1 O W O N N O D W N O H O O W O O O O H N HO 20 berthha01 1871 1 WS3 NA 17 73 17 17 TOWOOWOOHOOWHOO 21 biermch01 1871 1 FW1 NA 1 2 0 0 22 birdge01 1871 1 RC1 NA 25 106 19 28 23 birdsda01 1871 1 BS1 NA 29 152 51 46 24 brainas01 1871 1 WS3 NA 30 134 24 30 25 brannmi01 1871 1 CH1 NA 3 14 IN 1 26 burrohe01 1871 1 WS3 NA 12 63 11 15 27 careyto01 1871 1 FW1 NA 19 87 16 20 28 carleji01 1871 1 CL1 NA 29 127 31 32 29 conefr01 1871 1 BS1 NA 19 77 17 20 30 connone01 1871 1 TRO NA 7 33 6 7 Batting + + 1059 Ready