Discussion: Major League Sports Problem
Discussion: Major League Sports Problem ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS ON Discussion: Major League Sports Problem Im studying and need help with a Excel question to help me learn. West Virginia University CS101 Major League Sports Problem computer science 101 HW help Excel. I have attached the instructions and the Data Files. I want it to be done as soon as possible data_files_hw1_mlsp.zip instructions_hw1_mlsp.pdf HOMEWORK INSTRUCTIONS Homework #1 Major League Sports Problem Background Information Professional teams in all major sports in the U.S. and Canada operate as franchises within a league. The four major leagues include Major League Baseball (MLB), the National Basketball Association (NBA), National Football League (NFL), and National Hockey League (NHL). The four major leagues are distinguished from other leagues in terms of their business size and popularity, as measured by annual revenue and average attendance. For example, in the 2014-2015 season, the 30 NBA teams generated combined revenue of $5.18 billion. Problem Statement In this assignment, students will analyze the four major sports leagues by revenue and attendance for the years 2005 through 2015. Instructions IMPORTANT: Complete the steps below in the order they are given. Completing the steps out of order may complicate the assignment or result in an incorrect result. 1. Download and extract the provided Data Files ZIP file. It contains the following file for use in this assignment: a. revenue.csv Information on revenue of the four major sports leagues for the years 2005 through 2015 [1][4]. Column Name Year MLB Revenue Type Number Number NBA Revenue Number NFL Revenue Number NHL Revenue Number Total Revenue Number Introduction to Computer Applications West Virginia University Page 1 of 6 Description Year of the data. Revenue generated by Major League Baseball teams. Revenue generated by National Basketball Association teams. Revenue generated by National Football League teams. Revenue generated by National Hockey League teams. Total revenue of the four major sports leagues. West Virginia University CS101 Major League Sports Problem Version 1.3 Modified 5/23/2018 HOMEWORK INSTRUCTIONS Homework #1 Major League Sports Problem b. attendance.csv Information on attendance of the four major sports leagues for the years 2005 through 2015 [5][8]. Column Name Year MLB Attendance Type Number Number NBA Attendance Number NFL Attendance Number NHL Attendance Number Total Attendance Number Description Year of the data. Total attendance of teams. Total attendance of Association teams. Total attendance of League teams. Total attendance of League teams. Total attendance of leagues. 2. Create a new Microsoft Excel workbook named lastname_firstname_hw1_mlsp.xlsx. 3. We must adjust the sheets in our workbook. 4. 5. a. Rename Sheet1 to Revenue. b. Add a new sheet named Attendance. c. Add a new sheet named Analysis Questions. all Major League Baseball all National Basketball all National Football all National Hockey the four major sports Import the following items into the workbook: a. revenue.csv file Import starting in cell A3 of the Revenue sheet. The file is comma-delimited. Its first row contains headers. b. attendance.csv file Import starting in cell A3 of the Attendance sheet. The file is comma-delimited. Its first row contains headers. We wish to apply formatting to the Revenue sheet. a. b. We must setup a table to store data on revenue. i. If a table does not already exist in cells A3 through F14, create one using a style of your choice. The table has headers and will overlap external data ranges. If prompted, convert the selection to a table and remove all external connections. ii. If a table already exists in cells A3 through F14, format the table using a style of your choice other than the default table style. We need to add additional columns to store rank and percentage data. i. Insert two new table columns to the right of existing column F. c. For the table, turn on the Total Row option. West Virginia University CS101 Major League Sports Problem d. Enter text in the cells as indicated below: Introduction to Computer Applications West Virginia University Page 2 of 6 Version 1.3 Modified 5/23/2018 HOMEWORK INSTRUCTIONS Homework #1 Major League Sports Problem 6. 7. A1: Major League Sports Revenue Firstname Lastname ii. G3: Total Revenue Rank iii. H3: NFL Revenue Percentage e. Merge-and-center cells A1 through H1. f. Set the font size to 16-point for cell A1. We need to perform calculations to analyze the Revenue sheet data. a. In column H, calculate the percentage of total revenue that came from the NFL using the formula: [?????? ??????????????] [?????????? ??????????????] b. In column G, use the RANK.EQ() function to rank each year by its total revenue. c. We would like to summarize the revenue data. i. In the total row, individually sum columns B through F. ii. In the total row, do not display any statistics in columns G and H. We must apply additional formatting to the Revenue sheet. a. b. 8. i. Add borders to the cells as indicated below: i. F3 through F15: left thick solid line ii. G3 through G15: left thin solid line Format the cells as indicated below: i. B4 through F15: currency with no decimal places ii. H4 through H14: percentage with 1 decimal place c. AutoFit the widths of columns A through H. d. Apply conditional formatting to the NFL revenue percentage in cells H4 through H14. i. If the percentage was less than 38% (< 0.38), change the cell fill color to red and the text color to white. ii. If the percentage was at least 40% (? 0.40), change the fill color to green and the text color to white. We also wish to apply formatting to the Attendance sheet. a. We must setup a table to store data on attendance. i. If a table does not already exist in cells A3 through F14, create one using a style of your choice. The table has headers and will overlap Introduction to Computer Applications West Virginia University Page 3 of 6 Version 1.3 Modified 5/23/2018 HOMEWORK INSTRUCTIONS Homework #1 Major League Sports Problem external data ranges. West Virginia University CS101 Major League Sports Problem If prompted, convert the selection to a table and remove all external connections. ii. b. We need to add an additional column to store percentage data. i. c. 9. If a table already exists in cells A3 through F14, format the table using a style of your choice other than the default table style. Insert one new table column to the right of column F. Enter text in the cells as indicated below: i. A1: Major League Sports Attendance ii. G3: MLB Attendance Percentage d. Merge (but do not center) cells A1 through G1. e. Apply the Title cell style to cell A1. On the Attendance sheet, we wish to calculate major league sports attendance statistics. a. In column G, calculate the percentage of total attendance from MLB using the formula: [?????? ????????????????????] [?????????? ????????????????????] 10. We must apply additional formatting to the Attendance sheet. a. b. Format the cells as indicated below: i. B4 through F14: number with no decimal places, use 1000 separator ii. G4 through G14: percentage with 2 decimal places AutoFit the widths of columns A through G. 11. We need to set up the Analysis Questions sheet so that it can store responses to the analysis questions. a. Enter text in the cells as indicated below: i. A1: Question Number ii. B1: Response b. Bold the contents of row 1. c. AutoFit the width of column A. Set the width of column B to 100 (8.39). d. Set the height for rows 2 through 5 to 110 (1.53). e. Change the vertical alignment setting for columns A and B so that the text is displayed at the top of each row. Introduction to Computer Applications West Virginia University Page 4 of 6 Version 1.3 Modified 5/23/2018 HOMEWORK INSTRUCTIONS Homework #1 Major League Sports Problem f. Turn on text wrapping for column B. 12. Starting in row 2 of the Analysis Questions sheet, answer four of the five analysis questions below. Respond to one question per row. a. Despite a drop-off in growth of revenue in 2012, there has been a steady increase in total revenue of the four major sports leagues. West Virginia University CS101 Major League Sports Problem What do you think is the main reason behind this? b. NHL revenue dropped 22% in the 2012-2013 season. Why might revenue have fallen so sharply? c. More people attended MLB games than NFL, NBA, and NHL games combined during the period 2005 to 2015. Why does MLB have so much more attendance than the other leagues? d. The Super Bowl is famous for having the most expensive commercial airtime on television. Why is Super Bowl airtime so costly? e. The four major sports leagues each have revenue that is many times larger than the other professional sports leagues in the U.S. and Canada [9]. Why is this the case? Grading Rubric This assignment is worth 50 points. It will be graded by your instructor using this rubric, with partial credit awarded as appropriate: Steps 3a-c Step 4 Steps 5a-f Step 6a Step 6b Steps 6c(i)-(ii) Steps 7a-c 1.5 points total 5 points 3.5 points total 4 points total 5 points total 3.5 points total 2 points total Steps 7d(i)-(ii) Steps 8a-e Step 9a Steps 10a-b Steps 11a-f Steps 12a-e (pick 4 of 5) 4 points total 3 points total 4 points total 1.5 points total 3 points total 2.5 points each The analysis questions in Steps 12a-e will be evaluated using this rubric: Standard Answer is reasonable. Answer is supported. Introduction to Computer Applications West Virginia University Meets Requirements (1.25 points) Answer addresses the question prompt and is factually correct or a reasonable interpretation of available data. Logical rationale is provided to support the given answer. Page 5 of 6 Does Not Meet Requirements (0 points) Answer does not address the question prompt, is factually incorrect, or is an unreasonable interpretation of available data. Logical rationale is not provided to support the given answer. West Virginia University CS101 Major League Sports Problem Version 1.3 Modified 5/23/2018 HOMEWORK INSTRUCTIONS Homework #1 Major League Sports Problem Acknowledgments The logos in the introduction appear courtesy of Major League Baseball [10], the National Basketball Association [11], National Football League [12], and National Hockey League [13]. References [1] MLB league revenue 2001-2015, Statista. Available: https://www.statista.com/statistics/193466/total-league-revenue-of-the-mlbsince-2005/. Accessed: Dec. 19, 2016. [2] NBA league revenue 2001-2015, Statista. Available: https://www.statista.com/statistics/193467/total-league-revenue-of-the-nbasince-2005/. Accessed: Dec. 19, 2016. [3] NFL league revenue 2001-2015, Statista. Available: https://www.statista.com/statistics/193457/total-league-revenue-of-the-nflsince-2005/. Accessed: Dec. 19, 2016. [4] NHL league revenue 2005-2016, Statista. Available: https://www.statista.com/statistics/193468/total-league-revenue-of-the-nhlsince-2006/. Accessed: Dec. 19, 2016. [5] MLB Attendance Report, ESPN.com. Available: //www.espn.com/mlb/attendance. Accessed: Dec. 19, 2016. [6] NBA Attendance Report, ESPN.com. Available: //www.espn.com/nba/attendance. Accessed: Dec. 19, 2016. [7] NFL Attendance Report, ESPN.com. Available: //www.espn.com/nfl/attendance. Accessed: Dec. 19, 2016. [8] NHL Attendance Report, ESPN.com. Available: //www.espn.com/nhl/attendance. Accessed: Dec. 19, 2016. [9] List of professional sports leagues by revenue, Wikipedia, Dec. 16, 2016. Available: https://en.wikipedia.org/w/index.php?title=List_of_professional_sports_leagues _by_revenue&oldid=755162530. [10] Major League Baseball Logo. 2016. Available: https://en.wikipedia.org/w/index.php?title=File:Major_League_Baseball.svg&old id=748241041. [11] National Basketball Association Logo. 2016. Available: https://en.wikipedia.org/w/index.php?title=File:NBALogo.svg&oldid=747804895 . [12] National Football League Logo. 2016. Available: https://en.wikipedia.org/w/index.php?title=File:National_Football_League_2008 .svg&oldid=740500839. [13] National Hockey League Logo. 2016. Available: https://en.wikipedia.org/w/index.php?title=File:05_NHL_Shield.svg&oldid=7092 20251. Introduction to Computer Applications West Virginia University Page 6 of 6 Version 1.3 Modified 5/23/2018 West Virginia University CS101 Major League Sports Problem Get a 10 % discount on an order above $ 100 Use the following coupon code : NURSING10
