ࡱ> kmj` bjbj .^p;~~~~^^^r8.Tr>BX(''' >">">">">">">$W?hAF>^'c'"'''F>~~[>***'^~^ >*' >**p9@^$;6 1'^:;|q>0>:UBA(xUB($;UB^$;''*'''''F>F>)^'''>''''rrrrrrrrr~~~~~~ Excel Project 2 Baseball Statistics Open the spreadsheet baseball.xls and save it with your name as part of the file name. This spreadsheet contains statistics for some players on the Richfield Barons baseball team for their 20 games last season. Data has been entered for Games 1-10 and Games 11-20. Your task will be to create the formulas that compile statistics for the season. You will be using different formulas and functions in this project to calculate the season statistics for the team. You wont need to know much about baseball in order to complete this project. Baseball is played on a field that has 4 bases laid out in a square (or diamond). These bases are home plate, first base, second base, and third base going counter-clockwise from home plate. Players are AT BAT when they go to home plate and try to hit a baseball thrown to them by a pitcher who is standing in the middle of the square (diamond). Runs are scored when players have traveled from home plate through first, second, and third bases and have returned to home plate.  SHAPE \* MERGEFORMAT  Statistics about batting and scoring are kept for each player for each game and are shown on the spreadsheet for this project (baseball.xls). Abbreviations have been used for labeling the columns that describe the data collected for each player. These are: ABAt BatsThe number of times a player is at bat during a game1BSinglesThe number of times a player has hit the ball and reached first base as a result of the hit2BDoublesThe number of times a player has hit the ball and reached second base as a result of the hit3BTriplesThe number of times a player has hit the ball and reached third base as a result of the hitHRHome RunsThe number of times a player has hit the ball and has reached home plate as a result of the hitHTotal HitsThe number of times a player has hit the ball RBIRuns Batted In.The number of runs (scores) that resulted from a players hits, this can include runs from other players who were on a base before the player hit the ballTBTotal basesTotal number of bases reached as a result of a hit during the season (1 base for a single, 2 bases for a double, 3 bases for a triple, and 4 bases for a home run)AVGBatting AveragePlayers season batting average (total hits divided by total at bats) SLGSlugging PercentagePlayers season slugging percentage (total bases divided by total at bats)  Calculate the total at-bats (AB), total singles (1B), total doubles (2B), total triples (3B), total home runs (HR), total hits (H), and total runs batted in (RBI) for the season (all games) for each player. Use the formula auto fill method for entering the formulas for these calculations. Calculate each players average by dividing the seasons total hits (H) by the seasons total at-bats (AB). (show to 3 decimal places) Compile the total bases (TB) for each player using the formula: 1B + (2B*2) + (3B*3) + (HR*4) Type the formula inserting the appropriate cell references for the seasons singles, doubles, triples and home runs. Calculate the slugging percentage (SLG) for each player by dividing total bases (TB) by total at-bats (AB). Calculate the seasons total hits, doubles, triples, home runs, RBIs and total bases for the entire team using the Sum function. Insert these totals in a row below the entire team statistics in the appropriate columns and boldface them. Calculate the team average, the highest average, the lowest average, the highest slugging average (SLG) and the RBI leader for the season using functions and formulas. Remove the yellow color in your answer cells. Format the worksheet appropriately using font styles, colors, borders, etc. Merge the cells with the title Richfield Barons and subtitle Team statistics and center align both to the table. Save your changes and upload this file to your web page. The grading criteria for this assignment follow on the next page: Excel -Baseball Project Grading Criteria Points PossiblePoints AwardedCorrect formula and values for total at-bats, total hits, total doubles, total triples, total home runs, and total runs batted in for all games for each player 6 Correct formula and values for the average of each player2Correct formula and values for the total bases for each player2Correct formula and values for the slugging percentage for each player2Correct formula for calculating total hits, total doubles, total triples, total home runs, total RBIs and total bases for the entire team in the season 4 Correct function and formula applied for calculating the team average, the highest average, the lowest average, the highest slugging and the RBI leader for the season2 Formatting the work sheet font styles, colors, borders, merged cells, centered titles2Total Points20     EDT321 Excel Baseball Project Baseball project.doc  DATE \@ "M/d/yy" 9/27/04 Page  PAGE 3 Pitcher Third Base Second Base First Base Home Plate &(=Ielx}  0 \ ` x   H  l ) + C D [ \ ʾʎʎrrjh CJOJQJU^Jh CJOJQJ^JhtCJOJQJ^JhlCJOJQJ^JhW*ACJOJQJ^JhvmCJOJQJ^JhxCJOJQJ^JhmCJOJQJ^Jhxh)m5CJOJQJ^Jh)mCJOJQJ^Jh)mh)mOJQJ^J,&'( * + ` a d e h p $Ifgdi$$Ifa$gdigdm\ ] ^ _ ` a b { % & ' W b c e g Ǹ||pdpXppF#hihi5CJOJQJ^JaJhmCJOJQJ^JhxCJOJQJ^Jh)mCJOJQJ^Jh CJOJQJ^JhiCJOJQJ^JhtCJOJQJ^Jh8fCJOJQJ^JhlCJOJQJ^JhhlCJOJQJ^Jjh CJOJQJU^J%jh h CJOJQJU^J*jh CJOJQJU^JmHnHug h i k l  uvwzLMO89:ναqqeναναqeqeναh CJOJQJ^J hih CJOJQJ^JaJh CJOJQJ^JaJ#hih 5CJOJQJ^JaJh 5CJOJQJ^JaJhmCJOJQJ^J hihtCJOJQJ^JaJ hihmCJOJQJ^JaJhiCJOJQJ^JaJ#hihm5CJOJQJ^JaJ' yi\\ $Ifgdi$$Ifa$gdikd$$IflFd f!06    4 la vyi\\ $Ifgdi$$Ifa$gdikd@$$IflFd f!06    4 lavwzyi\\ $Ifgdi$$Ifa$gdikd$$IflFd f!06    4 laLyi\\ $Ifgd1I$$Ifa$gd1Ikd$$IflFd f!06    4 laLMOZyi\\ $Ifgd1I$$Ifa$gd1IkdP$$IflFd f!06    4 la9yi\\ $Ifgdi$$Ifa$gdikd$$IflFd f!06    4 la9:=Iyi\\ $Ifgdi$$Ifa$gdikd$$IflFd f!06    4 la:<=HIGHIMпбЉЗznbREhvm5CJOJQJ^Jh]h)m5CJOJQJ^Jh)mCJOJQJ^Jh3CJOJQJ^Jh35CJOJQJ^JaJh3CJOJQJ^JaJhxCJOJQJ^Jh CJOJQJ^JaJh CJOJQJ^JaJ hihxCJOJQJ^JaJhxCJOJQJ^JaJ#hihx5CJOJQJ^JaJhx5CJOJQJ^JaJHyi\\ $Ifgdi$$Ifa$gdikd`$$IflFd f!06    4 laHIMayi\\ $Ifgdi$$Ifa$gdikd$$IflFd f!06    4 laZ[./ysnhnfnffnh^ & Fh^hkd$$IflFd f!06    4 la   !#-137=LMPQVlózmÊaUh]CJOJQJ^JhxCJOJQJ^Jh 5CJOJQJ^Jh]h 5CJOJQJ^Jh)mCJOJQJ^Jhvm5CJOJQJ^Jh]h)m5CJOJQJ^Jh]hi5CJOJQJ^Jh CJOJQJ^Jh h 5CJOJQJ^Jh h)m5CJOJQJ^Jh hvm5CJOJQJ^J"*8=@EGRXg =Vs~踬ȏwwkkkkk[hKh)m5CJOJQJ^JhW*ACJOJQJ^Jh\2CJOJQJ^Jh;9CJOJQJ^Jh 5CJOJQJ^Jh]h]5CJOJQJ^Jh CJOJQJ^Jh h 5CJOJQJ^Jh]h)m5CJOJQJ^JhAPh)m5CJOJQJ^Jh)mCJOJQJ^JhiCJOJQJ^J#~(24c6XY㷪㷑woh)mCJaJh CJOJQJ^Jh)mCJOJQJ^JaJh\2CJOJQJ^Jh\25CJOJQJ^Jh]5CJOJQJ^Jh]h)m5CJOJQJ^JhKh)m5CJOJQJ^JhAPCJOJQJ^Jh)mCJOJQJ^JhKh 5CJOJQJ^J&34YZ $xx$Ifa$$xx$Ifa$gd] xx$If $ !a$Zx^Z^ & F$*39BHW]15YZ\]|ϻh]kCJOJQJ^JaJh]CJOJQJ^JaJh)mCJaJ h]h)mCJOJQJ^JaJ&h]h)m5CJOJQJ\^JaJh)m5OJQJ\^Jh)mCJaJh]CJOJQJ^JaJh8fCJOJQJ^JaJ4tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkdp$$IflF"&0"    44 la]tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd$$$Ifl7F"&0"    44 la]tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd$$Ifl[F"&0"    44 la]Y[\tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd $$IflF"&0"    44 la]\]tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd@ $$IflF"&0"    44 la]tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd $$IflF"&0"    44 la] !#$&DEF[ŷӡᯛ~soah\2CJOJQJ^JaJh\2h)mh\2CJaJ h)mh\2CJOJQJ^JaJhL3jhL3U h)mCJh?1#CJOJQJ^JaJh)mCJaJh]CJOJQJ^JaJh CJOJQJ^JaJh]kCJOJQJ^JaJ h]h)mCJOJQJ^JaJhuCJOJQJ^JaJtjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd $$IflF"&0"    44 la]tjZM $xx$Ifa$$xx$Ifa$gd] xx$Ifkd\ $$IflF"&0"    44 la] "#%&EFtrrrrrrrrrhr  !$gd)mkd $$IflF"&0"    44 la] [\novw}~ߺ{u h)mCJh1Ih h B*OJQJ^JphhL3h\2%hK0JCJOJQJ^JmHnHuh\20JCJOJQJ^J#jh\20JCJOJQJU^J%hKCJOJQJ^JaJmHnHuh\2CJOJQJ^JaJ#jh\2CJOJQJU^JaJF 7$8$H$gd   !H$gd)m,1h/ =!"#$% Dd 6D  3 @@"?$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If!vh555#v#v#v:V l065554a$$If]!vh555#v#v#v:V l0",5559a]$$If]!vh555#v#v#v:V l70",5559a]$$If]!vh555#v#v#v:V l[0",5559a]$$If]!vh555#v#v#v:V l0",5559a]$$If]!vh555#v#v#v:V l0",5559a]$$If]!vh555#v#v#v:V l0",5559a]$$If]!vh555#v#v#v:V l0",5559a]$$If]!vh555#v#v#v:V l0",5559a]$$If]!vh555#v#v#v:V l0",5559a]@@@ NormalCJ_HaJmH sH tH :@: Heading 1$@&5\DA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k(No List 4@4 Header  !4 @4 Footer  !.)@. Page Number ".:QPONM ".:=^&'(*+`adehp vwzLMOZ9:=I H I M a Z [ . / 34YZY[\] "#%&EF00000000000000000000000l00000000000000000000000000000 00 00 000 00 00 00 00000y0Fy0Fy0Fy0Fy0Fy0Hy0Hy0Hy0Jy0Jy0Jy0Ly0Ly0Ly0Ny0Ny0Ny0Py0Py0Py0Ry0Ry0Ry0Ty0Ty0Ty0Vy0Vy0Vy0y00y00y00y00y00y00y00y00@0y00@0y00y00y0y0m,A]csy0m,A]csy0m,A]csy0m,A]csy0l ,,ooor\ g :~[ ")- vL9H\F!#$%&'(*+,.C[^_AT\cjlr!lST,2$5ƺ^G. ;7@fS(    EC# S#  s"*?` R c $X99? EC# `  A` A#  ! B lB?C?DEF΂(!!~` E./F b .E#`2~<?<2##2;?;2b#F/ DH@`S" B_ C BCCCDEFC!"!"CC! @`S" A c D BBCBDEFB!!!!BB! @`S" ?` E BDCBDEFD!"!"BD! @`S"   4 F BCDE(F2 @`"<   4 G BCDE(F2 @`"<  _4 H BCDE(F2 ...@`"<  CW4 I BCDE(F2 ...@`"<   KH J # ^N K 3 S L BSCODEF"*OCOS*@`S" $f M S "aC# ` N C 8` f O S ERm f P S  8~` ` Q C _8` B S  ?\S1t "#%& "#%&ab MM # # 3 3   8 =  ~ 4c "#%&DF[w} "#%&EV%d "~O1/0JdEzCLX.s*kYHhD<L^`CJOJQJ^Jo(.L^`.LpLp^p`L.L@ @ ^@ `.L^`.LL^`L.L^`.L^`.LPLP^P`L.^`CJOJQJ^Jo(.^`.TLT^T`L.$ $ ^$ `.  ^ `.L^`L.^`.dd^d`.4L4^4`L.^`o(.^`.L^`L.pp^p`.@ @ ^@ `.L^`L.^`.^`.L^`L.^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.808^8`0o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.^`o(.^`o(.p0p^p`0o(.)$ $ ^$ `.  ^ `.L^`L.^`.dd^d`.4L4^4`L.L^`CJOJQJ^Jo(.L^`.LL^`L.L  ^ `.L\ \ ^\ `.L,L,^,`L.L^`.L^`.LL^`L.dECLd E*kYO/0D(6        D(6                        ^H        ~$ڛB//      D(6        x ]?1#L3W<4;9W*AAP]kLs8fi3lmvm)m\2u K-1Itehp vwzLMOZ9:=I H I M a Y[\]@  @@UnknownGz Times New Roman5Symbol3& z Arial"1hs&lډ&jډ&A "A "!4d2QHX?m2%Excel Project 2  Baseball StatisticsCAED Sheri Schmidt(       Oh+'0 ,8 X d p |(Excel Project 2 Baseball StatisticsCAEDNormalSheri Schmidt8Microsoft Office Word@x@|谤@ @Q0A՜.+,D՜.+,h$ hp  Arizona State University"  &Excel Project 2 Baseball Statistics Title0@$_AdHocReviewCycleID_EmailSubject _AuthorEmail_AuthorEmailDisplayName_ReviewingToolsShownOncei~week 7 materialsaigoe@cox.net Ann Igoe  !"#$%&'()*+,-./12345679:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXY[\]^_`acdefghilRoot Entry F2nData 01Table8}BWordDocument.^SummaryInformation(ZDocumentSummaryInformation8bCompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q