Discussion: Major League Sports Problem

Discussion: Major League Sports Problem ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS ON Discussion: Major League Sports Problem I’m 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

Struggling to find relevant content? Order a custom essay on
Discussion: Major League Sports Problem
Let our experts save you the hassle
Order Now
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
ENG 099
Excellent Paper. The only 100 in the class.
Customer 452775, July 19th, 2022
Other
thanks
Customer 452653, October 31st, 2021
Social Work and Human Services
Thank you for the great job
Customer 452469, February 3rd, 2021
Criminal Justice
Great work! Followed directions to the latter.
Customer 452485, September 1st, 2021
Human Resources Management (HRM)
Thanks.
Customer 452701, August 15th, 2023
Technology
Great job on the paper!
Customer 452885, December 28th, 2022
Human Resources Management (HRM)
Thanks very much.
Customer 452701, July 26th, 2023
Other
Excellent job
Customer 452813, December 26th, 2024
Nursing
Excellent PowerPoint! Thank you!
Customer 452707, June 29th, 2022
Psychology
Thgank you
Customer 452905, December 11th, 2022
Social Work and Human Services
Excellent Work
Customer 452587, November 22nd, 2021
Human Resources Management (HRM)
Thanks for your support.
Customer 452701, April 24th, 2023
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Good News ! We now help with PROCTORED EXAM. Chat with a support agent for more information