Description
see attached file for assignement.
Unformatted Attachment Preview
Assignment for Grades:
1. Working with Data I
Refer to the 2022 Baseball data, which reports information on the 30 Major
League Baseball teams for the 2022 season. (6 points)
a. Develop a 95 percent confidence interval for the mean number of errors
committed (Errors) by each team and interpret the results. (2 points)
b. Develop a 90 percent confidence interval for the mean number of stolen bases
(SB) by each team and interpret the results. (2 points)
c. Develop a 99 percent confidence interval for the mean number of home runs (HR)
per team and interpret the results. (2 points)
2. Working with Data II
Refer to NBA Player Performance data for 2022-23 season (6 points)
a. Develop a 95 percent confidence interval for the mean minutes per game (MPG)
of the NBA players in the 2022-2023 season and interpret the results.
b. Develop a 90 percent confidence interval for the mean 2-point field goal
percentage (@2p in the dataset) of the NBA players in the 2022-2023 season and
interpret the results.
c. Construct a histogram with a normal curve for the 2-point field goal percentage
variable (@2p in the dataset) of the NBA players in the 2022-2023 season. Is this
dataset normally distributed? Explain its distribution.
3. Exercise.com (8 points)
In this excise, we will determine if corporate president/CEOs’ compensations are related
to company performance by constructing a scatterplot. We will examine two types of
travel business corporations: airlines and leisure/event services.
President/CEO annual compensations and company annual revenues of the following five
airline companies will be studied:
For data consistency, I
Delta Air Lines, Inc. (DAL_ Edward H. Bastian)
United Continental Holdings, Inc. (UAL_ J. Scott Kirby)
Alaska Air Group (ALK_ Benito Minicucci)
American Airlines Group Inc. (AAL_ Robert D. Isom Jr.)
JetBlue Airways Corporation (JBLU_Robin N. Hayes)
filtered the corporate
leaders for this
exercise. The
President/CEO/
Director names are
included in the
parenthesis
President/CEO annual compensations and company annual revenues of the following
leisure/event service providers will be compared to those of the airlines:
Carnival Corporation (CCL_Joshua Ian Weinstein)
Cedar Fair L.P. (FUN_ Richard A. Zimmerman)
MGM Resorts International (MGM_ William J. Hornbuckle IV)
Live National Entertainment, Inc. (LYV_ Michael Rapino)
Six Flags Entertainment Co. (SIX_ Selim Bassoul)
You need to find out the above corporate leaders’ compensations and company
revenues from
http://quote.yahoo.com
1. On Yahoo Finance home page, type DAL (ticker symbol for Delta Air Lines Inc.,
tickers for all the companies are provided in parenthesis after the company names
above) in the Quote Lookup target as illustrated below:
2. Click DAL ticker. Basic financial data and an one-day stock performance chart come
up:
3. Click Profile as shown in the above screenshot. A page containing company contact
and key leadership team information comes up.
4. From the Key Executives table, select CEO & Director for this study by writing the
name and annual compensation for 2022 (data for Pay). For Delta Air Lines, Inc.,
CEO is: Edward H. Bastian and compensation was $3.91million in 2022.
5. Then select Statistics on Delta company page (see below).
6. Scroll down the page to Income Statement in the Financial Highlights section, you
will see Revenue of $57.262 billion for Delta Air Lines, Inc. in 2022.
7. Use the list of President/CEO/Director pre-selected for this study and continue to
gather the data for the President/CEO/Director’s salary and company’s revenues (the
reporting period for revenue may vary from company to company due to fiscal year
reporting schedule, but we will use the revenue reported in Yahoo Finance database
for this exercise).
Once you collect all the data, perform the following data entry and analysis:
a. Use four variables for this exercise: CEO name, type of industry (airline or
leisure, or use your own coding to define the two types of businesses), CEO
annual salary and company revenue. You can name these variables the way
you want.
b. Code the type of industry in two categories: such as airline and leisure.
c. Construct a simple scatterplot by setting the markers for the type of industry
and labeling the cases by President/CEO/Director’s name.
d. Discuss the relationship between company revenues and top executive salary.
Is there a relationship between the two variables for all the companies or just
one type of the industry? Can you identify any other relationships between
the two variables?
Purchase answer to see full
attachment
